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

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

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

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

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

contprefcode

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

contprefcode

PMC

L34A

string

36

ILR Learner FAM - Learner Support Reason 1

https://guidance.

submitlearnerdatabeta.fasst.org

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

learnfamcode

LearnFAMType/attribute/LSR

L34B

string

ILR Learner FAM - Learner Support Reason 2

https://guidance.

submitlearnerdatabeta.fasst.org

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

learnfamcode

LSR

L34C

string

ILR Learner FAM - Learner Support Reason 3

https://guidance.

submitlearnerdatabeta.fasst.org

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

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

learnfamcode

LearnFAMType/attribute/LSR

L31

numeric

ILR Learner - Learning Support


https://guidance.

submitlearnerdatabeta.fasst.org.uk/ilr

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

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

accom

Accom

L40A

numeric

ILR Learner FAM - National Learner Monitoring 1


https://guidance.

submitlearnerdatabeta.fasst.org

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

learnfamcode

LearnFAMType/attribute/NLM

L40B

numeric

ILR Learner FAM - National Learner Monitoring

1

2 https://guidance.

submitlearnerdatabeta.fasst.org

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

learnfamcode

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

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

providerspeclearnermonitoring

field/ProvSpecLearnMon

MCF

numeric

ILR Learner - Maths Condition of Funding


https://guidance.

submitlearnerdatabeta.fasst.org

submit-learner-data.service.gov.uk/

ilr/

22-23/ilr/entity/LearnerFAM/field/

learnfamtype

LearnFAMType/attribute/

mcf

MCF

ECF

numeric

ILR Learner - English Condition of Funding


https://guidance.

submitlearnerdatabeta.fasst.org.uk

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

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

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

PLANEEPHRS_2021

numeric

ILR Planned EEP Hours for ILR Year 2021/22

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

PLANLRNHRS_2022

numeric

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

PLANEEPHRS_2022

numeric

ILR Planned EEP Hours for ILR Year 2022/23

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

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

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/

ilr/

21-22/ilr/entity/Learner/field/

planeephours

JOBTITLE

Status
colourGreen
titleDue June 2022

string

Senior Software Developer

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

ILR Employment - Before Enrolment

Column Name

Required?

Format

Example

Notes

PRIOR_EMPSTAT_CODE

numeric

ILR Employment - Status before Enrolment

PlanLearnHours

PLANEEPHRS_2021

numeric

ILR Planned EEP Hours for ILR Year 2021/22 https://guidance.

submitlearnerdatabeta.fasst.org.uk/ilr

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

empstat

PlanEEPHours

PRIOR

PLANLRNHRS_

EMPSTAT_DATE

ILR Employment - Date Status before Enrolment Applies

2022

date

numeric

ILR Planned Learning Hours for ILR Year 2022/23 https://guidance.

submitlearnerdatabeta.fasst.org

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

dateempstatapp

PlanLearnHours

PRIOR

PLANEEPHRS_

EMPSTAT_LOE

2022

numeric

ILR

Employment - Length of Employment before Enrolment

Planned EEP Hours for ILR Year 2022/23 https://guidance.

submitlearnerdatabeta.fasst.org.uk

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

field

entity/

esmtype

Learner/

attribute

field/

loe

PlanEEPHours

PRIOR

PLANLRNHRS_

EMPSTAT_SEI

2023

numeric

ILR

Employment - Self Employment Indicator before Enrolment

PRIOR_EMPSTAT_EII

numeric

ILR Employment - Employment Intensity Indicator before Enrolment

Planned Learning Hours for ILR Year 2023/24 https://guidance.

submitlearnerdatabeta.fasst.org

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

field

entity/

esmtype

Learner/

attribute

field/

eii

PlanLearnHours

PRIOR

PLANEEPHRS_

EMPSTAT_BSI

2023

numeric

ILR

Employment - Benefits Status Indicator before Enrolment

Planned EEP Hours for ILR Year 2023/24 https://guidance.

submitlearnerdatabeta.fasst.org

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

field

entity/

esmtype

Learner/

attribute

field/

bsi

PRIOR_EMPSTAT_SEM

numeric

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

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_

LOU

CODE

numeric

ILR Employment -

Length of Unemployment

Status before Enrolment


https://guidance.

submitlearnerdatabeta.fasst.org

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

field

entity/

esmtype

LearnerEmploymentStatus/

attribute

field/

lou

EmpStat

PRIOR_EMPSTAT_

PEI

DATE

numeric

date

ILR Employment -

Previous Education Indicator

Date Status before Enrolment


Applies https://guidance.

submitlearnerdatabeta.fasst.org

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

field

entity/

esmtype

LearnerEmploymentStatus/

