...

new for 2021/22

Column Name

Required?

Format

Example

Notes

PRIOR_EMPSTAT_CODE

numeric

ILR Employment - Status before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/EmpStat

PRIOR_EMPSTAT_DATE

date

ILR Employment - Date Status before Enrolment Applies https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/DateEmpStatApp

PRIOR_EMPSTAT_LOE

numeric

ILR Employment - Length of Employment before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/LOE

PRIOR_EMPSTAT_SEI

numeric

ILR Employment - Self Employment Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/SEI

PRIOR_EMPSTAT_EII

numeric

ILR Employment - Employment Intensity Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/EII

PRIOR_EMPSTAT_BSI

numeric

ILR Employment - Benefits Status Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/BSI

PRIOR_EMPSTAT_SEM

numeric

ILR Employment - Small Employer before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/SEM

PRIOR_EMPSTAT_LOU

numeric

ILR Employment - Length of Unemployment before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/LOU

PRIOR_EMPSTAT_PEI

numeric

ILR Employment - Previous Education Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/PEI

PRIOR_EMPSTAT_OET1

numeric

Status
colourYellow
titlenew for 2021/22
ILR Employment - Other Employment Type 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/OET

PRIOR_EMPSTAT_OET2

numeric

Status
colourYellow
title

ILR Employment - Other Employment Type 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/OET

PRIOR_EMPSTAT_EMPCODE

PICS Organisation Code

ILR Employment - Employer before Enrolment
If this field is not provided the PRIOR_EMPSTAT_EMPNAME, PRIOR_EMPSTAT_EMPPOSTCODE and PRIOR_EMPSTAT_EMPEDRS fields are used to find a matching Organisation record. If no match is found a new record is created using the other PRIOR_EMPSTAT_EMP??? fields provided

PRIOR_EMPSTAT_EMPNAME

alphanumeric

Employer Name - used for matching

PRIOR_EMPSTAT_EMPADDR1

alphanumeric

Employer Address - Line 1

PRIOR_EMPSTAT_EMPADDR2

alphanumeric

Employer Address - Line 2

PRIOR_EMPSTAT_EMPADDR3

alphanumeric

Employer Address - Line 3

PRIOR_EMPSTAT_EMPADDR4

alphanumeric

Employer Address - Line 4

PRIOR_EMPSTAT_EMPADDR5

alphanumeric

Employer Address - Line 5

PRIOR_EMPSTAT_EMPPHONE

numeric

Employer Phone

PRIOR_EMPSTAT_EMPEMAIL

alphanumeric

Employer Email Address

PRIOR_EMPSTAT_EMPPOSTCODE

Postcode

Employer Postcode - used for matching

PRIOR_EMPSTAT_EMPEDRS

numeric

Employer EDS Registration Number - used for matching
https://esfahelp.education.gov.uk/hc/en-gb/articles/360014179980-Using-the-Employer-Data-Service-EDS-to-find-an-Employer-Registration-Number-ERN-

PRIOR_EMPSTAT_AGREEMENT_ID

6 alphanumeric

Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports

...

colour

Column Name

Required?

Format

Example

Notes

OTJHOURS

numeric

ILR Learning Delivery - Planned Hours https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/PHours

PROG_A11A

numeric

105

ILR Learning Delivery FAM - Source of Funding (SOF) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/SOF

PROG_ACT

1 alphanumeric

L

ILR Learning Delivery FAM - Apprenticeship Contract Type (ACT) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/ACT

1 or 2 as per ILR specification
L for ACT1 Levy Funded
N for ACT1 Non-Levy Funded

PROG_DELIVLOC

Postcode

ILR Learning Delivery - Delivery Location Postcode https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/DelLocPostCode

PROG_LSF

Status
Yellow
titleCOMING Feb 2022

numeric

ILR Learning Delivery FAM - Learning Support Funding (LSF) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/LSF

PROG_EEF

numeric

ILR Learning Delivery FAM - Eligibility for Enhanced Funding (EEF) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/EEF

PROG_HHS

alphanumeric

1*2

ILR Learning Delivery FAM - Household Situation (HHS) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/HHS

* separated list of ILR codes

PROG_HHSA

numeric

1

ILR Learning Delivery FAM - Household Situation (HHS 1)

First ILR Code

PROG_HHSB

numeric

2

ILR Learning Delivery FAM - Household Situation (HHS 2)

Second ILR Code

PROG_RES

numeric

ILR Learning Delivery FAM - Restart Indicator (RES) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/RES

PROG_A46A

numeric

ILR Learning Delivery FAM - Learner Delivery Monitoring (LDM 1) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/LDM

PROG_A46B

numeric

ILR Learning Delivery FAM - Learner Data Monitoring (LDM 2) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/LDM

PROG_A46C

numeric

ILR Learning Delivery FAM - Learner Data Monitoring (LDM 3) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/LDM

PROG_A46D

numeric

ILR Learning Delivery FAM - Learner Data Monitoring (LDM 4) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/LDM

PROG_A48A

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecDeliveryMonitoring

PROG_A48B

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecDeliveryMonitoring

PROG_A72A

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 3 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecDeliveryMonitoring

PROG_A72B

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 4 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecDeliveryMonitoring

...

Column Name

Required?

Format

Example

Notes

TRG_TNP

numeric

1000

ILR Apprenticeship Financial Record - Total Negotiate Price for Training (TNP1) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/AppFinRecord/field/AFinType/attribute/TNP

TRG_EMP

numeric

50

Employer’s Contribution to Training if not levy funded

TRG_EMP_START

numeric

40

Lump Sum of Employer’s Contribution to Training

TRG_EMP_SPRD

alphanumeric

Encoding of spreading method of Employer’s Contribution to Training

ASM_TNP

numeric

1000

ILR Apprenticeship Financial Record - Total Negotiate Price for Assessment (TNP2) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/AppFinRecord/field/AFinType/attribute/TNP

ASM_EMP

numeric

50

Employer’s Contribution to Assessment if not levy funded

ASM_EMP_START

numeric

40

Lump Sum of Employer’s Contribution to Assessment

ASM_EMP_SPRD

alphanumeric

Encoding of spreading method of Employer’s Contribution to Assessment

ADD_EMP

Status
colourGreen
titlefrom mid aug 2022

numeric

5000

Employer’s Additional Contributions

ADD_EMP_START

Status
colourGreen
titlefrom mid aug 2022

numeric

4000

Lump Sum of Employer’s Additional Contributions

ADD_EMP_SPRD

Status
colourGreen
titlefrom mid aug 2022

alphanumeric

Encoding of spreading method of Employer’s Additional Contributions

Functional Skills Assessments

...