Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| FileYear | smallint | 2 | ((0)) |
|
|
|||||
| ID | int | 4 | null |
|
|
|||||
| Status | varchar | 3 | ('') |
|
|
|||||
| StatusNextYear | varchar | 3 | ('') |
|
|
|||||
| StudentCampus | varchar | 3 | ('') |
|
|
|||||
| YearLevel | smallint | 2 | √ | null |
|
|
||||
| YearLevelSort | smallint | 2 | ((0)) |
|
|
|||||
| House | varchar | 5 | ('') |
|
|
|||||
| Form | varchar | 15 | ('') |
|
|
|||||
| Tutor | varchar | 15 | ('') |
|
|
|||||
| Boarder | varchar | 3 | ('') |
|
|
|||||
| Sports1 | varchar | 15 | ('') |
|
|
|||||
| Sports2 | varchar | 15 | ('') |
|
|
|||||
| LockerBook | varchar | 15 | ('') |
|
|
|||||
| LockerOther | varchar | 15 | ('') |
|
|
|||||
| FamilyPosition | smallint | 2 | ((0)) |
|
|
|||||
| LeavingDate | datetime | 16,3 | √ | null |
|
|
||||
| ReturningDate | datetime | 16,3 | √ | null |
|
|
||||
| LeavingReason | varchar | 3 | ('') |
|
|
|||||
| LeavingDestination | varchar | 15 | ('') |
|
|
|||||
| BoardingHouse | varchar | 15 | ('') |
|
|
|||||
| OverrideNextYearLevel | smallint | 2 | √ | null |
|
|
||||
| OverrideNextStudentCampus | varchar | 3 | ('') |
|
|
|||||
| OverrideNextBoarder | varchar | 3 | ('') |
|
|
|||||
| SchoolFTE | decimal | 7,2 | ((1)) |
|
|
|||||
| CalibreMark | decimal | 7,2 | ((0)) |
|
|
|||||
| TravelAllowanceFlag | bit | 1 | ((0)) |
|
|
|||||
| SchoolingYearOffset | smallint | 2 | ((0)) |
|
|
|||||
| LeavingPostSchoolActivityCode | varchar | 15 | ('') |
|
|
|||||
| DestinationRegionCode | varchar | 15 | ('') |
|
|
|||||
| DestinationSchool1Code | varchar | 15 | ('') |
|
|
|||||
| DestinationSchool2Code | varchar | 15 | ('') |
|
|
|||||
| DestinationSchool3Code | varchar | 15 | ('') |
|
|
|||||
| DestinationSchool4Code | varchar | 15 | ('') |
|
|
|||||
| DestinationSchool5Code | varchar | 15 | ('') |
|
|
|||||
| DestinationSchool6Code | varchar | 15 | ('') |
|
|
|||||
| TeachingLearningNotesAcademicFlag | bit | 1 | ((0)) |
|
|
|||||
| TeachingLearningNotesAttendanceFlag | bit | 1 | ((0)) |
|
|
|||||
| TeachingLearningNotesBehaviouralFlag | bit | 1 | ((0)) |
|
|
|||||
| TeachingLearningNotesCustodialFlag | bit | 1 | ((0)) |
|
|
|||||
| TeachingLearningNotesHealthFlag | bit | 1 | ((0)) |
|
|
|||||
| TeachingLearningNotesPersonalFlag | bit | 1 | ((0)) |
|
|
|||||
| IBFlag | bit | 1 | ((0)) |
|
|
|||||
| NCEALevel1 | varchar | 1 | ('') |
|
|
|||||
| NCEALevel2 | varchar | 1 | ('') |
|
|
|||||
| NCEALevel3 | varchar | 1 | ('') |
|
|
|||||
| Level1LiteracyMet | varchar | 1 | ('') |
|
|
|||||
| Level1NumeracyMet | varchar | 1 | ('') |
|
|
|||||
| UELiteracyMet | varchar | 1 | ('') |
|
|
|||||
| UENumeracyMet | varchar | 1 | ('') |
|
|
|||||
| StudentYearsGUID | varchar | 32 | ('') |
|
|
|||||
| StudentYearsSeq | int | 4 | √ | null |
|
|
||||
| LearningPathway | varchar | 30 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PastStudentYears | Primary key | Asc/Asc | ID + FileYear |
Relationships
Close relationships within degrees of separation
