vFutureMedicalHealthcarePrimContact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FutureID int 4 null
FutureNameInternal varchar 100 null
FutureNameExternal varchar 100 null
FutureLegalFullName varchar 150 null
FutureName varchar 51 null
FutureSurname varchar 30 null
FutureGiven1 varchar 20 null
FutureGiven2 varchar 50 null
FuturePreferred varchar 20 null
FuturePreferredFormal varchar 20 null
FutureGender varchar 15 null
FutureMobilePhone varchar 15 null
FutureBirthDate datetime 16,3 √ null
FutureStatus varchar 3 null
FutureCampus varchar 3 null
FutureYearLevel smallint 2 √ null
FutureYearLevelSort smallint 2 √ null
FutureHouse varchar 5 null
FutureForm varchar 15 null
FutureTutor varchar 15 null
FutureBoarder varchar 3 null
FutureBoarderType varchar 30 √ null
FutureBoardingHouse varchar 15 null
FutureCountryOfBirthDescription varchar 40 √ null
StudentHomeLanguageDescription varchar 100 √ null
FutureNationalityDescription varchar 30 √ null
DebtorID int 4 √ null
FutureBillingFlag bit 1 √ null
FutureSpecialBillingType varchar 5 √ null
FutureContactType varchar 3 √ null
FutureContactID int 4 √ null
FutureContactDescription varchar 30 √ null
FutureContactMailName varchar 100 √ null
FutureContactMailSalutation varchar 100 √ null
FutureContactTitle varchar 30 √ null
FutureContactNameInternal varchar 100 √ null
FutureContactNameExternal varchar 100 √ null
FutureContactLegalFullName varchar 150 √ null
FutureContactSurname varchar 30 √ null
FutureContactPreferred varchar 20 √ null
FutureContactPreferredFormal varchar 20 √ null
FutureContactSpouseID int 4 √ null
FutureContactSpouseTitle varchar 30 √ null
FutureContactSpouseSurname varchar 30 √ null
FutureContactSpousePreferred varchar 20 √ null
FutureContactLivesWithFlag bit 1 √ null
FutureContactPrimaryOnlyFlag bit 1 √ null
FutureContactNormalMailFlag bit 1 √ null
FutureContactReportsFlag bit 1 √ null
FutureContactParentFlag bit 1 √ null
FutureContactHomePhone varchar 15 √ null
FutureContactHomePhoneActual varchar 15 √ null
FutureContactHomePhoneAlt varchar 15 √ null
FutureContactMobilePhone varchar 15 √ null
FutureContactDefaultMobilePhone varchar 15 √ null
FutureAddressComma varchar 200 √ null
FutureAddressFull varchar 200 √ null
FutureHomeAddressComma varchar 200 √ null
FutureHomeAddressFull varchar 200 √ null
FutureAddress varchar 200 √ null
FutureContactAddressComma varchar 200 √ null
FutureContactAddressFull varchar 200 √ null
FutureContactAddressDPID varchar 8 √ null
FutureContactAddressDPIDBarcode varchar 60 √ null
FutureContactAddressSortPlanNumber varchar 3 √ null
FutureContactAddressPAFVersion varchar 10 √ 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
FutureContactHomeAddressSameFlag bit 1 √ null
FutureContactOccupCompany varchar 50 √ null
FutureContactOccupDescription varchar 120 √ null
FutureContactOccupCode varchar 15 √ null
FutureContactOccupPhone varchar 15 √ null
FutureContactOccupFax varchar 15 √ null
FutureContactDefaultEmailCode varchar 1 √ null
FutureContactOccupEmail varchar 100 √ null
FutureContactOccupMobilePhone varchar 15 √ null
FutureParishCode varchar 5 √ null
FutureParishDescription varchar 50 √ null
FutureReligionCode varchar 5 √ null
FutureReligionDescription varchar 40 √ null
FuturePhoneActual varchar 15 √ null
FuturePhoneSilentFlag bit 1 √ null
FuturePreviousSchoolCode varchar 15 √ null
FuturePreviousSchoolDescription varchar 100 √ null
FutureBaptismFlag bit 1 √ null
FutureBaptismDate datetime 16,3 √ null
FutureReconciliationFlag bit 1 √ null
FutureReconciliationDate datetime 16,3 √ null
FutureCommunionFlag bit 1 √ null
FutureCommunionDate datetime 16,3 √ null
FutureConfirmationFlag bit 1 √ null
FutureConfirmationDate datetime 16,3 √ null
FutureIndigenousFlag bit 1 √ null
FutureEnglishSecondFlag bit 1 √ null
FutureIntendsTertiaryFlag bit 1 √ null
FutureVisaType varchar 5 √ null
FutureVisaIssuedDate datetime 16,3 √ null
FutureVisaExpiryDate datetime 16,3 √ null
FutureVisaNumber varchar 20 √ null
FuturePassportNo varchar 15 √ null
FuturePassportCountryCode varchar 5 √ null
FuturePassportIssuedDate datetime 16,3 √ null
FuturePassportExpiryDate datetime 16,3 √ null
FutureEmergencyName varchar 80 √ null
FutureEmergencyAddress varchar 200 √ null
FutureEmergencyPhone varchar 15 √ null
FutureEmergencyPhoneAlt varchar 15 √ null
FutureEmergencyRelationship varchar 30 √ null
FutureEmergency2Name varchar 80 √ null
FutureEmergency2Address varchar 200 √ null
FutureEmergency2Phone varchar 15 √ null
FutureEmergency2PhoneAlt varchar 15 √ null
FutureEmergency2Relationship varchar 30 √ null
FutureDoctorName varchar 80 √ null
FutureDoctorAddress varchar 200 √ null
FutureDoctorPhone varchar 15 √ null
FutureDoctorPhoneAlt varchar 15 √ null
FutureDoctorSpecialisation varchar 50 √ null
FutureDoctor2Name varchar 80 √ null
FutureDoctor2Address varchar 200 √ null
FutureDoctor2Phone varchar 15 √ null
FutureDoctor2PhoneAlt varchar 15 √ null
FutureDoctor2Specialisation varchar 50 √ null
FutureDentistName varchar 80 √ null
FutureDentistAddress varchar 200 √ null
FutureDentistPhone varchar 15 √ null
FutureDentistPhoneAlt varchar 15 √ null
FutureMedicalAlert varchar 2000 √ null
FutureEmergency3Name varchar 80 √ null
FutureEmergency3Address varchar 200 √ null
FutureEmergency3Phone varchar 15 √ null
FutureEmergency3PhoneAlt varchar 15 √ null
FutureEmergency3Relationship varchar 30 √ null
FutureMedicalAlertFlag bit 1 √ null
FutureSpecialNeedsFlag bit 1 √ null
FutureStudyAtHomeFlag bit 1 √ null
FutureTSIFlag bit 1 √ null
FutureESLProficiencyLevel varchar 15 √ null
FutureESLListeningLevelCode varchar 15 √ null
FutureESLSpeakingLevelCode varchar 15 √ null
FutureESLReadingLevelCode varchar 15 √ null
FutureESLWritingLevelCode varchar 15 √ null
FutureAustudyFlag bit 1 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
BloodGroup varchar 3 √ null
PrivateInsuranceFlag bit 1 √ null
PrivateInsuranceDescription varchar 30 √ null
DisabilityLevel varchar 15 √ null
DisabilityLevelDescription varchar 50 √ null
PrivateInsuranceFund varchar 5 √ null
PrivateInsuranceNo varchar 30 √ null
MedicareNo varchar 12 √ null
MedicareLineNo tinyint 1 √ null
MedicareExpiryDate datetime 16,3 √ null
AmbulanceFlag bit 1 √ null
AmbulanceNo varchar 12 √ null
ImmunisationFormFlag bit 1 √ null
ImmunisationFormStatus varchar 15 √ null
ImmunisationFormDate datetime 16,3 √ null
PrivateInsuranceExtraCoverFlag bit 1 √ null
PrivateInsuranceTable varchar 30 √ null
MedicalLastModifiedDate datetime 16,3 √ null
MedicalLastModifiedBy int 4 √ null
FutureStudiesCode varchar 15 √ null
FutureGovernmentStudentNumber varchar 15 √ null
FutureContactEmail varchar 100 √ null
FutureContactDefaultEmail varchar 100 √ null
FutureContactSpouseEmail varchar 100 √ null
FutureContactSpouseOccupEmail varchar 100 √ null
FutureContactSpouseDefaultEmailCode varchar 1 √ null
FutureContactSpouseDefaultEmail varchar 100 √ null
PrivateHealthFundExpiryDate datetime 16,3 √ null
FutureCampusDescription varchar 30 √ null
ImmunisationFormStatusDescription varchar 50 √ null
FutureEmergencyMobilePhone varchar 15 √ null
FutureEmergencyDefaultMobilePhone varchar 15 √ null
FutureEmergency2MobilePhone varchar 15 √ null
FutureEmergency2DefaultMobilePhone varchar 15 √ null
FutureEmergency3MobilePhone varchar 15 √ null
FutureEmergency3DefaultMobilePhone varchar 15 √ null
ImmunisationOtherDetails varchar 2147483647 √ null
FutureContactSpouseDefaultMobilePhone varchar 15 √ null
SubSchool varchar 15 √ null
FutureHouseDescription varchar 30 null
HealthCareCardExpiryDate datetime 16,3 √ null
HealthCareCardFlag bit 1 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views