...
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 | |||||||
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/ |
L52 | string | 456 | ILR Preferred Method of Contact |
submit-learner-data.service.gov.uk/22-23/ilr/entity/ContactPreference/field/ContPrefType/attribute/ |
L34A | string | 36 | ILR Learner FAM - Learner Support Reason 1 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/ |
L34B | string | ILR Learner FAM - Learner Support Reason 2 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/ |
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/ |
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 |
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/ |
L42A | numeric | ILR Learner - Provider Specified Monitoring 1 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/ |
L42B | numeric | ILR Learner - Provider Specified Monitoring 2 |
submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/ |
MCF | numeric | ILR Learner - Maths Condition of Funding |
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 | |
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 ILR Year 2021/22
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planlearnhours
PLANEEPHRS_2021
numeric
ILR Planned EEP Hours for ILR Year 2021/22
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planeephours
PLANLRNHRS_2022
numeric
ILR Planned Learning Hours for ILR Year 2022/23
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planlearnhours
PLANEEPHRS_2022
numeric
ILR Planned EEP Hours for ILR Year 2022/23
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planeephours
PLANLRNHRS_2023
Status | ||||
---|---|---|---|---|
|
numeric
ILR Planned Learning Hours for ILR Year 2023/24
https://guidance.submit-learner-data.service.gov.uk/ilr/field/planlearnhours
PLANEEPHRS_2023
Status | ||||
---|---|---|---|---|
|
numeric
ILR Planned EEP Hours for ILR Year 2023/24
DAS_RPL_IDENTIFIED | string | Y | Apprenticeship Service Recognised Prior Learning - used in the Apprenticeship Service Bulk Upload https://www.gov.uk/government/publications/apprenticeship-service-bulk-upload-specification | |
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/ |
JOBTITLE
Status | ||||
---|---|---|---|---|
|
string
Senior Software Developer
This will be applied to any Employer/Work placement records created
ILR Employment - Before Enrolment
Column Name
Required?
Format
Example
Notes
PRIOR_EMPSTAT_CODE
numeric
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/ |
PLANLRNHRS_ |
ILR Employment - Date Status before Enrolment Applies
2022 |
date
numeric | ILR Planned Learning Hours for ILR Year 2022/23 https://guidance. |
submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ |
PLANEEPHRS_ |
2022 | numeric | ILR |
Planned EEP Hours for ILR Year 2022/23 https://guidance. |
PLANLRNHRS_ |
2023 | numeric | ILR |
PRIOR_EMPSTAT_EII
numeric
Planned Learning Hours for ILR Year 2023/24 https://guidance. |
PLANEEPHRS_ |
2023 | numeric | ILR |
Planned EEP Hours for ILR Year 2023/24 https://guidance. |
PRIOR_EMPSTAT_SEM
numeric
https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/esmtype/attribute/sei
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_ |
DATE |
date | ILR Employment - |
Date Status before Enrolment |
Applies https://guidance. |
PRIOR_EMPSTAT_ |
LOE | numeric |
Status | ||||
---|---|---|---|---|
|
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 |
Status | ||||
---|---|---|---|---|
|
ILR Employment - |
Self Employment Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ |
PRIOR_EMPSTAT_ |
EII |
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
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 |
Employer Name - used for matching
PRIOR_EMPSTAT_EMPADDR1
alphanumeric
Employer Address - Line 1
PRIOR_EMPSTAT_EMPADDR2
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 |
Employer Address - Line 3
PRIOR_EMPSTAT_EMPADDR4
alphanumeric
Employer Address - Line 4
PRIOR_EMPSTAT_EMPADDR5
alphanumeric
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 Phone
PRIOR_EMPSTAT_EMPEMAIL
alphanumeric
Employer Email Address
PRIOR_EMPSTAT_EMPPOSTCODE
Postcode
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:// |
/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/OET |
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
CHANGE_EMPSTAT_CODE
numeric
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 | ||||
---|---|---|---|---|
|
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
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/ |
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 | ILR Employment - |
Self Employment Indicator if Changed on / after Start |
If this field is not provided the CHANGE_EMPSTAT_EMPNAME, CHANGE_EMPSTAT_EMPPOSTCODE and CHANGE_EMPSTAT_EMPEDRS fields are used to find a matching Organisation record. If no match is found a new record is created using the other CHANGE_EMPSTAT_EMP??? fields provided
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 |
Employer Name - used for matching
CHANGE_EMPSTAT_EMPADDR1
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 2
CHANGE_EMPSTAT_EMPADDR3
alphanumeric
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_ |
numeric
Employer Phone
CHANGE_EMPSTAT_EMPEMAIL
alphanumeric
Employer Email Address
CHANGE_EMPSTAT_EMPPOSTCODE
Postcode
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:// |
22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/PEI |
CHANGE_EMPSTAT_ |
6 alphanumeric
Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports
ILR Programme Aim
Column Name
Required?
Format
Example
Notes
OTJHOURS
OET1 | numeric | ILR |
Employment - Other Employment Type 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/ |
CHANGE_EMPSTAT_OET2 | numeric |
105
ILR |
Employment - Other Employment Type 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ |
CHANGE_EMPSTAT_ |
1 alphanumeric
L
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
1 or 2 as per ILR specification
L for ACT1 Levy Funded
N for ACT1 Non-Levy Funded
PROG_DELIVLOC
* separated list of ILR codes | ||||
PROG_HHSA | numeric | 1 | ILR Learning Delivery |
https://guidance.submit-learner-data.service.gov.uk/ilr/field/dellocpostcode PROG_LSF
FAM - Household Situation (HHS 1) | ||||
PROG_HHSB | numeric | 2 | ILR Learning Delivery FAM - Household Situation (HHS 2) | |
PROG_RES | numeric | ILR Learning Delivery FAM - |
Restart Indicator (RES) https://guidance.submit-learner-data.service.gov.uk |
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/ |
PROG_ |
alphanumeric
A46B | numeric | ILR Learning Delivery FAM - |
Learner Data Monitoring (LDM 2) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
* separated list of ILR codes
PROG_HHSA
numeric
1
First ILR Code
PROG_HHSB
numeric
PROG_A46C | numeric | ILR Learning Delivery FAM - |
Second ILR CodePROG_RES
Learner Data Monitoring (LDM 3) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/LDM | ||||
PROG_A46D | numeric | ILR Learning Delivery FAM - |
Learner Data Monitoring (LDM 4) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/ |
PROG_ |
A48A |
alphanumeric | ILR Learning Delivery |
- Provider specified delivery monitoring 1 https://guidance.submit-learner-data.service.gov.uk/ |
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_A48B | alphanumeric | ILR Learning Delivery - Provider specified delivery monitoring |
2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
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 |
PROG_A72B
alphanumeric
4 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecDeliveryMonitoring |
ILR Component Aims
Multiple component aims can be included, but the last number of each column name below must be increased by 1 for each new qualification.
For example, AIMREF_1 becomes AIMREF_2 and then AIMREF_3.
...
Column Name
...
Required?
...
Format
...
Example
...
Notes
...
AIMREF_1
...
Yes
...
alphanumeric
...
1 for each new qualification.
For example, AIMREF_1 becomes AIMREF_2 and then AIMREF_3.
There must be an AIMREF field for the other fields to be imported.
Column Name | Required? | Format | Example | Notes |
---|---|---|---|---|
AIMREF_1 | Yes | alphanumeric | ILR Learning Delivery - Learning Aim Reference https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/LearnAimRef | |
AIMSTART_1 | date | ILR Learning Delivery - Start Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/LearnStartDate | ||
AIMEXPECT_1 | date | ILR Learning Delivery - Planned End Date https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/ |
AIMEND_1 | date | ILR Learning Delivery - |
Actual End Date |
https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/ |
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/ |
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 |
AIM_DELIVLOC_1 |
Postcode |
NR2 1LL | ILR Learning Delivery |
- Delivery Location Postcode https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
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/ |
AIM_DELIVLOC_1
Postcode
1 or 2 as per ILR specification
L for ACT1 Levy Funded
N for ACT1 Non-Levy Funded
FFI_1 | numeric | ILR Learning Delivery FAM | ||
HHS_1 | alphanumeric | 1*2 | ILR Learning Delivery |
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 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
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
PRIORFUNDADJ_1 | numeric |
2
ILR Learning Delivery |
Second ILR Code
RESTART- Funding adjustment for prior learning https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDelivery/field/PriorLearnFundAdj | ||||
OTHERFUNDADJ_1 | numeric | ILR Learning Delivery |
- Other Funding Adjustment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/ |
A46A_1 | numeric |
100321
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/LearnDelFAMType/attribute/ |
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/ |
A48A_1 |
alphanumeric | ILR Learning Delivery |
A46C_1
numeric
ILR Learning Delivery FAM - Learner Data Monitoring (LDM 3)
A46D_1
numeric
ILR Learning Delivery FAM - Learner Data Monitoring (LDM 4)
- 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/ |
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 |
A72B_1
alphanumeric
4 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecDeliveryMonitoring | ||||
AIMASSESSOR_1 | PICS Officer Code | Aim Main Assessor PICS Officer | ||
AIMIV_1 | PICS Officer Code | Aim Main Internal Verifier PICS Officer | ||
AIMEV_1 | PICS Officer Code | Aim Main External Verifier PICS Officer | ||
AIMDAM1_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM1) |
ILR Specification: Attribute field: Devolved Area Monitoring
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 |
AIMDAM5_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM5) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM | |
AIMDAM6_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM6) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearningDeliveryFAM/field/LearnDelFAMType/attribute/DAM |
Apprenticeship Costs
Column Name | Required? | Format | Example | Notes |
---|---|---|---|---|
TRG_TNP | numeric | 1000 | ILR Apprenticeship Financial Record - Total Negotiate Price for Training (TNP1) |
.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 |
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 |
English/ |
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
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 |