vPastStudentClassesAll


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID int 4 null
StudentGender varchar 15 √ null
FileYear smallint 2 null
FileSemester smallint 2 null
ActualSemester smallint 2 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
StudentInitials 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
StudentCampus varchar 3 √ null
StudentCampusDescription varchar 30 √ null
StudentYearLevel smallint 2 √ null
StudentYearLevelDescription varchar 30 √ null
StudentYearLevelSort smallint 2 √ null
StudentHouse varchar 5 √ null
StudentHouseDescription varchar 30 √ null
StudentHouseHeadofHouse varchar 100 √ null
StudentHouseCaptain varchar 100 √ null
StudentForm varchar 15 √ null
StudentTutor varchar 15 √ null
StudentBoarder varchar 3 √ null
StudentBoardingHouse varchar 15 √ null
StudentBoarderType varchar 30 √ null
ClassColumn smallint 2 √ null
FileType varchar 5 √ null
ClassCampus varchar 3 √ null
ClassCode varchar 15 √ null
StartDate datetime 16,3 √ null
StopDate datetime 16,3 √ null
ClassStatus varchar 3 √ null
StudentCalibreMark decimal 7,2 √ null
AssessmentCode varchar 15 √ null
ClassDescription varchar 100 √ null
ClassNormalYearLevel smallint 2 √ null
ClassNormalYearLevel2 smallint 2 √ null
ClassAdjustmentMean decimal 7,2 √ null
ClassAdjustmentStandardDeviation decimal 7,2 √ null
StaffMailName varchar 100 √ null
SchoolStaffCode varchar 30 √ null
StaffRegSchoolsBoardCode varchar 15 √ null
StaffRegistrationNumber varchar 15 √ null
StaffRegistrationType varchar 15 √ null
StaffRegistrationExpiryDate datetime 16,3 √ null
StaffCampus varchar 3 √ null
StaffTitle varchar 30 √ null
StaffPreferredFormal varchar 20 √ null
StaffPreferred varchar 20 √ null
StaffNameInternal varchar 100 √ null
StaffNameExternal varchar 100 √ null
StaffLegalFullName varchar 150 √ null
StaffGiven1 varchar 20 √ null
StaffGiven2 varchar 50 √ null
StaffSurname varchar 30 √ null
StaffInitials varchar 15 √ null
CurrentSemesterOnlyFlag int 4 null
StudentEmergencyName varchar 80 null
StudentEmergencyAddress varchar 200 null
StudentEmergencyPhone varchar 15 null
StudentEmergencyPhoneAlt varchar 15 null
StudentEmergencyRelat varchar 5 √ null
StudentEmergency2Name varchar 80 null
StudentEmergency2Address varchar 200 null
StudentEmergency2Phone varchar 15 null
StudentEmergency2PhoneAlt varchar 15 null
StudentEmergency2Relat varchar 5 √ null
StudentEmergency3Name varchar 80 null
StudentEmergency3Address varchar 200 null
StudentEmergency3Phone varchar 15 null
StudentEmergency3PhoneAlt varchar 15 null
StudentEmergency3Relat varchar 5 null
StudentStudyAtHomeFlag bit 1 null
StudentIBFlag bit 1 √ null
StudentFullFeeFlag bit 1 null
StudentTuitionVariationType varchar 3 null
StudentIntendsTertiaryFlag bit 1 null
StudentFamilyPosition smallint 2 √ null
StudentBirthDate datetime 16,3 √ null
StudentBirthCertificateOnFileFlag bit 1 null
StudentSuburb varchar 40 √ null
StudentState varchar 5 √ null
StudentCountryCode varchar 5 √ null
StudentPostCode varchar 5 √ null
StudentPhoneActual varchar 15 √ null
StudentPhoneAlt varchar 15 √ null
StudentFax varchar 15 √ null
StudentHomeAddressSameFlag bit 1 √ null
StudentHomeSuburb varchar 40 √ null
StudentHomeState varchar 5 √ null
StudentHomeCountryCode varchar 5 √ null
StudentHomePostCode varchar 5 √ null
StudentValidAddressFlag bit 1 √ null
StudentSilentPhoneFlag bit 1 √ null
StudentMailFlag bit 1 √ null
StudentMagazineFlag bit 1 √ null
StudentSolicitationFlag bit 1 √ null
StudentRaffleFlag bit 1 √ null
StudentAddressComma varchar 200 √ null
StudentAddressFull varchar 200 √ null
StudentAddressDPIDBarcode varchar 60 √ null
StudentHomeAddressComma varchar 200 √ null
StudentHomeAddressFull varchar 200 √ null
StudentHomeAddressDPIDBarcode varchar 60 √ null
StudentPhone varchar 15 √ null
LegalPhotoWebFlag bit 1 √ null
LegalPhotoPromFlag bit 1 √ null
LegalPhotoPublicationFlag bit 1 √ null
StudentStudiesCode varchar 15 null
ClassLearningAreaCode varchar 15 √ null
ClassLearningAreaDescription varchar 60 √ null
ClassLearningAreaReportSortSeq int 4 √ null
ClassLearningAreaActiveFlag bit 1 √ null
StudentSubSchool varchar 15 √ null
LearningPathway varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views