...
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 |
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 |
submit-learner-data.service.gov.uk/21-22/ilr/entity/ContactPreference/field/ContPrefType/attribute/ |
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/LSR | ||||
L34B | string | ILR Learner FAM - Learner Support Reason 2 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR | ||||
L34C | string | ILR Learner FAM - Learner Support Reason 3 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/ |
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/ |
DLA | numeric | ILR Learner FAM - Disabled Students Allowance |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/ |
ACCOM | numeric | ILR Learner Accommodation |
L40A | numeric | ILR Learner FAM - National Learner Monitoring 1 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/NLM | ||||
L40B | numeric | ILR Learner FAM - National Learner Monitoring |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/ |
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 |
ILR Learner - Prior Attainment Level Applied from Date |
Column Name
Required?
Format
Example
Notes
PRIOR_EMPSTAT_CODE
numeric
ILR Employment - Status before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/empstat
PRIOR_EMPSTAT_DATE
date
ILR Employment - Date Status before Enrolment Applies
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/dateempstatapp
PRIOR_EMPSTAT_LOE
numeric
ILR Employment - Length of Employment before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/loe
PRIOR_EMPSTAT_SEI
numeric
ILR Employment - Self Employment Indicator before Enrolment
PRIOR_EMPSTAT_EII
numeric
ILR Employment - Employment Intensity Indicator before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/eii
PRIOR_EMPSTAT_BSI
numeric
ILR Employment - Benefits Status Indicator before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/bsi
PRIOR_EMPSTAT_SEM
numeric
ILR Employment - Small Employer before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/sei
PRIOR_EMPSTAT_LOU
numeric
ILR Employment - Length of Unemployment before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/lou
PRIOR_EMPSTAT_PEI
numeric
ILR Employment - Previous Education Indicator before Enrolment
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/pei
PRIOR_EMPSTAT_OET1
numeric
Status | ||||
---|---|---|---|---|
|
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
ILR Planned Learning Hours for 2021
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planlearnhours
PLANEEPHRS_2021
numeric
ILR Planned EEP Hours for 2021
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planeephours
PLANLRNHRS_2022
numeric
ILR Planned Learning Hours for 2022
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planlearnhours
PLANEEPHRS_2022
numeric
ILR Planned EEP Hours for 2022
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planeephours
ILR Employment - Before Enrolment
DAS_RPL_IDENTIFIED | string | Y | Apprenticeship Service Recognised Prior Learning - used in the Apprenticeship Service Bulk Upload https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification | |
DAS_TRAININGHOURSREDUCTION | Apprenticeship Service Off-the-job training reduced due to prior learning - used in the Apprenticeship Service Bulk Upload https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification | |||
DAS_TOTALTRAININGHOURS | number | Apprenticeship Service Total off-the-job hours for the apprenticeship standard - used in the Apprenticeship Service Bulk Upload https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification | ||
DAS_DURATIONREDUCED | number | Apprenticeship Service Duration Reduced by Weeks - used in the Apprenticeship Service Bulk Upload https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification | ||
DAS_PRICEREDUCED | number | 1250 | Apprenticeship Service Price Reduced by £s - used in the Apprenticeship Service Bulk Upload https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification | |
CONTRACT | PICS Contract Code | PICS Contract | ||
SCHOOL_ORGCODE | PICS Organisation Code | Creates a Learner “School“ Placement record with the same Start and Expected End dates as the Learner Episode | ||
COLLEGE_ORGCODE | PICS Organisation Code | Creates a Learner “College“ Placement record with the same Start and Expected End dates as the Learner Episode | ||
PLANLRNHRS_2021 | numeric | ILR Planned Learning Hours for ILR Year 2021/22 https://guidance.submit-learner-data.service.gov.uk/21-22/ilr/entity/Learner/field/PlanLearnHours | ||
PLANEEPHRS_2021 | numeric | ILR Planned EEP Hours for ILR Year 2021/22 https://guidance.submit-learner-data.service.gov.uk/21-22/ilr/entity/Learner/field/PlanEEPHours | ||
PLANLRNHRS_2022 | numeric | ILR Planned Learning Hours for ILR Year 2022/23 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/PlanLearnHours | ||
PLANEEPHRS_2022 | numeric | ILR Planned EEP Hours for ILR Year 2022/23 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/PlanEEPHours | ||
PLANLRNHRS_2023 | numeric | ILR Planned Learning Hours for ILR Year 2023/24 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/PlanLearnHours | ||
PLANEEPHRS_2023 | numeric | ILR Planned EEP Hours for ILR Year 2023/24 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/PlanEEPHours | ||
JOBTITLE | string | Senior Software Developer | This will be applied to any Employer/Work placement records created | |
BKSB_USERNAME | string | Learner’s bksb username or User ID | ||
SMARTASSESSOR_ID | string | d053223cd2fa46479a6e30923a2c20c6 | Learner’s Smart Assessor User ID |
ILR Employment - Before Enrolment
Column Name | Required? | Format | Example | Notes |
---|---|---|---|---|
PRIOR_EMPSTAT_CODE | numeric | ILR Employment - Status before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/EmpStat | ||
PRIOR_EMPSTAT_DATE | date | ILR Employment - Date Status before Enrolment Applies https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
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 |
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 |
alphanumeric
Employer Address - Line 2
PRIOR_EMPSTAT_EMPADDR3
alphanumeric
Employer Address - Line 3
PRIOR_EMPSTAT_EMPADDR4
alphanumeric
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/ |
22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/PEI |
PRIOR_EMPSTAT_ |
6 alphanumeric
OET1 | numeric | ILR Employment - |
...
Column Name
Required?
Format
Example
Notes
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/ |
PRIOR_EMPSTAT_ |
EMPCODE |
PICS Organisation Code | ILR Employment - |
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 | ||||
---|---|---|---|---|
|
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
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/ |
CHANGE_EMPSTAT_ |
SEI | numeric |
Status | ||||
---|---|---|---|---|
|
ILR Employment - |
Self Employment Indicator if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ |
CHANGE_EMPSTAT_ |
EII |
numeric | ILR Employment - |
CHANGE_EMPSTAT_EMPNAME
alphanumeric
Employment Intensity Indicator if Changed on / after Start |
If this field is not provided the CHANGE_EMPSTAT_EMPNAME, CHANGE_EMPSTAT_EMPPOSTCODE and CHANGE_EMPSTAT_EMPEDRS fields are used to find a matching Organisation record. If no match is found a new record is created using the other CHANGE_EMPSTAT_EMP??? fields provided
CHANGE_EMPSTAT_ |
BSI |
numeric |
Employer Address - Line 1
CHANGE_EMPSTAT_EMPADDR2
alphanumeric
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 |
Employer Address - Line 3
CHANGE_EMPSTAT_EMPADDR4
alphanumeric
Employer Address - Line 4
CHANGE_EMPSTAT_EMPADDR5
alphanumeric
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 |
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 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/ |
PROG_A11A
numeric
105
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_ |
EMPCODE |
PICS Organisation Code | ILR |
https://guidance.
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
1 or 2 as per ILR specification
L for ACT1 Levy Funded
N for ACT1 Non-Levy Funded
PROG_DELIVLOC
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/ |
PROG_ |
Status | ||||
---|---|---|---|---|
|
numeric
A72A | alphanumeric | ILR Learning Delivery |
- Provider specified delivery monitoring 3 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
PROG_ |
A72B |
alphanumeric | ILR Learning Delivery |
- Provider specified delivery monitoring 4 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
PROG_HHS
alphanumeric
1*2
ILR Learning Delivery FAM - Household Situation (HHS)
https://guidance.submit-learner-data.service.gov.uk/ilr/field/learndelfamtype/attribute/hhs
* separated list of ILR codes
PROG_HHSA
numeric
1
First ILR Code
PROG_HHSB
numeric
2
Second ILR Code
PROG_RES
numeric
ILR Component Aims
Multiple component aims can be included, but the last number of each column name below must be increased by 1 for each new qualification.
For example, AIMREF_1 becomes AIMREF_2 and then AIMREF_3.
There must be an AIMREF field for the other fields to be imported.
Column Name | Required? | Format | Example | Notes |
---|---|---|---|---|
AIMREF_1 | Yes | alphanumeric | ILR Learning Delivery - Learning Aim Reference https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/LearnAimRef | |
AIMSTART_1 | date | ILR Learning Delivery - Start Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
AIMEXPECT_ |
1 |
date | ILR Learning Delivery |
- Planned End Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
AIMEND_ |
1 |
date | ILR Learning Delivery |
PROG_A46C
numeric
ILR Learning Delivery FAM - Learner Data Monitoring (LDM 3)
PROG_A46D
numeric
ILR Learning Delivery FAM - Learner Data Monitoring (LDM 4)
PROG_A48A
alphanumeric
ILR Learning Delivery - Provider specified delivery monitoring 1
- Actual End Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/LearnActEndDate | ||||
AIMTYPE_1 | numeric | ILR Learning Delivery - Aim Type https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/ |
A10_ |
1 |
numeric | 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
- 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 |
AIMSTART_1
/LearnDelFAMType/attribute/ACT 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/ |
AIMEND_1
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
| ||||
HHSA_1 | numeric | 1 | ILR Learning Delivery FAM - Household Situation (HHS 1) First ILR Code | |
HHSB_1 | numeric | 2 | ILR Learning Delivery |
https://guidance.submit-learner-data.service.gov.uk/ilr/field/aimtype A10
FAM - Household Situation (HHS 2) Second ILR Code | ||||
RESTART_1 | numeric | ILR Learning Delivery |
FAM - Restart Indicator (RES) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/ |
A22_1 | numeric | 100321 | ILR Learning Delivery - |
Subcontractor UKPRN https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/ |
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 | ILR Learning Delivery |
- Other Funding Adjustment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
1 or 2 as per ILR specification
L for ACT1 Levy Funded
N for ACT1 Non-Levy Funded
AIM_DELIVLOC_1
Postcode
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/ |
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
HHS_1
alphanumeric
numeric | ILR Learning Delivery FAM - |
Learner Data Monitoring (LDM 3) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/ |
separated list of ILR codes
A46D_1 | numeric |
1
ILR Learning Delivery FAM - |
First ILR Code
HHSB_1
numeric
2
ILR Learning Delivery FAM - Household Situation (HHS 2)
Second ILR Code
RESTART_1
numeric
Learner Data Monitoring (LDM 4) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/ |
A48A_1 |
numeric
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/ |
A72B_1 |
alphanumeric | ILR Learning Delivery - |
Provider specified delivery monitoring 4 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
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/ |
A46C_1
AIMDAM2_1 | numeric |
ILR Learning Delivery FAM - Learner Data Monitoring (LDM 2)
001 | ILR Learning Delivery FAM - |
A46D_1
numeric
ILR Learning Delivery FAM - Learner Data Monitoring (LDM 4)
A48A_1
alphanumeric
ILR Learning Delivery - Provider specified delivery monitoring 1
Devolved Area Monitoring (DAM2) https://guidance.submit-learner-data.service. |
A48B_1
alphanumeric
ILR Learning Delivery - Provider specified delivery monitoring 2
A72A_1
alphanumeric
ILR Learning Delivery - Provider specified delivery monitoring 3
A72B_1
alphanumeric
ILR Learning Delivery - Provider specified delivery monitoring 4
AIMASSESSOR_1
PICS Officer Code
Aim Main Assessor PICS Officer
AIMIV_1
PICS Officer Code
Aim Main Internal Verifier PICS Officer
AIMEV_1
PICS Officer Code
Aim Main External Verifier PICS Officer
gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM | ||||
AIMDAM3_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring ( |
DAM3) |
ILR Specification: Attribute field: Devolved Area Monitoring
AIMDAM4_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring ( |
AIMDAM5_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring ( |
AIMDAM4_1
numeric
001
ILR Learning Delivery FAM - Devolved Area Monitoring (DAM4)
AIMDAM5_1
numeric
001
AIMDAM6_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM6) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM |
Apprenticeship Costs
Column Name | Required? | Format | Example | Notes |
---|---|---|---|---|
TRG_TNP | numeric | 1000 | ILR Apprenticeship Financial Record - Total Negotiate Price for Training (TNP1) |
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ |
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/ |
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
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 |
English/ |
Literacy Initial Assessment Date |
LIT_FIRSTASSLEV | alphanumeric | D |
Maths/Numeracy Assessment Level
X - Not required
A- Below Entry 1
B - Entry 1
C - Entry 2
D - Entry 3
E - Level 1
F - Level 2
G - Level 3
Y - Concession
Z - Proxy
English/Literacy Initial Assessment Level See Code Lists | |||
LIT_FIRSTASSRES | numeric | 67 |
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 |
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 |