SDR Field Mappings Appendix
The following appendices detail the relevant fields in ebs that are mapped for the export files for the SDR return:

The fields in ebs that are mapped for the Student file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
1.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
1.2 | ID | Student Identification Code | 10 |
PEOPLE.FES_SEC_PERSON_ CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
1.3 | GENDER | Gender | 1 | PEOPLE.SEX | |
1.4 | DOB | Date of Birth | 8 | PEOPLE.DATE_OF_BIRTH | DDMMYYYY |
1.5 | (removed) | (padded blanks) | 6 | ||
1.6 | NAMEID | Name ID Code | 5 | Not stored – always calculated | See Definition of
EBS_LEARNERS. NAMEIDCODE |
1.7 | PRIOR_A | Main Activity at 1 October in Year Prior to Formal Enrolment | 2 | PEOPLE.PRIOR_LEARNER_STATUS | Right Justify |
1.8 | FIRST_YR | First Year of Formal Tertiary Education | 4 | PEOPLE.FIRST_TERTIARY_YEAR | |
1.9 | DIS_ACCESS | Disability Services Accessed Indicator | 1 | PEOPLE.DIS_ACCESSED | Convert Y = 1, N = 2 |
1.10 | S_SCHOOL | Last Secondary School Attended | 4 | PEOPLE.SCHOOL | Right Justify |
1.11 | Y_SCHOOL | Last Year of Secondary School | 4 | PEOPLE.LAST_SCHOOL_YEAR | |
1.12 | SEC_QUAL | Highest Secondary School Qualification | 2 | PEOPLE.SECONDARY_QUALIFICATION | Left Justify |
1.13 | CITIZEN | Country of Citizenship | 3 | PEOPLE.NATIONALITY | Fill character 9 |
1.14 | (removed) | (padded blanks) | 2 | ||
1.15 | DISABILITY | Disability Indicator | 1 | PEOPLE.DISABILITY | Fill character 9 |
1.16 | FINISH | Expectation to Complete a Qualification this year | 1 | PEOPLE.FINISH_THIS_YEAR | |
1.17 | IWI | Iwi Affiliation | 12 | PEOPLE.IWI_1, IWI_2 and IWI_3 | Left Justify |
1.18 | (removed) | (padded blanks) | 9 | ||
1.19 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
1.20 | FOREIGN_FEE* | Tuition fee paid by foreign fee-paying student | 5 |
If web_config parameter SDRForeignFeeOutput = 'Y' THEN Sum (FEES_LIST.AMOUNT) where PEOPLE.NZ_FUNDING lookup VERIFIER (domain FUNDING). OPS_MASTER = '1' (International) FEES_LIST.FEE_DATE <= Extract Date and FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' For fees relating to the learner's relevant enrolments |
Right Justify |
1.21 | MAX_Exempt_Fee | Maxima Exempt Fees | 5 |
Sum (FEES_LIST.AMOUNT) where FEES_LIST.FEE_DATE in return year and FEES_LIST.FEE_DATE <= Extract Date and FEE_TYPES.SDR_TYPE = 'E' FEE TYPES.INCLUDE_IN_RETURN = 'Y' |
Includes GST Right Justify |
1.22 | ETHNIC | Ethnicity | 9 | PEOPLE.NZ_ETHNICITY_1, NZ_ETHNICITY_2, NZ_ETHNICITY_3 | Left Justify |
1.23 | PERM_POST_CODE | Permanent Post Code | 4 | ADDRESSES.UK_POST_CODE_PT1 from student current address (END_DATE is null) of type (WEB_CONFIG.PARAMETER = 'SDR_PERM_PCODE') | Fill character 8 |
1.24 | TERM_POST_CODE | Term Post Code | 4 | ADDRESSES.UK_POST_CODE_PT1 from student current address (END_DATE is null) of type (WEB_CONFIG.PARAMETER = 'SDR_TERM_PCODE') | Fill character 8 |

