Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FileType | varchar | 5 | null |
|
|
|||
| FileYear | smallint | 2 | null |
|
|
|||
| FileSemester | smallint | 2 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| ClassCampus | varchar | 3 | null |
|
|
|||
| ClassCode | varchar | 15 | null |
|
|
|||
| ClassCodeFull | varchar | 19 | null |
|
|
|||
| ClassDescription | varchar | 100 | null |
|
|
|||
| AssessmentCode | varchar | 15 | null |
|
|
|||
| ResultTypeSynergyMeaning | varchar | 30 | null |
|
|
|||
| ResultTypeNCEAFlag | bit | 1 | √ | null |
|
|
||
| StandardNumber | int | 4 | null |
|
|
|||
| StandardVersion | int | 4 | null |
|
|
|||
| StandardLanguage | varchar | 1 | null |
|
|
|||
| StandardNumberFull | varchar | 16 | √ | null |
|
|
||
| AreaSeq | smallint | 2 | null |
|
|
|||
| Result | varchar | 30 | null |
|
|
|||
| NCEAResult | varchar | 30 | √ | null |
|
|
||
| NCEAResultValidFlag | bit | 1 | √ | null |
|
|
||
| ResultClassification | varchar | 15 | null |
|
|
|||
| WithdrawnFlag | bit | 1 | √ | null |
|
|
||
| ResultDate | datetime | 16,3 | √ | null |
|
|
||
| ResultDateNotNULL | datetime | 16,3 | null |
|
|
|||
| IndigenousPaperFlag | bit | 1 | null |
|
|
|||
| IndigenousAnswerFlag | bit | 1 | null |
|
|
|||
| AssessmentRequestType | varchar | 5 | 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 |
|
|
|||
| StandardAssessmentRequestIndicatorDescription | varchar | 40 | √ | null |
|
|
||
| NZQAExportFlag | int | 4 | 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 |
|
|
||
| ResultCredits | int | 4 | null |
|
|
|||
| AssessableFlag | bit | 1 | null |
|
|
|||
| StudentAssessmentResultsSeq | int | 4 | null |
|
|
|||
| Heading | varchar | 255 | null |
|
|
|||
| ShortCourseFlag | bit | 1 | null |
|
|
Table contained 0 rows