Data requirements: Commitments – Data System Refresh programme

Data requirements: Commitments – Data System Refresh programme

Last updated 2 July 2024
Last updated 2 July 2024

This page outlines the changes in 2025 for all Commitments Data Submissions.

Below, you'll find information about:

Adding, editing and uploading Mix of Provision (MoP) data 

There are two methods available to enter data:

  • Add row: Manually add or edit data in the MoP webform. The webform includes drop down lists of relevant reference data. Calculated fields update and file formats validate as you go.
    This option is ideal for most providers.
  • Upload file: Upload data into the webform using the CSV UTF-8 file format. Formula fields will calculate as part of the upload process. Once uploaded, data can be edited in the webform, if needed.
    This option is ideal for more complex MoPs – multiple qualifications across multiple sites.
    A one-off transition to the new MoP template is required for providers who wish to use prior year MoP data as their starting point.

Resources to support transition to the new MoP templates in DXP Ngā Kete

Data requirements – MoPs

The Data Requirements document below tells you what data the Tertiary Education Commission (TEC) needs from you when you submit your MoP on DXP Ngā Kete.

This includes how to prepare your MoP template .csv upload files.

Alternatively, you can prepare your MoP using the DXP Ngā Kete webform. The data requirements are built into the webform – with instant data validation and drop-down reference data values.

DXP Data Requirements – MoPs (DOCX 412 KB)

Data requirements – Educational Performance Indicator Commitments (EPICs)

We have updated the names of the EPIC data submissions to reflect the current policy setting.

However, there are no changes to the data you need to submit for EPICs.

You must complete EPICs using the DXP Ngā Kete webforms. The data requirements and specifications are built into the webform – with instant data validation and drop-down reference data values.

DXP Data Requirements – EPICs (PDF 386 KB)

Delivery at Qualification (DQ) 3-7 and 7+ templates required for different TEOs

We have updated the DQ3-7 and 7+ template requirements to better align to work-based and provider-based delivery. Here are the details of DQ3-7 and 7+ MoPs required for different TEOs and what has changed for 2025.

DQ3-7 and 7+ MoP and EPIC Template Submission Requirements (PDF 296 KB)

Reference data

The Reference Data document below lists values for specific fields referred to in the Data Requirements. Reference data will be aligned to Stats NZ definitions (where possible). 

DXP Reference Data for MoPs (XLSX 25 KB)

TEO-specific qualification reference data will be provided in the DXP Ngā Kete webforms for these templates:

  • Delivery at Levels 1-2 (DQ1-2) MoP
  • DQ3-7 and all industry training (DQ3-7) qualification MoP
  • DQ7(degree) and above (DQ7+) qualification MoP
  • Youth Guarantee MoP.

MoP tolerance error and warnings

The error and warning messages in the table below will display in DXP Ngā Kete if your MoP is outside the allowable tolerance in relation to Fund and funding allocation.

Fund and issue

Message on screen

Error – prevents submission

All funds

Issue: MoP is above tolerance compared to the funding allocation

You’re out of tolerance for funded delivery

Your MoP is above the allowable tolerance of $xxx compared to the Funding Allocation; please amend the data to be able to submit.

Warning – does not prevent submission

All funds

Issue: MoP is below the funding allocation

You’re out of tolerance for funded delivery

Your value of funded delivery is below your funding allocation. Please check if the information entered is accurate. If you are unable to deliver the expected volume, please contact us to discuss a funding decrease. TEC Customer Contact Group on 0800 601 301 or customerservice@tec.govt.nz.

Warning – does not prevent submission

DQ3-7 and DQ7+

Issue: MoP is above 105% of the funding allocation (unfunded over-delivery)

You’re out of tolerance for total delivery

The total delivery entered in your MoP is above 105% of the Funding Allocation. Organisations who deliver over 105% will be in breach of the funding conditions.

Please refer to the TEC website for more information about over-delivery and if you have any further questions contact us on 0800 601 301 or customerservice@tec.govt.nz.

Changes to MoP templates

We have made some changes to rationalise and standardise MoP collection templates. These are listed in the table below.

Changes that apply across all or most MoP templates

Field

Change

Comment

Territorial Local Authority

Removed

Report Region of delivery data only

NZQCF

Renamed

Was NZQF

Funded EFTS & Funded Learners

 

Unfunded EFTS & Unfunded Learners (when applicable)

Renamed / standardised

Applied to all fields for EFTS, learner numbers and ‘places’

Funded value & Unfunded value (when applicable)

Renamed / standardised

Applied to all fields that were previously and variously called ‘Value of delivery / Allocation’

Total intended learner hours

Standardised

All relevant MoPs now:

  • require both Hours per learner and Number of learners, and
  • will calculate the Total intended learner hours.

Previously, some MoPs calculated the Hours per learner from the Total intended learner hours.

All changes, by individual template

Template

Changes

ACE in Communities

Removed:

  • Territorial Local Authority

Replaced:

  • Primary Priority Provision and Primary Focus – replaced by two connected lists for Priority Provision

Renamed:

  • Primary Target Priority Group for the Course – now Primary target group
  • Number of Hours per Learner – now Hours per learner
  • Number of Intended Funded Learners – now Number of learners
  • Value of Planned Delivery (Funded) – now Funded value

