Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RefID | varchar | 32 | √ | null |
|
|
||
| RefIDComingFrom | varchar | 14 | null |
|
|
|||
| StudentPersonalRefId | varchar | 32 | null |
|
|
|||
| LocalID | int | 4 | √ | null |
|
|
||
| SchoolInfoRefID | varchar | 32 | √ | null |
|
|
||
| TimeFrame | varchar | 1 | null |
|
|
|||
| MembershipType | varchar | 2 | null |
|
|
|||
| SchoolYear | int | 4 | √ | null |
|
|
||
| EntryDate | datetime | 16,3 | √ | null |
|
|
||
| YearLevel | varchar | 2 | √ | null |
|
|
||
| HomeGroup | varchar | 30 | null |
|
|
|||
| RecordClosureReason | varchar | 10 | null |
|
|
|||
| ExitDate | datetime | 16,3 | √ | null |
|
|
||
| ExitStatusCode | varchar | 4 | √ | null |
|
|
||
| ExitType | varchar | 4 | null |
|
|
|||
| ExitTypeOtherCodeList | varchar | 20 | √ | null |
|
|
||
| FTE | decimal | 7,2 | null |
|
|
|||
| FTPTStatus | varchar | 2 | null |
|
|
|||
| PreviousSchool | varchar | 20 | √ | null |
|
|
||
| OtherSchool | varchar | 20 | null |
|
|
|||
| OtherSchoolFTE | varchar | 30 | √ | null |
|
|
||
| LivingAtHomeFlag | varchar | 1 | null |
|
|
|||
| NewArrivalFlag | varchar | 1 | null |
|
|
|||
| TransitionalPrep | varchar | 1 | null |
|
|
|||
| SchoolLanguage1Code | varchar | 20 | √ | null |
|
|
||
| SchoolLanguage2Code | varchar | 20 | √ | null |
|
|
||
| SchoolLanguage3Code | varchar | 20 | √ | null |
|
|
||
| EthnicLanguage1Code | varchar | 20 | √ | null |
|
|
||
| EthnicLanguage2Code | varchar | 20 | √ | null |
|
|
||
| EthnicLanguage3Code | varchar | 20 | √ | null |
|
|
||
| VSLLanguage1Code | varchar | 20 | √ | null |
|
|
||
| VSLLanguage2Code | varchar | 20 | √ | null |
|
|
||
| VSLLanguage3Code | varchar | 20 | √ | null |
|
|
||
| DECLanguage1Code | varchar | 20 | √ | null |
|
|
||
| DECLanguage2Code | varchar | 20 | √ | null |
|
|
||
| DECLanguage3Code | varchar | 20 | √ | null |
|
|
||
| PALSLanguage1Code | varchar | 20 | √ | null |
|
|
||
| PALSLanguage2Code | varchar | 20 | √ | null |
|
|
||
| PALSLanguage3Code | varchar | 20 | √ | null |
|
|
||
| OTHERLanguage1Code | varchar | 20 | √ | null |
|
|
||
| OTHERLanguage2Code | varchar | 20 | √ | null |
|
|
||
| OTHERLanguage3Code | varchar | 20 | √ | null |
|
|
||
| GenerateFutureStudentGuidFlag | bit | 1 | √ | null |
|
|
||
| LeavingDate | datetime | 16,3 | √ | null |
|
|
||
| Now | datetime | 16,3 | √ | null |
|
|
||
| CurrentFileYear | smallint | 2 | null |
|
|
|||
| DestinationSchool | varchar | 5 | √ | null |
|
|
Table contained 0 rows