...
Column Name | Required? | Format | Example | Notes | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
FIRSTNAME | string | Roberta | ||||||||
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 | LRS Preferred Name | |||||||||
MIAP_VERIFTYPE | numeric | LRS Identity Verification Type | ||||||||
MIAP_VERIFTEXT | 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 | |||||||
ALL_LLDD | string | 12*13*96 | ILR LLDD codes | |||||||
PRIMARY_LLDD | string | 12 | ILR Primary LLDD | |||||||
RUI | string | 67 | ILR Restricted Use Indicator | |||||||
L52 | string | 456 | ILR Preferred Method of Contact | |||||||
L34A | string | 36 | ILR Learner FAM - Learner Support Reason 1 https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamcode | |||||||
L34B | string | ILR Learner FAM - Learner Support Reason 2 https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamcode | ||||||||
L34C | string | ILR Learner FAM - Learner Support Reason 3 https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamcode | ||||||||
L34D | string | ILR Learner FAM - Learner Support Reason 4 https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/learnfamcode | ||||||||
L31 | numeric | ILR Learner - Learning Support | ||||||||
DLA | numeric | ILR Learner FAM - Disabled Students Allowance | ||||||||
ACCOM | numeric | ILR Learner Accommodation | ||||||||
L40A | numeric | ILR Learner FAM - National Learner Monitoring 1 | ||||||||
L40B | numeric | ILR Learner FAM - National Learner Monitoring 1 | ||||||||
L42A | numeric | ILR Learner - Provider Specified Monitoring 1 | ||||||||
L42B | numeric | ILR Learner - Provider Specified Monitoring 2 | ||||||||
MCF | numeric | ILR Learner - Maths Condition of Funding | ||||||||
ECF | numeric | ILR Learner - English Condition of Funding | ||||||||
EHC | numeric | ILR Learner FAM - Education Health Care plan | ||||||||
GCSE_ENG_GRADE | alphanumeric | ILR Learner - English GCSE Grade https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/enggrade | ||||||||
GCSE_MATH_GRADE | alphanumeric | ILR Learner - Maths GCSE Grade https://guidance.submitlearnerdatabeta.fasst.org.uk/ilr/field/mathgrade | ||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||||
PLANEEPHRS_2022 | numeric | ILR Planned EEP Hours for 2022 https://guidance.submit-learner-data.service.gov.uk/ilr/field/planeephours |
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.submitlearnerdatabeta.fasst.org.uk/ilr/field/dateempstatapp | ||||||||
PRIOR_EMPSTAT_LOE | numeric | ILR Employment - Length of Employment before Enrolment | ||||||||
PRIOR_EMPSTAT_SEI | numeric | ILR Employment - Self Employment Indicator before Enrolment | ||||||||
PRIOR_EMPSTAT_EII | numeric | ILR Employment - Employment Intensity Indicator before Enrolment | ||||||||
PRIOR_EMPSTAT_BSI | numeric | ILR Employment - Benefits Status Indicator before Enrolment | ||||||||
PRIOR_EMPSTAT_SEM | numeric | ILR Employment - Small Employer before Enrolment | ||||||||
PRIOR_EMPSTAT_LOU | numeric | ILR Employment - Length of Unemployment before Enrolment | ||||||||
PRIOR_EMPSTAT_PEI | numeric | ILR Employment - Previous Education Indicator before Enrolment | ||||||||
PRIOR_EMPSTAT_OET1 | numeric |
ILR Employment - Other Employment Type 1 https://guidance.submit-learner-data.service.gov.uk/ilr/field/esmtype/attribute/oet | ||||||||
PRIOR_EMPSTAT_OET2 | numeric |
ILR Employment - Other Employment Type 2 https://guidance.submit-learner-data.service.gov.uk/ilr/field/esmtype/attribute/oet | ||||||||
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 |
...
Column Name | Required? | Format | Example | Notes | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
CHANGE_EMPSTAT_CODE | numeric | ILR Employment - Status if Changed on / after Start | ||||||||
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 | ||||||||
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 | ||||||||
CHANGE_EMPSTAT_BSI | numeric | ILR Employment - Benefits Status Indicator if Changed on / after Start | ||||||||
CHANGE_EMPSTAT_SEM | numeric | ILR Employment - Small Employer if Changed on / after Start | ||||||||
CHANGE_EMPSTAT_LOU | numeric | ILR Employment - Length of Unemployment if Changed on / after Start | ||||||||
CHANGE_EMPSTAT_PEI | numeric | ILR Employment - Previous Education Indicator if Changed on / after Start | ||||||||
CHANGE_EMPSTAT_OET1 | numeric |
ILR Employment - Other Employment Type 1 https://guidance.submit-learner-data.service.gov.uk/ilr/field/esmtype/attribute/oet | ||||||||
CHANGE_EMPSTAT_OET2 | numeric |
ILR Employment - Other Employment Type 2 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 | ||||||||
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 |
...
Column Name | Required? | Format | Example | Notes | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
OTJHOURS | numeric | ILR Learning Delivery - Planned Hours | ||||||||
PROG_A11A | numeric | 105 | ILR Learning Delivery FAM - Source of Funding (SOF) | |||||||
PROG_ACT | 1 alphanumeric | L | ILR Learning Delivery FAM - Apprenticeship Contract Type (ACT) | |||||||
PROG_DELIVLOC | Postcode | ILR Learning Delivery - Delivery Location Postcode | ||||||||
PROG_LSF
| numeric | ILR Learning Delivery FAM - Learning Support Funding (LSF) | ||||||||
PROG_EEF | numeric | ILR Learning Delivery FAM - Eligibility for Enhanced Funding (EEF) | ||||||||
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 | ILR Learning Delivery 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) | ||||||||
PROG_A46A | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM 1) https://guidance.submit-learner-data.service.gov.uk/ilr/field/learndelfamtype/attribute/ldm | ||||||||
PROG_A46B | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM 2) | ||||||||
PROG_A46C | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM 3) | ||||||||
PROG_A46D | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM 4) | ||||||||
PROG_A48A | alphanumeric | ILR Learning Delivery - Provider specified delivery monitoring 1 https://guidance.submit-learner-data.service.gov.uk/ilr/field/provspecdelmon | ||||||||
PROG_A48B | alphanumeric | ILR Learning Delivery - Provider specified delivery monitoring 2 | ||||||||
PROG_A72A | alphanumeric | ILR Learning Delivery - Provider specified delivery monitoring 3 | ||||||||
PROG_A72B | alphanumeric | ILR Learning Delivery - Provider specified delivery monitoring 4 |
...
Column Name | Required? | Format | Example | Notes |
|---|---|---|---|---|
AIMREF_1 | Yes | alphanumeric | ILR Learning Delivery - Learning Aim Reference | |
AIMSTART_1 | date | ILR Learning Delivery - Start Date https://guidance.submit-learner-data.service.gov.uk/ilr/field/learnstartdate | ||
AIMEXPECT_1 | date | ILR Learning Delivery - Planned End Date | ||
AIMEND_1 | date | ILR Learning Delivery - | ||
AIMTYPE_1 | numeric | ILR Learning Delivery - Aim Type | ||
A10_1 | numeric | ILR Learning Delivery - Funding Model | ||
A15_1 | numeric | ILR Learning Delivery - Programme Type https://guidance.submit-learner-data.service.gov.uk/ilr/field/progtype | ||
A11A_1 | numeric | 105 | ILR Learning Delivery FAM - Source of Funding (SOF) | |
ACT_1 | alphanumeric | ILR Learning Delivery FAM - Apprenticeship Contract Type (ACT) 1 or 2 as per ILR specification | ||
AIM_DELIVLOC_1 | Postcode | NR2 1LL | ILR Learning Delivery - Delivery Location Postcode | |
EEF_1 | numeric | ILR Learning Delivery FAM - Eligibility for Enhanced Funding (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/ilr/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) | ||
A22_1 | numeric | 100321 | ILR Learning Delivery - Subcontractor UKPRN https://guidance.submit-learner-data.service.gov.uk/ilr/field/partnerukprn | |
PRIORFUNDADJ_1 | numeric | ILR Learning Delivery - Funding adjustment for prior learning | ||
OTHERFUNDADJ_1 | numeric | ILR Learning Delivery - Other Funding Adjustment | ||
A46A_1 | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM 1) https://guidance.submit-learner-data.service.gov.uk/ilr/field/learndelfamtype/attribute/ldm | ||
A46B_1 | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM 2) | ||
A46C_1 | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM 3) | ||
A46D_1 | numeric | ILR Learning Delivery FAM - Learner Data Monitoring (LDM 4) | ||
A48A_1 | alphanumeric | ILR Learning Delivery - Provider specified delivery monitoring 1 https://guidance.submit-learner-data.service.gov.uk/ilr/field/provspecdelmon | ||
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 | ||
AIMDAM1_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM1) | |
AIMDAM2_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM2) | |
AIMDAM3_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM3) | |
AIMDAM4_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM4) | |
AIMDAM5_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM5) | |
AIMDAM6_1 | numeric | 001 | ILR Learning Delivery FAM - Devolved Area Monitoring (DAM6) |
...