vStudentContactsRelationOnly


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
ID int 4 null
FileYear smallint 2 null
FileSemester smallint 2 null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 null
StudentLeavingDestination varchar 15 null
StudentReturningDate datetime 16,3 √ null
StudentContactType varchar 3 null
ContactType varchar 3 null
StudentContactDescription varchar 30 √ null
StudentContactLivesWithFlag bit 1 null
StudentContactNormalMailFlag bit 1 null
StudentContactReportsFlag bit 1 null
StudentContactParentFlag bit 1 null
ContactLinkedID int 4 null
StudentContactID int 4 null
StudentContactMailName varchar 100 √ null
StudentContactMailSalutation varchar 100 √ null
StudentContactNameInternal varchar 100 √ null
StudentContactNameExternal varchar 100 √ null
StudentContactLegalFullName varchar 150 √ null
StudentContactPreferred varchar 20 √ null
StudentContactPreferredFormal varchar 20 √ null
StudentContactGiven1 varchar 20 √ null
StudentContactGiven2 varchar 50 √ null
StudentContactSurname varchar 30 √ null
StudentContactOccupCompany varchar 50 √ null
StudentContactOccupType varchar 120 √ null
StudentContactOccupDesc varchar 50 √ null
StudentContactOccupPhone varchar 15 √ null
StudentContactOccupFax varchar 15 √ null
StudentContactOccupMobilePhone varchar 15 √ null
StudentContactSilentOccupMobilePhoneFlag bit 1 √ null
StudentContactOccupEmail varchar 100 √ null
StudentContactOccupAddressComma varchar 200 √ null
StudentContactOccupAddressFull varchar 200 √ null
StudentContactOccupAddressDPID varchar 8 √ null
StudentContactOccupAddressDPIDBarcode varchar 60 √ null
StudentContactOccupAddressSortPlanNumber varchar 3 √ null
StudentContactOccupAddressPAFVersion varchar 10 √ null
StudentContactMobilePhone varchar 15 √ null
StudentContactDefaultMobilePhone varchar 15 √ null
StudentContactSilentMobilePhoneFlag bit 1 √ null
StudentContactAddressComma varchar 200 √ null
StudentContactAddressFull varchar 200 √ null
SilentHomeAddressFlag bit 1 √ null
StudentContactAddressDPID varchar 8 √ null
StudentContactAddressDPIDBarcode varchar 60 √ null
StudentContactAddressSortPlanNumber varchar 3 √ null
StudentContactAddressPAFVersion varchar 10 √ null
StudentContactAHPhone varchar 15 √ null
StudentContactAHPhoneActual varchar 15 √ null
StudentContactSilentPhoneFlag bit 1 √ null
StudentContactAHPhoneAlt varchar 15 √ null
StudentContactAHFax varchar 15 √ null
StudentContactHomeAddressComma varchar 200 √ null
StudentContactHomeAddressFull varchar 200 √ null
StudentContactHomeAddressDPID varchar 8 √ null
StudentContactHomeAddressDPIDBarcode varchar 60 √ null
StudentContactHomeAddressSortPlanNumber varchar 3 √ null
StudentContactHomeAddressPAFVersion varchar 10 √ null
StudentContactEmail varchar 100 √ null
StudentContactDefaultEmail varchar 201 √ null
ContactRelationship varchar 5 √ null
ContactDescription varchar 30 √ null
ContactSpouseID int 4 √ null
ContactSpouseMailNamePrimary varchar 100 √ null
ContactSpouseNameInternal varchar 100 √ null
ContactSpouseNameExternal varchar 100 √ null
ContactSpouseLegalFullName varchar 150 √ null
ContactSpousePreferred varchar 20 √ null
ContactSpousePreferredFormal varchar 20 √ null
ContactSpouseGiven1 varchar 20 √ null
ContactSpouseGiven2 varchar 50 √ null
StudentContactSpouseSurname varchar 30 √ null
ContactSpouseOccupCompany varchar 50 √ null
ContactSpouseOccupType varchar 120 √ null
ContactSpouseOccupDesc varchar 50 √ null
ContactSpouseBusinessPhone varchar 15 √ null
ContactSpouseOccupFax varchar 15 √ null
ContactSpouseOccupMobilePhone varchar 15 √ null
StudentContactSpouseSilentOccupMobilePhoneFlag bit 1 √ null
ContactSpouseMobilePhone varchar 15 √ null
ContactSpouseDefaultMobilePhone varchar 15 √ null
StudentContactSpouseSilentMobilePhoneFlag bit 1 √ null
ContactSpouseOccupEmail varchar 100 √ null
ContactSpouseEmail varchar 100 √ null
ContactSpouseDefaultEmail varchar 201 √ null
ContactSpouseOccupAddressComma varchar 200 √ null
ContactSpouseOccupAddressFull varchar 200 √ null
ContactSpouseOccupAddressDPID varchar 8 √ null
ContactSpouseOccupAddressDPIDBarcode varchar 60 √ null
ContactSpouseOccupAddressSortPlanNumber varchar 3 √ null
ContactSpouseOccupAddressPAFVersion varchar 10 √ null
ContactSpouseRelationship varchar 5 √ null
ContactSpouseDescription varchar 30 √ null
DebtorID int 4 null
DebtorPrimaryOnlyFlag bit 1 null
StudentMedicalAlertFlag bit 1 null
StudentSpecialNeedsFlag bit 1 null
StudentTSIFlag bit 1 null
StudentIndigenousFlag bit 1 null
StudentStudyAtHomeFlag bit 1 null
StudentIntendsTertiaryFlag bit 1 null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
CurrentSemesterOnlyFlag int 4 null
StudentStudiesCode varchar 15 null
StudentGovernmentStudentNumber varchar 15 √ null
StudentNameInternal varchar 100 null
StudentNameExternal varchar 100 null
StudentLegalFullName varchar 150 null
StudentSurname varchar 30 null
StudentPreferred varchar 20 null
StudentPreferredFormal varchar 20 null
StudentGiven1 varchar 20 null
StudentGiven2 varchar 50 null
StudentName varchar 51 null
StudentBirthDate datetime 16,3 √ null
StudentGender varchar 15 null
StudentReligionCode varchar 5 null
StudentReligionDescription varchar 40 √ null
StudentParishCode varchar 5 null
StudentParishDescription varchar 50 √ null
StudentCountryOfBirthCode varchar 5 null
StudentCountryOfBirthDescription varchar 40 √ null
StudentHomeLanguageCode varchar 5 null
StudentHomeLanguageDescription varchar 100 √ null
StudentNationalityCode varchar 5 null
StudentNationalityDescription varchar 30 √ null
StudentDirectoryIncludeFlag bit 1 null
StudentDirectoryProvideFlag bit 1 null
StudentContactDirectoryIncludeFlag bit 1 √ null
StudentContactDirectoryProvideFlag bit 1 √ null
StudentContactSpouseDirectoryIncludeFlag bit 1 √ null
StudentContactSpouseDirectoryProvideFlag bit 1 √ null
LegalParentsSeparatedFlag bit 1 √ null
LegalPrivacyPolicyAgreedFlag bit 1 √ null
StudentContactUseSMS varchar 15 √ null
StudentContactSpouseUseSMS varchar 15 √ null
StudentContactUseEmail varchar 15 √ null
StudentContactSpouseUseEmail varchar 15 √ null
StudentContactTitle varchar 30 √ null
StudentContactReligionCode varchar 5 √ null
StudentContactReligionDescription varchar 40 √ null
StudentContactCountryOfBirthCode varchar 5 √ null
StudentContactCountryOfBirthDescription varchar 40 √ null
ContactSpouseTitle varchar 30 √ null
ContactSpouseReligionCode varchar 5 √ null
ContactSpouseReligionDescription varchar 40 √ null
ContactSpouseCountryOfBirthCode varchar 5 √ null
ContactSpouseCountryOfBirthDescription varchar 40 √ null
StudentContactPrimaryOnlyFlag bit 1 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views