vStudentRelations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 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
StudentGender varchar 15 √ null
FileYear smallint 2 null
FileSemester smallint 2 null
StudentStatus varchar 3 null
StudentStatusDescription varchar 30 √ null
StudentStatusNextYear varchar 3 null
StudentStatusNextYearDescription varchar 30 √ null
StudentEntryDate datetime 16,3 √ null
StudentEntryCampus varchar 3 null
StudentEntryYearLevel smallint 2 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 null
StudentLeavingDestination varchar 15 null
StudentReturningDate datetime 16,3 √ null
StudentCampus varchar 3 null
StudentCampusDescription varchar 30 √ null
StudentYearLevel smallint 2 √ null
StudentYearLevelSort smallint 2 null
StudentYearLevelDescription varchar 30 √ null
StudentHouse varchar 5 null
StudentForm varchar 15 null
StudentFormDescription varchar 30 √ null
StudentFormHomeroom varchar 15 √ null
StudentFormHomeroomTeacher varchar 100 √ null
StudentTutor varchar 15 null
StudentBoarder varchar 3 null
StudentBoarderSynergyMeaning varchar 30 √ null
StudentBoarderType varchar 30 √ null
StudentBoardingHouse varchar 15 null
DebtorID int 4 null
StudentFamilyPosition smallint 2 null
StudentApplicationDate datetime 16,3 √ null
StudentMedicalAlertFlag bit 1 null
StudentSpecialNeedsFlag bit 1 null
StudentStudyAtHomeFlag bit 1 null
StudentFullFeeFlag bit 1 null
StudentTSIFlag bit 1 null
StudentIndigenousFlag bit 1 null
StudentIntendsTertiaryFlag bit 1 null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
Relationship varchar 5 null
RelationDescription varchar 30 √ null
RelationGenerationGap tinyint 1 √ null
RelationID int 4 √ null
RelationMailNamePrimary varchar 100 √ null
RelationNameInternal varchar 100 √ null
RelationNameExternal varchar 100 √ null
RelationLegalFullName varchar 150 √ null
RelationSurname varchar 30 √ null
RelationPreferred varchar 20 √ null
RelationPreferredFormal varchar 20 √ null
RelationGiven1 varchar 20 √ null
RelationGiven2 varchar 50 √ null
RelationOccupCompany varchar 50 √ null
RelationOccupType varchar 120 √ null
RelationOccupDesc varchar 50 √ null
RelationOccupPhone varchar 15 √ null
RelationOccupFax varchar 15 √ null
RelationOccupMobilePhone varchar 15 √ null
RelationOccupEmail varchar 100 √ null
RelationOccupAddressComma varchar 200 √ null
RelationOccupAddressFull varchar 200 √ null
RelationOccupAddressDPID varchar 8 √ null
RelationOccupAddressDPIDBarcode varchar 60 √ null
RelationOccupAddressSortPlanNumber varchar 3 √ null
RelationOccupAddressPAFVersion varchar 10 √ null
RelationMobilePhone varchar 15 √ null
RelationDefaultMobilePhone varchar 15 √ null
RelationAddressComma varchar 200 √ null
RelationAddressFull varchar 200 √ null
RelationAddressDPID varchar 8 √ null
RelationAddressDPIDBarcode varchar 60 √ null
RelationAddressSortPlanNumber varchar 3 √ null
RelationAddressPAFVersion varchar 10 √ null
RelationPhoneActual varchar 15 √ null
RelationSilentPhoneFlag bit 1 √ null
RelationPhoneAlt varchar 15 √ null
RelationFax varchar 15 √ null
RelationEmail varchar 100 √ null
RelationDefaultEmail varchar 201 √ null
RelationSpouseID int 4 √ null
RelationSpouseMailNamePrimary varchar 100 √ null
RelationSpouseNameInternal varchar 100 √ null
RelationSpouseNameExternal varchar 100 √ null
RelationSpouseLegalFullName varchar 150 √ null
RelationSpouseSurname varchar 30 √ null
RelationSpousePreferred varchar 20 √ null
RelationSpousePreferredFormal varchar 20 √ null
RelationSpouseGiven1 varchar 20 √ null
RelationSpouseGiven2 varchar 50 √ null
RelationSpouseOccupCompany varchar 50 √ null
RelationSpouseOccupType varchar 120 √ null
RelationSpouseOccupDesc varchar 50 √ null
RelationSpouseBusinessPhone varchar 15 √ null
RelationSpouseOccupFax varchar 15 √ null
RelationSpouseOccupMobilePhone varchar 15 √ null
RelationSpouseMobilePhone varchar 15 √ null
RelationSpouseDefaultMobilePhone varchar 15 √ null
RelationSpouseOccupEmail varchar 100 √ null
RelationSpouseEmail varchar 100 √ null
RelationSpouseDefaultEmail varchar 201 √ null
RelationSpouseOccupAddressComma varchar 200 √ null
RelationSpouseOccupAddressFull varchar 200 √ null
RelationSpouseOccupAddressDPID varchar 8 √ null
RelationSpouseOccupAddressDPIDBarcode varchar 60 √ null
RelationSpouseOccupAddressSortPlanNumber varchar 3 √ null
RelationSpouseOccupAddressPAFVersion varchar 10 √ null
StudentStudiesCode varchar 15 null
StudentGovernmentStudentNumber varchar 15 √ null
StudentDeceasedFlag bit 1 √ null
StudentDeceasedDate datetime 16,3 √ null
RelationDeceasedFlag bit 1 √ null
RelationSpouseDeceasedFlag bit 1 √ null
StudentSubSchool varchar 15 √ null
StudentEntrySubSchool varchar 15 √ null
RelationshipSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views