Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Info box added, with links to guidance on UDF/Officer/Codes in Imports

...

A CSV or XLSX file import can be used to import Learner data from other data sources. The table below shows what types of imports are available for learners.

Supported Options

 

CSV file format accepted

(tick)

XLSX file format accepted

(tick)

User Defined Fields supported

(tick)

Record Handling

 

Single record in file

User redirected to the New Learner window

Multiple records in file

File added to the Import List with a status of Pending

Info

Further information is also available on the following:

Column Name

Required?

Format

Example

Notes

FIRSTNAME

string

Roberta

PREFFIRSTNAME

Status
colourGreen
titleexpected mid October 2023

string

Ro

Preferred First Name

SURNAME

string

Smith

PREV_SURNAME

string

Jones

SEX

string

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

ETHNICORIGIN

numeric

33

ILR Ethnicity
https://guidance.

submitlearnerdatabeta.fasst.org.uk

submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/

ethnicity

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

string

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.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/

llddhealthprob

LLDDHealthProb

ALL_LLDD

string

12*13*96

ILR LLDD codes


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/LLDDandHealthProblem/field/

llddcat

LLDDCat

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

submit-learner-data.service.gov.uk/21-22/ilr/entity/ContactPreference/field/ContPrefType/attribute/

contprefcode

RUI

L52

string

456

ILR Preferred Method of Contact


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/ContactPreference/field

/contprefcode

/ContPrefType/attribute/PMC

L34A

string

36

ILR Learner FAM - Learner Support Reason 1

https://guidance.

submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamcode

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR

L34B

string

ILR Learner FAM - Learner Support Reason 2

https://guidance.

submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamcode

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR

L34C

string

ILR Learner FAM - Learner Support Reason 3

https://guidance.

submitlearnerdatabeta.fasst.org.uk

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/

learnfamcode

LearnFAMType/attribute/LSR

L34D

string

ILR Learner FAM - Learner Support Reason 4

https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/

learnfamcode

attribute/LSR

L31

numeric

ILR Learner - Learning Support


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/

alscost

ALSCost

DLA

numeric

ILR Learner FAM - Disabled Students Allowance


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/

learnfamcode

DLA

ACCOM

numeric

ILR Learner Accommodation


https://guidance.

submitlearnerdatabeta.fasst.org.uk

submit-learner-data.service.gov.uk/22-23/ilr/

field/accom

entity/Learner/field/Accom

L40A

numeric

ILR Learner FAM - National Learner Monitoring 1


https://guidance.

submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamcode

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/NLM

L40B

numeric

ILR Learner FAM - National Learner Monitoring

1

2 https://guidance.

submitlearnerdatabeta.fasst.org.uk

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/

learnfamcode

LearnFAMType/attribute/NLM

L42A

numeric

ILR Learner - Provider Specified Monitoring 1


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/

providerspeclearnermonitoring

ProviderSpecLearnerMonitoring/field/ProvSpecLearnMon

L42B

numeric

ILR Learner - Provider Specified Monitoring 2


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/

providerspeclearnermonitoring

ProvSpecLearnMon

MCF

numeric

ILR Learner - Maths Condition of Funding


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/

learnfamtype

LearnFAMType/attribute/

mcf

MCF

ECF

numeric

ILR Learner - English Condition of Funding


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/

learnfamtype

LearnFAMType/attribute/

ecf

ECF

EHC

numeric

ILR Learner FAM - Education Health Care plan


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

learnfamtype

LearnFAMType/attribute/

ehc

EHC

GCSE_ENG_GRADE

alphanumeric

ILR Learner - English GCSE Grade

https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/

enggrade

EngGrade

GCSE_MATH_GRADE

alphanumeric

ILR Learner - Maths GCSE Grade

https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/

mathgrade

MathGrade

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

StatuscolourYellowtitle

new for 2021/22

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

priorlevel

PriorLevel

PRIORATTAINMENTDATE

date

31/08/

2021 StatuscolourYellowtitlenew for

2021

/22

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

datelevelapp

Column Name

Required?

Format

Example

Notes

PRIOR_EMPSTAT_CODE

numeric

ILR Employment - Status before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/empstat

PRIOR_EMPSTAT_DATE

date

ILR Employment - Date Status before Enrolment Applies

https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/dateempstatapp

PRIOR_EMPSTAT_LOE

numeric

