Import 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:
1	Standard 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 Current Student Maintenance - NCEA tab.
2	Standard Version	DAS Standard Version number Example: 3

		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 Current Student Maintenance - NCEA tab.
3	Standard Type	U=Unit Standard A=Achievement Standard S = Scholarship

		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 Current Student Maintenance - NCEA tab.
4	Standard Title	Title of Standard

		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 Current Student Maintenance - NCEA tab
5	Level	Level of Standard Example: 3

		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 Current Student Maintenance - NCEA tab
6	Credits

		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. Current Student Maintenance - NCEA tab
7	Field Code	DAS Field code of Standard Example: 72

		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. Current Student Maintenance - NCEA tab
8	Field Name	DAS Field name of Standard

		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. Current Student Maintenance - NCEA tab
9	Subfield Code	DAS Sub-field code of Standard Example: 299

		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. Current Student Maintenance - NCEA tab
10	Subfield Name	DAS Sub-field name of Standard

		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. Current Student Maintenance - NCEA tab
11	Domain Code	DAS Domain code of Standard Example: 1059

		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
12	Domain Name	DAS Domain name of Standard

		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. Current Student Maintenance - NCEA tab
13	L1 Numeracy	Indicates if the standard counts towards Level 1 Numeracy Values: C = Corequisite T = Numeracy Transition List N = Not Applicable

		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. Current Student Maintenance - NCEA tab
14	L1 Literacy	Indicates if the standard counts towards Level 1 Literacy Values: C = Corequisite T = Literacy Transition List Only M = Te Reo Matatini Transition List Only X = Standard is on both Literacy and Te Reo Matatini Transition Lists N = Not Applicable

		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. Current Student Maintenance - NCEA tab
15	Assessment Method	Indicates the assessment method of the Standard Values I=Internally assessed E=Externally assessed

		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. Current Student Maintenance - NCEA tab
16	Achieved/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)

		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. Current Student Maintenance - NCEA tab
17	Translated Paper Available	Indicates if a translated exam paper is available for a Standard Values:Y / N

		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. Current Student Maintenance - NCEA tab
18	Answer in Te Reo Māori	Indicates if a standard can be answered in te reo Māori, including internally assessed standards Values: Y / N

		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. Current Student Maintenance - NCEA tab
19	Context	Indicates if a standard must have a context Values: Y / N

		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. Current Student Maintenance - NCEA tab
20	Last Assessment Date	Indicates last assessment date of standard version Format: dd/mm/ccyy

		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. Current Student Maintenance - NCEA tab
21	UE Numeracy	Indicates if the standard counts towards UE numeracy Values: A = (unit stds) 26623,26626 and 26627 only B = (new Achievement stds (AS) only N = Not applicable

		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. Current Student Maintenance - NCEA tab
22	UE Literacy Read	Indicates UE Literacy Read standard Values: Y / N

		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. Current Student Maintenance - NCEA tab
23	UE Literacy Write	Indicates UE Literacy Write standard Values: Y / N

		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. Current Student Maintenance - NCEA tab
24	UE Māori Literacy Read	Indicates UE Māori Literacy Read standard Values: Y / N

		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. Current Student Maintenance - NCEA tab
25	UE Māori Literacy Write	Indicates UE Māori Literacy Write standard Values: Y / N

		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. Current Student Maintenance - NCEA tab
26	Assessment 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.

		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. Current Student Maintenance - NCEA tab
27	Assessment Session Code	Indicates the assessment session for each externally assessed standard. This includes non-exam-based external assessment. Example: L1-CHEM

		Not currently imported.
28	Digital Practice Exam Available	Indicates if an externally assessed digital exam standard is available for Digital Practice Exam Values: Y/N

		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. Current Student Maintenance - NCEA tab
29	Assessment Opportunities	Indicates the maximum number of assessment opportunities available for externally assessed standards.

		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. Current Student Maintenance - NCEA tab

-	Standard Language	Standard 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.