attribute

field/

pei

DateEmpStatApp

PRIOR_EMPSTAT_

OET1

LOE

numeric

Status
colourYellow
titlenew for 2021/22

ILR Employment -

Other Employment Type 1

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_

OET2

SEI

numeric

Status
colourYellow
titlenew for 2021/22

ILR Employment -

Other Employment Type 2

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

esmtype

ESMType/attribute/

oet

SEI

PRIOR_EMPSTAT_

EMPCODE

EII

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

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_

EMPNAME

SEM

alphanumeric

numeric

Employer Name - used for matching

PRIOR_EMPSTAT_EMPADDR1

alphanumeric

Employer Address - Line 1

PRIOR_EMPSTAT_EMPADDR2

alphanumeric

Employer Address - Line 2

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_

EMPADDR3

LOU

alphanumeric

numeric

Employer Address - Line 3

PRIOR_EMPSTAT_EMPADDR4

alphanumeric

Employer Address - Line 4

PRIOR_EMPSTAT_EMPADDR5

alphanumeric

Employer Address - Line 5

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_

EMPPHONE

PEI

numeric

Employer Phone

PRIOR_EMPSTAT_EMPEMAIL

alphanumeric

Employer Email Address

PRIOR_EMPSTAT_EMPPOSTCODE

Postcode

Employer Postcode - used for matching

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_

EMPEDRS

OET1

numeric

Employer EDS Registration Number - used for matching

ILR Employment - Other Employment Type 1 https://

esfahelp.education

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

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

OET2

numeric

ILR Employment - Other Employment Type 2 https://guidance.

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

CHANGE_EMPSTAT_DATE

date

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

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

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/

field

entity/

esmtype

LearnerEmploymentStatus/

attribute

field/

oet

DateEmpStatApp

CHANGE_EMPSTAT_

OET2

LOE

numeric

StatuscolourYellowtitle

new for 2021/22

ILR Employment -

Other Employment Type 2

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_

EMPCODE

SEI

PICS Organisation Code

numeric

ILR Employment -

Employer

Self Employment 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/SEI

CHANGE_EMPSTAT_EII

numeric

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

CHANGE_EMPSTAT_

EMPNAME

BSI

alphanumeric

numeric

Employer Name - used for matching

CHANGE_EMPSTAT_EMPADDR1

alphanumeric

Employer Address - Line 1

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_

EMPADDR2

SEM

alphanumeric

numeric

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

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

numeric

Employer Phone

CHANGE_EMPSTAT_EMPEMAIL

alphanumeric

Employer Email Address

CHANGE_EMPSTAT_EMPPOSTCODE

Postcode

Employer Postcode - used for matching

LOU

numeric

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_

EMPEDRS

PEI

numeric

Employer EDS Registration Number - used for matching

ILR Employment - Previous Education Indicator if Changed on / after Start https://

esfahelp.education

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

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

OET1

numeric

ILR

Learning Delivery - Planned Hours

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

phoursPROG_A11A

attribute/OET

CHANGE_EMPSTAT_OET2

numeric

105

ILR

Learning Delivery FAM - Source of Funding (SOF)

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

1 alphanumeric

L

ILR Learning Delivery FAM - Apprenticeship Contract Type (ACT)

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

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

LearnDelFAMType/attribute/

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

PROG_DELIVLOC

Postcode

HHS

* separated list of ILR codes

PROG_HHSA

numeric

1

ILR Learning Delivery

- Delivery Location Postcode
https://guidance.submit-learner-data.service.gov.uk/ilr/field/dellocpostcode PROG_LSF StatuscolourYellowtitleCOMING Feb 2022

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 -

Learning Support Funding (LSF)

Restart Indicator (RES) https://guidance.submit-learner-data.service.gov.uk

/ilr

/22-23/ilr/entity/LearningDeliveryFAM/field/

learndelfamtype

LearnDelFAMType/attribute/

lsf

RES

PROG_

EEF

A46A

numeric

ILR Learning Delivery FAM -

Eligibility for Enhanced Funding (EEF)

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

learndelfamtype

LearnDelFAMType/attribute/

eef

LDM

PROG_

HHS

alphanumeric

1*2

A46B

numeric

ILR Learning Delivery FAM -

Household Situation (HHS)

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

field

entity/

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

LearningDeliveryFAM/field/LearnDelFAMType/attribute/LDM

PROG_A46C

numeric

ILR Learning Delivery FAM -

Household Situation (HHS 2)
Second ILR CodePROG_RES

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 -

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

PROG_

A46A

A48A

numeric

alphanumeric

ILR Learning Delivery

FAM - Learner Data Monitoring (LDM 1)

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

