Learner Import Specification in PICSWeb
Instructions on using this specification to create an import file are available in Uploading a New Import File.
A CSV or XLSX file import can be used to import Learner data from other data sources. The table below shows what types of imports are available for learners.
Supported Options |
|
---|---|
CSV file format accepted | |
XLSX file format accepted | |
User Defined Fields supported | |
Record Handling |
|
Single record in file | User redirected to the New Learner window |
Multiple records in file | File added to the Import List with a status of Pending |
Further information is also available on the following:
Column Name | Required? | Format | Example | Notes | Data Type | FIeld Length |
---|---|---|---|---|---|---|
FIRSTNAME |
| string | Roberta |
| String | 100 |
PREFFIRSTNAME |
| string | Ro | Preferred First Name | String | 30 |
SURNAME |
| string | Smith |
| String | 100 |
PREV_SURNAME |
| string | Jones |
| String | 30 |
SEX |
| string |
| 1: Male | String | 1 |
ETHNICORIGIN |
| numeric | 33 | ILR Ethnicity | String | 2 |
TITLE |
| numeric | 4 | 1: Mr 2: Mrs 3: Miss 4: Ms 5: Dr 6: Rev 7: Hon 8: Mx 9: Other | String | 1 |
BIRTHDATE |
| date | 13/03/2003 |
| DateTime |
|
NINUMBER |
| string | JB010101A |
| String | 9 |
PHOTOFILEID |
| File GUID |
| Must be an existing PICS File GUID | String | 32 |
MIAP_ULN |
| numeric | 100000009 | LRS Unique Learner Number (ULN) | String | 10 |
MIAP_FPN_SEEN |
| numeric |
| LRS Ability to Share / Privacy Notice seen 0 - No seen | String | 1 |
MIAP_PREFNAME |
| string |
| LRS Preferred Name | String | 35 |
MIAP_VERIFTYPE |
| numeric |
| LRS Identity Verification Type | String | 3 |
MIAP_VERIFTEXT |
| string |
| LRS Identity Verification Type Other details | String | 255 |
PROV_ID |
| string |
| Provider Assigned Internal Identifier | String | 20 |
LSC_ULIN |
| string | COB1234455 | ILR Learner Reference Number | String | 12 |
TAG_IDS |
| string | a1a1a1a1a1a1a1a1a1a1a1a1a1a1a1a1*b2b2b2b2b2b2b2b2b2b2b2b2b2b2b2b2* | INTERNAL USE ONLY A list of guids separated by an *. Each guid must be 32 chars long | String | ∞ |
TAG_NAMES |
| string | April 2022*Engineers* | A list of tags to create separated by an *. | String | ∞ |
ADDR1 |
| string | Flat A | First line of Home Address | String | 50 |
ADDR2 |
| string | 123 Acacia Avenue | Second line of Home Address | String | 50 |
ADDR3 |
| string | Suburb | Third line of Home Address | String | 50 |
ADDR4 |
| string | Townville | Fourth line of Home Address | String | 50 |
POSTCODE |
| string | TO1 1WN | Home Postcode | String | 8 |
L17POSTCODE |
| string | TO1 1WN | Home Postcode prior to enrolment | String | 8 |
PHONE |
| numeric | 01603492620 | Home Phone number | String | 18 |
MOBILEPHONE |
| numeric | 07799000001 | Mobile Phone number | String | 18 |
| string | bob@here.com |
| String | 100 | |
NOKNAME |
| string | A Smith | Next of Kin Name | String | 30 |
NOKREL |
| string | Parent | Next of Kin Relationship | String | 30 |
NOKPHONE |
| string | 01603492620 | First Next of Kin Phone Number | String | 15 |
NOKPHONE2 |
| string | 07799000002 | Second Next of Kin Phone Number | String | 15 |
NOKEMAIL |
| string | asmith@home.com | Next of Kin Email Address | String | 100 |
CONT_METH |
| string | PETS | Allowed Contact Methods between Provider & Learner T: Telephone | String | 5 |
PREF_CONTACT_METH |
| string | E | Preferred Contact Method between Provider & Learner | String | 1 |
SITE |
| string |
| PICS Internal Site code | String | 10 |
CLIENT_ID |
| string |
| Learner Internal Client structure Identifier. Used when importing new Episodes for an existing Learner | String | 5 |
ULIN_ID |
| string |
| Learner Internal Learner Reference Number structure Identifier. Used when importing new Episodes for an existing Learner Reference | String | 5 |
PICS_APIDENT |
| string |
| Source Applicant Identifier for linking between an existing Applicant and a Learner | String | 5 |
RISKLEVEL |
| string |
| Learner Risk Level 1: High 2: Medium 3: Low | String | 1 |
QUALPLAN |
| string |
| PICS Qualification Plan code | String | 10 |
ILR_SELF_DISAB |
| string | 2 | ILR Learner’s Self Assessed Disability status https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/LLDDHealthProb | String | 1 |
ALL_LLDD |
| string | 12*13*96 | ILR LLDD codes https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LLDDandHealthProblem/field/LLDDCat, separated by an *. | String | 75 |
PRIMARY_LLDD |
| string | 12 | ILR Primary LLDD | String | 2 |
RUI |
| string | 67 | ILR Restricted Use Indicator https://guidance.submit-learner-data.service.gov.uk/21-22/ilr/entity/ContactPreference/field/ContPrefType/attribute/RUI | String | 3 |
L52 |
| string | 456 | ILR Preferred Method of Contact https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ContactPreference/field/ContPrefType/attribute/PMC | String | 4 |
L34A |
| string | 36 | ILR Learner FAM - Learner Support Reason 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR | String | 2 |
L34B |
| string |
| ILR Learner FAM - Learner Support Reason 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR | String | 2 |
L34C |
| string |
| ILR Learner FAM - Learner Support Reason 3 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR | String | 2 |
L34D |
| string |
| ILR Learner FAM - Learner Support Reason 4 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/LSR | String | 2 |
L31 |
| numeric |
| ILR Learner - Learning Support https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ALSCost | Int |
|
DLA |
| numeric |
| ILR Learner FAM - Disabled Students Allowance https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/DLA | String | 1 |
ACCOM |
| numeric |
| ILR Learner Accommodation https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/Accom | String | 1 |
L40A |
| numeric |
| ILR Learner FAM - National Learner Monitoring 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/NLM | String | 3 |
L40B |
| numeric |
| ILR Learner FAM - National Learner Monitoring 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/NLM | String | 3 |
L42A |
| numeric |
| ILR Learner - Provider Specified Monitoring 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/ProvSpecLearnMon | String | 20 |
L42B |
| numeric |
| ILR Learner - Provider Specified Monitoring 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/ProvSpecLearnMon | String | 20 |
EHC |
| numeric |
| ILR Learner FAM - Education Health Care plan https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/EHC | String | 1 |
GCSE_ENG_GRADE |
| alphanumeric |
| ILR Learner - English GCSE Grade https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/EngGrade | String | 4 |
GCSE_MATH_GRADE |
| alphanumeric |
| ILR Learner - Maths GCSE Grade https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/MathGrade | String | 4 |
PRIOREDU |
| numeric |
| ILR Learner - Prior Attainment (to 2020) | String | 2 |
PRIORATTAINMENT |
| numeric | 03 | ILR Learner - Prior Attainment Level | String | 2 |
PRIORATTAINMENTDATE |
| date | 31/08/2021 | ILR Learner - Prior Attainment Level Applied from Date | DateTime |
|
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 | String | 1 |
DELIV_LOC_ORGCODE |
| PICS Organisation Code |
| Delivery Location Organisation | String | 6 |
DELIV_LOC_POSTCODE |
| Postcode |
| Delivery Location Postcode | String | 8 |
PROG_START |
| date |
| Start of Programme | DateTime |
|
LRN_EXPEND |
| date |
| Expected End of Learning Portion of Apprenticeship | DateTime |
|
PROG_EXPEND |
| date |
| Expected End of Programme | DateTime |
|
MAINAIMREF |
| alphanumeric |
| Qualification Reference code for the main aim of Learning | String | 8 |
MAINAIM_OTHERFUNDADJ |
| numeric |
| Other Funding Adjustment to apply to the Main ILR Component Aim | Short |
|
DAS_COHORT |
| alphanumeric |
| Apprenticeship Service Cohort Reference | String | 20 |
DAS_STATUS |
| numeric |
| Apprenticeship Service Status 0 - Non-AS | String | 1 |
DAS_RPL_IDENTIFIED
|
| string | Y | Apprenticeship Service Recognised Prior Learning - used in the Apprenticeship Service Bulk Upload Apprenticeship service bulk upload specification | String | 1 |
DAS_TRAININGHOURSREDUCTION |
| number |
| Apprenticeship Service Off-the-job training reduced due to prior learning - used in the Apprenticeship Service Bulk Upload | Short |
|
DAS_TOTALTRAININGHOURS |
| number |
| Apprenticeship Service Total off-the-job hours for the apprenticeship standard - used in the Apprenticeship Service Bulk Upload | Short |
|
DAS_DURATIONREDUCED |
| number |
| Apprenticeship Service Duration Reduced by Weeks - used in the Apprenticeship Service Bulk Upload | Short |
|
DAS_PRICEREDUCED |
| number | 1250 | Apprenticeship Service Price Reduced by £s - used in the Apprenticeship Service Bulk Upload | Int |
|
CONTRACT |
| PICS Contract Code |
| PICS Contract | String | 5 |
SCHOOL_ORGCODE |
| PICS Organisation Code |
| Creates a Learner “School“ Placement record with the same Start and Expected End dates as the Learner Episode | String | 6 |
COLLEGE_ORGCODE |
| PICS Organisation Code |
| Creates a Learner “College“ Placement record with the same Start and Expected End dates as the Learner Episode | String | 6 |
PLANLRNHRS_2023 |
| numeric |
| ILR Planned Learning Hours for ILR Year 2023/24 https://guidance.submit-learner-data.service.gov.uk/23-24/ilr/entity/Learner/field/PlanLearnHours | Short |
|
PLANEEPHRS_2023 |
| numeric |
| ILR Planned EEP Hours for ILR Year 2023/24 https://guidance.submit-learner-data.service.gov.uk/23-24/ilr/entity/Learner/field/PlanEEPHours | Short |
|
PLANLRNHRS_2024 |
| numeric |
| ILR Planned Learning Hours for ILR Year 2024/25 https://guidance.submit-learner-data.service.gov.uk/24-25/ilr/entity/Learner/field/PlanLearnHours | Short |
|
PLANEEPHRS_2024 |
| numeric |
| ILR Planned EEP Hours for ILR Year 2024/25 https://guidance.submit-learner-data.service.gov.uk/24-25/ilr/entity/Learner/field/PlanEEPHours | Short |
|
PLANLRNHRS_2025 |
| numeric |
| ILR Planned Learning Hours for ILR Year 2024/25 https://guidance.submit-learner-data.service.gov.uk/24-25/ilr/entity/Learner/field/PlanLearnHours | Short |
|
PLANEEPHRS_2025 |
| numeric |
| ILR Planned EEP Hours for ILR Year 2024/25 https://guidance.submit-learner-data.service.gov.uk/24-25/ilr/entity/Learner/field/PlanEEPHours | Short |
|
SMARTASSESSOR_ID |
| string | d053223cd2fa46479a6e30923a2c20c6 | Learner’s Smart Assessor User ID | Guid |
|
ILR Employment - Before Enrolment
Column Name | Required? | Format | Example | Notes | Data Type | Field Length |
---|---|---|---|---|---|---|
PRIOR_EMPSTAT_CODE |
| numeric |
| ILR Employment - Status before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/EmpStat | String | 2 |
PRIOR_EMPSTAT_DATE |
| date |
| ILR Employment - Date Status before Enrolment Applies https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerEmploymentStatus/field/DateEmpStatApp | DateTime |
|
PRIOR_EMPSTAT_LOE |
| numeric |
| ILR Employment - Length of Employment before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/LOE | String | 2 |
PRIOR_EMPSTAT_SEI |
| numeric |
| ILR Employment - Self Employment Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/SEI | String | 2 |
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 | String | 2 |
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 | String | 2 |
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 | String | 2 |
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 | String | 2 |
PRIOR_EMPSTAT_PEI |
| numeric |
| ILR Employment - Previous Education Indicator before Enrolment https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/PEI | String | 2 |
PRIOR_EMPSTAT_OET1 |
| numeric |
| ILR Employment - Other Employment Type 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/OET | String | 2 |
PRIOR_EMPSTAT_OET2 |
| numeric |
| ILR Employment - Other Employment Type 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/OET | String | 2 |
PRIOR_EMPSTAT_EMPCODE |
| PICS Organisation Code |
| ILR Employment - Employer before Enrolment | String | 6 |
PRIOR_EMPSTAT_EMPNAME |
| alphanumeric |
| Employer Name - used for matching | String | 60 |
PRIOR_EMPSTAT_EMPADDR1 |
| alphanumeric |
| Employer Address - Line 1 | String | 60 |
PRIOR_EMPSTAT_EMPADDR2 |
| alphanumeric |
| Employer Address - Line 2 | String | 60 |
PRIOR_EMPSTAT_EMPADDR3 |
| alphanumeric |
| Employer Address - Line 3 | String | 60 |
PRIOR_EMPSTAT_EMPADDR4 |
| alphanumeric |
| Employer Address - Line 4 | String | 60 |
PRIOR_EMPSTAT_EMPADDR5 |
| alphanumeric |
| Employer Address - Line 5 | String | 60 |
PRIOR_EMPSTAT_EMPPHONE |
| numeric |
| Employer Phone | String | 25 |
PRIOR_EMPSTAT_EMPEMAIL |
| alphanumeric |
| Employer Email Address | String | 100 |
PRIOR_EMPSTAT_EMPPOSTCODE |
| Postcode |
| Employer Postcode - used for matching | String | 8 |
PRIOR_EMPSTAT_EMPEDRS |
| numeric |
| Employer EDS Registration Number - used for matching | String | 9 |
PRIOR_EMPSTAT_AGREEMENT_ID |
| 6 alphanumeric |
| Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports | String | 6 |
ILR Employment - Change on/after Start
Column Name | Required? | Format | Example | Notes | Date Type | Field Length |
---|---|---|---|---|---|---|
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 | String | 2 |
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 | DateTime |
|
CHANGE_EMPSTAT_LOE |
| numeric |
| ILR Employment - Length of Employment if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/LOE | String | 2 |
CHANGE_EMPSTAT_SEI |
| numeric |
| ILR Employment - Self Employment Indicator if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/SEI | String | 2 |
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 | String | 2 |
CHANGE_EMPSTAT_BSI |
| numeric |
| ILR Employment - Benefits Status Indicator if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/BSI | String | 2 |
CHANGE_EMPSTAT_SEM |
| numeric |
| ILR Employment - Small Employer if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/SEM | String | 2 |
CHANGE_EMPSTAT_LOU |
| numeric |
| ILR Employment - Length of Unemployment if Changed on / after Start https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/LOU | String | 2 |
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 | String | 2 |
CHANGE_EMPSTAT_OET1 |
| numeric |
| ILR Employment - Other Employment Type 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/OET | String | 2 |
CHANGE_EMPSTAT_OET2 |
| numeric |
| ILR Employment - Other Employment Type 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/EmploymentStatusMonitoring/field/ESMType/attribute/OET | String | 2 |
CHANGE_EMPSTAT_EMPCODE |
| PICS Organisation Code |
| ILR Employment - Employer if Changed on / after Start | String | 6 |
CHANGE_EMPSTAT_EMPNAME |
| alphanumeric |
| Employer Name - used for matching | String | 60 |
CHANGE_EMPSTAT_EMPADDR1 |
| alphanumeric |
| Employer Address - Line 1 | String | 60 |
CHANGE_EMPSTAT_EMPADDR2 |
| alphanumeric |
| Employer Address - Line 2 | String | 60 |
CHANGE_EMPSTAT_EMPADDR3 |
| alphanumeric |
| Employer Address - Line 3 | String | 60 |
CHANGE_EMPSTAT_EMPADDR4 |
| alphanumeric |
| Employer Address - Line 4 | String | 60 |
CHANGE_EMPSTAT_EMPADDR5 |
| alphanumeric |
| Employer Address - Line 5 | String | 60 |
CHANGE_EMPSTAT_EMPPHONE |
| numeric |
| Employer Phone | String | 25 |
CHANGE_EMPSTAT_EMPEMAIL |
| alphanumeric |
| Employer Email Address | String | 100 |
CHANGE_EMPSTAT_EMPPOSTCODE |
| Postcode |
| Employer Postcode - used for matching | String | 8 |
CHANGE_EMPSTAT_EMPEDRS |
| numeric |
| Employer EDS Registration Number - used for matching | String | 9 |
CHANGE_EMPSTAT_AGREEMENT_ID |
| 6 alphanumeric |
| Employer Apprenticeship Service Agreement ID. Used for AS Bulk exports | String | 6 |
ILR Programme Aim
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.
Apprenticeship Costs
Column Name | Required? | Format | Example | Notes | Data Type | Field Length |
---|---|---|---|---|---|---|
TRG_TNP |
| numeric | 1000 | ILR Apprenticeship Financial Record - Total Negotiate Price for Training (TNP1) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/AppFinRecord/field/AFinType/attribute/TNP | Int |
|
TRG_EMP |
| numeric | 50 | Employer’s Contribution to Training if not levy funded | Decimal |
|
TRG_EMP_START |
| numeric | 40 | Lump Sum of Employer’s Contribution to Training | Decimal |
|
TRG_EMP_SPRD |
| alphanumeric |
| Encoding of spreading method of Employer’s Contribution to Training | String | ∞ |
ASM_TNP |
| numeric | 1000 | ILR Apprenticeship Financial Record - Total Negotiate Price for Assessment (TNP2) https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/AppFinRecord/field/AFinType/attribute/TNP | Int |
|
ASM_EMP |
| numeric | 50 | Employer’s Contribution to Assessment if not levy funded | Decimal |
|
ASM_EMP_START |
| numeric | 40 | Lump Sum of Employer’s Contribution to Assessment | Decimal |
|
ASM_EMP_SPRD |
| alphanumeric |
| Encoding of spreading method of Employer’s Contribution to Assessment | String | ∞ |
ADD_EMP |
| numeric | 5000 | Additional Employer Price | Decimal |
|
ADD_EMP_START |
| numeric | 4000 | Additional Employer Lump Sum | Decimal |
|
ADD_EMP_SPRD |
| alphanumeric |
| Additional Employer Encoding of spreading method | String | ∞ |
Functional Skills Initial Assessments
From the PICS release for the 2023/24 ILR Year (due mid August 2023) imports of Functional Skills Initial Assessments will require either a Level or a Result to be processed. If a date is not specified the Episode Start date will be used.
Column Name | Required? | Format | Example | Notes | Data Type | Field Length |
---|---|---|---|---|---|---|
LIT_FIRSTASSDATE |
| date | 31/08/2021 | English/Literacy Initial Assessment Date | DateTime |
|
LIT_FIRSTASSLEV |
| alphanumeric | D | English/Literacy Initial Assessment Level See Code Lists | String | 3 |
LIT_FIRSTASSRES |
| numeric | 67 | English/Literacy Initial Assessment Result | Double |
|
NUM_FIRSTASSDATE |
| date | 31/08/2021 | Maths/Numeracy Initial Assessment Date | DateTime |
|
NUM_FIRSTASSLEV |
| alphanumeric | D | Maths/Numeracy Initial Assessment Level See Code Lists | String | 3 |
NUM_FIRSTASSRES |
| numeric | 67 | Maths/Numeracy Initial Assessment Result | Double |
|
ICT_FIRSTASSDATE |
| date | 31/08/2021 | ICT Initial Assessment Date | DateTime |
|
ICT_FIRSTASSLEV |
| alphanumeric | D | ICT Initial Assessment Level See Code Lists | String | 3 |
ICT_FIRSTASSRES |
| numeric | 67 | ICT Initial Assessment Result | Double |
|
ESOL_FIRSTASSDATE |
| date | 31/08/2021 | English as a Second Language Initial Assessment Date | DateTime |
|
ESOL_FIRSTASSLEV |
| alphanumeric | D | English as a Second Language Initial Assessment Level See Code Lists | String | 3 |
ESOL_FIRSTASSRES |
| numeric | 67 | English as a Second Language Initial Assessment Result | Double |
|
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 | Data Type | Field Length |
---|---|---|---|---|---|---|
PRIORQUAL_TITLECODE_1 | Title or Code | 5 alphanumeric | 0005Z | PICS Code for the Title of the Prior Qualification | String | 10 |
PRIORQUAL_NAME_1 | Title or Code | string | Maths GCSE | Title for the Prior Qualification | String | 40 |
PRIORQUAL_LEVEL_CODE_1 |
| 5 alphanumeric | GCSE01 | PICS Code for the Level | String | 5 |
PRIORQUAL_LEVEL_1 |
| string | GCSE | Level | String | 50 |
PRIORQUAL_GRADE_CODE_1 |
| 5 alphanumeric | GCSE1 | PICS Code for the Grade | String | 5 |
PRIORQUAL_GRADE_1 |
| string | 1 | Grade | String | 50 |
PRIORQUAL_ACHDATE_1 |
| date |
| Achievement Date | DateTime |
|
Advanced Learning Loans/SLC
Column Name | Required? | Format | Example | Notes | Data Type | Field Length |
---|---|---|---|---|---|---|
SLC_APPID |
| alphanumeric |
| Application ID | String | 11 |
SLC_CUSTREF |
| alphanumeric |
| Customer Reference | String | 11 |
SLC_COURSECOST |
| numeric |
| Course Cost Excluding VAT | Decimal |
|
SLC_COURSEVAT |
| numeric |
| Course Cost VAT | Decimal |
|
SLC_LOANAMOUNT |
| numeric |
| Loan Amount | Decimal |
|
SLC_LOANSTART |
| date |
| Loan Start Date | DateTime |
|
SLC_LOANEND |
| date |
| Loan End Date | DateTime |
|
SLC_BALANCE |
| numeric |
| Balance for Learner to Pay | Decimal |
|