Index of Derived Variables 2009/2010

INTRODUCTION

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

Please note:

  • Variables new for 2009/2010 are marked 'New'.
  • Variables that remain unchanged are marked 'Existing'.
  • Variables that existed in previous years but have been altered for 2009/2010 are marked 'Amended'.
  • Variables that have been deleted for 2009/2010 that are sourced for the definition of existing variables, have been either replaced by new variables carrying out a similar function or have been removed entirely. The existing variables affected by this change have been marked as 'Amended' for 2009/2010.
  • Variables that have been deleted are not included in this list, but are still available via the Index of Derived Variables 2008/2009.

 

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

Derived Variable Derived Variable Description Status Data Definition
A_ACTIVE Aim Active for the current academic year Existing Active
A_ACH_PAYMENT_EFY Achievement Payment Expected for Full Year. New ER Achievement Funding Data Definition
A_ACH_PAYMENT_P1 to A_ACH_PAYMENT_P12

Achievement Payment in period 1

to

Achievement Payment in period 12.		 Defined ER Achievement Funding Data Definition
A_ACH_PAYMENT_Y2D Achievement Payment for year to date. Defined ER Achievement Funding Data Definition
A_ACH_SLN_EFY Achievement SLN Expected for Full Year. New ER Achievement Funding Data Definition
A_ACH_SLN_P1 to A_ACH_SLN_P12

Achievement SLN in period 1

to

Achievement SLN in period 12		 Defined ER Achievement Funding Data Definition
A_ACH_SLN_Y2D Achievement SLN for year to date. Defined ER Achievement Funding Data Definition
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+ Existing Age
A_ALS_PAYMENT_EFY Additional Learner Support Payment Expected for Full Year. New ALS payment data defination
A_ALS_PAYMENT_P1 to A_ALS_PAYMENT_P12

Additional Learner Support payment in period 1; to

Additional Learner Support payment in period 12.		 Defined ALS payment data defination
A_ALS_PAYMENT_Y2D Additional Learner Support payment for year to date. Defined ALS payment data defination
A_ATYPE Type of aim Amended Aim type
A_BAL_PAYMENT_EFY Balance Payment Expected for Full Year. New ER Balancing payment data definition
A_BAL_PAYMENT_P1 to A_BAL_PAYMENT_P12

Balance Payment in period 1

to

Balance Payment in period 12.		 Defined ER Balancing payment data definition
A_BAL_PAYMENT_Y2D Balance Payment for year to date. Defined ER Balancing payment data definition
A_ BAL _SLN_EFY Balance SLN Expected for Full Year. New ER Balancing payment data definition

A_BAL_SLN_P1 to
A_ BAL _SLN_P12

 

Balance SLN in period 1

to

Balance SLN in period 12		 Defined ER Balancing payment data definition
A_ BAL _SLN_Y2D Balance SLN for year to date. Defined ER Balancing payment data definition
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 Existing 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_E2E_BONUS_SLN_EFY E2E Bonus SLN Expected for Full Year. New Learner Responsive E2E Funding Data Definition
A_E2E_BONUS_SLN_P1 to A_E2E_BONUS_SLN_P12

E2E Bonus SLN in period 1

to

E2E Bonus SLN in period 12.		 Defined Learner Responsive E2E Funding Data Definition
A_E2E_BONUS_SLN_Y2D E2E Bonus SLN for year to date. Defined Learner Responsive E2E Funding Data Definition
A_E2E_PROG _SLN_EFY E2E Programme SLN Expected for Full Year. New Learner Responsive E2E Funding Data Definition

A_E2E_PROG_SLN_P1 to
A_E2E_PROG _SLN_P12

 

E2E Programme SLN in period 1

to

