...
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 |
| ||||||||
PRIOR_EMPSTAT_OET2 | numeric | |||||||||
colour | Yellow | title | new for 2021/22ILR 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 | ||||||||
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 | ||||||||
PRIOR_EMPSTAT_AGREEMENT_ID | 6 alphanumeric | Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports |
...
...
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
| numeric | 5000 | Employer’s Additional Contributions | |||||||
ADD_EMP_START
| numeric | 4000 | Lump Sum of Employer’s Additional Contributions | |||||||
ADD_EMP_SPRD
| alphanumeric | Encoding of spreading method of Employer’s Additional Contributions |
Functional Skills Assessments
...