Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Seq | int identity | 4 | √ | null |
|
|
||
| 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 |
|
|
||
| ModifiedDate | datetime | 16,3 | (getdate()) |
|
|
|||
| ModifiedBy | varchar | 50 | ('') |
|
|
|||
| SystemProcessNumber | int | 4 | √ | null |
|
|
||
| SchoolingYearOffset | smallint | 2 | √ | null |
|
|
||
| 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 |
|
|
||
| SIF3RefID | uniqueidentifier | 16 | √ | null |
|
|
||
| LearningPathway | varchar | 30 | ('') |
|
|
|||
| TransactionMode | char | 1 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| AK_StudentYearsHistory_ID_includes | Performance | Asc | ID |
| AK_StudentYearsHistory_StudentFileYearID | Performance | Asc/Asc | FileYear + ID |