Import Student Results File

Owned by Graham Kidd
Last updated: Oct 22, 2024
8 min read

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

Element

Element Content (From NZQA)

./DataExtractionDateTime

Date the data was extracted and the file was created

Import details

  • This value is not imported.

  • This value records the Date and Time the file was created by NZQA.

  • Type:          Date & time

  • Cardinality: 1

./AcademicYear

The academic year that is the subject of the extracted data.

Import details

  • This value is not imported.

  • The imported data is imported into this Academic Year.

  • Type:          Integer

  • Cardinality: 1

./Provider/

Refer to sub-elements

Import details

  • This value is not imported.

  • Provider details are only used to determine if student results should be imported or not by identifying if result from home school or external school.

  • If Student Result is provided by home school then results not imported. 
    If Student Result is provided by external school then results imported. 

  • Type:           Complex

  • Cardinality:  0, 1

../ProviderNumber

The MoE ID of the provider requesting the file

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

../ProviderLocationNumber

The location of the provider requesting the file

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

./Learners/Learner/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 1 - ∞

../Learner Details/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Complex

  • Cardinality: 1

.../NationalStudentNumber

NSN of the learner

Import Details

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Integer

  • Cardinality: 1

.../LearnerName/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Complex

  • Cardinality: 1

..../FirstName

First name of the learner

Import Details

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Alphanumeric

  • Cardinality: 1

..../MiddleName

Middle names of the learner

Import Details

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Alphanumeric

  • Cardinality: 0 - 2

..../LastName

Surname of the learner

Import Details

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Alphanumeric

  • Cardinality: 1

.../GenderCode

Gender of the learner

Import Details

  • Values: M or F

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Alphanumeric

  • Cardinality: 1

.../BirthDate

Birth date of the learner

Import Details

  • Example: 1993-12-17

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Date

  • Cardinality: 1

.../LocalIdentifier

Enrolling school’s local id for the learner

Import Details

  • Student's Synergetic community ID.

  • This value is not imported.

  • Used to identify student within Synergetic

  • Type: Alphanumeric

  • Cardinality: 1

.../EthnicityCode

Ethnicity code of the learner (1 to 3 instances)

Import Details

  • Example: 111

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1 - 3

../HighestAttainmentCode

Highest attainment of the learner as calculated by NZQA

Import Details

  • This value is imported into the Secondary Attainment Level field of the NZMOE tab in Current Student Maintenance.

  • See Current Student Maintenance - NZMOE tab.

  • Values: Refer to Section 5.1 of Secondary Schools Data Exchange Specifications Manual

  • Type: Integer

  • Cardinality: 0,1

../NCEAEntries/Entry/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 0 - ∞

.../Standard/

Standard

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 1

..../Standard Number

Standard number for the entry

Import Details

  • This value is imported into the Number (Standard Number) field on the NCEA tab of Current Student Maintenance.

  • See Current Student Maintenance - NCEA tab.

  • For Import Student Results File this value is used to identify the NCEA standard to populate with the results.

  • For Import Student Results File (External) and the student does not have this standard then a non-assessment linked standard is created.

  • Type: Integer

  • Cardinality: 1

..../StandardVersionNumber

Standard version number for the entry

Import Details

  • This value is only imported into the Ver (Standard Version) field on the NCEA tab of Current Student Maintenance.

  • See Current Student Maintenance - NCEA tab.

  • For Import Student Results File this value is used to identify the NCEA standard to populate with the results.

  • For Import Student Results File (External) and the student does not have this standard then a non-assessment linked standard is created.

  • Type: Integer

  • Cardinality: 1

.../LevelCode

Level code of the standard for the entry

Import Details

  • Values: 01 to 10

  • This value is not imported.

  • Parent Element

  • Type: Alphanumeric

  • Cardinality: 1

.../SecondaryResult

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 0, 1

..../SecondaryResultCode

Assessed result for the entry

Import Details

  • Example: A

  • This value is the Result field on the NCEA tab of Current Student Maintenance.

  • See Current Student Maintenance - NCEA tab.

  • For both Import Student Results File and Import Student Results File (External) this value is imported into NCEA Results field for externally assessed results.

  • An error is generated if the import value and the Synergetic stored value for internally assessed results differ.

  • Type: Alphanumeric

  • Cardinality: 1

..../CompletedDate

Completion date of the learner

Import Details

  • Example: 1993-12-17

  • This value is the Completed field on the NCEA tab of Current Student Maintenance.

  • See Current Student Maintenance - NCEA tab.

  • For both Import Student Results File and Import Student Results File (External) this value is imported into NCEA Completed field for externally assessed results.

  • An error is generated if the import value and the Synergetic stored value for internally assessed results differ.

  • Type: Date

  • Cardinality: 1

.../Credit Value

Credit value achieved for the entry if it has a positive result (i.e. A, M or E)

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 0, 1

.../ReviewPendingIndicator

true if the entry is currently pending a derived grade.

Import Details

  • This value is not imported.

  • For Import Student Results File if the ReviewPendingIndicator value is C, then a warning is generated.

  • Type: Boolean

  • Cardinality: 0, 1

.../SecondaryCourseNumber

The Course Code assigned to the entry by the enrolling school, if any

Import Details

.../EnrollingProvider/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 0, 1

..../ProviderNumber

The MoE ID of the enrolling/reporting provider for the entry.

Import Details

  • This value is imported into the Provider field on the NCEA tab of Current Student Maintenance.

  • Type: Integer

  • Cardinality: 1

