vStudentMedicalHealthcareAllContacts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
CurrentSemesterOnlyFlag int 4 null
StudentNameInternal varchar 100 √ null
StudentNameExternal varchar 100 √ null
StudentLegalFullName varchar 150 √ null
StudentName varchar 51 √ null
StudentSurname varchar 30 √ null
StudentGiven1 varchar 20 √ null
StudentGiven2 varchar 50 √ null
StudentPreferred varchar 20 √ null
StudentPreferredFormal varchar 20 √ null
StudentGender varchar 15 √ null
StudentMobilePhone varchar 15 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
StudentLeavingDestination varchar 15 √ null
StudentReturningDate datetime 16,3 √ null
StudentBirthDate datetime 16,3 √ null
StudentStatus varchar 3 √ null
StudentStatusNextYear varchar 3 √ null
StudentCampus varchar 3 √ null
StudentYearLevel smallint 2 √ null
StudentYearLevelSort smallint 2 √ null
StudentHouse varchar 5 √ null
StudentForm varchar 15 √ null
StudentFormDescription varchar 30 √ null
StudentFormHomeroomTeacher varchar 15 √ null
StudentTutor varchar 15 √ null
StudentBoarder varchar 3 √ null
StudentBoarderType varchar 30 √ null
StudentBoardingHouse varchar 15 √ null
StudentCountryOfBirthDescription varchar 40 √ null
StudentHomeLanguageDescription varchar 100 √ null
StudentNationalityDescription varchar 30 √ null
StudentCampusDescription varchar 30 √ null
StudentHouseDescription varchar 30 √ null
StudentContactSpouseDefaultMobilePhone varchar 15 √ null
DebtorID int 4 √ null
StudentBillingFlag bit 1 √ null
FullFeeFlag bit 1 null
StudentSpecialBillingType varchar 5 √ null
StudentContactType varchar 3 √ null
StudentContactID int 4 √ null
StudentContactSpouseID int 4 √ null
StudentContactDescription varchar 30 √ null
StudentContactMailName varchar 100 √ null
StudentContactMailSalutation varchar 100 √ null
StudentContactTitle varchar 30 √ null
StudentContactNameInternal varchar 100 √ null
StudentContactNameExternal varchar 100 √ null
StudentContactLegalFullName varchar 150 √ null
StudentContactSurname varchar 30 √ null
StudentContactPreferred varchar 20 √ null
StudentContactPreferredFormal varchar 20 √ null
StudentContactSpouseTitle varchar 30 √ null
StudentContactSpouseSurname varchar 30 √ null
StudentContactSpousePreferred varchar 20 √ null
StudentContactLivesWithFlag bit 1 √ null
StudentContactPrimaryOnlyFlag bit 1 √ null
StudentContactNormalMailFlag bit 1 √ null
StudentContactValidAddress bit 1 √ null
StudentContactReportsFlag bit 1 √ null
StudentContactParentFlag bit 1 √ null
StudentContactHomePhone varchar 15 √ null
StudentContactHomePhoneActual varchar 15 √ null
StudentContactHomePhoneAlt varchar 15 √ null
StudentContactMobilePhone varchar 15 √ null
StudentContactDefaultMobilePhone varchar 15 √ null
StudentAddressComma varchar 200 √ null
StudentAddressFull varchar 200 √ null
StudentHomeAddressComma varchar 200 √ null
StudentHomeAddressFull varchar 200 √ null
StudentAddress varchar 200 √ null
StudentContactAddressComma varchar 200 √ null
StudentContactAddressFull varchar 200 √ null
StudentContactAddressDPID varchar 8 √ null
StudentContactAddressDPIDBarcode varchar 60 √ null
StudentContactAddressSortPlanNumber varchar 3 √ null
StudentContactAddressPAFVersion varchar 10 √ 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
StudentContactHomeAddressSameFlag bit 1 √ null
StudentContactOccupCompany varchar 50 √ null
StudentContactOccupType varchar 50 √ null
StudentContactOccupDescription varchar 120 √ null
StudentContactOccupCode varchar 15 √ null
StudentContactOccupPhone varchar 15 √ null
StudentContactOccupFax varchar 15 √ null
StudentContactDefaultEmailCode varchar 1 √ null
StudentContactOccupEmail varchar 100 √ null
StudentContactOccupMobilePhone varchar 15 √ null
StudentParishCode varchar 5 √ null
StudentParishDescription varchar 50 √ null
StudentReligionCode varchar 5 √ null
StudentReligionDescription varchar 40 √ null
StudentPhoneActual varchar 15 √ null
StudentPhoneSilentFlag bit 1 √ null
StudentPreviousSchoolCode varchar 15 √ null
StudentPreviousSchoolDescription varchar 100 √ null
StudentBaptismFlag bit 1 √ null
StudentBaptismDate datetime 16,3 √ null
StudentReconciliationFlag bit 1 √ null
StudentReconciliationDate datetime 16,3 √ null
StudentCommunionFlag bit 1 √ null
StudentCommunionDate datetime 16,3 √ null
StudentConfirmationFlag bit 1 √ null
StudentConfirmationDate datetime 16,3 √ null
StudentIndigenousFlag bit 1 √ null
StudentEnglishSecondFlag bit 1 √ null
StudentIntendsTertiaryFlag bit 1 √ null
StudentVisaType varchar 5 √ null
StudentVisaIssuedDate datetime 16,3 √ null
StudentVisaExpiryDate datetime 16,3 √ null
StudentVisaNumber varchar 20 √ null
StudentPassportNo varchar 15 √ null
StudentPassportCountryCode varchar 5 √ null
StudentPassportIssuedDate datetime 16,3 √ null
StudentPassportExpiryDate datetime 16,3 √ null
StudentEntryDate datetime 16,3 √ null
StudentEntryYearLevel smallint 2 √ null
StudentEmergencyName varchar 80 √ null
StudentEmergencyAddress varchar 200 √ null
StudentEmergencyPhone varchar 15 √ null
StudentEmergencyPhoneAlt varchar 15 √ null
StudentEmergencyRelationship varchar 30 √ null
StudentEmergency2Name varchar 80 √ null
StudentEmergency2Address varchar 200 √ null
StudentEmergency2Phone varchar 15 √ null
StudentEmergency2PhoneAlt varchar 15 √ null
StudentEmergency2Relationship varchar 30 √ null
StudentDoctorName varchar 80 √ null
StudentDoctorAddress varchar 200 √ null
StudentDoctorPhone varchar 15 √ null
StudentDoctorPhoneAlt varchar 15 √ null
StudentDoctorSpecialisation varchar 50 √ null
StudentDoctor2Name varchar 80 √ null
StudentDoctor2Address varchar 200 √ null
StudentDoctor2Phone varchar 15 √ null
StudentDoctor2PhoneAlt varchar 15 √ null
StudentDoctor2Specialisation varchar 50 √ null
StudentDentistName varchar 80 √ null
StudentDentistAddress varchar 200 √ null
StudentDentistPhone varchar 15 √ null
StudentDentistPhoneAlt varchar 15 √ null
StudentMedicalAlert varchar 2000 √ null
StudentEmergency3Name varchar 80 √ null
StudentEmergency3Address varchar 200 √ null
StudentEmergency3Phone varchar 15 √ null
StudentEmergency3PhoneAlt varchar 15 √ null
StudentEmergency3Relationship varchar 30 √ null
StudentMedicalAlertFlag bit 1 √ null
StudentSpecialNeedsFlag bit 1 √ null
StudentStudyAtHomeFlag bit 1 √ null
StudentTSIFlag bit 1 √ null
StudentESLProficiencyLevel varchar 15 √ null
StudentESLListeningLevelCode varchar 15 √ null
StudentESLSpeakingLevelCode varchar 15 √ null
StudentESLReadingLevelCode varchar 15 √ null
StudentESLWritingLevelCode varchar 15 √ null
StudentAustudyFlag bit 1 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
StudentStudiesCode varchar 15 √ null
StudentGovernmentStudentNumber varchar 15 √ null
StudentContactEmail varchar 100 √ null
StudentContactDefaultEmail varchar 201 √ null
StudentContactSpouseEmail varchar 100 √ null
StudentContactSpouseOccupEmail varchar 100 √ null
StudentContactSpouseDefaultEmailCode varchar 1 √ null
StudentContactSpouseDefaultEmail varchar 201 √ null
BloodGroup varchar 3 √ null
PrivateInsuranceFlag bit 1 √ null
PrivateInsuranceDescription varchar 30 √ 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
PrivateHealthFundExpiryDate datetime 16,3 √ null
ImmunisationOtherDetails varchar 2147483647 √ null
ImmunisationFormStatusDescription varchar 50 √ null
StudentEmergencyMobilePhone varchar 15 √ null
StudentEmergencyDefaultMobilePhone varchar 15 √ null
StudentEmergency2MobilePhone varchar 15 √ null
StudentEmergency2DefaultMobilePhone varchar 15 √ null
StudentEmergency3MobilePhone varchar 15 √ null
StudentEmergency3DefaultMobilePhone varchar 15 √ null
StudentSubSchool varchar 15 √ null
HealthCareCardFlag bit 1 √ null
HealthCareCardNo varchar 30 √ null
HealthCareCardExpiryDate datetime 16,3 √ null
MedicalAlertFlag bit 1 √ null
MedicalAlert varchar 2000 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views