Index of Derived Variables 2008/2009

INTRODUCTION

This is a full list of all Derived Variables with links to appropriate Data Definitions. 

Please note:

  • Variables new for 2008/2009 are marked 'New'.
  • Variables that remain unchanged are marked 'Existing'.
  • Variables that existed in previous years but have been altered for 2008/2009 are marked 'Amended'.
  • Variables that have been deleted are not included in this list, but are still available via the Index of Derived Variables 2007/2008.
  • For a Summary of Changes to the 2008/2009 Derived Variables, including deleted variables please refer to the Log of Amendments to Derived Variables 2008/2009.

    Jump to: [Aim Level] [ESF] [Learner Level] [Programme Level]

    Derived Variable Derived Variable Description Status Data Definition
    A_ACTIVE Aim Active for the current academic year New Active
    A_AGEST Age of the learner as at the start date of aim Existing Age
    A_AGESTB Age of the learner as at the start date of aim banded Existing Age
    A_AGESTBAND Age of the learner as at the start date of aim banded as 16-18 and 19+ New Age
    A_ATYPE Type of aim Amended Aim type
    A_DPLA Local Authority Based on the Aim DP Postcode Existing Location of the Delivery Provider (Aim Level)
    A_DPLLSC LLSC of the Aim Delivery Provider, Based on the DP Postcode Existing Location of the Delivery Provider (Aim Level)
    A_DPREG Region of the Aim Delivery Provider, Based on the DP Postcode Amended Location of the Delivery Provider (Aim Level)
    A_DPWA01 Local Authority ward code of the Aim Delivery Provider Existing Location of the Delivery Provider (Aim Level)
    A_DPWA03 Local Authority ward code of the Aim Delivery Provider Existing Location of the Delivery Provider (Aim Level)
    A_DPWARD Local Authority ward code of the Aim Delivery Provider Existing Location of the Delivery Provider (Aim Level)
    A_ESFTY ESF Co-financing type Existing New ESF Aim
    A_FE_PROVMIX_
    MATRIX         		FE provision mix matrix Amended Provision Mix Matrix
    A_FE_PROVMIX_
    MATRIX_SUMM         		Provision Mix Matrix Summary Amended Provision Mix Matrix Summary
    A_FFA Framework for Achievement Aim Existing Framework for Achievement
    A_FRANCH Franchised Aim Existing Franchised Aim
    A_FULLY_FUNDED Aim Fully Funded New Fully Funded
    A_FUNDED_AGE_BAND Age Band Used in DLF Funding Calc New Age
    A_IL_IY Aim in learning in Year New In Learning in Year
    A_IL_P1-12 In Learning in Period X Amended In Learning
    A_ILAVY2 Average Number of Periods In Learning in Current Year to Date Existing In Learning
    A_ILPY2D Number of Periods In-Learning in Current Year, Year To Date Existing In Learning
    A_INYR_ACTUAL_
    GLH         		Aim Actual current year GLH New Current year Guided Learning Hours (CYGLH)
    A_INYR_EXPECTED_
    GLH         		Aim Expected current year GLH New Current year Guided Learning Hours (CYGLH)
    A_IY_SLN_PAYMENT Does the Aim generate SLN or receive an In Year Payment, up to the current period New In Year SLN Payment Data Definition
    A_IY_QUALIFYING_
    SLN_PERIOD         		Aim Passes In Year Qualifying Period to be Eligible to Generate SLN New In Year Qualifying SLN Period
    A_JAN Aim active on 1 January in this year Existing Active on Census Date
    A_L2WID Level 2 Width For Full Level 2 Aims Existing Aim Contribution to Full level 2 and Full level 3
    A_L3WID Level 3 Width For Full Level 3 Aims Existing Aim Contribution to Full level 2 and Full level 3
    A_LEAVEP Period left in Amended Leave Period
    A_NOV Aim active on 1 November in this year Existing Active on Census Date
    A_NVQLEV Notional NVQ Level of the Aim Amended Notional NVQ Level
    A_OCT Aim active on 1 October in this year Existing Active on Census Date
    A_OPROV Aim other provision Existing Other Provision Flag
    A_PRIOR_SLN_
    PAYMENT         		Has the Aim generated SLN or received a Payment in Previous Years New Prior SLN Payment
    A_SFL   Counts Towards Skills For Life Target Amended Skills for Life Flags
    A_SFL_LEITCH_LIT Leitch Skills For Life Literacy aim New Skills for Life (SFL) LEITCH Literacy
    A_SFL_LEITCH_LIT_
    ACH         		Leitch Skills For Life Literacy Achiever New Skills for Life (SFL) LEITCH Literacy Achievers
    A_SFL_LEITCH_NUM Leitch Skills For Life Numeracy Aim New Skills for Life (SFL) LEITCH Numeracy
    A_SFL_LEITCH_NUM_
    ACH         		Leitch Skills For Life Numeracy Achiever New Skills for Life (SFL) LEITCH Numeracy Achievers
    A_SFLP Skills For Life Participation Existing Skills for Life Participation 
    A_SFLTY Skills For Life Type Amended Skills for Life Type
    A_SSA_T1 LAD SSA Tier 1 Code Existing Sector Subject Areas
    A_SSA_T2 LAD SSA Tier 2 Code Existing Sector Subject Areas
    A_STARTP Period started in Amended Start Period 
    A_TODATE_QUALIFYING_
    SLN_PAYMENT         		Aim Passes the Qualifying Period in Any Year to be Eligible to Generate SLN New To Date Qualifying SLN Payment
    A_TO_DATE_SLN_
    PAYMENT         		Aim generated SLN or received a Payment in Previous Years or in this Year New To Date SLN Payment
    A_TTGAIN Train to Gain Aim Amended Train to Gain
    A_TTGBROKE Train to Gain Brokerage Amended Train to Gain
    E_IL_P1-12 In Learning in Period X Existing In Learning
    E_ILAVY2 Average Number of Periods In Learning in Current Year Existing In Learning 
    E_ILPY2D Number of Periods IN-Learning In Current Year Existing In Learning
    E_LEAVEP Period left in Amended Leave Period
    E_STARTP Period started in Amended Start Period
    L_A23 Learner Level Delivery Location Postcode  Amended Learner Level Delivery Location Postcode
    L_ACTIVE Learner Active for the current academic year New Active
    L_ADDSUP Eligible for learner support Amended Eligible for Additional Learner Support
    L_AGE Age of learner as at 31 August Existing Age
    L_AGEB Age of learner as at 31 August banded Existing Age
    L_AGEBAND Age of learner as at 31 August 16-18 and 19+ Bands New Age
    L_ATYPE In Year Aim Type for a Learner Amended Aim Type
    L_DISADV Learner Disadvantaged Existing Disadvantaged Learner
    L_DPLA Local Authority based on the Delivery Location Postcode Existing Location of the Delivery Provider (Learner Level)
    L_DPLLSC LLSC of the Delivery Location Postcode Existing Location of the Delivery Provider (Learner Level)
    L_DPREG Region of the Delivery Location Postcode Amended Location of the Delivery Provider (Learner Level)
    L_DPWA01 Local Authority Ward of the Delivery Location Postcode (2001 census) Existing Location of the Delivery Provider (Learner Level)
    L_DPWA03 Local Authority ward code of the Learner Delivery Location (2003 census) Existing Location of the Delivery Provider (Learner Level)
    L_DPWARD Local Authority Ward of the Delivery Location Postcode (1991 census) Existing Location of the Delivery Provider (Learner Level)
    L_FFA Framework for Achievement Learner Existing Framework for Achievement
    L_FIRST_FULLLEVEL2 First Full Level 2 Learner Amended First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
    L_FIRST_FULLLEVEL2_
    ACHIEVE         		First Full Level 2 Achievement Learner Amended First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
    L_FIRST_FULLLEVEL3 First Full Level 3 Learner Amended First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
    L_FIRST_FULLLEVEL3_
    ACHIEVE         		First Full Level 3 Achievement Learner Amended First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
    L_FRANCH Franchised Aims Existing Franchised Aim
    L_FTELP Full Time Equivalent. Amended Full Time Equivalent
    L_FULLLEVEL2 Full Level 2 Learner Amended Full Level 2 and 3
    L_FULLLEVEL2_
    ACHIEVE         		Full Level 2 Achievement Learner Amended Full Level 2 and 3 Achievement
    L_FULLLEVEL2_
    COMPLETE         		Full Level 2 Completion Learner Amended Full Level 2 and 3 Completion
    L_FULLLEVEL3 Full Level 3 Learner Amended Full Level 2 and 3
    L_FULLLEVEL3_
    ACHIEVE         		Full Level 3 Achievement Learner Amended Full Level 2 and 3 Achievement
    L_FULLLEVEL3_
    COMPLETE         		Full Level 3 Completion Learner Amended Full Level 2 and 3 Completion
    L_FUND Sources of funding for the learner Amended Sources of Funding
    L_IL_IY Learner in learning in Year New In Learning in Year
    L_IL_P1 – 12 Learner In-Learning Period X Amended Learner Level in Learning
    L_INYR_ACTUAL_
    GLH         		Actual In Year GLH New Current Year Guided Learning Hours (CYGLH)
    L_INYR_EXPECTED_
    GLH         		Expected In Year GLH New Current Year Guided Learning Hours (CYGLH)
    L_IY_SLN_PAYMENT Learner Received SLN or Payment This Year To Date New In Year SLN Payment
    L_JAN Learner active on 1 January in this year Existing Active on Census Date
    L_LLA Local Authority of Learner Postcode Existing Location of the Learner
    L_LLLSC Home LSC of Learner Postcode Existing Location of the Learner
    L_LREG Home Region of Learner Postcode Amended Location of the Learner
    L_LWAR01 Local Authority Ward Code of Learner Postcode (2001 Census) Existing Location of the Learner
    L_LWAR03 Local Authority Ward Code of Learner Postcode (2003 Census) Existing Location of the Learner
    L_LWARD Local Authority Ward Code of Learner Postcode (1991 Census) Existing Location of the Learner
    L_MODE_B Learners mode of attendance Amended Mode of Attendance
    L_NOV Learner active on 1 November in this year Existing Active on Census Date
    L_NVQLEV Notional NVQ Level of Learner Existing Notional NVQ Level
    L_OCT Learner active on 1 October in this year Existing Active on Census Date
    L_OS1200 Learner has more than 1200 Expected Onsite GLH Existing Expected Daytime On-Site Guided Learning Hours
    L_OSEGLH Expected daytime on-site GLH Amended Expected Daytime On-Site Guided Learning Hours
    L_PLA Local Authority based on the Provider postcode Existing Location of the Provider
    L_PLLSC LLSC based on the 1-1 'owner' relationship UPIN to LLSC Existing Location of the Provider
    L_PREG Region of the Owning Provider Amended Location of the Provider
    L_PRIOR_SLN_
    PAYMENT         		Learner Received an SLN or Payment in Previous Year(s) New Prior SLN Payment
    L_PWAR01 Local Authority ward code of the owning provider postcode (2001 census) Existing Location of the Provider
    L_PWAR03 Local Authority ward code of the owning provider postcode (2003 census) Existing Location of the Provider
    L_PWARD Local Authority ward code of the owning provider postcode (1991 census) Existing Location of the Provider
    L_SFL Learner Counts Towards Skills For Life Target Existing Skills for Life Flags
    L_SFL_LEITCH_LIT Leitch Skills For Life Literacy Learner New Skills for Life (SFL) LEITCH Literacy
    L_SFL_LEITCH_LIT_
    ACH         		Leitch Skills For Life Literacy Achiever New Skills for Life (SFL) LEITCH Literacy Achievers
    L_SFL_LEITCH_NUM Leitch Skills For Life Numeracy Learner New Skills for Life (SFL) LEITCH Numeracy
    L_SFL_LEITCH_NUM_
    ACH         		Leitch Skills For Life Numeracy Achiever New Skills for Life (SFL) LEITCH Numeracy Achievers
    L_TO_DATE_SLN_
    PAYMENT         		Learner generated SLN or received a Payment in Previous Years or In this Year New To Date SLN Payment
    L_TTGAIN Train to Gain Learner Amended Train to Gain
    L_UPLF67 0607 Widening Participation Uplift Factor Based on Learner Postcode Existing Widening Participation Uplift Factors
    L_UPLF78 0708 Widening Participation Uplift Factor Based on Learner Postcode Existing Widening Participation Uplift Factors
    L_UPLF89 0809 Widening Participation Uplift Factor Based on Learner Postcode New Widening Participation Uplift Factors
    L25_REG Region of the Funding LSC New Region of the Funding LSC
    P_ACTIVE Programme Active New Active
    P_AVIL Learner average in learning at Programme Level New Learner average in learning at Programme Level
    P_AVILY2D Learner average in learning at Programme Level year to date New Learner average in learning at Programme Level
    P_IL_IY Programme in learning in Year New In Learning in Year
    P_IY_SLN_PAYMENT Programme Generates SLN or receives and In Year Payment up to the current period New In Year SLN Payment
    P_NVQ_ACH_DATE Achievement of NVQ New Programme Achievement of NVQs
    P_PRIOR_SLN_
    PAYMENT         		Programme generated SLN or received a Payment Prior to this Year New Prior SLN Payment
    P_PROG_STATUS Status of NVQ Framework New Programme Status
    PERIOD Collection Period Data Contains Existing Period Data
    P_TO_DATE_SLN_
    PAYMENT         		Programme generated SLN or received a Payment in Previous Years or In this Year New To Date SLN Payment
    TOTACT (temporary variable) The Actual number of days for the aim New Attendance
    TOTEXP (temporary variable) The Expected number of days for the aim New Attendance

    Date last modfied: 3rd March 2009