E2E Programme SLN in period 12		 Defined Learner Responsive E2E Funding Data Definition
A_E2E_PROG _SLN_Y2D E2E Programme SLN for year to date. Defined Learner Responsive E2E Funding Data Definition
A_FE_PROVMIX_
MATRIX 		 FE provision mix matrix Existing  Provision Mix Matrix
A_FE_PROVMIX_
MATRIX_SUMM 		 Provision Mix Matrix Summary Existing  Provision Mix Matrix Summary
A_FRANCH Franchised Aim Existing Franchised Aim
A_FULLY_FUNDED Aim Fully Funded Defined Fully Funded
A_FUNDED_AGE_BAND Age Band Used in DLF Funding Calc Defined Age
A_FUNDINGSOURCE Source of funding for the aim New Funding Sources
A_IL_IY Aim in learning in Year Existing In Learning in Year
A_IL_P1 to A_IL_P12 In Learning in Period 1-12 Existing  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 Existing Current year Guided Learning Hours (CYGLH)
A_INYR_EXPECTED_
GLH 		 Aim Expected current year GLH Existing 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 Existing In Year SLN Payment Data Definition
A_IY_QUALIFYING_
SLN_PERIOD 		 Aim Passes In Year Qualifying Period to be Eligible to Generate SLN Defined 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 Existing  Leave Period
A_NOTIONLEV Notional NVQ Level of the Aim New Notional NVQ Level
A_NOV Aim active on 1 November in this year Existing Active on Census Date
A_OCT Aim active on 1 October in this year Existing Active on Census Date
A_OP_PAYMENT_EFY On Programme Payment Expected for Full Year. New On-programme funding data definition
A_OP_PAYMENT_P1 to A_OP_PAYMENT_P12

On Programme Payment in period 1

to

A_OP_PAYMENT_P12 On Programme Payment in period 12.		 Defined On-programme funding data definition
A_OP_PAYMENT_Y2D On Programme Payment for year to date. Defined On-programme funding data definition
A_OP_SLN_EFY On Programme SLN Expected for Year. New On-programme funding data definition

A_OP_SLN_P1 to A_OP_SLN_P12

 

On Programme SLN in period 1

to

A_OP_SLN_P12 On Programme SLN in period 12		 Defined On-programme funding data definition
A_OP_SLN_Y2D On Programme SLN for year to date. Defined On-programme funding data definition
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 Existing Prior SLN Payment
A_QCF Qualifications and Credit Framework Aim New Qualifications and Credit Framework
A_SFL   Counts Towards Skills For Life Target Amended Skills for Life Flags
A_SFL_LEITCH_LIT Leitch Skills For Life Literacy aim Existing Skills for Life (SFL) LEITCH Literacy
A_SFL_LEITCH_LIT_
ACH 		 Leitch Skills For Life Literacy Achiever Existing Skills for Life (SFL) LEITCH Literacy Achievers
A_SFL_LEITCH_NUM Leitch Skills For Life Numeracy Aim Existing Skills for Life (SFL) LEITCH Numeracy
A_SFL_LEITCH_NUM_
ACH 		 Leitch Skills For Life Numeracy Achiever Existing Skills for Life (SFL) LEITCH Numeracy Achievers
A_SFLP Skills For Life Participation Amended Skills for Life Participation 
A_SFLTY Skills For Life Type Amended Skills for Life Type
A_SLN_PAYMENT_EFY Any SLN or payments expected for full year. New SLN payment
A_SLN_PAYMENT_P1 to A_SLN_PAYMENT_P12

Any SLN or payments in period 1 to Any SLN or payments in period 12.

 Defined SLN payment
A_SSA_T1 LAD SSA Tier 1 Code Amended Sector Subject Areas
A_SSA_T2 LAD SSA Tier 2 Code Amended Sector Subject Areas
A_STARTP Period started in Existing  Start Period 
A_TODATE_QUALIFYING_
SLN_PAYMENT 		 Aim Passes the Qualifying Period in Any Year to be Eligible to Generate SLN Existing To Date Qualifying SLN Payment
A_TO_DATE_SLN_
PAYMENT 		 Aim generated SLN or received a Payment in Previous Years or in this Year Existing To Date SLN Payment
A_TOTAL_PAYMENT_EFY Payment Expected for Full Year. New Total Funding Data Definition

A_TOTAL_PAYMENT_P1 to
A_TOTAL_PAYMENT_P12

 

Payment in period 1
to
Payment in period 12.

 Defined Total Funding Data Definition
A_TOTAL_PAYMENT_Y2D Payment year to date. Defined Total Funding Data Definition
A_TOTAL_SLN_EFY SLN Expected for Full Year. New Total Funding Data Definition

A_TOTAL_SLN_P1 to
A_TOTAL_SLN_P12

 

