Page Comparison

• This value records the Date and Time the file was created. 
• This value has a maximum field length of 19.
• This value has the Type Date-Time
• This value has the format YYYY-MM-DDTHH:MM:SS

• This value is defined using the Year field on the NZQA tab of Student Data Import/Export… window.  See below.
• This value has a maximum field length of 4.
• This value has the Type Integer
• This value has the format YYYY.

Software ID for Synergetic provided by NZQA, for Synergetic is 525

• This value is hardcoded, and is the Unique identifier for an SMS, available on request from NZQA (Synergetic = 525)
• This value has a maximum field length of 3.
• This value has the Type N as defined by NZQA

• The version number of Synergetic that the school is running
• This value has a maximum field length of 60.
• This value has the Type Alphanumeric.

• This value is defined using the Configuration Key field Students|DataExport|NZQA|ExportResults|DefaultProviderCode. See Configuration File Maintenance window.
• This value has a maximum field length of 5.
• This value has the Type N as defined by NZQA

• This value is defined using the Configuration Key field Students|DataExport|NZQA|ExportResults|DefaultProviderLocationCode. See Configuration File Maintenance window.
• This value has a maximum field length of 2.
• This value has the Type N as defined by NZQA

(Course Details)

FileTypeCode

(This is actually an attribute of the SecondaryCourses element)

File Type Code - Secondary Courses File type

• This value is hard-coded as FR
• This value has a maximum field length of 2.
• This value has the Type Alphanumeric.

Secondary Course Number

A unique number that identifies a secondary course.  Optional but must be supplied if Secondary Course Name is supplied

• This value is defined using the Assessment Code (Code) field of Subject Area Assessment Maintenance. See Maintaining subject assessments.
• This value has a maximum field length of 10.
• This value has the Type Alphanumeric.

• This value is defined using the Assessment Heading (Heading) field of Subject Area Assessment Maintenance. See Maintaining subject assessments.
• This value has a maximum field length of 60.
• This value has the Type Alphanumeric.

Short Course Indicator

Indicator to advise NZQA that course does not have sufficient credits for endorsement

• • This field value is defined using the Short Course field of Subject Area Assessment Maintenance. See Maintaining subject assessments.
  • This field has Has the values: 1, 0, True, False
  • This value has a maximum field length of 5.
  • This value has the Type Alphanumeric.

File Type Code - Learner Enrolment File Type 

• This value is always FR (Full Replacement)
• This value has a maximum field length of 2.
• This value has the Type Alphanumeric.

• Value examples, eg: 0123456789 or 123456789 leading 0 optional.  No separators eg: ‘-’ or ‘/’
  Ref: MoE 2021 SMS Roll Returns Page 45
• This value is defined using the NSN field of the NZMOE or Codes tabs in Current Student Maintenance. See Current Student Maintenance - NZMOE tab or Current Student Maintenance - Codes tab.
• This value has a maximum field length of 10.
• This value has the Type N as defined by NZQA

Community ID.

• School’s own unique student id, example: ABC4880
  Ref: MoE 2021 SMS Roll Returns Page 51
• This value is defined using the ID field of Community Maintenance. See Community.
• This value has a maximum field length of 10.
• This value has the Type Alphanumeric.

• Ref: MoE 2021 SMS Roll Returns Page 51
• This value is defined using the Given 1 field of the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This value has a maximum field length of 60.
• This value has the Type Alphanumeric.

• Ref: MoE 2021 SMS Roll Returns Page 51
• This value is defined using the Given 2 field of the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This value has a maximum field length of 30.
• This value has the Type Alphanumeric.

• Ref: MoE 2021 SMS Roll Returns Page 51
• This value is defined using the Given 2 field of the Name tab of Community Maintenance. See Community Maintenance - Name tab.
  Given 2 is broken into two names if there is space in it.
• This value has a maximum field length of 30.
• This value has the Type Alphanumeric.

• Ref: MoE 2021 SMS Roll Returns Page 51
• This value is defined using the Surname field of the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This value has a maximum field length of 60.
• This value has the Type Alphanumeric.

• ValuesHas the values: M or F
  Ref: MoE 2021 SMS Roll Returns Page 42
• This value is defined using the Gender field of the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This value has a maximum field length of 1.
• This value has the Type Alphanumeric.

• This value is defined using the Date of Birth field of the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This value has Format of YYYY-MM-DD
  Example: 1989-05-19
• This value has a maximum field length of 10.
• This value has the Type Date.

• Example: 111
  Ref: MoE 2021 SMS Roll Returns Page 42,43
• This value is defined using the Ethnic Group 1 field of the NZMOE tab in Current Student Maintenance. See Current Student Maintenance - NZMOE tab.
• This value has a maximum field length of 5.
• This value has the Type N as defined by NZQA

