• achieved_credits 

• date_of_birth 

• disability_identified_code 

• employer_head_office 

• employment_location_tla_code 

• english_second_language_identified_flag 

• ethnicity1_code 

• ethnicity2_code 

• expected_credits 

• funding_source_code 

• gender_code 

• industry_code 

• iwi1_code 

• iwi2_code 

• nsn 

• prior_activity_code 

• programme_completion_date 

• programme_credit 

• programme_duration 

• programme_level 

• programme_name 

• programme_number 

• programme_withdrawal_date 

• provider_code 

• reporting_year 

• self_reported_highest_secondary_qualification_code 

• self_reported_last_secondary_school_code 

• self_reported_last_secondary_school_year 

• student_id 

• total_number_of_completed_unit_standards 

• total_number_of_unit_standards 

Formatting the Spreadsheet 

Required - Install Kutools for Excel (this is used to prefix and suffix the ") 

1. Run find and replace for gender_code (1 = M, 2 = F) 

2. Run find a replace for disability identified (0 = 1,   

3. Convert the date_of_birth column to date format YYYY-MM-DD 

4. Select this column and copy content 

5. Paste the data into Notepad 

6. Back in the spreadsheet, delete the entire date_of_birth column  

7. Add a blank column back into the same location 

8. Set the format of the column to text 

9. Copy the content from NotePad and paste to the column 

10. Repeat steps 2 – 8 for the columns  
        - programme_completion_date  
           - programme_withdrawal_date 

11. Select the data for column employment_location_tla_code 

12. Format it as a custom column with 3 zeros 
     

13.  Use Kutools to add " before all first characters 

14. Use Kutools to add " after last characters 

15. Use find and replace to locate blank cells and replace with "" 

 
Save as .CSV with the name itr_enrolment_[provider code]_YYYY(reporting year)_YYYYMM(extract year & month), e.g., itr_enrolment_8022_2019_202207