New:

  • Rate per learner hour (calculated – for information)

ACE in Schools

 

Removed:

  • Two fields relating to sub-contracting
  • Territorial Local Authority

Replaced:

  • Primary Priority Provision and Primary Focus – replaced by two connected lists for Priority Provision

Renamed:

  • Primary Target Priority Group for the Course – now Primary target group
  • Number of Hours per Learner – now Hours per learner
  • Number of Intended Funded Learners – now Number of learners
  • Value of Planned Delivery (Funded) – now Funded value

ACE in TEIs

Removed:

  • Territorial Local Authority

Replaced:

  • Primary Priority Provision and Primary Focus – replaced by two connected lists for Priority Provision

Renamed:

  • Primary Target Priority Group for the Course – now Primary target group
  • Number of Hours per Learner – now Hours per learner
  • Number of Intended Funded Learners – now Number of learners
  • Value of Planned Delivery (Funded) – now Funded value

DQ3-7 and DQ7+ Universities

Removed:

  • Level of study

New:

  • Fund: to indicate DQ7+ or DQ3-7 for each ‘row’ of data

Note also:

  • Some fields have been re-ordered.

DQ1-2

Removed:

  • Territorial Local Authority

Renamed:

  • Funding Category – now Qualification type
  • $ per EFTS for the Qualification – now Rate per qualification
  • Funded and unfunded EFTS and Values renamed as above

DQ3-10 EFTS/Learners for EPICs

New:

  • Learner numbers for work-based provision

Note also:

  • You are required to provide EFTS / learner numbers by qualification level where this detail is not collected in the main MoP. This data is required for EPIC calculations.

DQ3-7 All modes of delivery

New template:

This MoP will capture all DQ3-7 commitments for TEOs that do work-based or work-based and provider-based. You will need to provide this data:

  • Subject category (F1–F6)
  • Mode of Delivery
  • Region
  • Funding rate
  • Funded EFTS
  • Funded Value (calculated)
  • Unfunded EFTS
  • Unfunded Value (calculated)
  • Total EFTS
  • Total Value (calculated) 
  • (Repeat for )

DQ3-7 qualification

Removed:

  • Territorial Local Authority

Added:

  • Correctional facility – Yes or No

Renamed:

  • $ per EFTS for the Qualification – now Rate per qualification
  • Funded and unfunded EFTS and Values renamed as above

DQ7+ Delivery Classification

Removed:

  • Level of study

Note also:

  • Some fields have been re-ordered.

DQ7+ qualification

Removed:

  • Territorial Local Authority

Added:

  • Correctional facility – Yes or No

Renamed:

  • $ per EFTS for the Qualification – now Rate per qualification
  • Funded and unfunded EFTS and Values renamed as above

Emergency Management (EM)

Removed:

  • Territorial Local Authority

Renamed:

  • Number of Hours per Learner – now Hours per learner
  • Number of Intended Funded Learners – now Number of learners
  • Value of Planned Delivery (Funded) – now Funded value
  • Rate – now Rate per learner hour (calculated – for information)

English Language Teaching – ILN

 

Renamed – previously known as ESOL

Removed:

  • Territorial Local Authority

Renamed:

  • No. of Places (Allocation) – now Number of learners
  • Hours – now Hours per learner
  • Value of Delivery – now Funded value

Revised data and calculation:

  • Total intended learner hours will be calculated from:
    • Hours per learner, and
    • Number of learners

Intensive Literacy & Numeracy (ILN)

Removed:

  • Territorial Local Authority

Renamed:

  • No. of Places (Allocation) – now Number of learners
  • Hours – now Hours per learner
  • Value of Delivery – now Funded value

Revised data and calculation:

  • Total intended learner hours will be calculated from:
    • Hours per learner, and
    • Number of learners

 

Māori and Pasifika Trades Training (MPTT)

Removed:

  • Territorial Local Authority

Renamed:

  • Funding Category – now Qualification type
  • Applicable Top-up Funding Rate – now Top-up funding rate
  • Applicable Top-up Funding Rate – now Top-up funding rate
  • 2024 SAC 1&2 Non-Competitive Funding Rate – now Rate per qualification
  • 2024 SAC 1&2 Non-Competitive Funding – now DQ1-2 funded value

Search and Rescue (SAR)

Removed:

  • Territorial Local Authority

Renamed:

  • Number of Hours per Learner – now Hours per learner
  • Number of Intended Funded Learners – now Number of learners
  • Value of Planned Delivery (Funded) – now Funded value
  • Rate – now Rate per learner hour (calculated – for information)

TEO-led Workplace Literacy Fund

Removed:

  • Territorial Local Authority

Renamed:

  • No. of Places (Allocation) – now Number of learners
  • Hours – now Hours per learner
  • Value of Delivery – now Funded value

Revised data and calculation:

  • Total intended learner hours will be calculated from:
    • Hours per learner, and
    • Number of learners

Youth Guarantee

Removed:

  • Territorial Local Authority

Renamed:

  • Qualification Type (Initiative name) – now Qualification type
  • Applicable Funding Rate – now Rate per qualification
  • Value of Delivery – now Funded value