vFutureContactsRelationOnly


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FutureID int 4 null
ID int 4 null
FutureContactType varchar 3 null
ContactType varchar 3 null
FutureContactDescription varchar 30 √ null
FutureContactLivesWithFlag bit 1 null
FutureContactNormalMailFlag bit 1 null
FutureContactReportsFlag bit 1 null
FutureContactParentFlag bit 1 null
ContactLinkedID int 4 null
FutureContactID int 4 null
FutureContactMailName varchar 100 √ null
FutureContactNameInternal varchar 100 √ null
FutureContactNameExternal varchar 100 √ null
FutureContactLegalFullName varchar 150 √ null
FutureContactPreferred varchar 20 √ null
FutureContactPreferredFormal varchar 20 √ null
FutureContactGiven1 varchar 20 √ null
FutureContactGiven2 varchar 50 √ null
FutureContactSurname varchar 30 √ null
FutureContactOccupCompany varchar 50 √ null
FutureContactOccupType varchar 120 √ null
FutureContactOccupDesc varchar 50 √ null
FutureContactOccupPhone varchar 15 √ null
FutureContactOccupFax varchar 15 √ null
FutureContactOccupMobilePhone varchar 15 √ null
FutureContactSilentOccupMobilePhoneFlag bit 1 √ null
FutureContactOccupEmail varchar 100 √ null
FutureContactOccupAddressComma varchar 200 √ null
FutureContactOccupAddressFull varchar 200 √ null
FutureContactOccupAddressDPID varchar 8 √ null
FutureContactOccupAddressDPIDBarcode varchar 60 √ null
FutureContactOccupAddressSortPlanNumber varchar 3 √ null
FutureContactOccupAddressPAFVersion varchar 10 √ null
FutureContactMobilePhone varchar 15 √ null
FutureContactDefaultMobilePhone varchar 15 √ null
FutureContactSilentMobilePhoneFlag bit 1 √ null
FutureContactAddressComma varchar 200 √ null
FutureContactAddressFull varchar 200 √ null
SilentHomeAddressFlag bit 1 √ null
FutureContactAddressDPID varchar 8 √ null
FutureContactAddressDPIDBarcode varchar 60 √ null
FutureContactAddressSortPlanNumber varchar 3 √ null
FutureContactAddressPAFVersion varchar 10 √ null
FutureContactAHPhone varchar 15 √ null
FutureContactAHPhoneActual varchar 15 √ null
FutureContactSilentPhoneFlag bit 1 √ null
FutureContactAHPhoneAlt varchar 15 √ null
FutureContactAHFax varchar 15 √ null
FutureContactHomeAddressComma varchar 200 √ null
FutureContactHomeAddressFull varchar 200 √ null
FutureContactHomeAddressDPID varchar 8 √ null
FutureContactHomeAddressDPIDBarcode varchar 60 √ null
FutureContactHomeAddressSortPlanNumber varchar 3 √ null
FutureContactHomeAddressPAFVersion varchar 10 √ null
FutureContactEmail varchar 100 √ null
FutureContactDefaultEmail 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
FutureContactSpouseSurname 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
FutureContactSpouseSilentOccupMobilePhoneFlag bit 1 √ null
ContactSpouseMobilePhone varchar 15 √ null
ContactSpouseDefaultMobilePhone varchar 15 √ null
FutureContactSpouseSilentMobilePhoneFlag 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
FutureMedicalAlertFlag bit 1 null
FutureSpecialNeedsFlag bit 1 null
FutureTSIFlag bit 1 null
FutureIndigenousFlag bit 1 null
FutureStudyAtHomeFlag bit 1 null
FutureIntendsTertiaryFlag bit 1 null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
FutureStudiesCode varchar 15 null
FutureGovernmentStudentNumber varchar 15 √ null
FutureNameInternal varchar 100 null
FutureNameExternal varchar 100 null
FutureLegalFullName varchar 150 null
FutureSurname varchar 30 null
FuturePreferred varchar 20 null
FuturePreferredFormal varchar 20 null
FutureGiven1 varchar 20 null
FutureGiven2 varchar 50 null
FutureName varchar 51 null
FutureBirthDate datetime 16,3 √ null
FutureGender varchar 15 null
FutureReligionCode varchar 5 null
FutureReligionDescription varchar 40 √ null
FutureParishCode varchar 5 null
FutureParishDescription varchar 50 √ null
FutureCountryOfBirthCode varchar 5 null
FutureCountryOfBirthDescription varchar 40 √ null
FutureHomeLanguageCode varchar 5 null
FutureHomeLanguageDescription varchar 100 √ null
FutureNationalityCode varchar 5 null
FutureNationalityDescription varchar 30 √ null
FutureDirectoryIncludeFlag bit 1 null
FutureDirectoryProvideFlag bit 1 null
FutureContactDirectoryIncludeFlag bit 1 √ null
FutureContactDirectoryProvideFlag bit 1 √ null
FutureContactSpouseDirectoryIncludeFlag bit 1 √ null
FutureContactSpouseDirectoryProvideFlag bit 1 √ null
LegalParentsSeparatedFlag bit 1 √ null
LegalPrivacyPolicyAgreedFlag bit 1 √ null
FutureContactUseSMS varchar 15 √ null
FutureContactSpouseUseSMS varchar 15 √ null
FutureContactUseEmail varchar 15 √ null
ContactSpouseUseEmail varchar 15 √ null
FutureContactTitle varchar 30 √ null
FutureContactReligionCode varchar 5 √ null
FutureContactReligionDescription varchar 40 √ null
FutureContactCountryOfBirthCode varchar 5 √ null
FutureContactCountryOfBirthDescription varchar 40 √ null
ContactSpouseTitle varchar 30 √ null
ContactSpouseReligionCode varchar 5 √ null
ContactSpouseReligionDescription varchar 40 √ null
ContactSpouseCountryOfBirthCode varchar 5 √ null
ContactSpouseCountryOfBirthDescription varchar 40 √ null
FutureContactHomeLanguageCode varchar 5 √ null
FutureContactHomeLanguageDescription varchar 100 √ null
ContactSpouseHomeLanguageCode varchar 5 √ null
ContactSpouseHomeLanguageDescription varchar 100 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views