ilr/field/learndelfamtype/attribute/ldm

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

PROG_A48A

22-23/ilr/entity/ProviderSpecDeliveryMonitoring

PROG_A48B

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring

1

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

field

entity/

provspecdelmon

ProviderSpecDeliveryMonitoring

PROG_

A48B

A72A

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring

2

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

PROG_

A72A

A72B

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring

3

PROG_A72B

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 4

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.

...

Column Name

...

Required?

...

Format

...

Example

...

Notes

...

AIMREF_1

...

Yes

...

alphanumeric

...

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/

learnaimref

LearnPlanEndDate

AIMSTART

AIMEND_1

date

ILR Learning Delivery -

Start

Actual End Date

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

learnstartdate

LearnActEndDate

AIMEXPECT

AIMTYPE_1

date

numeric

ILR Learning Delivery -

Planned End Date

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

learnplanenddate

AimType

AIMEND

A10_1

date

numeric

ILR Learning Delivery -


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

learnactenddate

FundModel

AIMTYPE

A15_1

numeric

ILR Learning Delivery -

Aim

Programme Type


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

aimtype

ProgType

A10

A11A_1

numeric

105

ILR Learning Delivery FAM -

Funding Model

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

fundmodelA15

LearnDelFAMType/attribute/SOF

ACT_1

numeric

alphanumeric

ILR Learning Delivery FAM -

Programme Type

Apprenticeship Contract Type (ACT) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/

field/progtypeA11A

entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/ACT

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

AIM_DELIVLOC_1

numeric

Postcode

105

NR2 1LL

ILR Learning Delivery

FAM - Source of Funding (SOF)

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

field

entity/

learndelfamtype

LearningDelivery/

attribute

field/

sof

DelLocPostCode

ACT

EEF_1

alphanumeric

numeric

ILR Learning Delivery FAM -

Apprenticeship Contract Type (ACT)

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

learndelfamtype

LearnDelFAMType/attribute/

act

AIM_DELIVLOC_1

Postcode

NR2 1LL

EEF

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

FFI_1

numeric

ILR Learning Delivery FAM

HHS_1

alphanumeric

1*2

ILR Learning Delivery

- Delivery Location Postcode

FAM - Household Situation (HHS) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/

field/dellocpostcodeEEF

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

learndelfamtype

LearnDelFAMType/attribute/

eef

RES

FFI

A22_1

numeric

ILR Learning Delivery FAM

HHS_1

alphanumeric

1*2

100321

ILR Learning Delivery

FAM - Household Situation (HHS)

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

field

entity/

learndelfamtype/attribute/hhs
  • separated list of ILR codes

HHSA_1

numeric

1

ILR Learning Delivery FAM - Household Situation (HHS 1)

First ILR Code

HHSB

LearningDelivery/field/PartnerUKPRN

PRIORFUNDADJ_1

numeric

2

ILR Learning Delivery

FAM - Household Situation (HHS 2)

Second ILR Code

RESTART

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

OTHERFUNDADJ_1

numeric

ILR Learning Delivery

FAM - Restart Indicator (RES)

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

field

entity/

learndelfamtype

LearningDelivery/

attribute

field/

res

OtherFundAdj

A22

A46A_1

numeric

100321

ILR Learning Delivery

- Subcontractor UKPRN

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

partnerukprnPRIORFUNDADJ

LearnDelFAMType/attribute/LDM

A46B_1

numeric

ILR Learning Delivery

- Funding adjustment for prior learning

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

priorlearnfundadjOTHERFUNDADJ

LearnDelFAMType/attribute/LDM

A46C_1

numeric

ILR Learning Delivery

- Other Funding Adjustment

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

otherfundadj

LDM

A46A

A46D_1

numeric

ILR Learning Delivery FAM - Learner Data Monitoring (LDM

1

4)

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

learndelfamtype

LearnDelFAMType/attribute/

ldm

LDM

A46B

A48A_1

numeric

alphanumeric

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)

A48A

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

A48B_1

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring

1

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

field

entity/

provspecdelmon

ProviderSpecDeliveryMonitoring

A48B

A72A_1

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring

2A72A

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

A72B_1

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring

3

A72B_1

alphanumeric

ILR Learning Delivery - Provider specified delivery monitoring 4

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 Officer

AIMDAM1_1

numeric

001

ILR Learning Delivery FAM - Devolved Area Monitoring (DAM1)


ILR Specification: Attribute field: Devolved Area Monitoring

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

- Devolved Area Monitoring (DAM2) 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 (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 (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 (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/ilr/entity/appfinrecord

.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

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

NUM

LIT_FIRSTASSLEV

alphanumeric

D

Maths

English/

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

NUM

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