SLN in period 1
to
SLN in period 12.

 Defined Total Funding Data Definition
A_TOTAL_SLN_Y2D SLN year to date. Defined Total Funding Data Definition
A_TTGAIN Train to Gain Aim Amended Train to Gain
A_TTGBROKE Train to Gain Brokerage Existing  Train to Gain
L_A23 Learner Level Delivery Location Postcode  Amended Learner Level Delivery Location Postcode
L_ACH_PAYMENT_EFY Achievement Payment Expected for Full Year for all aims of the learner. New ER Achievement Funding Data Definition
L_ACH_PAYMENT_P1 to L_ACH_PAYMENT_P12

Sum of Achievement Payments in period 1 for all aims of the learner

to

Sum of Achievement Payments in period 12 for all aims of the learner.		 Defined ER Achievement Funding Data Definition
L_ACH_PAYMENT_Y2D Sum of Achievement Payment for year to date for all aims of the learner. Defined ER Achievement Funding Data Definition
L_ACH_SLN_EFY Achievement SLN Expected for Full Year for all aims of the learner. New ER Achievement Funding Data Definition
L_ACH_SLN_P1 to L_ACH_SLN_P12

Sum of Achievement SLN in period 1 for all aims of the learner

to

Sum of Achievement SLN in period 12 for all aims of the learner.		 Defined ER Achievement Funding Data Definition
L_ACH_SLN_Y2D Sum of Achievement SLN for year to date for all aims of the learner. Defined ER Achievement Funding Data Definition
L_ACTIVE Learner Active for the current academic year Existing Active
L_ADDSUP Eligible for learner support Existing 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 Existing Age
L_ALS_PAYMENT_EFY Sum of Additional Learner Support Payments Expected for Full Year, for all aims of the learner. New ALS payment data definition
L_ALS_PAYMENT_P1 to L_ALS_PAYMENT_P12

Sum of Additional Learner Support payments in period 1 for all aims of the learner; to

Sum of Additional Learner Support payments in period 12 for all aims of the learner.		 Defined ALS payment data definition
L_ALS_PAYMENT_Y2D Sum of Additional Learner Support payments in year to date for all aims of the learner. Defined ALS payment data definition
L_ATYPE In Year Aim Type for a Learner Amended Aim Type
L_BAL_PAYMENT_EFY Sum of Balance Payment Expected for Full Year for all aims of the learner. New ER Balancing payment data definition
L_ BAL _PAYMENT_P1 to L_ BAL _PAYMENT_P12

Sum of Balance Payments in period 1 for all aims of the learner

to

Sum of Balance Payments in period 12 for all aims of the learner.		 Defined ER Balancing payment data definition
L_BAL_PAYMENT_Y2D Sum of Balance Payment for year to date for all aims of the learner. Defined ER Balancing payment data definition
L_BAL_SLN_EFY Sum of Balance SLN Expected for Full Year for all aims of the learner. New ER Balancing payment data definition

L_BAL_SLN_P1 to
L_BAL_SLN_P12

 

Sum of Balance SLN in period 1 for all aims of the learner

to

Sum of Balance SLN in period 12 for all aims of the learner.		 Defined ER Balancing payment data definition
L_BAL_SLN_Y2D Sum of Balance SLN for year to date for all aims of the learner. Defined ER Balancing payment data definition
L_DISADV Learner Disadvantaged Existing Disadvantaged Learner
L_DPLA Local Authority based on the Delivery Location Postcode Amended Location of the Delivery Provider (Learner Level)
L_DPLLSC LLSC of the Delivery Location Postcode Amended 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) Amended Location of the Delivery Provider (Learner Level)
L_DPWA03 Local Authority ward code of the Learner Delivery Location (2003 census) Amended Location of the Delivery Provider (Learner Level)
L_DPWARD Local Authority Ward of the Delivery Location Postcode (1991 census) Amended Location of the Delivery Provider (Learner Level)
L_E2E_BONUS_SLN_EFY Sum of E2E Bonus SLN Expected for Full Year for all aims of the learner. New Learner Responsive E2E Funding Data Definition
L_E2E_BONUS_SLN_P1 to L_E2E_BONUS_SLN_P12

Sum of E2E Bonus SLNs in period 1 for all aims of the learner