ILR Employment - Length of Employment before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/loe

PRIOR_EMPSTAT_SEI

numeric

ILR Employment - Self Employment Indicator before Enrolment

PRIOR_EMPSTAT_EII

numeric

ILR Employment - Employment Intensity Indicator before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/eii

PRIOR_EMPSTAT_BSI

numeric

ILR Employment - Benefits Status Indicator before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/bsi

PRIOR_EMPSTAT_SEM

numeric

ILR Employment - Small Employer before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/sei

PRIOR_EMPSTAT_LOU

numeric

ILR Employment - Length of Unemployment before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/lou

PRIOR_EMPSTAT_PEI

numeric

ILR Employment - Previous Education Indicator before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/pei

PRIOR_EMPSTAT_OET1

numeric

Status
colourYellow
titlenew for 2021/22
ILR Employment - Other Employment Type 1

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

MAINAIM_OTHERFUNDADJ

numeric

Other Funding Adjustment to apply to the Main ILR Component Aim

https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/OtherFundAdj

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 2021
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planlearnhours

PLANEEPHRS_2021

numeric

ILR Planned EEP Hours for 2021

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

PLANLRNHRS_2022

numeric

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

PLANEEPHRS_2022

numeric

ILR Planned EEP Hours for 2022

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

ILR Employment - Before Enrolment

DAS_RPL_IDENTIFIED

string

Y

Apprenticeship Service Recognised Prior Learning - used in the Apprenticeship Service Bulk Upload

https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification
Y - Yes
N - No

DAS_TRAININGHOURSREDUCTION

Apprenticeship Service Off-the-job training reduced due to prior learning - used in the Apprenticeship Service Bulk Upload

https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification

DAS_TOTALTRAININGHOURS

number

Apprenticeship Service Total off-the-job hours for the apprenticeship standard - used in the Apprenticeship Service Bulk Upload

https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification

DAS_DURATIONREDUCED

number

Apprenticeship Service Duration Reduced by Weeks - used in the Apprenticeship Service Bulk Upload

https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification

DAS_PRICEREDUCED

number

1250

Apprenticeship Service Price Reduced by £s - used in the Apprenticeship Service Bulk Upload

https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification

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

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

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

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

PLANLRNHRS_2023

numeric

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

PLANEEPHRS_2023

numeric

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

JOBTITLE

string

Senior Software Developer

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

BKSB_USERNAME

string

Learner’s bksb username or User ID

SMARTASSESSOR_ID

string

d053223cd2fa46479a6e30923a2c20c6

Learner’s Smart Assessor User ID

ILR Employment - Before Enrolment

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/

field

entity/

esmtype

LearnerEmploymentStatus/

attribute

field/

oet

DateEmpStatApp

PRIOR_EMPSTAT_

OET2

LOE

numeric

StatuscolourYellow

titlenew for 2021/22

ILR Employment -

Other Employment Type 2

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

esmtype

ESMType/attribute/

oet

LOE

PRIOR_EMPSTAT_

EMPCODE

SEI

PICS Organisation Code

numeric

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

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_

EMPNAME

BSI

alphanumeric

numeric

Employer Name - used for matching

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_

EMPADDR1

SEM

alphanumeric

numeric

Employer Address - Line 1

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_

EMPADDR2

LOU

alphanumeric

Employer Address - Line 2

PRIOR_EMPSTAT_EMPADDR3

alphanumeric

Employer Address - Line 3

PRIOR_EMPSTAT_EMPADDR4

alphanumeric

Employer Address - Line 4

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_

EMPADDR5

PEI

alphanumeric

numeric

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

ILR Employment - Previous Education Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/

hc/en-gb/articles/360014179980-Using-the-Employer-Data-Service-EDS-to-find-an-Employer-Registration-Number-ERN-

22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/PEI

PRIOR_EMPSTAT_

AGREEMENT_ID

6 alphanumeric

Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports

OET1

numeric

ILR Employment -

...

Column Name

Required?

Format

Example

Notes

CHANGE_EMPSTAT_CODE

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

ILR Employment -

Status if Changed on / after Start

Other Employment Type 2 https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/

empstat

attribute/OET

CHANGE

PRIOR_EMPSTAT_

DATE

EMPCODE

date

PICS Organisation Code

ILR Employment -

Date Status if Changed on / after Start Applies

https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/dateempstatapp

