Versions Compared

Version Old Version 32 New Version 33
Changes made by

Tim Davies (Pellcomp) (Deactivated)

Joe Robson (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column Name

Required?

Format

Example

Notes

FIRSTNAME

string

Roberta

SURNAME

string

Smith

PREV_SURNAME

string

Jones

SEX

string

1: Male
2: Female
M: Male
F: Female

ETHNICORIGIN

numeric

33

ILR Ethnicity
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/Ethnicity

TITLE

numeric

4

1: Mr

2: Mrs

3: Miss

4: Ms

5: Dr

6: Rev

7: Hon

8: Mx

9: Other

BIRTHDATE

date

13/03/2003

NINUMBER

string

JB010101A

PHOTOFILEID

File GUID

Must be an existing PICS File GUID

MIAP_ULN

numeric

100000009

LRS Unique Learner Number (ULN)

MIAP_FPN_SEEN

numeric

LRS Ability to Share / Privacy Notice seen

0 - No seen
1 - Seen

MIAP_PREFNAME

string

LRS Preferred Name

MIAP_VERIFTYPE

numeric

LRS Identity Verification Type
0 - None Provided
1 - Relationship with school
2 - Passport
3 - Driving licence
4 - ID Card
5 - National Insurance card
6 - Certificate of Entitlement to Funding
7 - Bank credit/debit card
999 - Other (please specify in MIAP_VERIFTEXT)

MIAP_VERIFTEXT

LRS Identity Verification Type Other details

PROV_ID

string

Provider Assigned Internal Identifier

LSC_ULIN

string

COB1234455

ILR Learner Reference Number

TAG_IDS

string

INTERNAL USE ONLY
pcTagList RecGUID values * separated

TAG_NAMES

string

April 2022*Engineers*

Names of the tags to create * separated

ADDR1

string

Flat A

First line of Home Address

ADDR2

string

123 Acacia Avenue

Second line of Home Address

ADDR3

string

Suburb

Third line of Home Address

ADDR4

string

Townville

Fourth line of Home Address

POSTCODE

string

TO1 1WN

Home Postcode

L17POSTCODE

string

TO1 1WN

Home Postcode prior to enrolment

PHONE

numeric

01603492620

Home Phone number

MOBILEPHONE

numeric

07799000001

Mobile Phone number

EMAIL

string

bob@here.com

NOKNAME

string

A Smith

Next of Kin Name

NOKREL

string

Parent

Next of Kin Relationship

NOKPHONE

string

01603492620

First Next of Kin Phone Number

NOKPHONE2

string

07799000002

Second Next of Kin Phone Number

NOKEMAIL

string

asmith@home.com

Next of Kin Email Address

CONT_METH

string

PETS

Allowed Contact Methods between Provider & Learner
Any combination of the following codes:
E: Email
P: Post

T: Telephone
S: SMS

PREF_CONTACT_METH

string

E

Preferred Contact Method between Provider & Learner
One of the codes in Allowed Contact Methods

SITE

string

PICS Internal Site code

CLIENT_ID

string

Learner Internal Client structure Identifier. Used when importing new Episodes for an existing Learner

ULIN_ID

string

Learner Internal Learner Reference Number structure Identifier. Used when importing new Episodes for an existing Learner Reference

PICS_APIDENT

string

Source Applicant Identifier for linking between an existing Applicant and a Learner

RISKLEVEL

string

Learner Risk Level

1: High

2: Medium

3: Low

QUALPLAN

string

PICS Qualification Plan code

ILR_SELF_DISAB

string

2

ILR Learner’s Self Assessed Disability status
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/llddhealthprobLLDDHealthProb

ALL_LLDD

string

12*13*96

ILR LLDD codes
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/LLDDandHealthProblem/field/llddcatLLDDCat

PRIMARY_LLDD

string

12

ILR Primary LLDD
One of the code specified in ALL_LLDD

RUI

string

67

ILR Restricted Use Indicator
https://guidance.submitlearnerdatabeta.fasst.org.uk/previous/20-21/ilr/field/contprefcode

L52

string

456

ILR Preferred Method of Contact
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/contprefcodesubmit-learner-data.service.gov.uk/22-23/ilr/entity/ContactPreference/field/ContPrefType/attribute/PMC

L34A

string

36

ILR Learner FAM - Learner Support Reason 1 https://guidance.submitlearnerdatabeta.fasst.org.uksubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/learnfamcodeLearnFAMType/attribute/LSR

L34B

string

ILR Learner FAM - Learner Support Reason 2 https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/learnfamcodeLSR

L34C

string

ILR Learner FAM - Learner Support Reason 3 https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/learnfamcodeLSR

L34D

string

ILR Learner FAM - Learner Support Reason 4 https://guidance.submitlearnerdatabeta.fasst.org.uksubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/learnfamcodeLearnFAMType/attribute/LSR

L31

numeric

ILR Learner - Learning Support
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilrsubmit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/alscostALSCost

DLA

numeric

ILR Learner FAM - Disabled Students Allowance
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamcodesubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/DLA

ACCOM

numeric

ILR Learner Accommodation
https://guidance.submitlearnerdatabeta.fasst.org.uksubmit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/accomAccom

L40A

numeric

ILR Learner FAM - National Learner Monitoring 1
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/learnfamcodeLearnFAMType/attribute/NLM

L40B

numeric

ILR Learner FAM - National Learner Monitoring 1
2 https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/learnfamcodeNLM

L42A

numeric

ILR Learner - Provider Specified Monitoring 1
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/providerspeclearnermonitoringProvSpecLearnMon

L42B

numeric

ILR Learner - Provider Specified Monitoring 2
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/providerspeclearnermonitoringProvSpecLearnMon

MCF

numeric

ILR Learner - Maths Condition of Funding
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/learnfamtypeLearnFAMType/attribute/mcfMCF

ECF

numeric

ILR Learner - English Condition of Funding
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamtype/attribute/ecfsubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/ECF

EHC

numeric

ILR Learner FAM - Education Health Care plan
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/learnfamtypeLearnFAMType/attribute/ehcEHC

GCSE_ENG_GRADE

alphanumeric

ILR Learner - English GCSE Grade https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/enggradeEngGrade

GCSE_MATH_GRADE

alphanumeric

ILR Learner - Maths GCSE Grade https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/mathgradeMathGrade

PRIOREDU

numeric

ILR Learner - Prior Attainment (to 2020)
https://guidance.submit-learner-data.service.gov.uk/previous/20-21/ilr/field/priorattain

PRIORATTAINMENT 

numeric

03

ILR Learner - Prior Attainment Level
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/PriorAttain/field/PriorLevel

PRIORATTAINMENTDATE

date

31/08/2021

ILR Learner - Prior Attainment Level Applied from Date
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/PriorAttain/field/DateLevelApp

DELIV_LOC_SOURCE

numeric

E

Delivery Location/Postcode Source

1: From “DELIV_LOC_SOURCE_POSTCODE” field

2: Home Postcode

3: Specific Organisation - specify code in “DELIV_LOC_ORGCODE“ field
4: Same as Employer

5: Same as Provider

DELIV_LOC_ORGCODE

PICS Organisation Code

Delivery Location Organisation

DELIV_LOC_POSTCODE

Postcode

Delivery Location Postcode

PROG_START

date

Start of Programme

LRN_EXPEND

date

Expected End of Learning Portion of Apprenticeship

PROG_EXPEND

date

Expected End of Programme

MAINAIMREF

alphanumeric

Qualification Reference code for the main aim of Learning

DAS_COHORT

alphanumeric

Apprenticeship Service Cohort Reference

DAS_STATUS

numeric

Apprenticeship Service Status

0 - Non-AS
1 - AS Eligible
2 - Ready for AS
3 - Sent to AS
4 - On AS

CONTRACT

PICS Contract Code

PICS Contract

SCHOOL_ORGCODE

PICS Organisation Code

Creates a Learner “School“ Placement record with the same Start and Expected End dates as the Learner Episode

COLLEGE_ORGCODE

PICS Organisation Code

Creates a Learner “College“ Placement record with the same Start and Expected End dates as the Learner Episode

PLANLRNHRS_2021

numeric

ILR Planned Learning Hours for ILR Year 2021/22
https://guidance.submit-learner-data.service.gov.uk/21-22/ilr/entity/Learner/field/planlearnhoursPlanLearnHours

PLANEEPHRS_2021

numeric

ILR Planned EEP Hours for ILR Year 2021/22 https://guidance.submit-learner-data.service.gov.uk/21-22/ilr/entity/Learner/field/planeephoursPlanEEPHours

PLANLRNHRS_2022

numeric

ILR Planned Learning Hours for ILR Year 2022/23
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/planlearnhoursPlanLearnHours

PLANEEPHRS_2022

numeric

ILR Planned EEP Hours for ILR Year 2022/23 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/planeephoursPlanEEPHours

PLANLRNHRS_2023

Status
colourGreen
titleDue June 2022

numeric

ILR Planned Learning Hours for ILR Year 2023/24
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planlearnhours

PLANEEPHRS_2023

Status
colourGreen
titleDue June 2022

numeric

ILR Planned EEP Hours for ILR Year 2023/24

https://guidance.submit-learner-data.service.gov.uk/ilr/field/planeephours

JOBTITLE

Status
colourGreen
titleDue June 2022

string

Senior Software Developer

This will be applied to any Employer/Work placement records created

...

Column Name

Required?

Format

Example

Notes

PRIOR_EMPSTAT_CODE

numeric

ILR Employment - Status before Enrolment
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/empstatEmpStat

PRIOR_EMPSTAT_DATE

date

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

PRIOR_EMPSTAT_LOE

numeric

ILR Employment - Length of Employment before Enrolment
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/loeLOE

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.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/eiiEII

PRIOR_EMPSTAT_BSI

numeric

ILR Employment - Benefits Status Indicator before Enrolment
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/bsiBSI

PRIOR_EMPSTAT_SEM

numeric

ILR Employment - Small Employer before Enrolment
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/seiSEM

PRIOR_EMPSTAT_LOU

numeric

ILR Employment - Length of Unemployment before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uksubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/louLOU

PRIOR_EMPSTAT_PEI

numeric

ILR Employment - Previous Education Indicator before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilrsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/peiPEI

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/esmtypeESMType/attribute/oetOET

PRIOR_EMPSTAT_OET2

numeric

Status
colourYellow
titlenew for 2021/22

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

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

...

new for 2021/22

Column Name

Required?

Format

Example

Notes

CHANGE_EMPSTAT_CODE

numeric

ILR Employment - Status if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uksubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/empstatEmpStat

CHANGE_EMPSTAT_DATE

date

ILR Employment - Date Status if Changed on / after Start Applies https://guidance.submitlearnerdatabeta.fasst.org.uksubmit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/dateempstatappDateEmpStatApp

CHANGE_EMPSTAT_LOE

numeric

ILR Employment - Length of Employment if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uksubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/loeLOE

CHANGE_EMPSTAT_SEI

numeric

ILR Employment - Self Employment Indicator if Changed on / after Start

CHANGE_EMPSTAT_EII

numeric

ILR Employment - Employment Intensity Indicator if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/eiiSEI

CHANGE_EMPSTAT_BSIEII

numeric

ILR Employment - Benefits Status Employment Intensity Indicator if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/bsiEII

CHANGE_EMPSTAT_SEMBSI

numeric

ILR Employment - Small Employer Benefits Status Indicator if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/seisubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/BSI

CHANGE_EMPSTAT_LOUSEM

numeric

ILR Employment - Length of Unemployment Small Employer if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.orgsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/louSEM

CHANGE_EMPSTAT_PEILOU

numeric

ILR Employment - Previous Education Indicator Length of Unemployment if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilrsubmit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/peiLOU

CHANGE_EMPSTAT_OET1PEI

numeric

Status
colourYellow
title

ILR Employment - Other Employment Type 1
Previous Education Indicator if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/esmtypeESMType/attribute/oetPEI

CHANGE_EMPSTAT_OET2OET1

numeric

Status
colourYellow
titlenew for 2021/22

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

CHANGE_EMPSTAT_OET2

numeric

Status
colourYellow
titlenew for 2021/22

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

CHANGE_EMPSTAT_EMPCODE

PICS Organisation Code

ILR Employment - Employer if Changed on / after Start
If this field is not provided the CHANGE_EMPSTAT_EMPNAME, CHANGE_EMPSTAT_EMPPOSTCODE and CHANGE_EMPSTAT_EMPEDRS fields are used to find a matching Organisation record. If no match is found a new record is created using the other CHANGE_EMPSTAT_EMP??? fields provided

CHANGE_EMPSTAT_EMPNAME

alphanumeric

Employer Name - used for matching

CHANGE_EMPSTAT_EMPADDR1

alphanumeric

Employer Address - Line 1

CHANGE_EMPSTAT_EMPADDR2

alphanumeric

Employer Address - Line 2

CHANGE_EMPSTAT_EMPADDR3

alphanumeric

Employer Address - Line 3

CHANGE_EMPSTAT_EMPADDR4

alphanumeric

Employer Address - Line 4

CHANGE_EMPSTAT_EMPADDR5

alphanumeric

Employer Address - Line 5

CHANGE_EMPSTAT_EMPPHONE

numeric

Employer Phone

CHANGE_EMPSTAT_EMPEMAIL

alphanumeric

Employer Email Address

CHANGE_EMPSTAT_EMPPOSTCODE

Postcode

Employer Postcode - used for matching

CHANGE_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-

CHANGE_EMPSTAT_AGREEMENT_ID

6 alphanumeric

Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports

...

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/phoursPHours

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/learndelfamtypeLearnDelFAMType/attribute/sofSOF

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/learndelfamtypeLearnDelFAMType/attribute/actACT

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/dellocpostcodeDelLocPostCode

PROG_LSF

Status
colourYellow
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/learndelfamtypeLearnDelFAMType/attribute/lsfLSF

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/learndelfamtypeLearnDelFAMType/attribute/eefEEF

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/learndelfamtypeLearnDelFAMType/attribute/hhsHHS

* 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/learndelfamtypeLearnDelFAMType/attribute/resRES

PROG_A46A

numeric

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

PROG_A46B

numeric

ILR Learning Delivery FAM - Learner Data Monitoring (LDM 2)

PROG_A46C

numeric

ILR Learning Delivery FAM - Learner Data Monitoring (LDM 3)

PROG_A46D

numeric

ILR Learning Delivery - Provider specified delivery monitoring 1

ILR Learning Delivery FAM - Learner Data Monitoring (LDM 4)

PROG_A48A

alphanumeric

https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/provspecdelmonLearnDelFAMType/attribute/LDM

PROG_A48BA46C

alphanumericnumeric

ILR Learning Delivery - Provider specified delivery monitoring 2

PROG_A72A

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 3

PROG_A72B

alphanumericFAM - 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 - Provider specified delivery monitoring 4

ILR Component Aims

Multiple component aims can be included, but the last number of each column name below must be increased by 1 for each new qualification.

For example, AIMREF_1 becomes AIMREF_2 and then AIMREF_3.
There must be an AIMREF field for the other fields to be imported.

Column Name

Required?

Format

Example

Notes

AIMREF_1

Yes

alphanumeric

ILR Learning Delivery - Learning Aim Reference

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

ILR Component Aims

Multiple component aims can be included, but the last number of each column name below must be increased by 1 for each new qualification.

For example, AIMREF_1 becomes AIMREF_2 and then AIMREF_3.
There must be an AIMREF field for the other fields to be imported.

Column Name

Required?

Format

Example

Notes

AIMREF_1

Yes

alphanumeric

ILR Learning Delivery - Learning Aim Reference https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/LearnAimRef

AIMSTART_1

date

ILR Learning Delivery - Start Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/LearnStartDate

AIMEXPECT_1

date

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

AIMEND_1

date

ILR Learning Delivery - Actual End Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/LearnActEndDate

AIMTYPE_1

numeric

ILR Learning Delivery - Aim Type https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/learnaimrefAimType

AIMSTARTA10_1

datenumeric

ILR Learning Delivery - Start DateFunding Model https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/learnstartdateFundModel

AIMEXPECTA15_1

datenumeric

ILR Learning Delivery - Planned End Date
Programme Type https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/learnplanenddateProgType

AIMENDA11A_1

numeric

date105

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

AIMTYPEACT_1

numericalphanumeric

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

A10_1

numeric

ILR Learning Delivery - Funding Model
https://guidance.submit-learner-data.service.gov.uk/ilr/field/fundmodel

A15_1

numericLearnDelFAMType/attribute/ACT

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

AIM_DELIVLOC_1

Postcode

NR2 1LL

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

A11AEEF_1

numeric105

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

FFI_1

numeric

ILR Learning Delivery FAM

HHS_1

alphanumericalphanumeric

1*2

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

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

AIM_DELIVLOC_1

Postcode

NR2 1LL

ILR Learning Delivery - Delivery Location Postcode
https://guidance.submit-learner-data.service.gov.uk/ilr/field/dellocpostcode

EEFHHS

  • separated list of ILR codes

HHSA_1

numeric

1

ILR Learning Delivery FAM - Household Situation (HHS 1)

First ILR Code

HHSB_1

numeric

2

ILR Learning Delivery FAM - Household Situation (HHS 2)

Second ILR Code

RESTART_1

numeric

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

FFIA22_1

numeric

ILR Learning Delivery FAM

HHS_1

alphanumeric

1*2

ILR Learning Delivery FAM - Household Situation (HHS)

100321

HHSB_1

numeric

2

ILR Learning Delivery FAM - Household Situation (HHS 2)

Second ILR Code

ILR Learning Delivery - Subcontractor UKPRN https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/fieldentity/learndelfamtypeLearningDelivery/attributefield/hhs

  • separated list of ILR codes

HHSA_1

numeric

1

ILR Learning Delivery FAM - Household Situation (HHS 1)

First ILR Code

RESTARTPartnerUKPRN

PRIORFUNDADJ_1

numericILR Learning Delivery FAM - Restart Indicator (RES)

ILR Learning Delivery - Funding adjustment for prior learning https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/fieldentity/learndelfamtypeLearningDelivery/attributefield/resPriorLearnFundAdj

A22OTHERFUNDADJ_1

numeric100321

ILR Learning Delivery - Subcontractor UKPRNOther Funding Adjustment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/partnerukprnOtherFundAdj

PRIORFUNDADJA46A_1

numeric

ILR Learning Delivery - Funding adjustment for prior learning
FAM - Learner Data Monitoring (LDM 1) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/priorlearnfundadjattribute/LDM

OTHERFUNDADJA46B_1

numeric

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

A46C_1

numeric

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

A46BA46D_1

numeric

ILR Learning Delivery FAM - Learner Data Monitoring (LDM 2)

A46C_1

numeric

ILR Learning Delivery FAM - Learner Data Monitoring (LDM 3)

A46D_1

numeric

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

A48A_1

alphanumeric

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

A48B_1

alphanumeric

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

A72A_1

alphanumeric

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

A72B_1

alphanumeric

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

AIMASSESSOR_1

PICS Officer Code

Aim Main Assessor PICS Officer

AIMIV_1

PICS Officer Code

Aim Main Internal Verifier PICS Officer

AIMEV_1

PICS Officer Code

Aim Main External Verifier PICS OfficerAIMDAM1Officer

AIMDAM1_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (DAM1) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM

AIMDAM2_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (DAM1DAM2)
ILR Specification: Attribute field: Devolved Area Monitoring AIMDAM2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM

AIMDAM3_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (DAM2)AIMDAM3(DAM3) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM

AIMDAM4_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (DAM3)AIMDAM4DAM4) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM

AIMDAM5_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (DAM4)

AIMDAM5_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (DAM5)DAM5) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM

AIMDAM6_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (DAM6) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM

Apprenticeship Costs

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/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/appfinrecordAppFinRecord/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

...