Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RefID | varchar | 32 | null |
|
|
|||
| LocalID | int | 4 | null |
|
|
|||
| GivenName | varchar | 20 | null |
|
|
|||
| MiddleName | varchar | 50 | null |
|
|
|||
| FamilyName | varchar | 30 | null |
|
|
|||
| PreferredGivenName | varchar | 20 | null |
|
|
|||
| AddressType | varchar | 4 | null |
|
|
|||
| AddressRole | varchar | 4 | null |
|
|
|||
| Line1 | varchar | 250 | √ | null |
|
|
||
| ApartmentNumber | varchar | 25 | √ | null |
|
|
||
| StreetNumber | varchar | 25 | √ | null |
|
|
||
| Complex | varchar | 50 | √ | null |
|
|
||
| StreetName | varchar | 50 | √ | null |
|
|
||
| StreetType | varchar | 15 | √ | null |
|
|
||
| City | varchar | 40 | √ | null |
|
|
||
| PostalCode | varchar | 5 | √ | null |
|
|
||
| StateProvince | varchar | 5 | √ | null |
|
|
||
| Sex | varchar | 1 | null |
|
|
|||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| CountryOfBirth | varchar | 20 | null |
|
|
|||
| IndigenousStatus | varchar | 1 | null |
|
|
|||
| IntegrationAide | varchar | 1 | null |
|
|
|||
| HomeLanguageCode | varchar | 100 | √ | null |
|
|
||
| DwellingArrangement | varchar | 4 | null |
|
|
|||
| ReligionType | varchar | 20 | √ | null |
|
|
||
| ReligionOtherCodeset | varchar | 5 | √ | null |
|
|
||
| ReligionOtherCode | varchar | 20 | √ | null |
|
|
||
| ReligiousRegion | varchar | 20 | √ | null |
|
|
||
| ImmunisationCertificateStatus | varchar | 20 | null |
|
|
|||
| VisaStatisticalCode | varchar | 2 | null |
|
|
|||
| VisaSubClass | varchar | 15 | √ | null |
|
|
||
| VisaExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| EconomicDisadvantage | varchar | 1 | null |
|
|
|||
| FirstAUSchoolEnrollment | datetime | 16,3 | √ | null |
|
|
||
| TravelModeToSchool | varchar | 20 | √ | null |
|
|
||
| TravelToSchoolDetails | varchar | 255 | √ | null |
|
|
||
| AccompanimementToSchool | varchar | 1 | √ | null |
|
|
||
| DateUpdatedTMToSchool | nvarchar | 200 | √ | null |
|
|
||
| TravelModeFromSchool | varchar | 20 | √ | null |
|
|
||
| TravelModeFromSchoolDetails | varchar | 255 | √ | null |
|
|
||
| AccompanimementFromSchool | varchar | 1 | √ | null |
|
|
||
| DateUpdatedTMFromSchool | nvarchar | 200 | √ | null |
|
|
||
| P1Language | varchar | 100 | √ | null |
|
|
||
| P2Language | varchar | 100 | √ | null |
|
|
||
| P1EmploymentType | varchar | 20 | √ | null |
|
|
||
| P2EmploymentType | varchar | 20 | √ | null |
|
|
||
| P1SchoolEducationLevel | int | 4 | null |
|
|
|||
| P2SchoolEducationLevel | int | 4 | null |
|
|
|||
| P1NonSchoolEducation | varchar | 20 | √ | null |
|
|
||
| P2NonSchoolEducation | varchar | 20 | √ | null |
|
|
||
| FileYear | smallint | 2 | √ | null |
|
|
||
| LeavingDate | datetime | 16,3 | √ | null |
|
|
||
| VSN | varchar | 15 | √ | null |
|
|
||
| MostRecentYearlevel | smallint | 2 | √ | null |
|
|
Table contained 0 rows