CHANGE_EMPSTAT_LOE

numeric

ILR Employment - Length of Employment if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/loe

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.org.uk/ilr/field/esmtype/attribute/eii

CHANGE_EMPSTAT_BSI

numeric

ILR Employment - Benefits Status Indicator if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/bsi

CHANGE_EMPSTAT_SEM

numeric

ILR Employment - Small Employer if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/sei

CHANGE_EMPSTAT_LOU

numeric

ILR Employment - Length of Unemployment if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/lou

CHANGE_EMPSTAT_PEI

numeric

ILR Employment - Previous Education Indicator if Changed on / after Start
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/pei

CHANGE_EMPSTAT_OET1

numeric

Status
colourYellow
titlenew for 2021/22
ILR Employment - Other Employment Type 1

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

ILR Employment - Change on/after Start

Column Name

Required?

Format

Example

Notes

CHANGE_EMPSTAT_CODE

numeric

ILR Employment - Status if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/EmpStat

CHANGE_EMPSTAT_DATE

date

ILR Employment - Date Status if Changed on / after Start Applies https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/DateEmpStatApp

CHANGE_EMPSTAT_LOE

numeric

ILR Employment - Length of Employment if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/

esmtype

ESMType/attribute/

oet

LOE

CHANGE_EMPSTAT_

OET2

SEI

numeric

Status
colourYellow
titlenew for 2021/22

ILR Employment -

Other Employment Type 2

Self Employment Indicator if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/

esmtype

ESMType/attribute/

oet

SEI

CHANGE_EMPSTAT_

EMPCODE

EII

PICS Organisation Code

numeric

ILR Employment -

Employer

CHANGE_EMPSTAT_EMPNAME

alphanumeric

Employer Name - used for matching

Employment Intensity Indicator 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

https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/EII

CHANGE_EMPSTAT_

EMPADDR1

BSI

alphanumeric

numeric

Employer Address - Line 1

CHANGE_EMPSTAT_EMPADDR2

alphanumeric

Employer Address - Line 2

ILR Employment - Benefits Status Indicator if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/BSI

CHANGE_EMPSTAT_

EMPADDR3

SEM

alphanumeric

numeric

Employer Address - Line 3

CHANGE_EMPSTAT_EMPADDR4

alphanumeric

Employer Address - Line 4

CHANGE_EMPSTAT_EMPADDR5

alphanumeric

Employer Address - Line 5

ILR Employment - Small Employer if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/SEM

CHANGE_EMPSTAT_

EMPPHONE

LOU

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

ILR Programme Aim

Column Name

Required?

Format

Example

Notes

OTJHOURS

numeric

ILR Learning Delivery - Planned Hours

ILR Employment - Length of Unemployment if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/LOU

CHANGE_EMPSTAT_PEI

numeric

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

CHANGE_EMPSTAT_OET1

numeric

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

phours

PROG_A11A

numeric

105

ILR Learning Delivery FAM - Source of Funding (SOF)

ESMType/attribute/OET

CHANGE_EMPSTAT_OET2

numeric

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

learndelfamtype

ESMType/attribute/

sof

OET

PROG

CHANGE_EMPSTAT_

ACT

EMPCODE

alphanumeric

PICS Organisation Code

ILR

Learning Delivery FAM - Apprenticeship Contract Type (ACT)
https://guidance.

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

ILR Programme Aim

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

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

LearnDelFAMType/attribute/

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

PROG_DELIVLOC

Postcode

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 -

Delivery Location Postcode

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

field

entity/

dellocpostcode

ProviderSpecDeliveryMonitoring

PROG_

LSF
Status
colourYellow
titleCOMING Feb 2022

numeric

A72A

alphanumeric

ILR Learning Delivery

FAM - Learning Support Funding (LSF)

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

field/learndelfamtype/attribute/lsf

entity/ProviderSpecDeliveryMonitoring

PROG_

EEF

A72B

numeric

alphanumeric

ILR Learning Delivery

FAM - Eligibility for Enhanced Funding (EEF)

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

field/learndelfamtype/attribute/eef

PROG_HHS

alphanumeric

1*2

ILR Learning Delivery FAM - Household Situation (HHS)

https://guidance.submit-learner-data.service.gov.uk/ilr/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)

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/

field

entity/

learndelfamtype

LearningDelivery/

attribute

field/

res

LearnStartDate

PROG

AIMEXPECT_

