Page Comparison

This is still a work in progress. If any errors found please contact Support.

./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

./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

../EnrollingProvider/ProviderNumber

The MoE ID of the provider requesting the file

Import Details

• This value is not imported.

• Type: Integer

• Cardinality: 1

../EnrollingProvider/ProviderLocationNumberNumber

The location of the provider requesting the file

Import Details

• This value is not imported.

• Type: Integer

• Cardinality: 1

../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 - ∞

./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

.../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

.../FundingYearLevelCode

Year Level of student

Import Details

• This value is not imported. (Check with Andrew Rose - is this Imported?)

• Value 00 to 15

• Type: Integer

• Cardinality: 1

.../AssessingProvider/

Refer to sub-elements

Import Details

• This value is not imported.

• Parent Element

• Type: Complex

• Cardinality: 0, 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

../HighestAttainmentCode

Highest attainment of the learner as calculated by NZQA (Is this a Duplicate Row - Asking Catherine Edser of 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

../QualificationsAchieved/
QualificationAchieved/ 

Refer to sub-elements

Import Details

• This value is not imported.

• Parent Element

• Type: Complex

• Cardinality: 0 - ∞

.../Qualification/

Refer to sub-elements

Import Details

• This value is not imported.

• Parent Element

• Type: Complex

• Cardinality: 1

.../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