| Field name |
Description |
Derived Variable |
Derivation |
|
COLLECTION |
Collection (FE, WBL, ESFSE, UFI, ACL) |
|
|
|
PERIOD |
Period of the year this file relates to |
Period |
|
|
L01 |
Provider Number |
|
Framework Identifier |
|
L03 |
Learner reference number |
|
Framework Identifier |
|
A05 |
Learning aim data set sequence |
|
Set to 0 |
|
A10 |
LSC Funding stream |
|
Set to 50 |
|
A15 |
Programme type (WBL) |
|
Framework Identifier |
|
A16 |
Programme entry route (WBL) |
|
WhereA10=40,41 or 42 (and A27>31 July 2004), then the aim with the earliest start date provides the A16. If there are two aims with different values in A16, then set to -99 |
|
A23 |
Delivery location postcode |
|
From NVQ aim with the latest start date of all the NVQ aims that make up the framework, where no NVQ record = -99 |
|
A26 |
Sector framework of learning (WBL) |
|
Framework Identifier |
|
A27 |
Learning start date |
|
Earliest start date of all the aims that make up the framework |
|
A28 |
Learning planned end date |
|
Latest planned end date of all the aims that make up the framework |
|
A31 |
Learning actual end date |
|
See Below |
|
A43 |
Sector framework achievement date (WBL) |
|
Max value of all aims that make up the framework |
|
A53 |
Additional learning needs |
|
From the aim with the latest start date of all the aims that make up the framework |
|
A_SSA_T1 |
LAD - SSA Tier 1 Code |
Sector Subject Areas |
From NVQ aim with the latest start date of all the NVQ aims that make up the framework, where no NVQ record = -99 |
|
A_SSA_T2 |
LAD - SSA Tier 2 |
Sector Subject Areas |
From NVQ aim with the latest start date of all the NVQ aims that make up the framework, where no NVQ record = -99 |
|
A_AGEST |
DV - Age of the learner as at the start date of aim |
Age |
From the aim with the earliest start date of all the aims that make up the framework |
|
A_AGESTB |
DV - Age of the learner as at the start date of aim banded |
Age |
From the aim with the earliest start date of all the aims that make up the framework |
|
A_DPLLSC |
DV - LLSC of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number |
Location of the Delivery Provider (Aim level) |
Derived from Framework A23 |
|
A_DPREG |
DV - Region of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number |
Location of the Delivery Provider (Aim level) |
Derived from Framework A23 |
|
A_DPLA |
DV - Local Authority based on the Aimr DP postcode |
Location of the Delivery Provider (Aim level) |
Derived from Framework A23 |
|
A_DPWA01 |
DV - Local Authority ward code of the Delivery Provider (2001 census) |
Location of the Delivery Provider (Aim level) |
Derived from Framework A23 |
|
A_DPWA03 |
DV - Local Authority ward code of the Delivery Provider (2003 census) |
Location of the Delivery Provider (Aim level) |
Derived from Framework A23 |
|
A_DPWARD |
DV - Local Authority ward code of the Delivery Provider (1991 census) |
Location of the Delivery Provider (Aim level) |
Derived from Framework A23 |
|
A_IL_P1 |
DV - In-Learning in Period 1 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P2 |
DV - In-Learning in Period 2 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P3 |
DV - In-Learning in Period 3 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P4 |
DV - In-Learning in Period 4 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P5 |
DV - In-Learning in Period 5 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P6 |
DV - In-Learning in Period 6 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P7 |
DV - In-Learning in Period 7 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P8 |
DV - In-Learning in Period 8 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P9 |
DV - In-Learning in Period 9 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P10 |
DV - In-Learning in Period 10 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P11 |
DV - In-Learning in Period 11 |
In Learning |
Max value of all aims that make up the framework |
|
A_IL_P12 |
DV - In-Learning in Period 12 |
In Learning |
Max value of all aims that make up the framework |
|
A_ILPY2D |
DV - Number of periods in-learning in current year, year to date |
In Learning |
Sum of (framework record values) A_IL_P1 to A_IL_P12 |
|
A_ILAVY2 |
DV - Average number of periods in-learning in current year to date |
In Learning |
Framework record A_ILPY2D/PERIOD |
|
A_LEAVEP |
DV - Period Left in |
Leave Period |
Derived from Framework record A31 |
|
A_STARTP |
DV - Period Started in |
Start Period |
Derived from Framework record A27 |
|
A_STATUS |
DV - Status of NVQ / Framework (Only in Framework and Aims file |
Framework and NVQ Status |
See Below |
|
L11 |
Date of birth |
|
From Learner record |
|
L12 |
Ethnicity |
|
From Learner record |
|
L13 |
Sex |
|
From Learner record |
|
L14 |
Learning difficulties and/or disabilities and/or health problems |
|
From Learner record |
|
L15 |
Disability |
|
From Learner record |
|
L16 |
Learning difficulty |
|
From Learner record |
|
L17 |
Home Postcode |
|
From Learner record |
|
L22 |
Current Postcode |
|
From Learner record |
|
L25 |
LSC number of funding LSC |
|
From Learner record |
|
L33 |
Disadvantage uplift factor (FE) |
|
From Learner record |
|
L35 |
Prior attainment level |
|
From Learner record |
|
L39 |
Destination (WBL) |
|
From Learner record |
|
L44 |
NCS delivery LSC number |
|
From Learner record |
|
L_ACT_B |
DV - Actual current year GLH using 1 Oct 1 Feb 15 May |
Current Year Guided Learning Hours |
From Learner record |
|
L_AGE |
DV - Age of the learner as at 31 August 2003 |
Age |
From Learner record |
|
L_AGEB |
DV - Age of the learner as at 31 August 2003 banded |
Age |
From Learner record |
|
L_ATYPE |
DV - In-year aim type of the learner |
Aim Type |
From Learner record |
|
L_SFL |
DV - 1/0 flag to indicate if the learner is a basic skills learner or not |
Skills for Life |
From Learner record |
|
L_DISADV |
DV - 1/0 flag to indicate IF the learner is considered to be disadvantaged or not |
Disadvantaged Learner |
From Learner record |
|
L_DPLLSC |
DV - LLSC of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number |
Location of the Delivery Provider (Learner level) |
From Learner record |
|
L_DPREG |
DV - Region of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number |
Location of the Delivery Provider (Learner level) |
From Learner record |
|
L_DPLA |
DV – Local Authority based on the Learner DP postcode |
Location of the Delivery Provider (Learner level) |
From Learner record |
|
L_DPWA01 |
DV - Local Authority ward code of the Delivery Provider (2001 census) |
Location of the Delivery Provider (Learner level) |
From Learner record |
|
L_DPWA03 |
DV - Local Authority ward code of the Delivery Provider (2003 census) |
Location of the Delivery Provider (Learner level) |
From Learner record |
|
L_DPWARD |
DV - Local Authority ward code of the Delivery Provider (1991 census) |
Location of the Delivery Provider (Learner level) |
From Learner record |
|
L_EXP_B |
DV - Expected current year GLH using 1 Oct 1 Feb 15 May |
Current Year Guided Learning Hours |
From Learner record |
|
L_FRANCH |
DV - does the learner have any franchised aims (1/0 flag) |
Franchised Aim |
From Learner record |
|
L_FTELP |
DV - Full time equivalent learner profile method i.e expected learner cyglh/450, up to a maximum value of 1 FTE. |
Full Time Equivalent |
From Learner record |
|
L_FULLLEVEL2 |
DV - Full NVQ level 2 learner flag |
Full Level 2 & 3 |
From Learner record |
|
L_FULLLEVEL3 |
DV - Full NVQ level 3 learner flag |
Full Level 2 & 3 |
From Learner record |
|
L_FUND |
DV - Sources of funding for the learner |
Source of Funding |
From Learner record |
|
L_OCT |
DV - Learner was active on 1 Oct in this year |
Active on Census Date |
From Learner record |
|
L_LIVE_B |
DV - Status of aim for inclusion in analysis using 1 Oct as first census date (Method B) |
Status for Inclusion in Analysis |
From Learner record |
|
L_LLLSC |
DV - Home LSC of the Learner, based on the Learner postcode |
Location of the Learner |
From Learner record |
|
L_LREG |
Home Region of the Learner, based on the Learner postcode |
Location of the Learner |
From Learner record |
|
L_LLA |
DV – Local Authority based on the Learner postcode |
Location of the Learner |
From Learner record |
|
L_LWAR01 |
DV - Local Authority ward code of the Learner (2001 census) |
Location of the Learner |
From Learner record |
|
L_LWAR03 |
DV - Local Authority ward code of the Learner (2003 census) |
Location of the Learner |
From Learner record |
|
L_LWARD |
DV - Local Authority ward code of the Learner (1991 census) |
Location of the Learner |
From Learner record |
|
L_MODE_B |
DV - Learners mode attendance using 1 Nov, 1 Feb, 15 May (Method B) |
Mode of Attendance |
From Learner record |
|
L_NVQLEV |
DV - NVQ level of the learner |
Notional NVQ Level |
From Learner record |
|
L_LIS_FG |
DV - LIS Funding Flag |
LIS Funding Generated |
From Learner record |
|
L_PLLSC |
DV - LLSC based on the 1-1 'owner' relationship UPIN to LLSC |
Location of the Provider |
From Learner record |
|
L_PREG |
DV - Region of the Owning Provider, based on the Learner postcode |
Location of the Provider |
From Learner record |
|
L_PLA |
DV – Local Authority based on the Provider postcode |
Location of the Provider |
From Learner record |
|
L_PWAR01 |
DV - Local Authority ward code of the Owning Provider (2001 census) |
Location of the Provider |
From Learner record |
|
L_PWAR03 |
DV - Local Authority ward code of the Owning Provider (2003 census) |
Location of the Provider |
From Learner record |
|
L_PWARD |
DV - Local Authority ward code of the Owning Provider (1991 census) |
Location of the Provider |
From Learner record |
|
L_UPLF56 |
DV - 05/06 Widening participation uplift factor based on learners postcode prior to enrolling |
Widening Participation Uplift Factors |
From Learner record |
|
L_UPLF67 |
DV – 06/07 Widening participation uplift factor based on learners postcode prior to enrolling |
Widening Participation Uplift Factors |
From Learner record |
|
L_TTGAIN |
DV - Train to Gain Learner |
Train to Gain |
From Learner record |