to

Sum of E2E Bonus SLNs in period 12 for all aims of the learner.

 Defined Learner Responsive E2E Funding Data Definition
L_E2E_BONUS_SLN_Y2D Sum of E2E Bonus SLN for year to date for all aims of the learner. Defined Learner Responsive E2E Funding Data Definition
L_E2E_PROG_SLN_EFY Sum of E2E Programme SLN Expected for Full Year for all aims of the learner. New Learner Responsive E2E Funding Data Definition

L_E2E_PROG_SLN_P1 to L_E2E_PROG_SLN_P12

 

Sum of E2E Programme SLN in period 1 for all aims of the learner

to

Sum of E2E Programme SLN in period 12 for all aims of the learner.		 Defined Learner Responsive E2E Funding Data Definition
L_E2E_PROG_SLN_Y2D Sum of E2E Programme SLN for year to date for all aims of the learner. Defined Learner Responsive E2E Funding Data Definition
L_FIRST_FULLLEVEL2 First Full Level 2 Learner Existing  First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
L_FIRST_FULLLEVEL2_
ACHIEVE 		 First Full Level 2 Achievement Learner Existing  First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
L_FIRST_FULLLEVEL3 First Full Level 3 Learner Existing  First Full Level 2 and 3 and First Full Level 2 and 3 Achievement
L_FIRST_FULLLEVEL3_
ACHIEVE 		 First Full Level 3 Achievement Learner Existing  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. Existing  Full Time Equivalent
L_FULLLEVEL2 Full Level 2 Learner Existing  Full Level 2 and 3
L_FULLLEVEL2_
ACHIEVE 		 Full Level 2 Achievement Learner Existing Full Level 2 and 3 Achievement
L_FULLLEVEL2_
COMPLETE 		 Full Level 2 Completion Learner Existing Full Level 2 and 3 Completion
L_FULLLEVEL3 Full Level 3 Learner Existing Full Level 2 and 3
L_FULLLEVEL3_
ACHIEVE 		Full Level 3 Achievement Learner Existing Full Level 2 and 3 Achievement
L_FULLLEVEL3_
COMPLETE 		 Full Level 3 Completion Learner Existing Full Level 2 and 3 Completion
L_FUND Sources of funding for the learner Amended Sources of Funding
L_FUNDINGSOURCE Sources of funding for the learner New Funding Sources
L_IL_IY Learner in learning in Year Existing In Learning in Year
L_IL_P1 to L_IL_P12  Learner In-Learning Period X Existing  Learner Level in Learning
L_INYR_ACTUAL_
GLH 		 Actual In Year GLH Existing Current Year Guided Learning Hours (CYGLH)
L_INYR_EXPECTED_
GLH 		 Expected In Year GLH Existing Current Year Guided Learning Hours (CYGLH)
L_IY_SLN_PAYMENT Learner Received SLN or Payment This Year To Date Existing 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 Amended Location of the Learner
L_LLLSC Home LSC of Learner Postcode Amended 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) Amended Location of the Learner
L_LWAR03 Local Authority Ward Code of Learner Postcode (2003 Census) Amended Location of the Learner
L_LWARD Local Authority Ward Code of Learner Postcode (1991 Census) Amended Location of the Learner
L_MODE_B Learners mode of attendance Existing  Mode of Attendance
L_NOTIONLEV Notional NVQ Level of Learner New Notional NVQ Level
L_NOV Learner active on 1 November in this year Existing Active on Census Date
L_OCT Learner active on 1 October in this year Existing Active on Census Date
L_OP_PAYMENT_EFY Sum of On Programme Payment Expected for Full Year for all aims of the learner. New On-programme Funding Data Definition
L_OP_PAYMENT_P1 to L_OP_PAYMENT_P12

Sum of On Programme Payments in period 1 for all aims of the learner
to
Sum of On Programme Payments in period 12 for all aims of the learner.

 Defined On-programme Funding Data Definition
L_OP_PAYMENT_Y2D Sum of On Programme Payment for year to date for all aims of the learner. Defined On-programme Funding Data Definition
L_OP_SLN_EFY Sum of On Programme SLN Expected for Full Year for all aims of the learner. New On-programme Funding Data Definition

L_OP_SLN_P1 to
L_OP_SLN_P12

 

