Learner Import Specification in PICSWeb

Owned by Joe Robson (Unlicensed), created
Last updated: May 10, 2024 by Harry KempVersion comment
8 min read

Instructions on using this specification to create an import file are available in Uploading a New Import File.

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

XLSX file format accepted

User Defined Fields supported

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

Further information is also available on the following:

Column Name

Required?

Format

Example

Notes

Column Name

Required?

Format

Example

Notes

FIRSTNAME

 

string

Roberta

 

PREFFIRSTNAME expected 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.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/LLDDHealthProb

ALL_LLDD

 

string

12*13*96

ILR LLDD codes https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LLDDandHealthProblem/field/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.submit-learner-data.service.gov.uk/21-22/ilr/entity/ContactPreference/field/ContPrefType/attribute/RUI

L52

 

string

456

ILR Preferred Method of Contact https://guidance.submit-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.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.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.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR

L34D

 

string

 

ILR Learner FAM - Learner Support Reason 4 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR

L31

 

numeric

 

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

DLA

 

numeric

 

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

ACCOM

 

numeric

 

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

L40A

 

numeric

 

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

L40B

 

numeric

 

ILR Learner FAM - National Learner Monitoring 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/NLM

L42A

 

numeric

 

ILR Learner - Provider Specified Monitoring 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/ProvSpecLearnMon

L42B

 

numeric

 

ILR Learner - Provider Specified Monitoring 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/ProvSpecLearnMon

MCF

 

numeric

 

ILR Learner - Maths Condition of Funding https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/MCF

ECF

 

numeric

 

ILR Learner - English Condition of Funding https://guidance.submit-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/LearnFAMType/attribute/EHC

GCSE_ENG_GRADE

 

alphanumeric

 

ILR Learner - English GCSE Grade https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/EngGrade

GCSE_MATH_GRADE

 

alphanumeric

 

ILR Learner - Maths GCSE Grade https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/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

DAS_RPL_IDENTIFIED

 

 

string

Y

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

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

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

Apprenticeship service bulk upload specification

DAS_DURATIONREDUCED

 

number

 

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

Apprenticeship service bulk upload specification

DAS_PRICEREDUCED

 

number

1250

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

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

Column Name

Required?

Format

Example

Notes

PRIOR_EMPSTAT_CODE

 

numeric

 

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

PRIOR_EMPSTAT_DATE

 

date

 

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

PRIOR_EMPSTAT_LOE

 

numeric

 

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

PRIOR_EMPSTAT_SEI

 

numeric

 

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

PRIOR_EMPSTAT_EII

 

numeric

 

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

PRIOR_EMPSTAT_BSI

 

numeric

 

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

PRIOR_EMPSTAT_SEM

 

numeric

 

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

PRIOR_EMPSTAT_LOU

 

numeric

 

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

PRIOR_EMPSTAT_PEI

 

numeric

 

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

PRIOR_EMPSTAT_OET1

 

numeric

 

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

PRIOR_EMPSTAT_OET2

 

numeric

 

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

PRIOR_EMPSTAT_EMPCODE

 

PICS Organisation Code

 

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

PRIOR_EMPSTAT_EMPNAME

 

alphanumeric

 

Employer Name - used for matching

PRIOR_EMPSTAT_EMPADDR1

 

alphanumeric

 

Employer Address - Line 1

PRIOR_EMPSTAT_EMPADDR2

 

alphanumeric

 

Employer Address - Line 2

PRIOR_EMPSTAT_EMPADDR3

 

alphanumeric

 

Employer Address - Line 3

PRIOR_EMPSTAT_EMPADDR4

 

alphanumeric

 

Employer Address - Line 4

PRIOR_EMPSTAT_EMPADDR5

 

alphanumeric

 

Employer Address - Line 5

PRIOR_EMPSTAT_EMPPHONE

 

numeric

 

Employer Phone

PRIOR_EMPSTAT_EMPEMAIL

 

alphanumeric

 

Employer Email Address

PRIOR_EMPSTAT_EMPPOSTCODE

 

Postcode

 

Employer Postcode - used for matching

PRIOR_EMPSTAT_EMPEDRS

 

numeric

 

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

PRIOR_EMPSTAT_AGREEMENT_ID

 

6 alphanumeric

 

Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports

ILR Employment - Change on/after Start

Column Name

Required?

Format

Example

Notes

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

CHANGE_EMPSTAT_SEI

 

numeric

 

ILR Employment - Self Employment Indicator if Changed on / after Start 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_BSI

 

numeric

 

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_SEM

 

numeric

 

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

ILR Programme Aim

Column Name

Required?

Format

Example

Notes

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

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

A10_1

 

numeric

 

ILR Learning Delivery - 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/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 - Delivery Location Postcode https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/DelLocPostCode

EEF_1

 

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

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/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 FAM - Household Situation (HHS 2)

Second ILR Code

RESTART_1

 

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

A22_1

 

numeric

100321

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

PRIORFUNDADJ_1

 

numeric

 

ILR Learning Delivery - 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 - Other Funding Adjustment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/OtherFundAdj

A46A_1

 

numeric

 

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

A46B_1

 

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

A46C_1

 

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

A46D_1

 

numeric

 

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

A48A_1

 

alphanumeric

 

ILR Learning Delivery - 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 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/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 Officer

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

Column Name

Required?

Format

Example

Notes

TRG_TNP

 

numeric

1000

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

TRG_EMP

 

numeric

50

Employer’s Contribution to Training if not levy funded

TRG_EMP_START

 

numeric

40

Lump Sum of Employer’s Contribution to Training

TRG_EMP_SPRD

 

alphanumeric

 

Encoding of spreading method of Employer’s Contribution to Training

ASM_TNP

 

numeric

1000

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

ASM_EMP

 

numeric

50

Employer’s Contribution to Assessment if not levy funded

ASM_EMP_START

 

numeric

40

Lump Sum of Employer’s Contribution to Assessment

ASM_EMP_SPRD

 

alphanumeric

 

Encoding of spreading method of Employer’s Contribution to Assessment

ADD_EMP

 

numeric

5000

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

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

Column Name

Required?

Format

Example

Notes

LIT_FIRSTASSDATE

 

date

31/08/2021

English/Literacy Initial Assessment Date

LIT_FIRSTASSLEV

 

alphanumeric

D

English/Literacy Initial Assessment Level

See Code Lists

LIT_FIRSTASSRES

 

numeric

67

English/Literacy Initial Assessment Result

NUM_FIRSTASSDATE

 

date

31/08/2021

Maths/Numeracy Initial Assessment Date

NUM_FIRSTASSLEV

 

alphanumeric

D

Maths/Numeracy Initial Assessment Level

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

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

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

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