• Example: 211
  Ref: MoE 2021 SMS Roll Returns Page 42,43
• This value is defined using the Ethnic Group 2 field of the NZMOE tab in Current Student Maintenance. See Current Student Maintenance - NZMOE tab.
• This value has a maximum field length of 5.
• This value has the Type N as defined by NZQA

• Example: 421
  Ref: MoE 2021 SMS Roll Returns Page 39
• This value is defined using the Ethnic Group 3 field of the NZMOE tab in Current Student Maintenance. See Current Student Maintenance - NZMOE tab.
• This value has a maximum field length of 5.
• This value has the Type N as defined by NZQA

• Example: 0101
  Ref: MoE 2021 SMS Roll Returns Page 42
• This value is defined using the IWI 1 field of the NZMOE tab in Current Student Maintenance. See Current Student Maintenance - NZMOE tab.
• This value has a maximum field length of 4.
• This value has the Type N as defined by NZQA

• Example: .0809
  Ref: MoE 2021 SMS Roll Returns Page 42
• This value is defined using the IWI 2 field of the NZMOE tab in Current Student Maintenance. See Current Student Maintenance - NZMOE tab.
• This value has a maximum field length of 4.
• This value has the Type N as defined by NZQA

• Example: 1004
  Ref: MoE 2021 SMS Roll Returns Page 342
• This value is defined using the IWI 3 field of the NZMOE tab in Current Student Maintenance. See Current Student Maintenance - NZMOE tab.
• This value has a maximum field length of 4.
• This value has the Type N as defined by NZQA

• Ref: MoE 2021 SMS Roll Returns Page 36
• This value is defined using the Country of Citizenship field of the NZMOE tab in Current Student Maintenance. See Current Student Maintenance - NZMOE tab.
• This value has a maximum field length of 3.
• This value has the Type Alphanumeric.

• This value is defined as per the Note below.
• This value has a maximum field length of 40.
• This value has the Type Alphanumeric.

Note:  

Override Address
If Students > Current Student Maintenance > NZQA > Override Address (for Export Only) is ticked Address comes from the Address field of NZQA tab. (ignore next cases.)

See: Current Student Maintenance - NZQA tab

Whose Address?
If the Configuration Key: Students | DataExport | NZQA | AddressContact = SC1 then the Primary Contact's Address is used
If the Configuration Key: Students | DataExport | NZQA | AddressContact is left blank then the highest "Lives With" Contact's Address is used 

See: Configuration File Maintenance window

Which Address?
If Students | DataExport | NZQA | AddressType = H then Home Address is used, otherwise Postal Address.

See: Configuration File Maintenance window and Community Maintenance - Home Address tab or Community Maintenance - Postal Address tab

• This value is defined as per the Note above.
• This value has a maximum field length of 40.
• This value has the Type Alphanumeric.

• This value is defined as per the Note above.
• This value has a maximum field length of 40.
• This value has the Type Alphanumeric.

• This value is defined as per the Note above.
• This value has a maximum field length of 40.
• This value has the Type Alphanumeric.

• This value is defined as per the Note above.
• This value has a maximum field length of 4.
• This value has the Type N as defined by NZQA

• This value is defined using the EntryDate field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
• This value has Format of YYYY-MM-DD
  Example: 2021-05-13
• This value has a maximum field length of 10.
• This value has the Type Date.

• This value is defined using the Withdrawn field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
• Has the values: 1, 0, True, False
• This value has a maximum field length of 5.
• This value has the Type Alphanumeric.

• This value is defined using the Student Type field of the NZMOE tab in Current Student Maintenance. See Current Student Maintenance - NZMOE tab.
  Example: FF….
  Ref: MoE 2021 SMS Roll Returns Page 52
• This value has a maximum field length of 6.
• This value has the Type Alphanumeric.

• This value is defined using the Tertiary Release field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
• Has the values: 1, 0, True, False
• This value has a maximum field length of 5.
• This value has the Type Alphanumeric.

• The source of this value is defined using the ExportSortKey field of luYearLevel in Lookup Tables Maintenance. See Lookup Table Maintenance window.
  Default = Form        See: Current Student Maintenance - School tab
  Example: 13AB
• Sort order for admission slips
  Often form class of student
• This value has a maximum field length of 6.
• This value has the Type Alphanumeric.

• This value is defined using the Payment Amount field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
  Example: 375.00
• This value has a maximum field length of 8.
• This value has the Type N as defined by NZQA

• This value is defined using the Leaving Date field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
• This value has a maximum field length of 10.
• This value has Format of YYYY-MM-DD
  Example: 2021-09-06
