Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FileYear | smallint | 2 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| StandardNumber | int | 4 | null |
|
|
|||
| StandardVersion | int | 4 | null |
|
|
|||
| StandardLanguage | varchar | 1 | null |
|
|
|||
| StandardNumberFull | varchar | 16 | √ | null |
|
|
||
| Result | varchar | 3 | null |
|
|
|||
| DateCompleted | datetime | 16,3 | √ | null |
|
|
||
| WithdrawnFlag | bit | 1 | null |
|
|
|||
| TeReoPaperFlag | bit | 1 | √ | null |
|
|
||
| TeReoAnswerFlag | bit | 1 | √ | null |
|
|
||
| AssessmentRequestType | varchar | 5 | null |
|
|
|||
| ProviderCode | varchar | 15 | null |
|
|
|||
| ProviderDescription | varchar | 100 | √ | null |
|
|
||
| ProviderExternalSystemCode | varchar | 15 | √ | null |
|
|
||
| ProviderExternalSystemLocationCode | varchar | 15 | √ | null |
|
|
||
| ContextCode | varchar | 15 | null |
|
|
|||
| ContextDescription | varchar | 100 | √ | null |
|
|
||
| ContextNCEAStandards | varchar | 255 | √ | null |
|
|
||
| ContextCodeExternal | varchar | 20 | √ | null |
|
|
||
| StandardType | varchar | 1 | null |
|
|
|||
| StandardTitle | varchar | 255 | √ | null |
|
|
||
| StandardLevel | int | 4 | null |
|
|
|||
| StandardCredits | int | 4 | null |
|
|
|||
| StandardFieldCode | int | 4 | null |
|
|
|||
| StandardFieldName | varchar | 60 | null |
|
|
|||
| StandardSubfieldCode | int | 4 | null |
|
|
|||
| StandardSubfieldName | varchar | 60 | null |
|
|
|||
| StandardDomainCode | int | 4 | null |
|
|
|||
| StandardDomainName | varchar | 60 | null |
|
|
|||
| StandardL1Numeracy | varchar | 1 | null |
|
|
|||
| StandardL1Literacy | varchar | 1 | null |
|
|
|||
| StandardUENumeracy | varchar | 1 | null |
|
|
|||
| StandardUELiteracyRead | varchar | 1 | null |
|
|
|||
| StandardUELiteracyWrite | varchar | 1 | null |
|
|
|||
| StandardAssessmentOption | varchar | 1 | null |
|
|
|||
| StandardUEMaoriLiteracyRead | varchar | 1 | null |
|
|
|||
| StandardUEMaoriLiteracyWrite | varchar | 1 | null |
|
|
|||
| StandardMeritPermissible | varchar | 1 | null |
|
|
|||
| StandardTranslatedPaperAvailable | varchar | 1 | null |
|
|
|||
| StandardTeReoAnswerPermissable | varchar | 1 | null |
|
|
|||
| StandardContext | varchar | 1 | null |
|
|
|||
| StandardLastAssessmentDate | datetime | 16,3 | √ | null |
|
|
||
| StandardAssessmentRequestIndicator | varchar | 2 | null |
|
|
|||
| AssessmentCode | varchar | 15 | null |
|
|
|||
| CourseEndorsementCode | varchar | 2 | null |
|
|
Table contained 0 rows