A46A

1

numeric

date

ILR Learning Delivery

FAM - Learner Data Monitoring (LDM 1)

- Planned End Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/

field

entity/

learndelfamtype

LearningDelivery/

attribute

field/

ldm

LearnPlanEndDate

PROG

AIMEND_

A46B

1

numeric

date

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 FAM - Learner Data Monitoring (LDM 4)

PROG_A48A

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 1

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

provspecdelmon

AimType

PROG

A10_

A48B

1

alphanumeric

numeric

ILR Learning Delivery

- Provider specified delivery monitoring 2

PROG_A72A

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 3

PROG_A72B

alphanumeric

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.

Column Name

Required?

Format

Example

Notes

AIMREF_1

Yes

alphanumeric

ILR Learning Delivery - Learning Aim Reference

- Funding Model https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/FundModel

A15_1

numeric

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

A11A_1

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

ACT_1

alphanumeric

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

/learnaimref

AIMSTART_1

date

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

Start Date

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

learnstartdate

DelLocPostCode

AIMEXPECT

EEF_1

date

numeric

ILR Learning Delivery

- Planned End Date

FAM - Eligibility for Enhanced Funding (EEF) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/

field/learnplanenddate

AIMEND_1

date

entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/EEF

FFI_1

numeric

ILR Learning Delivery FAM

HHS_1

alphanumeric

1*2

ILR Learning Delivery FAM -


Household Situation (HHS) https://guidance.submit-learner-data.service.gov.

uk/ilr/field/learnactenddateAIMTYPE

uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/HHS

  • 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

- Aim Type
https://guidance.submit-learner-data.service.gov.uk/ilr/field/aimtype A10

FAM - Household Situation (HHS 2)

Second ILR Code

RESTART_1

numeric

ILR Learning Delivery

- Funding Model

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

fundmodelA15

LearnDelFAMType/attribute/RES

A22_1

numeric

100321

ILR Learning Delivery -

Programme Type

Subcontractor UKPRN https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/

progtype

PartnerUKPRN

A11A

PRIORFUNDADJ_1

numeric

105

ILR Learning Delivery

FAM

-

Source of Funding (SOF)

Funding adjustment for prior learning https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/

field

entity/

learndelfamtype

LearningDelivery/

attribute

field/

sof

PriorLearnFundAdj

ACT

OTHERFUNDADJ_1

alphanumeric

numeric

ILR Learning Delivery

FAM - Apprenticeship Contract Type (ACT)

- Other Funding Adjustment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/

field

entity/

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

LearningDelivery/field/OtherFundAdj

A46A_1

numeric

ILR Learning Delivery

- Delivery Location Postcode

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

dellocpostcode

attribute/LDM

EEF

A46B_1

numeric

ILR Learning Delivery FAM -

Eligibility for Enhanced Funding (EEF)

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

learndelfamtype

LearnDelFAMType/attribute/

eef

LDM

FFI

A46C_1

numeric

ILR Learning Delivery FAM

HHS_1

alphanumeric

1*2

numeric

ILR Learning Delivery FAM -

Household Situation (HHS)

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

learndelfamtype

LearnDelFAMType/attribute/

hhs
  • separated list of ILR codes

HHSA

LDM

A46D_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 - Restart Indicator (RES)

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

learndelfamtype

LearnDelFAMType/attribute/

res

LDM

A22100321

A48A_1

numeric

alphanumeric

ILR Learning Delivery -

Subcontractor UKPRN

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

field

entity/

partnerukprn

ProviderSpecDeliveryMonitoring

PRIORFUNDADJ

A48B_1

numeric

alphanumeric

ILR Learning Delivery

- Funding adjustment for prior learning

- 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 3 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/

field

entity/

priorlearnfundadj

ProviderSpecDeliveryMonitoring

OTHERFUNDADJ

A72B_1

numeric

alphanumeric

ILR Learning Delivery -

Other Funding Adjustment

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

field/otherfundadjA46A

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 Officer

AIMDAM1_1

numeric

001

ILR Learning Delivery FAM -

Learner Data

Devolved Area Monitoring (

LDM 1

DAM1)

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

learndelfamtype

LearnDelFAMType/attribute/

ldm

DAM

A46B

A46C_1

numeric

AIMDAM2_1

numeric

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

001

ILR Learning Delivery FAM -

Learner Data Monitoring (LDM 3)

