Export entries and results file

• 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 is defined using the Short Course field of Subject Area Assessment Maintenance. See Maintaining subject assessments.
  • This field 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.

• 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