vStudentMedicalHealthcare


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
FileYear smallint 2 null
StudentCampus varchar 3 null
StudentYearLevel smallint 2 √ null
StudentSurname varchar 30 null
StudentGiven1 varchar 20 null
StudentGiven2 varchar 50 null
StudentPreferred varchar 20 null
StudentGender varchar 15 null
StudentBirthDate datetime 16,3 √ null
StudentCampusDescription varchar 30 √ null
StudentCampusSort int 4 √ null
StudentYearLevelDescription varchar 30 null
StudentYearLevelSort smallint 2 null
StudentSubSchool varchar 15 null
StudentHouse varchar 5 null
StudentHouseDescription varchar 30 √ null
StudentForm varchar 15 null
StudentFormDescription varchar 30 √ null
StudentTutor varchar 15 null
StudentBoarder varchar 3 null
StudentBoarderSynergyMeaning varchar 30 null
StudentBoardingHouse varchar 15 null
StudentStatus varchar 3 null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 null
StudentLeavingDestination varchar 15 null
StudentReturningDate datetime 16,3 √ null
StudentStatusNextYear varchar 3 null
StudentNameInternal varchar 100 null
StudentNameExternal varchar 100 null
StudentLegalFullName varchar 150 null
StudentPreferredFormal varchar 20 null
StudentCountryOfBirthDescription varchar 40 null
StudentHomeLanguageDescription varchar 100 null
StudentNationalityDescription varchar 30 null
StudentParishCode varchar 5 null
StudentParishDescription varchar 50 null
StudentReligionCode varchar 5 null
StudentReligionDescription varchar 40 null
StudentEntryDate datetime 16,3 √ null
StudentEntryYearLevel smallint 2 √ null
StudentStudiesCode varchar 15 null
StudentPreviousSchoolCode varchar 15 null
StudentPreviousSchoolDescription varchar 100 √ null
StudentStudyAtHomeFlag bit 1 null
StudentAustudyFlag bit 1 null
StudentIntendsTertiaryFlag bit 1 null
StudentIndigenousFlag bit 1 null
StudentTSIFlag bit 1 null
StudentSpecialNeedsFlag bit 1 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
StudentEnglishSecondFlag bit 1 null
StudentESLProficiencyLevel varchar 15 null
StudentESLListeningLevelCode varchar 15 null
StudentESLSpeakingLevelCode varchar 15 null
StudentESLReadingLevelCode varchar 15 null
StudentESLWritingLevelCode varchar 15 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
StudentEmergencyName varchar 80 null
StudentEmergencyAddress varchar 200 null
StudentEmergencyPhone varchar 15 null
StudentEmergencyPhoneAlt varchar 15 null
StudentEmergencyRelationship varchar 30 null
StudentEmergencyID int 4 null
StudentEmergencyDefaultMobilePhone varchar 15 null
StudentEmergency2Name varchar 80 null
StudentEmergency2Address varchar 200 null
StudentEmergency2Phone varchar 15 null
StudentEmergency2PhoneAlt varchar 15 null
StudentEmergency2Relationship varchar 30 null
StudentEmergency2ID int 4 null
StudentEmergency2DefaultMobilePhone varchar 15 null
StudentEmergency3Name varchar 80 null
StudentEmergency3Address varchar 200 null
StudentEmergency3Phone varchar 15 null
StudentEmergency3PhoneAlt varchar 15 null
StudentEmergency3Relationship varchar 30 null
StudentEmergency3ID int 4 null
StudentEmergency3DefaultMobilePhone varchar 15 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
DebtorID int 4 null
StudentBillingFlag bit 1 null
FullFeeFlag bit 1 null
StudentSpecialBillingType varchar 5 null
StudentPhoneActual varchar 15 null
StudentPhoneSilentFlag bit 1 null
StudentHomeAddressComma varchar 200 null
LegalPhotoWebFlag bit 1 null
LegalPhotoPromFlag bit 1 null
LegalPhotoPublicationFlag bit 1 null
StudentMedicalAlertFlag bit 1 null
StudentMedicalAlert varchar 2000 √ null
BloodGroup varchar 3 null
DisabilityLevel varchar 15 null
DisabilityLevelDescription varchar 50 null
PrivateInsuranceFlag bit 1 null
PrivateInsuranceFund varchar 5 null
PrivateInsuranceDescription varchar 30 null
PrivateInsuranceNo varchar 30 null
PrivateInsuranceExtraCoverFlag bit 1 null
PrivateInsuranceTable varchar 30 null
PrivateHealthFundExpiryDate datetime 16,3 √ null
AmbulanceFlag bit 1 null
AmbulanceNo varchar 12 null
MedicareNo varchar 12 null
MedicareLineNo tinyint 1 √ null
MedicareExpiryDate datetime 16,3 √ null
HealthCareCardFlag bit 1 null
HealthCareCardNo varchar 30 null
HealthCareCardExpiryDate datetime 16,3 √ null
ImmunisationFormFlag bit 1 null
ImmunisationFormDate datetime 16,3 √ null
ImmunisationFormStatus varchar 15 null
ImmunisationFormStatusDescription varchar 50 null
ImmunisationFormStatusSynergyMeaning varchar 15 null
ImmunisationOtherDetails varchar 2147483647 null
MedicalDetailsSeq int 4 √ null
ModifiedBy int 4 √ null
ModifiedDate datetime 16,3 √ null
StudentGenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views