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 |
|
|
|||
| EntryCampus | varchar | 3 | null |
|
|
|||
| EntryYearLevel | smallint | 2 | √ | null |
|
|
||
| EntryDate | datetime | 16,3 | √ | null |
|
|
||
| EntryDateActual | datetime | 16,3 | √ | null |
|
|
||
| StartCampusYear | smallint | 2 | null |
|
|
|||
| PreviousSchool | varchar | 15 | √ | 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 |
|
|
|||
| StudiesCode | varchar | 15 | null |
|
|
|||
| TuitionVariationType | varchar | 3 | null |
|
|
Table contained 0 rows