...
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 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 |
16
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
| 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/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 |