Import Student Results File

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