The fields in ebs that are mapped for the Course Enrolment file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
2.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
2.2 | ID | Student Identification Code | 10 |
PEOPLE.FES_SEC_PERSON_ CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
2.3 | QUAL | Qualification Code | 6 | UNIT_INSTANCES.SDR_QUALIFICATION_CODE. Taken from parent qualification, or use 'home' qual code if more than one parent. | Left Justify |
2.4 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
2.5 | CRS_SRT | Course Start Date | 8 |
PEOPLE_UNITS_SPECIAL.START_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.FES_START_DATE |
DDMMYYYY |
2.6 | CRS_END | Course End Date | 8 |
PEOPLE_UNITS_SPECIAL.END_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.FES_END_DATE |
DDMMYYYY |
2.7 | CRS_WTD | Student's Course Withdrawal Date | 8 | PEOPLE_UNITS.PROGRESS_DATE if PEOPLE_UNITS.PROGRESS_STATUS = 'W' | DDMMYYYY |
2.8 | ASSIST | Category of Fees Assessment for International Students | 2 | PEOPLE_UNITS.NZ_ASSIST | |
2.9 | ATTEND | Intramural/Extramural Attendance | 1 | PEOPLE_UNITS.ATTENDANCE_CODE | |
2.10 | CRS_SITE | Course Delivery Site | 2 |
Determine location from PEOPLE_UNITS.LOCATION_CODE, if null from UNIT_INSTANCES_OCCURRENCES.SLOC_LOCATION_CODE Lookup code from LOCATIONS.SITE_CODE |
|
2.11 | FUNDING | Source of Funding | 2 |
PEOPLE_UNITS.NZ_FUNDING if not null PEOPLE.NZ_FUNDING |
|
2.12 | RESIDENCY | Residential Status | 1 | Use PEOPLE_UNITS.RESIDENTIAL_STATUS to lookup VERIFIERS.OPS_MASTER where RV_DOMAIN = 'RESIDENTIAL_STATUS' - should be Y or N if null, use PEOPLE.RESIDENTIAL_STATUS | |
2.13 | AUS_RESIDENCY | Australian Residential Status | 1 | PEOPLE_UNITS.RESIDENTIAL_STATUS_2 | |
2.13.1 | MANAAPPR | Managed Apprenticeship |
1 | PEOPLE_UNITS.ENROLLED_AS_MGD_APPSHIP | |
2.14 | CATEGORY | Funding Category | 2 |
PEOPLE_UNITS_SPECIAL.FUNDING_CATEGORY and PEOPLE_UNITS_SPECIAL.FUNDING_STATUS (If PEOPLE_UNITS_SPECIAL.DETAILS = 'Y' or UNIT_INSTANCES.FUNDING_CATEGORY and UNIT_INSTANCES.FUNDING_STATUS |
|
2.15 | CLASS | Course Classification | 4 | UNIT_INSTANCES.COURSE_CLASSIFICATION | Left Justify |
2.16 | NZSCED | NZSCED Field of Study | 6 | UNIT_INSTANCES.NZSCED | |
2.17 | FACTOR | Course EFTS Factor | 6 |
PEOPLE_UNITS_SPECIAL.COURSE_EFTS_FACTOR (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.COURSE_EFTS_FACTOR |
|
2.18 | EFTS_MTH | EFTS by Month | 84 |
UIO_EFTS.EFTS_MONTH_01-12 and PEOPLE_UNITS_SPECIAL_EFTS.EFTS_MONTH_01-12 for rows that apply to the academic year being reported |
6 chars x12. Numeric with 4 d.p. e.g. 0.0100 |
2.19 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |

The fields in ebs that are mapped for the Course Register file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
3.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
3.2 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
3.3 | CTITLE | Course Title | 75 | UNIT_INSTANCE_OCCURRENCES.LONG_DESCRIPTION if not null else UNIT_INSTANCES.FES_LONG_DESCRIPTION |
Left Justify Truncate to 75 chars |
3.4 | QUAL | Qualification Code | 6 | UNIT_INSTANCES.SDR_QUALIFICATION_CODE |
This is the 'home' qualification code. Left Justify |
3.5 | CLASS | Course Classification | 4 | UNIT_INSTANCES.COURSE_CLASSIFICATION | Left Justify |
3.6 | NZSCED | NZSCED Field of Study | 6 | UNIT_INSTANCES.NZSCED | |
3.7 | REGISTERLEVEL | Level on the NZ Register of Quality Assured Qualifications | 1 | UNIT_INSTANCES.SDR_REGISTER_LEVEL | |
3.8 | CREDIT | Credit | 3 | UNIT_INSTANCES.COURSE_CREDITS | |
3.9 | CATEGORY | Funding Category | 2 | UNIT_INSTANCES.FUNDING_CATEGORY and UNIT_INSTANCES.FUNDING_STATUS | |
3.10 | FACTOR | Course EFTS Factor |
6 | UNIT_INSTANCE_OCCURRENCES.COURSE_EFTS_FACTOR | |
3.11 | STAGE | Stage of Pre-Service Teacher Education Qualification | 2 | UNIT_INSTANCES.QUALIFICATION_STAGE | |
3.12 | FEE | Course Tuition Fee | 5 |
Sum (FEE_VALUES.AMOUNT_PAYABLE) where FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year, or are null |
Includes GST Right Justify |
3.13 | INTERNET | Internet Based Learning Indicator | 1 | UNIT_INSTANCES.INTERNET_BASED_LEARNING | |
3.14 | PBRF Eligible | PBRF Eligible Course Indicator | 1 | UNIT_INSTANCES.SDR_PBRF_ELIGIBLE | |
3.15 | FOREIGN_FEE* | Tuition fee paid by foreign fee-paying student | 5 |
If web_config parameter SDRForeignFeeOutput = 'N' THEN Sum (FEE_VALUES.OVERSEAS_AMOUNT) where FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year or are null |
GST not included Right Justify |
3.16 | CCCOSTS Fee | Compulsory Course Costs Fee | 5 |
Sum (FEE_VALUES.AMOUNT_PAYABLE) where FEE_TYPES.SDR_TYPE = 'C' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year, or are null |
Includes GST Right Justify |
3.17 | EXEMPT Indicator | Course Exemption from FCCM | 1 | UNIT_INSTANCES.EXEMPT_INDICATOR | |
3.18 | EMB_LIT_NUM | Embedded Literacy and Numeracy Flag | 1 | UNIT_INSTANCES.EMBEDDED_LITERACY_NUMERACY |

The fields in ebs that are mapped for the Qualification Completion file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
4.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
4.2 | ID | Student Identification Code | 10 | PEOPLE.FES_SEC_PERSON_CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
4.3 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
4.4 | QUAL | Qualification Code | 6 |
ATTAINMENTS.SDR_QUALIFICATION_CODE if not null UNIT_INSTANCES.SDR_QUALIFICATION_CODE via PEOPLE_UNITS.UIO_ID of ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
4.5 | MAIN_1 | Main Subject 1 | 4 |
ATTAINMENTS.MAIN_SUBJECT_1 if not null UNIT_INSTANCES.MAIN_SUBJECT_1 via PEOPLE_UNITS.UIO_ID if ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
4.6 | MAIN_2 | Main Subject 2 | 4 |
ATTAINMENTS.MAIN_SUBJECT_2 if not null UNIT_INSTANCES.MAIN_SUBJECT_2 via PEOPLE_UNITS.UIO_ID if ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
4.7 | MAIN_3 | Main Subject 3 | 4 |
ATTAINMENTS.MAIN_SUBJECT_3 if not null UNIT_INSTANCES.MAIN_SUBJECT_3 via PEOPLE_UNITS.UIO_ID if ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
4.8 | YR_REQ_MET | Year Requirements Met | 4 | ATTAINMENTS.YEAR_REQUIREMENTS_MET | YYYY |
4.9 | (removed) | (padded blanks) | 4 |

The fields in ebs that are mapped for the Course Completion file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
5.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
5.2 | ID | Student Identification Code | 10 | PEOPLE.FES_SEC_PERSON_CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
5.3 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
5.4 | COMPLETE | Student Course Completion indicator | 1 |
PROGRESS_CODES.SDR_COMPLETION_INDICATOR for record linked to PEOPLE_UNITS.PROGRESS_CODE If code is '0or1' then use '1' if Extract Date <= CRS_END else '0' |
|
5.5 | CRS_SRT | Course Start Date | 8 |
PEOPLE_UNITS_SPECIAL.START_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURENCES.FES_START_DATE |
DDMMYYYY |
5.6 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
5.7 | CRS_END | Course End Date | 8 |
PEOPLE_UNITS_SPECIAL.END_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURENCES.FES_END_DATE |
DDMMYYYY |
5.8 | PBRF_CRS_COMP_YR | PBRF Course Completion Year | 4 | IF COMPLETE is 2 or 3 and UNIT_INSTANCES.SDR_PBRF_ELIGIBLE is not blank or 'X' then Year component of PEOPLE_UNITS.PROGRESS_DATE | YYYY |
The following appendices detail the relevant fields in ebs that are mapped for the export files for the SDR 2025+ return typr:

The fields in ebs that are mapped for the Student file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
1.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
1.2 | ID | Student Identification Code | 10 |
PEOPLE.FES_SEC_PERSON_ CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
1.3 | GENDER | Gender | 1 | PEOPLE.SEX | |
1.4 | DOB | Date of Birth | 8 | PEOPLE.DATE_OF_BIRTH | DD/MM/YYYY |
1.5 | TOTAL_FEE | Total fee for Domestic Student | 10 | ||
1.6 | NAMEID | Name ID Code | 5 | Not stored – always calculated | See Definition of
EBS_LEARNERS. NAMEIDCODE |
1.7 | PRIOR_A | Main Activity at 1 October in Year Prior to Formal Enrolment | 2 | PEOPLE.PRIOR_LEARNER_STATUS | Right Justify |
1.8 | FIRST_YR | First Year of Formal Tertiary Education | 4 | PEOPLE.FIRST_TERTIARY_YEAR | |
1.9 | DIS_ACCESS | Disability Services Accessed Indicator | 1 | PEOPLE.DIS_ACCESSED | Convert Y = 1, N = 2 |
1.10 | S_SCHOOL | Last Secondary School Attended | 4 | PEOPLE.SCHOOL | Right Justify |
1.11 | Y_SCHOOL | Last Year of Secondary School | 4 | PEOPLE.LAST_SCHOOL_YEAR | |
1.12 | SEC_QUAL | Highest Secondary School Qualification | 2 | PEOPLE.SECONDARY_QUALIFICATION | Left Justify |
1.13 | CITIZEN | Country of Citizenship | 3 | PEOPLE.NATIONALITY | Fill character 9 |
1.14 | FINISH | Expectation to Complete a Qualification this year | 1 | PEOPLE.FINISH_THIS_YEAR | |
1.15 | IWI | Iwi Affiliation | 77 | PEOPLE.IWI_1, IWI_2, IWI_3, IWI_4, IWI_5, and IWI_6 | Left Justify |
1.16 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
1.17 | FOREIGN_FEE* | Tuition fee paid by foreign fee-paying student | 5 |
If web_config parameter SDRForeignFeeOutput = 'Y' THEN Sum (FEES_LIST.AMOUNT) where PEOPLE.NZ_FUNDING lookup VERIFIER (domain FUNDING). OPS_MASTER = '1' (International) FEES_LIST.FEE_DATE <= Extract Date and FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' For fees relating to the learner's relevant enrolments |
Right Justify |
1.18 | MAX_Exempt_Fee | Maxima Exempt Fees | 5 |
Sum (FEES_LIST.AMOUNT) where FEES_LIST.FEE_DATE in return year and FEES_LIST.FEE_DATE <= Extract Date and FEE_TYPES.SDR_TYPE = 'E' FEE TYPES.INCLUDE_IN_RETURN = 'Y' |
Includes GST Right Justify |
1.19 | ETHNIC | Ethnicity | 18 | PEOPLE.NZ_ETHNICITY_1, NZ_ETHNICITY_2, NZ_ETHNICITY_3, NZ_ETHNICITY_4, NZ_ETHNICITY_5, and NZ_ETHNICITY_6 | Left Justify |
1.20 | PERM_POST_CODE | Permanent Post Code | 4 | ADDRESSES.UK_POST_CODE_PT1 from student current address (END_DATE is null) of type (WEB_CONFIG.PARAMETER = 'SDR_PERM_PCODE') | Fill character 8 |
1.21 | TERM_POST_CODE | Term Post Code | 4 | ADDRESSES.UK_POST_CODE_PT1 from student current address (END_DATE is null) of type (WEB_CONFIG.PARAMETER = 'SDR_TERM_PCODE') | Fill character 8 |
1.22 | DISABILITY_STATUS | Disability Status | 1 | ||
1.23 | DISABILITY_SUPPORT_NEEDS | Disability Support Needs | 28 | PEOPLE.DISAB_1, DISAB_2, DISAB_3, DISAB_4, DISAB_5, DISAB_6 and DISAB_7 |

The fields in ebs that are mapped for the Course Enrolment file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
2.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
2.2 | ID | Student Identification Code | 10 |
PEOPLE.FES_SEC_PERSON_ CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
2.3 | QUAL | Qualification Code | 6 | UNIT_INSTANCES.SDR_QUALIFICATION_CODE. Taken from parent qualification, or use 'home' qual code if more than one parent. | Left Justify |
2.4 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
2.5 | CRS_SRT | Course Start Date | 8 |
PEOPLE_UNITS_SPECIAL.START_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.FES_START_DATE |
DDMMYYYY |
2.6 | CRS_END | Course End Date | 8 |
PEOPLE_UNITS_SPECIAL.END_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.FES_END_DATE |
DDMMYYYY |
2.7 | CRS_WTD | Student's Course Withdrawal Date | 8 | PEOPLE_UNITS.PROGRESS_DATE if PEOPLE_UNITS.PROGRESS_STATUS = 'W' | DDMMYYYY |
2.8 | ASSIST | Category of Fees Assessment for International Students | 2 | PEOPLE_UNITS.NZ_ASSIST | |
2.9 | ATTEND | Intramural/Extramural Attendance | 1 | PEOPLE_UNITS.ATTENDANCE_CODE | |
2.10 | CRS_SITE | Course Delivery Site | 2 |
Determine location from PEOPLE_UNITS.LOCATION_CODE, if null from UNIT_INSTANCES_OCCURRENCES.SLOC_LOCATION_CODE Lookup code from LOCATIONS.SITE_CODE |
|
2.11 | FUNDING | Source of Funding | 2 |
PEOPLE_UNITS.NZ_FUNDING if not null PEOPLE.NZ_FUNDING |
|
2.12 | RESIDENCY | Residential Status | 1 | Use PEOPLE_UNITS.RESIDENTIAL_STATUS to lookup VERIFIERS.OPS_MASTER where RV_DOMAIN = 'RESIDENTIAL_STATUS' - should be Y or N if null, use PEOPLE.RESIDENTIAL_STATUS | |
2.13 | AUS_RESIDENCY | Australian Residential Status | 1 | PEOPLE_UNITS.RESIDENTIAL_STATUS_2 | |
2.13.1 | CATEGORY | Funding Category | 2 |
PEOPLE_UNITS_SPECIAL.FUNDING_CATEGORY and PEOPLE_UNITS_SPECIAL.FUNDING_STATUS (If PEOPLE_UNITS_SPECIAL.DETAILS = 'Y' or UNIT_INSTANCES.FUNDING_CATEGORY and UNIT_INSTANCES.FUNDING_STATUS |
|
2.14 | CLASS | Course Classification | 4 | UNIT_INSTANCES.COURSE_CLASSIFICATION | Left Justify |
2.15 | NZSCED | NZSCED Field of Study | 6 | UNIT_INSTANCES.NZSCED | |
2.16 | FACTOR | Course EFTS Factor | 6 |
PEOPLE_UNITS_SPECIAL.COURSE_EFTS_FACTOR (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURRENCES.COURSE_EFTS_FACTOR |
|
2.17 | EFTS_MTH | EFTS by Month | 84 |
UIO_EFTS.EFTS_MONTH_01-12 and PEOPLE_UNITS_SPECIAL_EFTS.EFTS_MONTH_01-12 for rows that apply to the academic year being reported |
6 chars x12. Numeric with 4 d.p. e.g. 0.0100 |
2.18 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
2.19 | CONSORTIUM | Consortium | 6 | ||
2.20 | ITE_SECTOR | ITE Sector | 1 | ||
2.21 | ITE_SUBJECT | ITE Subject | 19 |

The fields in ebs that are mapped for the Course Register file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
3.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
3.2 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
3.3 | CTITLE | Course Title | 75 | UNIT_INSTANCE_OCCURRENCES.LONG_DESCRIPTION if not null else UNIT_INSTANCES.FES_LONG_DESCRIPTION |
Left Justify Truncate to 75 chars |
3.4 | QUAL | Qualification Code | 6 | UNIT_INSTANCES.SDR_QUALIFICATION_CODE |
This is the 'home' qualification code. Left Justify |
3.5 | CLASS | Course Classification | 4 | UNIT_INSTANCES.COURSE_CLASSIFICATION | Left Justify |
3.6 | NZSCED | NZSCED Field of Study | 6 | UNIT_INSTANCES.NZSCED | |
3.7 | REGISTERLEVEL | Level on the NZ Qualifications and Credentials | 1 | UNIT_INSTANCES.SDR_REGISTER_LEVEL | |
3.8 | CREDIT | Credit | 3 | UNIT_INSTANCES.COURSE_CREDITS | |
3.9 | CATEGORY | Funding Category | 2 | UNIT_INSTANCES.FUNDING_CATEGORY and UNIT_INSTANCES.FUNDING_STATUS | |
3.10 | FACTOR | Course EFTS Factor |
6 | UNIT_INSTANCE_OCCURRENCES.COURSE_EFTS_FACTOR | |
3.11 | FEE | Course Tuition Fee | 10 |
Sum (FEE_VALUES.AMOUNT_PAYABLE) where FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year, or are null |
Includes GST Right Justify |
3.12 | PBRF Eligible | PBRF Eligible Course Indicator | 1 | UNIT_INSTANCES.SDR_PBRF_ELIGIBLE | |
3.13 | FOREIGN_FEE* | Tuition fee paid by international fee-paying student | 10 |
If web_config parameter SDRForeignFeeOutput = 'N' THEN Sum (FEE_VALUES.OVERSEAS_AMOUNT) where FEE_TYPES.SDR_TYPE = 'T' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year or are null |
GST not included Right Justify |
3.14 | CCCOSTS Fee | Compulsory Course Costs Fee | 10 |
Sum (FEE_VALUES.AMOUNT_PAYABLE) where FEE_TYPES.SDR_TYPE = 'C' and FEE_TYPES.INCLUDE_IN_RETURN = 'Y' and FEE_VALUES.Dates overlap calendar year, or are null |
Includes GST Right Justify |
3.15 | EXEMPT | Course Exemption from AMFM | 1 | UNIT_INSTANCES.EXEMPT_INDICATOR | |
3.16 | DISC_COURSE_TUITUON_FEE | Discounted Course Tuition Fee | 8 | ||
3.17 | DISC_COMPULSORY_CRS_FEE | Discounted Compulsory Course Costs Fee | 8 |

The fields in ebs that are mapped for the Qualification Completion file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
4.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
4.2 | ID | Student Identification Code | 10 | PEOPLE.FES_SEC_PERSON_CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
4.3 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
4.4 | QUAL | Qualification Code | 6 |
ATTAINMENTS.SDR_QUALIFICATION_CODE if not null UNIT_INSTANCES.SDR_QUALIFICATION_CODE via PEOPLE_UNITS.UIO_ID of ATTAINMENTS.PEOPLE_UNITS_ID is populated |
Left Justify |
4.5 | YR_REQ_MET | Year Requirements Met | 4 | ATTAINMENTS.YEAR_REQUIREMENTS_MET | YYYY |

The fields in ebs that are mapped for the Course Completion file are described in the following table.
Field No | Field Name | Field Title | Field Length | ebs Field | Comments |
---|---|---|---|---|---|
5.1 | INSTIT | Provider Code | 4 | INSTITUTION_DETAILS, parameter MOE_INSTITUTION_CODE | |
5.2 | ID | Student Identification Code | 10 | PEOPLE.FES_SEC_PERSON_CODE if not null PEOPLE.PERSON_CODE |
Use secondary person code for continuation from previous system. Left Justify |
5.3 | COURSE | Course Code | 20 | UNIT_INSTANCES.SDR_COURSE_CODE | Left Justify |
5.4 | COMPLETE | Student Course Completion indicator | 1 |
PROGRESS_CODES.SDR_COMPLETION_INDICATOR for record linked to PEOPLE_UNITS.PROGRESS_CODE If code is '0or1' then use '1' if Extract Date <= CRS_END else '0' |
|
5.5 | CRS_SRT | Course Start Date | 8 |
PEOPLE_UNITS_SPECIAL.START_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURENCES.FES_START_DATE |
DDMMYYYY |
5.6 | NSN | National Student Number | 10 | PEOPLE.UNIQUE_LEARNER_NO | Right Justify |
5.7 | CRS_END | Course End Date | 8 |
PEOPLE_UNITS_SPECIAL.END_DATE (If PEOPLE_UNITS.SPECIAL_DETAILS = 'Y') or UNIT_INSTANCE_OCCURENCES.FES_END_DATE |
DDMMYYYY |
5.8 | PBRF_CRS_COMP_YR | PBRF Course Completion Year | 4 | IF COMPLETE is 2 or 3 and UNIT_INSTANCES.SDR_PBRF_ELIGIBLE is not blank or 'X' then Year component of PEOPLE_UNITS.PROGRESS_DATE | YYYY |