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 |
---|---|---|---|---|
FIRSTNAME |
| string | Roberta |
|
PREFFIRSTNAME expected mid October 2023 |
| 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 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/LLDDHealthProb |
ALL_LLDD |
| string | 12*13*96 | ILR LLDD codes https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LLDDandHealthProblem/field/LLDDCat |
PRIMARY_LLDD |
| string | 12 | ILR Primary LLDD |
RUI |
| string | 67 | ILR Restricted Use Indicator https://guidance.submit-learner-data.service.gov.uk/21-22/ilr/entity/ContactPreference/field/ContPrefType/attribute/RUI |
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 |
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 |
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 |
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 |
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 |
L31 |
| numeric |
| ILR Learner - Learning Support https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/ALSCost |
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 |
ACCOM |
| numeric |
| ILR Learner Accommodation https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/Accom |
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 |
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 |
L42A |
| numeric |
| ILR Learner - Provider Specified Monitoring 1 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/ProvSpecLearnMon |
L42B |
| numeric |
| ILR Learner - Provider Specified Monitoring 2 https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/ProviderSpecLearnerMonitoring/field/ProvSpecLearnMon |
MCF |
| numeric |
| ILR Learner - Maths Condition of Funding https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/MCF |
ECF |
| numeric |
| ILR Learner - English Condition of Funding https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/LearnerFAM/field/LearnFAMType/attribute/ECF |
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 |
GCSE_ENG_GRADE |
| alphanumeric |
| ILR Learner - English GCSE Grade https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/field/EngGrade |
GCSE_MATH_GRADE |
| alphanumeric |
| ILR Learner - Maths GCSE Grade https://guidance.submit-learner-data.service.gov.uk/22-23/ilr/entity/Learner/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 |
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 |
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/entity/LearnerEmploymentStatus/field/DateEmpStatApp |
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 |
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 |
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 |
| 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 |
| 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://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/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 |
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/ESMType/attribute/LOE |
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 |
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 |
| 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 |
| 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 |
| 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/ESMType/attribute/OET |
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 |
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 |
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 |
---|---|---|---|---|
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 |
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/AppFinRecord/field/AFinType/attribute/TNP |
ASM_EMP |
| numeric | 50 | Employer’s Contribution to Assessment if not levy funded |
ASM_EMP_START |
| numeric | 40 | Lump Sum of Employer’s Contribution to Assessment |
ASM_EMP_SPRD |
| alphanumeric |
| Encoding of spreading method of Employer’s Contribution to Assessment |
ADD_EMP |
| numeric | 5000 | Additional Employer Price |
ADD_EMP_START |
| numeric | 4000 | Additional Employer Lump Sum |
ADD_EMP_SPRD |
| alphanumeric |
| Additional Employer Encoding of spreading method |
Functional Skills Initial Assessments
From the PICS release for the 2023/24 ILR Year (due mid August 2023) imports of Functional Skills Initial Assessments will require either a Level or a Result to be processed. If a date is not specified the Episode Start date will be used.
Column Name | Required? | Format | Example | Notes |
---|---|---|---|---|
LIT_FIRSTASSDATE |
| date | 31/08/2021 | English/Literacy Initial Assessment Date |
LIT_FIRSTASSLEV |
| alphanumeric | D | English/Literacy Initial Assessment Level 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 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 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 |