Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StaffScheduleSeq | int | 4 | null |
|
|
|||
| ScheduleDateTimeFrom | datetime | 16,3 | null |
|
|
|||
| ScheduleDateTimeTo | datetime | 16,3 | null |
|
|
|||
| ScheduleTimeFrom | datetime | 16,3 | √ | null |
|
|
||
| ScheduleTimeTo | datetime | 16,3 | √ | null |
|
|
||
| Comment | varchar | 1000 | null |
|
|
|||
| Room | varchar | 15 | null |
|
|
|||
| TeamCode | varchar | 15 | null |
|
|
|||
| FileType | varchar | 5 | null |
|
|
|||
| FileYear | smallint | 2 | null |
|
|
|||
| FileSemester | smallint | 2 | null |
|
|
|||
| ClassCampus | varchar | 3 | null |
|
|
|||
| ClassCode | varchar | 15 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| AttendedFlag | bit | 1 | √ | null |
|
|
||
| AttendanceDescription | varchar | 18 | null |
|
|
|||
| ClassType | varchar | 15 | null |
|
|
|||
| StudentID | int | 4 | null |
|
|
|||
| StudentNameInternal | varchar | 100 | null |
|
|
|||
| StudentNameExternal | varchar | 100 | null |
|
|
|||
| StudentLegalFullName | varchar | 150 | null |
|
|
|||
| StudentSurname | varchar | 30 | null |
|
|
|||
| StudentTitle | varchar | 30 | null |
|
|
|||
| StudentInitials | varchar | 15 | null |
|
|
|||
| StudentSuffix | varchar | 20 | null |
|
|
|||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| StudentPreferredFormal | varchar | 20 | null |
|
|
|||
| StudentGiven1 | varchar | 20 | null |
|
|
|||
| StudentGiven2 | varchar | 50 | null |
|
|
|||
| StudentOccupEmail | varchar | 100 | null |
|
|
|||
| StudentBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StudentGender | varchar | 15 | null |
|
|
|||
| StudentMobilePhone | varchar | 15 | null |
|
|
|||
| StudentDefaultMobilePhone | varchar | 15 | null |
|
|
|||
| StudentOccupMobilePhone | varchar | 15 | null |
|
|
|||
| StudentEmail | varchar | 100 | null |
|
|
|||
| StudentEducation | varchar | 255 | null |
|
|
|||
| StudentQualifications | varchar | 255 | null |
|
|
|||
| StudentActiveFlag | bit | 1 | √ | null |
|
|
||
| StudentStatus | varchar | 3 | √ | null |
|
|
||
| StudentStatusDescription | varchar | 30 | √ | null |
|
|
||
| StudentStatusSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| StudentStatusNextYear | varchar | 3 | √ | null |
|
|
||
| StudentCampus | varchar | 3 | √ | null |
|
|
||
| StudentCampusDescription | varchar | 30 | √ | null |
|
|
||
| StudentCampusSort | int | 4 | √ | null |
|
|
||
| StudentCampusRSBNumber | varchar | 30 | √ | null |
|
|
||
| StudentYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentOverrideNextYearLevel | smallint | 2 | √ | null |
|
|
||
| StudentOverrideNextStudentCampus | varchar | 3 | √ | null |
|
|
||
| StudentOverrideNextBoarder | varchar | 3 | √ | null |
|
|
||
| StudentYearLevelSort | smallint | 2 | √ | null |
|
|
||
| StudentYearLevelDescription | varchar | 30 | √ | null |
|
|
||
| StudentYearLevelCoordinator | varchar | 30 | √ | null |
|
|
||
| StudentYearLevelTimeTableGroup | varchar | 5 | √ | null |
|
|
||
| StudentYearLevelIncludeInCensusFlag | bit | 1 | √ | null |
|
|
||
| StudentHouse | varchar | 5 | √ | null |
|
|
||
| StudentHouseDescription | varchar | 30 | √ | null |
|
|
||
| StudentHeadOfHouse | varchar | 100 | √ | null |
|
|
||
| StudentHouseCaptain | varchar | 100 | √ | null |
|
|
||
| StudentForm | varchar | 15 | √ | null |
|
|
||
| StudentFormDescription | varchar | 30 | √ | null |
|
|
||
| StudentFormHomeRoom | varchar | 15 | √ | null |
|
|
||
| StudentFormStaffName | varchar | 100 | √ | null |
|
|
||
| StudentTutor | varchar | 15 | √ | null |
|
|
||
| StudentTutorDescription | varchar | 30 | √ | null |
|
|
||
| StudentTutorHomeRoom | varchar | 15 | √ | null |
|
|
||
| StudentTutorName | varchar | 100 | √ | null |
|
|
||
| StudentBoarder | varchar | 3 | √ | null |
|
|
||
| StudentBoarderSynergyMeaning | varchar | 30 | √ | null |
|
|
||
| StudentBoarderType | varchar | 30 | √ | null |
|
|
||
| StudentBoardingHouse | varchar | 15 | √ | null |
|
|
||
| StudentLockerBook | varchar | 15 | √ | null |
|
|
||
| StudentLockerOther | varchar | 15 | √ | null |
|
|
||
| StudentStudiesCode | varchar | 15 | null |
|
|
|||
| StudentGovernmentStudentNumber | varchar | 15 | √ | null |
|
|
||
| StudentEarlyLearningCode | varchar | 15 | √ | null |
|
|
||
| VocationalEducationCode | varchar | 15 | √ | null |
|
|
||
| StudentTertiaryCode | varchar | 15 | null |
|
|
|||
| StudentTimeTableCode | varchar | 15 | 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 |
|
|
||
| StudentEnquirySource | varchar | 10 | null |
|
|
|||
| StudentEnquirySourceComment | varchar | 50 | null |
|
|
|||
| StudentPreviousSchool | varchar | 15 | null |
|
|
|||
| StudentTuitionVariationType | varchar | 3 | null |
|
|
|||
| StudentDoctorName | varchar | 80 | null |
|
|
|||
| StudentDoctorPhone | varchar | 15 | null |
|
|
|||
| StudentDoctorPhoneAlt | varchar | 15 | null |
|
|
|||
| StudentDoctorAddress | varchar | 200 | null |
|
|
|||
| StudentDoctorSpecialisation | varchar | 50 | null |
|
|
|||
| StudentDoctor2Name | varchar | 80 | null |
|
|
|||
| StudentDoctor2Phone | varchar | 15 | null |
|
|
|||
| StudentDoctor2PhoneAlt | varchar | 15 | null |
|
|
|||
| StudentDoctor2Address | varchar | 200 | null |
|
|
|||
| StudentDoctor2Specialisation | varchar | 50 | null |
|
|
|||
| StudentDentistName | varchar | 80 | null |
|
|
|||
| StudentDentistPhone | varchar | 15 | null |
|
|
|||
| StudentDentistPhoneAlt | varchar | 15 | null |
|
|
|||
| StudentDentistAddress | varchar | 200 | 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 |
|
|
|||
| StudentLastLessonRcvdDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsVisaType | varchar | 5 | null |
|
|
|||
| StudentVisaIssuedDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsVisaExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentVisaNumber | varchar | 20 | null |
|
|
|||
| StudentPassportCountryCode | varchar | 5 | null |
|
|
|||
| StudentPassportIssuedDate | datetime | 16,3 | √ | null |
|
|
||
| StudentPassportExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| StudentsPassportNo | varchar | 15 | null |
|
|
|||
| StudentsComment | varchar | 2147483647 | √ | null |
|
|
||
| ExternalStudentFlag | bit | 1 | null |
|
|
|||
| EnglishSecondFlag | bit | 1 | null |
|
|
|||
| DisabilityFlag | bit | 1 | null |
|
|
|||
| IntegrationFlag | bit | 1 | √ | null |
|
|
||
| FullFeeFlag | bit | 1 | null |
|
|
|||
| EMAFlag | bit | 1 | √ | null |
|
|
||
| IntendsTertiaryFlag | bit | 1 | null |
|
|
|||
| CurrentSemesterOnlyFlag | int | 4 | null |
|
|
|||
| StudentFamilyPosition | smallint | 2 | √ | null |
|
|
||
| StudentParishCode | varchar | 5 | √ | null |
|
|
||
| StudentParishDescription | varchar | 50 | √ | null |
|
|
||
| StudentReligionCode | varchar | 5 | √ | null |
|
|
||
| StudentReligionDescription | varchar | 40 | √ | null |
|
|
||
| StudentPreviousSchoolCode | varchar | 15 | null |
|
|
|||
| StudentPreviousSchoolDescription | varchar | 100 | √ | null |
|
|
||
| StudentPreviousSchoolRSBNumber | varchar | 30 | √ | null |
|
|
||
| StudentPreviousSchoolSuburb | varchar | 40 | √ | null |
|
|
||
| IndigenousFlag | bit | 1 | null |
|
|
|||
| StudentIBFlag | bit | 1 | √ | null |
|
|
||
| StudentApplicationDate | datetime | 16,3 | √ | null |
|
|
||
| StudentMedicalAlertFlag | bit | 1 | null |
|
|
|||
| StudentSpecialNeedsFlag | bit | 1 | null |
|
|
|||
| StudentStudyAtHomeFlag | bit | 1 | null |
|
|
|||
| StudentTSIFlag | bit | 1 | null |
|
|
|||
| StudentESLProficiencyLevel | varchar | 15 | null |
|
|
|||
| StudentESLListeningLevelCode | varchar | 15 | √ | null |
|
|
||
| StudentESLSpeakingLevelCode | varchar | 15 | √ | null |
|
|
||
| StudentESLReadingLevelCode | varchar | 15 | √ | null |
|
|
||
| StudentESLWritingLevelCode | varchar | 15 | √ | null |
|
|
||
| LegalPhotoWebFlag | bit | 1 | √ | null |
|
|
||
| LegalPhotoPromFlag | bit | 1 | √ | null |
|
|
||
| LegalPhotoPublicationFlag | bit | 1 | √ | null |
|
|
||
| StudentBarcode | varchar | 20 | null |
|
|
|||
| StudentMedicalAlert | varchar | 2000 | √ | null |
|
|
||
| StudentSchoolFTE | decimal | 7,2 | √ | null |
|
|
||
| StudentInitialSchoolingYear | int | 4 | √ | null |
|
|
||
| StudentInitialSchoolingDate | datetime | 16,3 | √ | null |
|
|
||
| StudentNonResidentFlag | bit | 1 | null |
|
|
|||
| DirectoryIncludeFlag | bit | 1 | null |
|
|
|||
| DirectoryProvideFlag | bit | 1 | null |
|
|
|||
| AddressID | int | 4 | null |
|
|
|||
| StudentBirthCertificateOnFileFlag | bit | 1 | null |
|
|
|||
| StudentCountryOfBirthCode | varchar | 5 | √ | null |
|
|
||
| StudentCountryOfBirthCodeRaw | varchar | 5 | null |
|
|
|||
| StudentCountryOfBirthDescription | varchar | 40 | √ | null |
|
|
||
| StudentHomeLanguageCode | varchar | 5 | null |
|
|
|||
| StudentHomeLanguageDescription | varchar | 100 | √ | null |
|
|
||
| ActualSemester | smallint | 2 | null |
|
|
|||
| StudentAltCode | varchar | 15 | null |
|
|
|||
| ImportantCommentsFlag | bit | 1 | null |
|
|
|||
| StudentLeavingDestinationDesc | varchar | 100 | √ | null |
|
|
||
| DebtorID | int | 4 | null |
|
|
|||
| MCEETYAFormReceivedDate | datetime | 16,3 | √ | null |
|
|
||
| StudentNationalityCode | varchar | 5 | null |
|
|
|||
| StudentNationalityDescription | varchar | 30 | √ | null |
|
|
||
| StudentNationality2Code | varchar | 5 | null |
|
|
|||
| StudentNationality2Description | varchar | 30 | √ | null |
|
|
||
| StudentIntendedTertiaryCourseCode | varchar | 15 | √ | null |
|
|
||
| StudentSubSchool | varchar | 15 | √ | null |
|
|
||
| AustudyFlag | bit | 1 | null |
|
|
|||
| StudentEmergencyRelatDesc | varchar | 30 | √ | null |
|
|
||
| StudentEmergency2RelatDesc | varchar | 30 | √ | null |
|
|
||
| StudentEmergency3RelatDesc | varchar | 30 | √ | null |
|
|
||
| StudentNetworkLogin | varchar | 100 | null |
|
|
|||
| StaffID | int | 4 | null |
|
|
|||
| StaffNameInternal | varchar | 100 | √ | null |
|
|
||
| StaffNameExternal | varchar | 100 | √ | null |
|
|
||
| StaffLegalFullName | varchar | 150 | √ | null |
|
|
||
| StaffSurname | varchar | 30 | √ | null |
|
|
||
| StaffPreferredName | varchar | 20 | √ | null |
|
|
||
| StaffPreferredFormal | varchar | 20 | √ | null |
|
|
||
| StaffPreferred | varchar | 20 | √ | null |
|
|
||
| StaffTitle | varchar | 30 | √ | null |
|
|
||
| StaffGiven1 | varchar | 20 | √ | null |
|
|
||
| StaffGiven2 | varchar | 50 | √ | null |
|
|
||
| StaffMailingName | varchar | 100 | √ | null |
|
|
||
| StaffMailNamePrimary | varchar | 100 | √ | null |
|
|
||
| StaffWebSite | varchar | 100 | √ | null |
|
|
||
| StaffMailingAddress | varchar | 200 | √ | null |
|
|
||
| StaffAddressFull | varchar | 200 | √ | null |
|
|
||
| StaffAddressComma | varchar | 200 | √ | null |
|
|
||
| StaffAddressDPID | varchar | 8 | √ | null |
|
|
||
| StaffAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| StaffAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| StaffAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| StaffValidAddressFlag | bit | 1 | √ | null |
|
|
||
| StaffBirthDate | datetime | 16,3 | √ | null |
|
|
||
| StaffOccupPhone | varchar | 15 | √ | null |
|
|
||
| StaffOccupEmail | varchar | 100 | √ | null |
|
|
||
| StaffGender | varchar | 15 | √ | null |
|
|
||
| StaffCampus | varchar | 3 | √ | null |
|
|
||
| StaffCampusDescription | varchar | 30 | √ | null |
|
|
||
| StaffYearLevel | smallint | 2 | √ | null |
|
|
||
| SchoolStaffCode | varchar | 30 | √ | null |
|
|
||
| StaffCategory | varchar | 15 | √ | null |
|
|
||
| StaffCategoryDescription | varchar | 50 | √ | null |
|
|
||
| StaffCategoryType | varchar | 15 | √ | null |
|
|
||
| StaffBuilding | varchar | 15 | √ | null |
|
|
||
| StaffRoom | varchar | 15 | √ | null |
|
|
||
| StaffExtension | varchar | 15 | √ | null |
|
|
||
| StaffDepartment | varchar | 15 | √ | null |
|
|
||
| StaffVoiceMail | varchar | 15 | √ | null |
|
|
||
| StaffForm | varchar | 15 | √ | null |
|
|
||
| StaffRegSchoolsBoardCode | varchar | 15 | √ | null |
|
|
||
| StaffRegistrationNumber | varchar | 15 | √ | null |
|
|
||
| StaffRegistrationType | varchar | 15 | √ | null |
|
|
||
| StaffRegistrationExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| StaffMobilePhone | varchar | 15 | √ | null |
|
|
||
| StaffDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| StaffOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| StaffPhone | varchar | 15 | √ | null |
|
|
||
| ClassDescription | varchar | 100 | null |
|
|
|||
| LearningPathway | varchar | 30 | √ | null |
|
|
Table contained 0 rows