vStudentsCurrentPastFutureCombined


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
StudentSurname varchar 30 null
StudentName varchar 51 null
StudentGender varchar 15 null
StudentGiven1 varchar 20 null
StudentGiven2 varchar 50 null
StudentPreferred varchar 20 null
StudentLegalFullName varchar 150 null
StudentStatus varchar 3 null
StudentStatusSynergyMeaning varchar 30 null
StudentBirthDate datetime 16,3 √ null
StudentApplicationDate datetime 16,3 √ null
StudentEntryDate datetime 16,3 √ null
StudentLeftDate datetime 16,3 √ null
StudentLeavingReason varchar 3 null
StudentLeavingDestination varchar 15 null
StudentLeavingDestinationDescription varchar 100 √ null
StudentReturningDate datetime 16,3 √ null
FileYear int 4 √ null
StudentCampus varchar 3 null
StudentYearLevel smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
StudentYearLevelSort smallint 2 √ null
StudentType varchar 7 null
StudentEnquirySource varchar 10 null
StudentFullFeeFlag bit 1 null
StudentFamilyPosition int 4 null
PreviousSchool varchar 15 null
PreviousSchoolDescription varchar 100 √ null
StudentEmail varchar 100 null
StudentOccupEmail varchar 100 null
StudentSubSchool varchar 15 √ null
IBFlag bit 1 null
StudentCampusSort int 4 √ null
StudentCampusDescription varchar 30 null
LearningPathway varchar 30 null
GenderSynergyMeaning varchar 30 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views