..../ProviderLocationNumber

The location of the enrolling/reporting provider for the entry.

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

.../AssessingProvider/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 0, 1

..../Consented

Flag to show if the Result was from a School that had consent to assess

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

..../ProviderNumber

The MoE ID of the assessing provider for the entry.

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

..../ProviderLocationNumber

The location of the assessing provider for the entry.

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

../QualificationsAchieved/
QualificationAchieved/ 

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 0 - ∞

.../QualificationIdentifier/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 1

..../QualificationNumber 

Qualification number for the achieved qualification

Import Details

  • Used to determine the NCEA Level (1, 2, or 3) of the Result and then populate appropriate NCEA Level field of Current Student Maintenance - NZQA tab with EndorsementCode as that Result.
    The Result is the Endorsement Code field (see below).

    If Qualification Number = 0928 then NCEA Level1 is populated with EndorsementCode

    If Qualification Number = 0973 then NCEA Level2 is populated with EndorsementCode

    If Qualification Number = 1039 then NCEA Level3 is populated with EndorsementCode

  • Used to determine if University Entrance has been achieved.

    If Qualification Number = UE then Tertiary Entrance Achieved tickbox is set to on

    See Current Student Maintenance - Flags tab.

  • Type: Alphanumeric

  • Cardinality: 1

..../QualificationVersionNumber

Version number of the achieved qualification

Import Details

  • Imported into a Work Table, not populated into any database field

  • Type: Integer

  • Cardinality: 1

.../Qualification Title Name

Title of the achieved qualification

Import Details

  • This value is not imported.

  • Type: Alphanumeric

  • Cardinality: 1

.../LevelCode

Level code of the achieved qualification

Import Details

  • This value is not imported.

  • Values: 01 to 10

  • Type: Alphanumeric

  • Cardinality: 1

.../QualificationStrand/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 0 - ∞

..../StrandNumber

Strand number of the achieved strand

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

..../StrandTitleName

Title of the achieved strand

Import Details

  • This value is not imported.

  • Type: Alphanumeric

  • Cardinality: 1

..../StrandTypeCode

Type Code of the achieved strand

Import Details

  • This value is not imported.

  • Type: Alphanumeric

  • Cardinality: 1

..../LevelCode

Level code of the achieved strand

Import Details

  • This value is not imported.

  • Type: Alphanumeric

  • Cardinality: 0, 1

.../AchievedDate

Date the qualification was achieved

Import Details

  • This value is not imported.

  • Type: Date

  • Cardinality: 1

.../EndorsementCode

Endorsement code of the achieved qualification, if any

Import Details

  • Values: M or E

  • Used to populate NCEA Level field of Current Student Maintenance - NZQA tab
    See: ..../QualificationNumber description above.

  • Type: Alphanumeric

  • Cardinality: 1

../OtherAchievements/ OtherAchievement/ 

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 0 - ∞

.../AchievementCode

Code that represents the achievements.

Import Details

  • Used to populate Literacy Met and Numeracy Met fields of Current Student Maintenance - NZQA tab.

  • Values: Refer to Section 5.1

  • Populates Literacy and Numeracy Met fields based on this logic:

    • Level 1 Literacy Met as Y if AchievementCode = L1L ELSE N

    • Populates Level 1 Numeracy Met as Y if AchievementCode = L1N ELSE N

    • Populates UE Literacy Met as Y if AchievementCode = UEL ELSE N

    • Populates UE Numeracy Met as Y if AchievementCode = UEN ELSE N

  • Type: Alphanumeric

  • Cardinality: 1

.../AchievedYear

The year of the achievement

Import Details

  • Imported into a Work Table, not populated into any database field

  • Type: Integer

  • Cardinality: 1

.../AchievementValue

Represents the value of the achievement, if any

Import Details

  • This value is not imported.

  • Type: Decimal

  • Cardinality: 0, 1

.../SecondaryCourse
Endorsements/
Secondary CourseEndorsement/ 

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 0 - ∞

.../SecondaryCourse/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 1

..../SecondaryCourseNumber 

Code of the secondary course for a course endorsement result

Import Details

  • This value is not imported.

  • Used to match the Assessment Code of the imported Standard. This allows identification of the class in which to update the result of the Standard .

    See Asses > Subject Assessment Area Maintenance > Assessment Code

    (The Code field on Subject Assessment Selector.)

  • Type: Alphanumeric

  • Cardinality: 1

..../SecondaryCourseName

Name of the secondary course for a course endorsement result

Import Details

  • This value is not imported.

  • Type: Alphanumeric

  • Cardinality: 1

..../AcademicYear

Academic year for the course endorsement result

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

..../Provider/

Refer to sub-elements

Import Details

  • This value is not imported.

  • Parent Element

  • Type: Complex

  • Cardinality: 1

...../ProviderNumber

The MoE ID of the provider owning the course.

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

...../ProviderLocationNumber

The location of the provider owning the course.

Import Details

  • This value is not imported.

  • Type: Integer

  • Cardinality: 1

.../CourseEndorsementCode

Result code of the secondary course endorsement result

Import Details

  • Values: Refer to Section 5.1

  • Imported into Result field of the NCEA tab that is linked to the Assessment Code (SecondaryCourseCode) of Subject Assessment Area Maintenance for the Area that has a Result Type with SynergyMeaning of NCEASCE.

  • Type: Alphanumeric

  • Cardinality: 1