vStudentClassesAll


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
AssessableFlag bit 1 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
ClassStatusSynergyMeaning varchar 30 √ 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
ClassFeeCode varchar 15 null
ClassFeeDefaultUnits smallint 2 null
StudentClassFeeUnitsAdjustment smallint 2 null
StudentClassUnitsTotal smallint 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 bit 1 √ 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
StudentGovernmentStudentNumber varchar 15 √ null
ClassLearningAreaCode varchar 15 null
ClassLearningAreaDescription varchar 60 √ null
ClassLearningAreaReportSortSeq int 4 √ null
ClassLearningAreaActiveFlag bit 1 √ null
StaffID int 4 √ null
StudentCoursesSeq int 4 √ null
StudentSubSchool varchar 15 √ null
InterviewRequestedCode varchar 15 null
InterviewRequestedDescription varchar 50 null
LearningPathway varchar 30 null
StudentGenderSynergyMeaning varchar 30 √ null
StaffGenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views