Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FileYear | smallint | 2 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| Status | varchar | 3 | null |
|
|
|||
| StatusNextYear | varchar | 3 | null |
|
|
|||
| StudentCampus | varchar | 3 | null |
|
|
|||
| YearLevel | smallint | 2 | √ | null |
|
|
||
| YearLevelSort | smallint | 2 | null |
|
|
|||
| House | varchar | 5 | null |
|
|
|||
| Form | varchar | 15 | null |
|
|
|||
| Tutor | varchar | 15 | null |
|
|
|||
| Boarder | varchar | 3 | null |
|
|
|||
| Sports1 | varchar | 15 | null |
|
|
|||
| Sports2 | varchar | 15 | null |
|
|
|||
| LockerBook | varchar | 15 | null |
|
|
|||
| LockerOther | varchar | 15 | null |
|
|
|||
| FamilyPosition | smallint | 2 | null |
|
|
|||
| LeavingDate | datetime | 16,3 | √ | null |
|
|
||
| ReturningDate | datetime | 16,3 | √ | null |
|
|
||
| LeavingReason | varchar | 3 | null |
|
|
|||
| LeavingDestination | varchar | 15 | null |
|
|
|||
| BoardingHouse | varchar | 15 | null |
|
|
|||
| OverrideNextYearLevel | smallint | 2 | √ | null |
|
|
||
| OverrideNextStudentCampus | varchar | 3 | null |
|
|
|||
| OverrideNextBoarder | varchar | 3 | null |
|
|
|||
| SchoolFTE | decimal | 7,2 | null |
|
|
|||
| CalibreMark | decimal | 7,2 | null |
|
|
|||
| TravelAllowanceFlag | bit | 1 | null |
|
|
|||
| SchoolingYearOffset | smallint | 2 | null |
|
|
|||
| LeavingPostSchoolActivityCode | varchar | 15 | null |
|
|
|||
| DestinationRegionCode | varchar | 15 | null |
|
|
|||
| DestinationSchool1Code | varchar | 15 | null |
|
|
|||
| DestinationSchool2Code | varchar | 15 | null |
|
|
|||
| DestinationSchool3Code | varchar | 15 | null |
|
|
|||
| DestinationSchool4Code | varchar | 15 | null |
|
|
|||
| DestinationSchool5Code | varchar | 15 | null |
|
|
|||
| DestinationSchool6Code | varchar | 15 | null |
|
|
|||
| TeachingLearningNotesAcademicFlag | bit | 1 | null |
|
|
|||
| TeachingLearningNotesAttendanceFlag | bit | 1 | null |
|
|
|||
| TeachingLearningNotesBehaviouralFlag | bit | 1 | null |
|
|
|||
| TeachingLearningNotesCustodialFlag | bit | 1 | null |
|
|
|||
| TeachingLearningNotesHealthFlag | bit | 1 | null |
|
|
|||
| TeachingLearningNotesPersonalFlag | bit | 1 | null |
|
|
|||
| IBFlag | bit | 1 | null |
|
|
|||
| NCEALevel1 | varchar | 1 | null |
|
|
|||
| NCEALevel2 | varchar | 1 | null |
|
|
|||
| NCEALevel3 | varchar | 1 | null |
|
|
|||
| Level1LiteracyMet | varchar | 1 | null |
|
|
|||
| Level1NumeracyMet | varchar | 1 | null |
|
|
|||
| UELiteracyMet | varchar | 1 | null |
|
|
|||
| UENumeracyMet | varchar | 1 | null |
|
|
|||
| StudentYearsGUID | varchar | 32 | null |
|
|
|||
| StudentYearsSeq | int identity | 4 | null |
|
|
|||
| SIF3RefID | uniqueidentifier | 16 | √ | null |
|
|
||
| LearningPathway | varchar | 30 | null |
|
|
Table contained 0 rows