vStudentSiblingsAtSchool


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
StudentPreferred varchar 20 √ null
StudentPreferredFormal varchar 20 √ null
StudentNameInternal varchar 100 √ null
StudentNameExternal varchar 100 √ null
StudentLegalFullName varchar 150 √ null
StudentGiven1 varchar 20 √ null
StudentGiven2 varchar 50 √ null
StudentSurname varchar 30 √ null
StudentLeavingDate datetime 16,3 √ null
StudentLeavingReason varchar 3 √ null
StudentLeavingDestination varchar 15 √ null
StudentReturningDate datetime 16,3 √ null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
StudentStatus varchar 3 √ null
StudentStatusNextYear varchar 3 √ null
StudentStudentCampus varchar 3 √ null
StudentYearLevel smallint 2 √ null
StudentOverrideNextYearLevel smallint 2 √ null
StudentOverrideNextStudentCampus varchar 3 √ null
StudentOverrideNextBoarder varchar 3 √ null
StudentYearLevelSort smallint 2 √ null
StudentHouse varchar 5 √ null
StudentForm varchar 15 √ null
StudentTutor varchar 15 √ null
StudentBoarder varchar 3 √ null
StudentBoardingHouse varchar 15 √ null
StudentFamilyPosition smallint 2 √ null
StudentExternalStudentFlag bit 1 √ null
StudentEnglishSecondFlag bit 1 √ null
StudentDisabilityFlag bit 1 √ null
StudentFullFeeFlag bit 1 √ null
StudentNonResidentFlag bit 1 √ null
StudentAustudyFlag bit 1 √ null
StudentIndigenousFlag bit 1 √ null
StudentIBFlag bit 1 √ null
StudentMedicalAlertFlag bit 1 √ null
StudentSpecialNeedsFlag bit 1 √ null
StudentStudyAtHomeFlag bit 1 √ null
StudentTSIFlag bit 1 √ null
StudentESLProficiencyLevel varchar 15 √ null
StudentIntendsTertiaryFlag bit 1 √ null
SiblingID int 4 √ null
SiblingNameInternal varchar 100 √ null
SiblingNameExternal varchar 100 √ null
SiblingLegalFullName varchar 150 √ null
SiblingPreferred varchar 20 √ null
SiblingPreferredFormal varchar 20 √ null
SiblingGiven1 varchar 20 √ null
SiblingGiven2 varchar 50 √ null
SiblingSurname varchar 30 √ null
SiblingStatus varchar 3 √ null
SiblingStatusNextYear varchar 3 √ null
SiblingStudentCampus varchar 3 √ null
SiblingYearLevel smallint 2 √ null
SiblingOverrideNextYearLevel smallint 2 √ null
SiblingOverrideNextStudentCampus varchar 3 √ null
SiblingOverrideNextBoarder varchar 3 √ null
SiblingYearLevelSort smallint 2 √ null
SiblingHouse varchar 5 √ null
SiblingForm varchar 15 √ null
SiblingTutor varchar 15 √ null
SiblingBoarder varchar 3 √ null
SiblingFamilyPosition smallint 2 √ null
CurrentSemesterOnlyFlag int 4 null
LinkedID int 4 null
ContactSpouseID int 4 √ null
ContactSpouseFlag bit 1 √ null
ContactNameInternal varchar 100 √ null
ContactNameExternal varchar 100 √ null
ContactLegalFullName varchar 150 √ null
ContactSurname varchar 30 √ null
ContactSurnamePrevious varchar 30 √ null
ContactTitle varchar 30 √ null
ContactInitials varchar 15 √ null
ContactSuffix varchar 20 √ null
ContactPreferred varchar 20 √ null
ContactPreferredFormal varchar 20 √ null
ContactGiven1 varchar 20 √ null
ContactGiven2 varchar 50 √ null
ContactDeceasedDate datetime 16,3 √ null
ContactDeceasedFlag bit 1 √ null
ContactGender varchar 15 √ null
ContactMobilePhone varchar 15 √ null
ContactDefaultMobilePhone varchar 15 √ null
ContactEmail varchar 100 √ null
ContactMailNamePrimary varchar 100 √ null
ContactMailNameJoint varchar 100 √ null
ContactSuburb varchar 40 √ null
ContactState varchar 5 √ null
ContactCountryCode varchar 5 √ null
ContactPostCode varchar 5 √ null
ContactPhoneActual varchar 15 √ null
ContactPhoneAlt varchar 15 √ null
ContactFax varchar 15 √ null
ContactHomeSuburb varchar 40 √ null
ContactHomeState varchar 5 √ null
ContactHomeCountryCode varchar 5 √ null
ContactHomePostCode varchar 5 √ null
ContactValidAddressFlag bit 1 √ null
ContactSilentPhoneFlag bit 1 √ null
ContactAddressComma varchar 200 √ null
ContactAddressFull varchar 200 √ null
ContactHomeAddressComma varchar 200 √ null
ContactHomeAddressFull varchar 200 √ null
ContactPhone varchar 15 √ null
StudentStudiesCode varchar 15 √ null
StudentGovernmentStudentNumber varchar 15 √ null
SiblingRelationship varchar 30 √ null
StudentSubSchool varchar 15 √ null
StudentSiblingSubSchool varchar 15 √ null
LearningPathway varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views