|
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
|