A46D_1

numeric

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

A48A_1

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 1

Devolved Area Monitoring (DAM2) https://guidance.submit-learner-data.service.

gov.uk/ilr/field/provspecdelmon

A48B_1

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 2

A72A_1

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 3

A72B_1

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 4

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 Officer

AIMDAM1

gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM

AIMDAM3_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (

DAM1AIMDAM2

DAM3)


ILR Specification: Attribute field: Devolved Area Monitoring

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 (

DAM2)AIMDAM3

DAM4) 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 (

DAM3)

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

appfinrecord

Column Name

Required?

Format

Example

Notes

LIT_FIRSTASSDATE

date

31/08/2021

English/Literacy Assessment Date

LIT_FIRSTASSLEV

alphanumeric

D

English/Literacy Assessment Level

X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy

LIT_FIRSTASSRES

numeric

67

English/Literacy Assessment Result

NUM

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

Functional Skills Assessments

ADD_EMP

numeric

5000

Additional Employer Price

ADD_EMP_START

numeric

4000

Additional Employer Lump Sum

ADD_EMP_SPRD

alphanumeric

Additional Employer Encoding of spreading method

Functional Skills Initial Assessments

Note

From the PICS release for the 2023/24 ILR Year (due mid August 2023) imports of Functional Skills Initial Assessments will require either a Level or a Result to be processed. If a date is not specified the Episode Start date will be used.

Column Name

Required?

Format

Example

Notes

LIT_FIRSTASSDATE

date

31/08/2021

Maths

English/

Numeracy

Literacy Initial Assessment Date

NUMNUM

LIT_FIRSTASSLEV

alphanumeric

D

Maths/Numeracy Assessment Level

X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy

English/Literacy Initial Assessment Level

See Code Lists

LIT_FIRSTASSRES

numeric

67

Maths

English/

Numeracy

Literacy Initial Assessment Result

ICT

NUM_FIRSTASSDATE

date

31/08/2021

ICT

Maths/Numeracy Initial Assessment Date

ICT

NUM_FIRSTASSLEV

alphanumeric

D

ICT

Maths/Numeracy Initial Assessment Level

X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy

See Code Lists

NUM_FIRSTASSRES

numeric

67

Maths/Numeracy Initial Assessment Result

ICT_FIRSTASSDATE

date

31/08/2021

ICT Initial Assessment Date

ICT_FIRSTASSLEV

alphanumeric

D

ICT Initial Assessment Level

See Code Lists

ICT_FIRSTASSRES

numeric

67

ICT Initial Assessment Result

ESOL_FIRSTASSDATE

date

31/08/2021

English as a Second Language Initial Assessment Date

ESOL_FIRSTASSLEV

alphanumeric

D

English as a Second Language Initial Assessment Level

X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy

See Code Lists

ESOL_FIRSTASSRES

numeric

67

English as a Second Language Initial Assessment Result

Prior Qualifications

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

For example, PRIORQUAL_TITLECODE_1 becomes PRIORQUAL_TITLECODE_2 and then PRIORQUAL_TITLECODE_3.

Column Name

Required?

Format

Example

Notes

PRIORQUAL_TITLECODE_1

Title or Code

5 alphanumeric

0005Z

PICS Code for the Title of the Prior Qualification

PRIORQUAL_NAME_1

Title or Code

string

Maths GCSE

Title for the Prior Qualification

PRIORQUAL_LEVEL_CODE_1

5 alphanumeric

GCSE01

PICS Code for the Level

PRIORQUAL_LEVEL_1

string

GCSE

Level

PRIORQUAL_GRADE_CODE_1

5 alphanumeric

GCSE1

PICS Code for the Grade

PRIORQUAL_GRADE_1

string

1

Grade

PRIORQUAL_ACHDATE_1

date

Achievement Date

Advanced Learning Loans/SLC

Column Name

Required?

Format

Example

Notes

SLC_APPID

alphanumeric

Application ID

SLC_CUSTREF

alphanumeric

Customer Reference

SLC_COURSECOST

numeric

Course Cost Excluding VAT

SLC_COURSEVAT

numeric

Course Cost VAT

SLC_LOANAMOUNT

numeric

Loan Amount

SLC_LOANSTART

date

Loan Start Date

SLC_LOANEND

date

Loan End Date

SLC_BALANCE

numeric

Balance for Learner to Pay