Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt
nameImport Standards File

The following lists the fields of the NZQA Standards file and their database import destination in Synergetic, and where they can then be seen within Synergetic post-import.

Column

Heading

(NZQA Field Name)

NZQA Comments: 
1Standard Number

DAS Standard number

Example: *5340*
Configuration

Field is imported into the the Synergetic Database field StandardNumber of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Number field of 

Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.
See   See Current Student Maintenance - NCEA tab.

2Standard Version

DAS Standard Version number

Example: *3*
Configuration

Field is imported into the the Synergetic Database field StandardVersion of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Version field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.See   See Current Student Maintenance - NCEA tab.

3Standard Type

U=Unit Standard
A=Achievement Standard
S = Scholarship

Configuration

Field is imported into the the Synergetic Database field StandardType of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Type field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window. See Current Student Maintenance - NCEA tab.See   See Current Student Maintenance - NCEA tab.

4Standard TitleTitle of Standard
Configuration

Field is imported into the the Synergetic Database field StandardTitle of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Title field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.See   See Current Student Maintenance - NCEA tab

5Level

Level of Standard

Example: *3*
Configuration

Field is imported into the the Synergetic Database field Level of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Level field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.See   See Current Student Maintenance - NCEA tab

6Credits
Configuration

Field is imported into the the Synergetic Database field Credits of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Credits field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

7Field Code

DAS Field code of Standard

Example: *72*
Configuration

Field is imported into the the Synergetic Database field FieldCode of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Field Code field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

8Field NameDAS Field name of Standard
Configuration

Field is imported into the the Synergetic Database field FieldName of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Field Name field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

9Subfield Code

DAS Sub-field code of Standard

Example: *299*
Configuration

Field is imported into the the Synergetic Database field SubfieldCode of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Subfield Code field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

10Subfield NameDAS Sub-field name of Standard
Configuration

Field is imported into the the Synergetic Database field SubfieldName of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Subfield Name field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

11Domain Code

DAS Domain code of Standard

Example: *1059*
Configuration

Field is imported into the the Synergetic Database field DomainCode of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Domain Code field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.

Current Student Maintenance - NCEA tab

12Domain NameDAS Domain name of Standard
Configuration

Field is imported into the the Synergetic Database field DomainName of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Domain Name field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

13L1 Numeracy

Indicates if the standard counts towards Level 1 Numeracy

Values:

C = Corequisite
T = Numeracy Transition List
T R = Transition List (Restricted Usage)
N = Not Applicable

Configuration

Field is imported into the the Synergetic Database field L1Numeracy of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the L1 Numeracy field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

14L1 Literacy

Indicates if the standard counts towards Level 1 Literacy
Values:
C = CorequisiteT = Transition List (both NZC and Te Reo Matatini)
T NZC = Literacy Transition List Only
M T TRM = Te Reo Matatini Transition List Only
X = Standard is on both Literacy and T R = Transition List (Restricted Usage)
C NZC = NZC Corequisite
C TRM = Te Reo Matatini Transition ListsCorequsite
N = Not Applicable

Configuration

Field is imported into the the Synergetic Database field L1Literacy of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the L1 Literacy field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

15Assessment Method

Indicates the assessment method of the Standard

Values
I=Internally assessed

E=Externally assessed
Configuration

Field is imported into the the Synergetic Database field AssessmentOption of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Assessment Option field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

16Achieved/Merit/Excellence Permissible

Indicates the maximum result allowable for a Standard.

Values:

N (Not Applicable) e.g. Scholarship
A (Achieved) 
M (Achieved with Merit)
E (Achieved with Excellence)

Configuration

Field is imported into the the Synergetic Database field MeritPermissible of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Merit Permissible field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

17Translated Paper Available

Indicates if a translated exam paper is available for a Standard

Values:Y / N
Configuration

Field is imported into the the Synergetic Database field TranslatedPaperAvailable of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Translated Paper Available field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

18Answer in Te Reo Māori

Indicates if a standard can be answered in te reo Māori, including internally assessed standards

Values: Y / N
Configuration

Field is imported into the the Synergetic Database field TeReoAnswerPermissable of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Te Reo Answer Permissable field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

19Context

Indicates if a standard must have a context

Values: Y / N

Configuration

Field is imported into the the Synergetic Database field Context of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Context field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

20Last Assessment Date

Indicates last assessment date of standard version

Format: dd/mm/ccyy
Configuration

Field is imported into the the Synergetic Database field LastAssessmentDate of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the LastAssessmentDate field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

21UE Numeracy

Indicates if the standard counts towards UE numeracyNumeracy

Values:

C = Corequisite
A = (unit stds) 26623,26626 and 26627 only
B = (new Achievement stds (AS) onlyT = Numeracy Transition List
T R = Transition List (Restricted Usage)
N = Not

applicable

Applicable

Configuration

Field is imported into the the Synergetic Database field UENumeracy of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the UE Numeracy field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

22UE Literacy Read

Indicates UE Literacy Read standard

Values: Y / N
Configuration

Field is imported into the the Synergetic Database field UELiteracyRead of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the UELiteracyRead field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

23UE Literacy Write

Indicates UE Literacy Write standard
Values: Y / N

Configuration

Field is imported into the the Synergetic Database field UELiteracyWrite of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the UE Literacy Write field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

24UE Māori Literacy Read

Indicates UE Māori Literacy Read standard

Values: Y / N
Configuration

Field is imported into the the Synergetic Database field UEMaoriLiteracyRead of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the UE Maori Literacy Read field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

25UE Māori Literacy Write

Indicates UE Māori Literacy Write standard

Values: Y / N
Configuration

Field is imported into the the Synergetic Database field UEMaoriLiteracyWrite of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the UE Maori Literacy Write field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

26Assessment Request Indicator

Indicates available types for the given standard and assessment opportunity.
Example: 1=DE|PE;2=DE|PE;3=DS

Available Assessment Request Types:
DE = Digital Exam
PE = Paper Exam
DS = Digital Submission
PS = Physical Submission

The first Assessment Request Type should be the default available to schools.

Configuration

Field is imported into the the Synergetic Database field AssessmentRequestIndicator of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Assessment Request Indicator field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

27Assessment Session Code

Indicates the assessment session for each externally assessed standard.

This includes non-exam-based external assessment.

Example: *L1-CHEM*
Configuration

Not currently imported.Field is imported into the the Synergetic Database field AssessmentSessionCode of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Assessment Session Code field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

28Digital Practice Exam Available

Indicates if an externally assessed digital exam standard is available for Digital Practice Exam

Values: Y/N
Configuration

Field is imported into the the Synergetic Database field Digital Practice Exam of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Digital Practice Exam field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab

29Assessment Opportunities


Indicates the maximum number of assessment opportunities available for externally assessed standards.

Configuration

Field is imported into the the Synergetic Database field AssessmentOpportunities of table dbo.SubjectAssessmentNCEAStandards, and is visible in Synergetic in the Assessment Opportunities field of Current Student Maintenance > Select Standard row … Std > NCEA Standard Window.  See Current Student Maintenance - NCEA tab


30Excluded StandardsIndicates which other standards the given standard has an exclusion pair with. If more than one exists, they are separated by a “|” character.
For more information about exclusions please see our website: https://www2.nzqa.govt.nz/ncea/subjects/standards-exclusion-list/



-Standard LanguageStandard Language was removed by NZQA years ago and no longer appears in the Standards Import File but the field still exists in dbo.SubjectAssessmentNCEAStandards for historical purposes.



...