Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
DisabilityAdjustmentSeq | int | 4 | null |
|
|
|||
ID | int | 4 | null |
|
|
|||
Surname | varchar | 30 | √ | null |
|
|
||
Given1 | varchar | 20 | √ | null |
|
|
||
Given2 | varchar | 50 | √ | null |
|
|
||
Preferred | varchar | 20 | √ | null |
|
|
||
BirthDate | datetime | 16,3 | √ | null |
|
|
||
FileYear | smallint | 2 | √ | null |
|
|
||
Form | varchar | 15 | √ | null |
|
|
||
Tutor | varchar | 15 | √ | null |
|
|
||
House | varchar | 5 | √ | null |
|
|
||
EducationType | varchar | 15 | √ | null |
|
|
||
PrimaryEducationFlag | bit | 1 | √ | null |
|
|
||
SecondaryEducationFlag | bit | 1 | √ | null |
|
|
||
DisabilityCategoryCode | varchar | 15 | null |
|
|
|||
DisabilityCategory | varchar | 100 | √ | null |
|
|
||
DisabilityCategorySynergyMeaning | varchar | 15 | √ | null |
|
|
||
DisabilityAdjustmentLevelCode | varchar | 15 | null |
|
|
|||
DisabilityAdjustmentLevel | varchar | 100 | √ | null |
|
|
||
DisabilityAdjustmentLevelSynergyMeaning | varchar | 15 | √ | null |
|
|
||
DisabilityAdjustmentLevelSortOrder | int | 4 | √ | null |
|
|
||
IncludeInExportFlag | bit | 1 | null |
|
|
|||
IdentifiedNeeds | varchar | 2147483647 | √ | null |
|
|
||
AdjustmentsMade | varchar | 2147483647 | √ | null |
|
|
||
StartDate | datetime | 16,3 | √ | null |
|
|
||
ReviewDate | datetime | 16,3 | √ | null |
|
|
||
EndDate | datetime | 16,3 | √ | null |
|
|
||
Consultation | varchar | 2147483647 | √ | null |
|
|
||
Review | varchar | 2147483647 | √ | null |
|
|
||
CurrentDisabilityFlag | bit | 1 | √ | null |
|
|
||
CreatedByID | int | 4 | √ | null |
|
|
||
CreatedDate | datetime | 16,3 | √ | null |
|
|
||
ModifiedByID | int | 4 | √ | null |
|
|
||
ModifiedDate | datetime | 16,3 | √ | null |
|
|
Table contained 0 rows