• This value has the Type Date

• This value is defined using the Leaving Reason field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
• This value has a maximum field length of 1.
• This value has the Type Alphanumeric.

MoE Provider Number of school

• Note: Synergetic does not provide because for the non-Synergetic Schools: Correspondence School and Westmount use only
  Example: 75
• Optional but mandatory if Provider location number is suppled
• This value has a maximum field length of 5.
• This value has the Type Alphanumeric.

• Note: Synergetic does not provide because for the non-Synergetic Schools: Correspondence School and Westmount use only
  Example: 01
• Optional but mandatory if Provider location number is suppled
• This value has a maximum field length of 2.
• This value has the Type Alphanumeric.

• This value is defined using the Financial Assistance Type field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
  Values:

B = Benefit
I = Income
F= Family

• This value has a maximum field length of 1.
• This value has the Type Alphanumeric.

• This value is defined using the Benefit Number field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
• This value has a maximum field length of 15.
• This value has the Type Alphanumeric.

• This value is defined using the Number of Siblings (Candidate Count) field of the NZQA tab of Current Student Maintenance. See Current Student Maintenance - NZQA tab.
  Example: 2
• This value has a maximum field length of 2.
• This value has the Type N as defined by NZQA

• This value is defined using the Number field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
  Example: 744
• This value has a maximum field length of 5.
• This value has the Type N as defined by NZQA

• This value is defined using the Version field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
  Example: 1
• This value has a maximum field length of 2.
• This value has the Type N as defined by NZQA

• This value is defined using the Context field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
• This value has a maximum field length of 3.
• This value has the Type Alphanumeric.

• This value is defined using the Course (Assessment Code) field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
• This value has a maximum field length of 10.
• This value has the Type Alphanumeric.

• This value is defined using the Te Reo Paper Req field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
• Only valid for externally assessed standards as indicated on standards file.
  Values: 1, 0, True, False
• This value has a maximum field length of  5.
• This value has the Type Alphanumeric.

• This value is defined using the Te Reo Answer Req field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
• Applies to both externally and internally assessed standards
  Values: 1, 0, True, False
• This value has a maximum field length of 5.
• This value has the Type Alphanumeric.

• This value is defined using the Assessment Request Type field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
  Values:

DE = Digital Exam
PE = Paper Exam
DS = Digital Submission
PS = Physical Submission

• This value has a maximum field length of 2.
• This value has the Type Alphanumeric.

• This value is defined using the Digital Practice Exam Requested field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
  Values: 1, 0, True, False
• This value has a maximum field length of 5.
• This value has the Type Alphanumeric.

• This value is defined using the Assessment Opportunity field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
  Values: 1 to the number indicated by Field 29 “Assessment Opportunities” of the current Standards file.
• Please note only one opportunity can be selected per entry.
• This value has a maximum field length of 2.
• This value has the Type N as defined by NZQA

Note: Synergetic does not provide

• This value has a maximum field length of 2.
• This value has the Type N as defined by NZQA

• This value is defined using the Withdrawn field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
  Values: 1, 0, True, False
• This value has a maximum field length of 5.
• This value has the Type Alphanumeric.

• This value is defined using the Completed field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
• This value has Format of YYYY-MM-DD
  Example: 2021-05-23
• This value has a maximum field length of 10.
• This value has the Type Date.

• This value is defined using the Result field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
• Merit and Excellence not available for all Unit Standards, identified by Field 16 “Achieved/Merit/Excellence Permissible” of the current Standards file.
• This value has a maximum field length of 5.
• This value has the Type Alphanumeric.

• This value is defined using the Provider field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
  (Provider Number includes Number and Location - Proc splits these.)
  Example: 498
• This value has a maximum field length of 5.
• This value has the Type N as defined by NZQA

• This value is defined using the Provider field of the NCEA tab of Current Student Maintenance. See Current Student Maintenance - NCEA tab.
  (Provider Number includes Number and Location - Proc splits these.)
  Value: 01 thru 99
• This value has a maximum field length of 2.
• This value has the Type N as defined by NZQA

• This value is calculated by the Procedure that produces the Export.
  Example: 775
• This value has a maximum field length of 6.
• This value has the Type N as defined by NZQA

• This value is calculated by the Procedure that produces the Export.
  Example: 7550
• This value has a maximum field length of 6.
• This value has the Type N as defined by NZQA

• This value is the default email of logged in User.
• This value has a maximum field length of 255.
• This value has the Type Alphanumeric.

Note: Synergetic does not provide.

• Appended to file when file submitted to NZQA.
• Optional but if needed must be filled in once the file is uploaded.
• This value has a maximum field length of 255.
• This value has the Type Alphanumeric.