Sum of On Programme SLN in period 1 for all aims of the learner
to
On Programme SLN in period 12 for all aims of the learner.

 Defined On-programme Funding Data Definition
L_OP_SLN_Y2D Sum of On Programme SLN for year to date for all aims of the learner. Defined On-programme Funding Data Definition
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 Existing  Expected Daytime On-Site Guided Learning Hours
L_PLA Local Authority based on the Provider postcode Amended Location of the Provider
L_PLLSC LLSC based on the 1-1 'owner' relationship UPIN to LLSC Amended 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) Existing Prior SLN Payment
L_PWAR01 Local Authority ward code of the owning provider postcode (2001 census) Amended Location of the Provider
L_PWAR03 Local Authority ward code of the owning provider postcode (2003 census) Amended Location of the Provider
L_PWARD Local Authority ward code of the owning provider postcode (1991 census) Amended Location of the Provider
L_QCF Qualifications and Credit Framework Learner New Qualifications and Credit Framework
L_SFL Learner Counts Towards Skills For Life Target Amended Skills for Life Flags
L_SFL_LEITCH_LIT Leitch Skills For Life Literacy Learner Existing Skills for Life (SFL) LEITCH Literacy
L_SFL_LEITCH_LIT_
ACH 		 Leitch Skills For Life Literacy Achiever Existing Skills for Life (SFL) LEITCH Literacy Achievers
L_SFL_LEITCH_NUM Leitch Skills For Life Numeracy Learner Existing Skills for Life (SFL) LEITCH Numeracy
L_SFL_LEITCH_NUM_
ACH 		 Leitch Skills For Life Numeracy Achiever Existing Skills for Life (SFL) LEITCH Numeracy Achievers
L_SLN_PAYMENT_EFY Any SLN or payments expected for full year for all aims of the learner. New SLN payment
L_SLN_PAYMENT_P1 to L_SLN_PAYMENT_P12 Any SLN or payments in period 1 for all aims of the learner, to Any SLN or payments in period 12 for all aims of the learner. Defined SLN payment
L_TO_DATE_SLN_
PAYMENT 		 Learner generated SLN or received a Payment in Previous Years or In this Year Existing To Date SLN Payment
L_TOTAL_PAYMENT_EFY Payment Expected for Full Year. New Total Funding Data Definition

L_TOTAL_PAYMENT_P1 to
L_TOTAL_PAYMENT_P12

 

Payment in period 1
to
Payment in period 12.

 Defined Total Funding Data Definition
L_TOTAL_PAYMENT_Y2D Payment year to date. Defined Total Funding Data Definition
L_TOTAL_SLN_EFY SLN Expected for Full Year. New Total Funding Data Definition

L_TOTAL_SLN_P1 to
L_TOTAL_SLN_P12

 

SLN in period 1
to
SLN in period 12.

 Defined Total Funding Data Definition
L_TOTAL_SLN_Y2D SLN year to date. Defined Total Funding Data Definition
L_TTGAIN Train to Gain Learner Amended Train to Gain
L_UPLF0910 09/10 Widening Participation Uplift Factor Based on Learner Postcode New 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 Existing Widening Participation Uplift Factors
L25_REG Region of the Funding LSC Existing Region of the Funding LSC
P_ACTIVE Programme Active Existing Active
P_AVIL Learner average in learning at Programme Level Existing Learner average in learning at Programme Level
P_AVILY2D Learner average in learning at Programme Level year to date Existing Learner average in learning at Programme Level
P_IL_IY Programme in learning in Year Existing In Learning in Year
P_IY_SLN_PAYMENT Programme Generates SLN or receives and In Year Payment up to the current period Existing In Year SLN Payment
P_NVQ_ACH_DATE Achievement of NVQ Existing Programme Achievement of NVQs
P_PRIOR_SLN_
PAYMENT 		 Programme generated SLN or received a Payment Prior to this Year Existing Prior SLN Payment
P_PROG_STATUS Status of NVQ Framework Existing 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 Existing To Date SLN Payment
TOTACT (temporary variable) The Actual number of days for the aim Existing Attendance
TOTEXP (temporary variable) The Expected number of days for the aim Existing Attendance


Date last modfied: 23rd July 2009