Learner Standard File 2009/2010


 
NOTE: Standard File Views are open to change

1. The Learner Standard File has one row of data per learner for each provider.

PURPOSE

2. The Learner Standard File is used for the analysis of learner level data. For example, creating management information reports indicating learner numbers by sources of funding (L_FUND).

3. This dataset is part of the following collections

  • The Standard Files Collection

DETAILED DEFINITION

4. The standard files are created by running the 'standard code' on the raw data collected using the Individualised Learner Record (ILR). The standard code introduces a number of derived variables to the data which are stored in the standard files. The data is converted to both SPSS and Crystal format for analysis and reporting.

5. A learner is uniquely identified by a combination of the Provider Number (L01) and the Learner Reference Number (L03) fields.

6. The table below shows the fields within the Learner Standard File.

7. Where the variable name is of the form 'Lxx' (where xx is a two digit number) then this is taken from the field of the same name in the Individualised Learner Record (ILR) datasets.  Definitions for these variables are available in the 2008/09 ILR Specification on the Information Authority Website.

8. The definitions for the learner level Derived Variables (those with 'L_' prefix) can be found by following the hyperlink in the Variable Name column of the table.

Table 1. Fields in the Learner Standard File.

Variable Name Variable Label Data Definition
Year YEAR Academic Year of Dataset  
COLLECTION Collection Funding Stream (LR, ER, ESF SR, UfI, ASL)  
PERIOD PERIOD Collection Period Data Contains Period
L01 L01 Provider Number  
L02 L02 Contract Allocation Type  
L03 L03 Learner Reference Number  
L04 L04 Data Set Identifier Code  
L05 L05 Aim Datasets  
L11 L11 Date Of Birth  
L12 L12 Ethnicity  
L13 L13 Sex  
L14 L14 Learning Difficulties And Or Disabilities And Or Health Problems  
L15 L15 Disability  
L16 L16 Learning Difficulty  
L17 L17 Home Postcode  
L22 L22 Current Postcode  
L24 L24 Country Of Domicile
L25 L25 LSC Number Of Funding LSC  
L25_REG L25_REG Region of the Funding LSC Region of the Funding LSC
L27 L27 Restricted Use Indicator  
L28A L28a Eligibility For Enhanced Funding  
L28B L28b Eligibility For Enhanced Funding  
L29 L29 Additional Support  
L31 L31 Additional Support Cost  
L32 L32 Eligibility For Disadvantaged Uplift  
L33 L33 Disadvantage Uplift Factor  
L34A L34a Learner Support Reason  
L34B L34b Learner Support Reason  
L34C L34c Learner Support Reason  
L34D L34d Learner Support Reason  
L35 L35 Prior Attainment Level  
L36 L36 Learner Status On Last Working Day Before Learning  
L37 L37 Employment Status On First Day Of Learning  
L39 L39 Destination  
L40A L40a National Learning Monitoring  
L40B L40b National Learning Monitoring  
L41A L41a Local Learning Monitoring  
L41B L41b Local Learning Monitoring  
L42A L42a Provider Specified Learner Data  
L42B L42b Provider Specified Learner Data  
L44 L44 NES Delivery LSC Number  
L45 L45 Unique Learner Number  
L46 L46 UK Provider Reference Number  
L47 L47 Current Employment Status  
L48 L48 Date Employment Status Changed  
L49A L49A Discretionary learner support type  
L49B L49B Discretionary learner support type  
L49C L49C Discretionary learner support type  
L49D L49D Discretionary learner support type  
L_IL_P1 L_IL_P1 Learner In-Learning Period 1 Learner Level in Learning
L_IL_P2 L_IL_P2 Learner In-Learning Period 2 Learner Level in Learning
L_IL_P3 L_IL_P3 Learner In-Learning Period 3 Learner Level in Learning
L_IL_P4 L_IL_P4 Learner In-Learning Period 4 Learner Level in Learning
L_IL_P5 L_IL_P5 Learner In-Learning Period 5 Learner Level in Learning
L_IL_P6 L_IL_P6 Learner In-Learning Period 6 Learner Level in Learning
L_IL_P7 L_IL_P7 Learner In-Learning Period 7 Learner Level in Learning
L_IL_P8 L_IL_P8 Learner In-Learning Period 8 Learner Level in Learning
L_IL_P9 L_IL_P9 Learner In-Learning Period 9 Learner Level in Learning
L_IL_P10 L_IL_P10 Learner In-Learning Period 10 Learner Level in Learning
L_IL_P11 L_IL_P11 Learner In-Learning Period 11 Learner Level in Learning
L_IL_P12 L_IL_P12 Learner In-Learning Period 12 Learner Level in Learning
L_A23 L_A23 Learner Level Delivery Location Postcode Learner Level Delivery Location Postcode
L_ACTIVE L_ACTIVE Learner Active for the current academic year Active
L_FUND L_FUND Sources Of Funding For The Learner Sources of Funding
L_FUNDING SOURCE L_FUNDINGSOURCE Source of funding for the learner Funding Sources
L_INYR_ACTUAL_GLH L_INYR_ACTUAL_GLH Actual In Year GLH Current Year Guided Learning Hours (CYGLH)
L_INYR_EXPECTED_GLH L_INYR_EXPECTED_GLH Expected In Year GLH Current Year Guided Learning Hours (CYGLH)
L_ADDSUP L_ADDSUP Eligible For Learner Support Eligible for Additional Learner Support
L_AGE L_AGE Age Of Learner As At 31 August Age
L_AGEB L_AGEB Age Of Learner As At 31 August Banded Age
L_AGEBAND L_AGEBAND Age of learner as at 31 August 16-18 and 19+ Bands Age
L_ATYPE L_ATYPE In-Year Aim Type For A The Learner Aim Type
L_DISADV L_DISADV Learner Disadvantaged Disadvantaged Learner
L_DPLA L_DPLA Local Authority Based On The Delivery Location Postcode Location of the Delivery Provider
L_DPLLSC L_DPLLSC LLSC Of The Delivery Location Postcode Location of the Delivery Provider
L_DPREG L_DPREG Region Of The Delivery Location Postcode Location of the Delivery Provider (Learner Level)
L_DPWA01 L_DPWA01 Local Authority Ward Of The Delivery Location Postcode (2001 Census) Location of the Delivery Provider (Learner Level)
L_DPWA03 L_DPWA03 Local Authority Ward Of The Delivery Location Postcode(2003 Census) Location of the Delivery Provider (Learner Level)
L_DPWARD L_DPWARD Local Authority Ward Of The Delivery Location Postcode (1991 Census) Location of the Delivery Provider (Learner Level)
L_QCF L_QCF Qualifications and Credit Framework Learner Qualifications and Credit Framework
L_FULLLEVEL2 L_FULLLEVEL2 Full Level 2 Learner Full Level 2 and 3
L_FULLLEVEL2_ACHIEVE L_FULLLEVEL2_ACHIEVE Full Level 2 Achievement Learner Full Level 2 and 3 Achievement
L_FULLLEVEL2_COMPLETE L_FULLLEVEL2_COMPLETE Full Level 2 Completion Learner Full Level 2 and 3 Completion
L_FIRST_FULLLEVEL2 L_FIRST_FULLLEVEL2 First Full Level 2 Learner First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
L_FIRST_FULLLEVEL2
_ACHIEVE
L_FIRST_FULLLEVEL2_ACHIEVE First Full Level 2 Achievement Learner First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
L_FULLLEVEL3 L_FULLLEVEL3 Full Level 3 Learner Full Level 2 and 3
L_FULLLEVEL3_ACHIEVE L_FULLLEVEL3_ACHIEVE Full Level 3 Achievement Learner Full Level 2 and 3 Achievement
L_FULLLEVEL3_COMPLETE L_FULLLEVEL3_COMPLETE Full Level 3 Completion Learner Full Level 2 and 3 Completion
L_FIRST_FULLLEVEL3 L_FIRST_FULLLEVEL3 First Full Level 3 Learner First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
L_FIRST_FULLLEVEL3
_ACHIEVE
L_FIRST_FULLLEVEL3_ACHIEVE First Full Level 3 Achievement Learner First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
L_FRANCH L_FRANCH Franchised Aims Franchised Aim
L_FTELP L_FTELP Full Time Equivalent Full Time Equivalent
L_OCT L_OCT Learner Active On 1 October In This Year Active on Census Date
L_NOV L_NOV Learner Active On 1 November In This Year Active on Census Date
L_JAN L_JAN Learner Active On 1 January In This Year Active on Census Date
L_LLLSC L_LLLSC Home LSC Of Learner Postcode Location of the Learner
L_LREG L_LREG Home Region Of Learner Postcode Location of the Learner
L_LLA L_LLA Local Authority of Learner Postcode Location of the Learner
L_LWAR01 L_LWAR01 Local Authority Ward Code Of Learner Postcode (2001 Census) Location of the Learner
L_LWAR03 L_LWAR03 Local Authority Ward Code Of Learner Postcode (2003 Census) Location of the Learner
L_LWARD L_LWARD Local Authority Ward Code Of Learner Postcode (1991 Census) Location of the Learner
L_MODE_B L_MODE_B Learners Mode Of Attendence Using 1 Oct 1 Feb 15 May Mode of Attendance
L_NOTIONLEV L_NOTIONLEV Notional NVQ Level of Learner  Notional NVQ Level
L_OS1200 L_OS1200 Learner has more than 1200 Expected Onsite GLH Expected Daytime On-Site Guided Learning Hours
L_OSEGLH L_OSEGLH Expected Daytime On-Site GLH Expected Daytime On-Site Guided Learning Hours
L_PLLSC L_PLLSC LLSC Based On The 1-1 Owner Relationship UPIN To LLSC Location of the Provider
L_PREG L_PREG Region Of The Owning Provider Location of the Provider
L_PLA L_PLA Local Authority Based On The Provider Postcode Location of the Provider
L_PWAR01 L_PWAR01 Local Authority Ward Code Of The Owning Provider Postcode (2001 Census) Location of the Provider
L_PWAR03 L_PWAR03 Local Authority Ward Code Of The Owning Provider Postcode (2003 Census) Location of the Provider
L_PWARD L_PWARD Local Authority Ward Code Of The Owning Provider Postcode (1991 Census) Location of the Provider
L_SFL L_SFL Learner Counts Towards Skills For Life Target  Skills for Life Flags
L_SFL_LEITCH_LIT L_SFL_LEITCH_LIT Leitch Skills For Life Literacy Learner Skills for Life (SFL) LEITCH Literacy
L_SFL_LEITCH_LIT_ACH L_SFL_LEITCH_LIT_ACH Leitch Skills For Life Literacy Achiever Skills for Life (SFL) LEITCH Literacy Achievers
L_SFL_LEITCH_NUM L_SFL_LEITCH_NUM Leitch Skills For Life Numeracy Learner Skills for Life (SFL) LEITCH Numeracy
L_SFL_LEITCH_NUM_ACH L_SFL_LEITCH_NUM_ACH Leitch Skills For Life Numeracy Achiever Skills for Life (SFL) LEITCH Numeracy Achievers
  L_SLN Standard Learner Number (Not Yet Defined Or Populated)  
L_TTGAIN L_TTGAIN Train To Gain Learner Train to Gain
L_UPLF0910 L_UPLF0910 0910 Widening Participation Uplift Factor Based on Learner Postcode Widening Participation Uplift Factors
L_UPLF78 L_UPLF78 0708 Widening Participation Uplift Factor Based On Learner Postcode Widening Participation Uplift Factors
L_UPLF89 L_UPLF89 0809 Widening Participation Uplift Factor Based On Learner Postcode Widening Participation Uplift Factors
L_IY_SLN_PAYMENT L_IY_SLN_PAYMENT Learner Received SLN or Payment This Year To Date In Year SLN Payment
L_PRIOR_SLN_PAYMENT L_PRIOR_SLN_PAYMENT Learner Received an SLN or Payment in Previous Years or in This Year Prior SLN Payment
L_IL_IY L_IL_IY Learner in learning in Year In Learning in Year
L_TO_DATE_SLN_PAYMENT L_TO_DATE_SLN_PAYMENT Learner generated SLN or received Payment in This or Previous Years To Date SLN Payment

Date last modfied: 28th July 2009