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.
...
Formats
...
Handling
...
UDF Support
...
CSV
...
Yes
...
Single record
...
Redirect to New Learner window
...
Yes
...
XLSX
...
Yes
...
Multiple records
...
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 |
| Info |
|---|
Further information is also available on the following: |
Column Name | Required? | Format | Example | Notes | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
FIRSTNAME | string | Roberta | ||||||||
PREFFIRSTNAME
| string | Ro | Preferred First Name | |||||||
SURNAME | string | Smith | ||||||||
PREV_SURNAME | string | Jones | ||||||||
SEX | string | 1: Male | ||||||||
ETHNICORIGIN | numeric | 33 | ILR Ethnicity |
submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ |
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 | ||
MIAP_PREFNAME | string | LRS Preferred Name | ||
MIAP_VERIFTYPE | numeric | LRS Identity Verification Type | ||
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 | ||
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 | |
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 T: Telephone | |
PREF_CONTACT_METH | string | E | Preferred Contact Method between Provider & Learner | |
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 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ |
ALL_LLDD | string | 12*13*96 | ILR LLDD codes |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LLDDandHealthProblem/field/ |
PRIMARY_LLDD | string | 12 | ILR Primary LLDD | |
RUI | string | 67 | ILR Restricted Use Indicator |
L52 | string | 456 | ILR Preferred Method of Contact |
submit-learner-data.service.gov.uk/22-23/ilr/entity/ContactPreference/field/ |
L34A | string | 36 | ILR Learner FAM - Learner Support Reason 1 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/ |
L34B | string | ILR Learner FAM - Learner Support Reason 2 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/ |
L34C | string | ILR Learner FAM - Learner Support Reason 3 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR | ||||
L34D | string | ILR Learner FAM - Learner Support Reason 4 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/ |
L31 | numeric | ILR Learner - Learning Support |
submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ALSCost | ||||
DLA | numeric | ILR Learner FAM - Disabled Students Allowance |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/DLA | ||||
ACCOM | numeric | ILR Learner Accommodation |
submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ |
L40A | numeric | ILR Learner FAM - National Learner Monitoring 1 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/ |
L40B | numeric | ILR Learner FAM - National Learner Monitoring |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/ |
L42A | numeric | ILR Learner - Provider Specified Monitoring 1 |
L42B | numeric | ILR Learner - Provider Specified Monitoring 2 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/ |
MCF | numeric | ILR Learner - Maths Condition of Funding |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/ |
ECF | numeric | ILR Learner - English Condition of Funding |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/ |
EHC | numeric | ILR Learner FAM - Education Health Care plan |
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/ |
GCSE_ENG_GRADE | alphanumeric | ILR Learner - English GCSE Grade |
submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ |
GCSE_MATH_GRADE | alphanumeric | ILR Learner - Maths GCSE Grade |
submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ |
PRIOREDU | numeric | ILR Learner - Prior Attainment (to 2020) | ||
PRIORATTAINMENT | numeric | 03 |
ILR Learner - Prior Attainment Level |
PRIORATTAINMENTDATE | date |
31/08/2021 |
| Status | ||||
|---|---|---|---|---|
|
ILR Learner - Prior Attainment Level Applied from Date |
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 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 | ||
DAS_COHORT | alphanumeric | Apprenticeship Service Cohort Reference | ||
DAS_STATUS | numeric | Apprenticeship Service Status 0 - Non-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
DAS_RPL_IDENTIFIED | string | Y | Apprenticeship Service Recognised Prior Learning - used in the Apprenticeship Service Bulk Upload |
PLANEEPHRS_2021
numeric
ILR Planned EEP Hours for 2021
publications/apprenticeship-service-bulk-upload-specification | ||||
DAS_TRAININGHOURSREDUCTION | Apprenticeship Service Off-the-job training reduced due to prior learning - used in the Apprenticeship Service Bulk Upload |
PLANLRNHRS_2022
numeric
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 |
PLANEEPHRS_2022
numeric
publications/apprenticeship-service-bulk-upload-specification | ||||
DAS_DURATIONREDUCED | number | Apprenticeship Service Duration Reduced by Weeks - used in the Apprenticeship Service Bulk Upload |
ILR Employment - Before Enrolment
Column Name
Required?
Format
Example
Notes
PRIOR_EMPSTAT_CODE
numeric
publications/apprenticeship-service-bulk-upload-specification | ||||
DAS_PRICEREDUCED | number | 1250 | Apprenticeship Service Price Reduced by £s - used in the Apprenticeship Service Bulk Upload |
PRIOR_EMPSTAT_DATE
date
ILR Employment - Date Status before Enrolment Applies
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/ |
PLANEEPHRS_ |
2021 | numeric | ILR |
Planned EEP Hours for ILR Year 2021/22 https://guidance. |
PLANLRNHRS_ |
2022 | numeric | ILR |
PRIOR_EMPSTAT_EII
numeric
Planned Learning Hours for ILR Year 2022/23 https://guidance. |
PLANEEPHRS_ |
2022 | numeric | ILR |
Planned EEP Hours for ILR Year 2022/23 https://guidance. |
PLANLRNHRS_ |
2023 | numeric | ILR |
Planned Learning Hours for ILR Year 2023/24 https://guidance. |
PLANEEPHRS_ |
2023 | numeric | ILR |
Planned EEP Hours for ILR Year 2023/24 https://guidance. |
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 |
PRIOR_EMPSTAT_ |
| Status | ||||
|---|---|---|---|---|
|
DATE |
numeric
date | ILR Employment - |
Date Status before Enrolment Applies https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
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/ |
PRIOR_EMPSTAT_ |
SEI |
numeric | ILR Employment - |
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_ |
BSI |
numeric |
Employer Name - used for matching
PRIOR_EMPSTAT_EMPADDR1
alphanumeric
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 |
Employer Address - Line 2
PRIOR_EMPSTAT_EMPADDR3
alphanumeric
Employer Address - Line 3
PRIOR_EMPSTAT_EMPADDR4
alphanumeric
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 |
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
https://esfahelp.education
ILR Employment - Previous Education Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/ |
ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/PEI |
PRIOR_EMPSTAT_ |
6 alphanumeric
Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports
ILR Employment - Change on/after Start
Column Name
Required?
Format
Example
Notes
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. |
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 | ||||
|---|---|---|---|---|
|
https://guidance.submit-learner-data.service.gov.uk/ilr/field/esmtype/attribute/oet
CHANGE_EMPSTAT_OET2
numeric
| Status | ||||
|---|---|---|---|---|
|
https://guidance.submit-learner-data.service.gov.uk/ilr/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
OTJHOURS
numeric
PRIOR_EMPSTAT_EMPCODE | PICS Organisation Code | ILR Employment - Employer before Enrolment | ||
PRIOR_EMPSTAT_EMPNAME | alphanumeric | Employer Name - used for matching | ||
PRIOR_EMPSTAT_EMPADDR1 | alphanumeric | Employer Address - Line 1 | ||
PRIOR_EMPSTAT_EMPADDR2 | alphanumeric | Employer Address - Line 2 | ||
PRIOR_EMPSTAT_EMPADDR3 | alphanumeric | Employer Address - Line 3 | ||
PRIOR_EMPSTAT_EMPADDR4 | alphanumeric | Employer Address - Line 4 | ||
PRIOR_EMPSTAT_EMPADDR5 | alphanumeric | Employer Address - Line 5 | ||
PRIOR_EMPSTAT_EMPPHONE | numeric | Employer Phone | ||
PRIOR_EMPSTAT_EMPEMAIL | alphanumeric | Employer Email Address | ||
PRIOR_EMPSTAT_EMPPOSTCODE | Postcode | Employer Postcode - used for matching | ||
PRIOR_EMPSTAT_EMPEDRS | numeric | Employer EDS Registration Number - used for matching | ||
PRIOR_EMPSTAT_AGREEMENT_ID | 6 alphanumeric | Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports |
ILR Employment - Change on/after Start
CHANGE_EMPSTAT_ |
SEM | numeric |
105
ILR |
Employment - Small Employer if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ |
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/ |
1 or 2 as per ILR specification
L for ACT1 Levy Funded
N for ACT1 Non-Levy Funded
PROG_DELIVLOC
Postcode
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/ |
CHANGE_ |
| Status | ||||
|---|---|---|---|---|
|
EMPSTAT_OET1 | numeric | ILR |
Employment - Other Employment Type 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ |
CHANGE_EMPSTAT_ |
OET2 | numeric | ILR |
Employment - Other Employment Type 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ |
CHANGE_EMPSTAT_ |
alphanumeric
1*2
ILR Learning Delivery FAM - Household Situation (HHS)
EMPCODE | PICS Organisation Code | ILR Employment - Employer if Changed on / after Start | ||
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 | ||
CHANGE_EMPSTAT_AGREEMENT_ID | 6 alphanumeric | Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports |
ILR Programme Aim
* separated list of ILR codes
PROG_HHSA
numeric
1
First ILR Code
PROG_HHSB
numeric
2
Second ILR Code
PROG_RES
numeric
ILR Learning Delivery FAM - Restart Indicator (RES)
https://guidance.submit-learner-data.service.gov.uk/ilr/field/learndelfamtype/attribute/res
PROG_A46A
numeric
ILR Learning Delivery FAM - Learner Data Monitoring (LDM 1)
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/ |
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
AIMSTART_1 | date | ILR Learning Delivery - |
Start Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/ |
AIMEXPECT_ |
1 |
date | ILR Learning Delivery |
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
- 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/ |
A10_1 |
numeric | ILR Learning Delivery - |
Funding Model https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/ |
A15_1 |
numeric | ILR Learning Delivery - |
Programme Type https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/ |
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/ |
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/ |
A10_1
numeric
ILR Learning Delivery - Funding Model
https://guidance.submit-learner-data.service.gov.uk/ilr/field/fundmodel
A15_1
1 or 2 as per ILR specification | ||||
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/ |
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/ |
ACT_1
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/ |
1 or 2 as per ILR specification
L for ACT1 Levy Funded
N for ACT1 Non-Levy Funded
AIM_DELIVLOC_1
Postcode
NR2 1LL
ILR Learning Delivery - Delivery Location Postcode
https://guidance.submit-learner-data.service.gov.uk/ilr/field/dellocpostcode
| ||||
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/ |
A22_1 | numeric |
ILR Learning Delivery FAM
HHS_1
alphanumeric
1*2
ILR Learning Delivery FAM - Household Situation (HHS)
100321 | ILR Learning Delivery - Subcontractor UKPRN https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
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
PRIORFUNDADJ_1 | numeric |
ILR Learning Delivery - Funding adjustment for prior learning https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
OTHERFUNDADJ_1 | numeric |
100321
ILR Learning Delivery - |
Other Funding Adjustment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/ |
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/ |
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/ |
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/ |
A46D_1 | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM |
A46C_1
numeric
ILR Learning Delivery FAM - Learner Data Monitoring (LDM 3)
A46D_1
numeric
A48A_1 | alphanumeric | ILR Learning Delivery - Provider specified delivery monitoring 1 |
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
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 |
AIMEV_1
PICS Officer Code
Aim Main External Verifier PICS Officer
AIMDAM1_1
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) |
ILR Specification: Attribute field: Devolved Area Monitoring
AIMDAM3_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring ( |
AIMDAM4_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring ( |
AIMDAM4_1
numeric
001
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 |
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/ |
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/ |
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
| 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 | English/Literacy Initial Assessment Date | |||
LIT_FIRSTASSLEV | alphanumeric | D | English/Literacy 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 | ||||
LIT_FIRSTASSRES | numeric | 67 | English/Literacy Initial Assessment Result | |
NUM_FIRSTASSDATE | date |
31/08/2021 |
Maths/Numeracy Assessment Date
NUM_FIRSTASSLEV
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
D
Maths/Numeracy Assessment Level
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 Assessment Level
X - Not requiredA- 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
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 |