Index of Derived Variables 2011/2012

INTRODUCTION

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

Please note:   

  •    For 2011/12  a number of variables particularly those relating to funding are calculated when the dataset are produced and are not present in OLDC or LIS although the source data used to derive them is the below table indicates where the variables are derived                                                                                                                         

                                                                                                                                                                                                                                                                                                                                                                          

Jump to: [Aim Level] [Learner Level] [Programme Level]
Derived Variable Derived Variable Description Data Definition LIS/OLDC  Datasets 
A_ACTIVE Aim Active for the current academic year Active Yes Yes
A_ACH_PAYMENT_EFY Achievement Payment Expected for Full Year. ER Achievement Funding Data Definition Yes
A_ACH_PAYMENT_ACM1 to A_ACH_PAYMENT_ACM12

Achievement Payment in academic month 1
to
Achievement Payment in acedemic month 12.

ER Achievement Funding Data Definition Yes
A_ACH_PAYMENT_Y2D Achievement Payment for year to date. ER Achievement Funding Data Definition Yes
A_AGEST Age of the learner as at the start date of aim Age Yes Yes
A_AGESTB Age of the learner as at the start date of aim banded Age Yes Yes
A_AGESTBAND Age of the learner as at the start date of aim banded as 16-18 and 19+ Age Yes Yes
A_ALS_PAYMENT_EFY Additional Learner Support Payment Expected for Full Year. ALS payment data defination Yes
A_ALS_PAYMENT_ACM1 to A_ALS_PAYMENT_ACM12

Additional Learner Support payment in academic month 1; to

Additional Learner Support payment in academic month 12.
ALS payment data defination Yes
A_ALS_PAYMENT_Y2D Additional Learner Support payment for year to date. ALS payment data defination Yes
A_ATYPE Type of aim Aim type Yes Yes
A_BAL_PAYMENT_EFY Balance Payment Expected for Full Year. ER Balancing payment data definition Yes
A_BAL_PAYMENT_ACM1 to A_BAL_PAYMENT_ACM12

Balance Payment in academic month 1

to

Balance Payment in academic month 12.
ER Balancing payment data definition Yes
A_BAL_PAYMENT_Y2D Balance Payment for year to date. ER Balancing payment data definition Yes
A_CARRYIN Carry in aim Carry in Yes Yes
A_CONTRACTING_ORG_SRG Sub-regional grouping of the contracting organisation Sub-regional grouping of the contracting organisation Only in OLDC Yes
A_DAGLH Delivery-Adjusted Guided Learning Hours Delivery-Adjusted Guided Learning Hours Yes Yes
A_DP_SRG Aim-level Sub-Regional Grouping of delivery provider’s postcode Geographic Variables Only in OLDC Yes
A_FE_PROVMIX_MATRIX  FE provision mix matrix Provision Mix Matrix Yes Yes
A_FE_PROVMIX_MATRIX_SUMM  Provision Mix Matrix Summary Provision Mix Matrix Summary Yes Yes
A_AGENCY_FUNDING The agency which funds the learning aim Funding Agency Yes
A_FUNDINGSOURCE Source of funding for the aim Funding Sources Yes Yes
A_IL_IY Aim in learning in Year In Learning in Year Yes Yes
A_IL_ACM1 to A_IL_ACM12 In Learning in academic month 1-12 In Learning Yes
A_INYR_ACTUAL_GLH  Aim Actual current year GLH Current year Guided Learning Hours (CYGLH) Yes Yes
A_INYR_EXPECTED_
GLH 
Aim Expected current year GLH Current year Guided Learning Hours (CYGLH) Yes Yes
A_IY_SLN_PAYMENT Does the Aim generate SLN or receive an In Year Payment, up to the current period In Year SLN Payment Data Definition Yes
A_IY_QUALIFYING_SLN_PERIOD  Aim Passes In Year Qualifying Period to be Eligible to Generate SLN In Year Qualifying SLN Period Yes
A_JAN Aim active on 1 January in this year Active on Census Date Yes Yes
A_L2WID Level 2 Width For Full Level 2 Aims Aim Contribution to Full level 2 and Full level 3 Yes Yes
A_L3WID Level 3 Width For Full Level 3 Aims Aim Contribution to Full level 2 and Full level 3 Yes Yes
A_LARGE_EMP Large Employer Flags at Aim Level Large Employer Flags Yes Yes
A_LEAVEP/A_LEAVE_ACM Period/Academic month of leaving Leave Period Yes Yes
A_NOTIONLEV Notional NVQ Level of the Aim Notional NVQ Level Yes Yes
A_NOV Aim active on 1 November in this year Active on Census Date Yes Yes
A_OCT Aim active on 1 October in this year Active on Census Date Yes Yes
A_OP_PAYMENT_EFY On Programme Payment Expected for Full Year. On-programme funding data definition Yes
A_OP_PAYMENT_ACM1 to A_OP_PAYMENT_ACM12

On Programme Payment in academic month 1
to
A_OP_PAYMENT_P12 On Programme Payment in academic month 12.

On-programme funding data definition Yes
A_OP_PAYMENT_Y2D On Programme Payment for year to date. On-programme funding data definition Yes
A_OPROV Aim other provision Other Provision Flag Yes Yes
A_PRIOR_SLN_PAYMENT  Has the Aim generated SLN or received a Payment in Previous Years Prior SLN Payment Yes Yes
A_ProgLedApp Aim is Programme led Apprenticeship Programme led Apprenticeship Yes Yes
A_QCF Qualifications and Credit Framework Aim Qualifications and Credit Framework Yes Yes
A_SFL   Counts Towards Skills For Life Target Skills for Life Flags Yes Yes
A_SFLP Skills For Life Participation Skills for Life Participation  Yes Yes
A_SFLTY Skills For Life Type Skills for Life Type Yes Yes
A_SSA_T1 LAD SSA Tier 1 Code Sector Subject Areas Yes
A_SSA_T2 LAD SSA Tier 2 Code Sector Subject Areas Yes
A_STARTP/A_START_ACM Acdemic month/Period started in Start Period  Yes Yes
A_TO_DATE_SLN_PAYMENT  Aim generated SLN or received a Payment in Previous Years or in this Year To Date SLN Payment Yes
A_TOTAL_PAYMENT_EFY Payment Expected for Full Year. Total Funding Data Definition Yes

A_TOTAL_PAYMENT_ACM1 to A_TOTAL_PAYMENT_ACM12

 

Payment in academic month 1
to
Payment in academic month 12.

Total Funding Data Definition Yes
A_TOTAL_PAYMENT_Y2D Payment year to date. Total Funding Data Definition Yes
A_AIM_SLN_EFY SLN Expected for Full Year. Total Funding Data Definition Yes

A_AIM_SLN_ACM1 to A_AIM_SLN_ACM12

 

SLN in academic month 1
to
SLN in academic month 12.

Total Funding Data Definition Yes
A_AIM_SLN_Y2D SLN year to date. Total Funding Data Definition Yes
L_3RD_SECTOR Third sector flag at learner level Third sector flag Only in OLDC Yes
L_ACH_PAYMENT_EFY Achievement Payment Expected for Full Year for all aims of the learner. ER Achievement Funding Data Definition Yes
L_ACH_PAYMENT_ACM1 to L_ACH_PAYMENT_ACM12

Sum of Achievement Payments in academic month 1 for all aims of the learner
to
Sum of Achievement Payments in academic month 12 for all aims of the learner.

ER Achievement Funding Data Definition Yes
L_ACH_PAYMENT_Y2D Sum of Achievement Payment for year to date for all aims of the learner. ER Achievement Funding Data Definition Yes
L_ACTIVE Learner Active for the current academic year Active Yes Yes
L_ADDSUP Eligible for learner support Eligible for Additional Learner Support Yes Yes
L_AGE Age of learner as at 31 August Age Yes Yes
L_AGEB Age of learner as at 31 August banded Age Yes Yes
L_AGENCY The agency which funds the learner Funding Agency Yes
L_ALS_PAYMENT_EFY Sum of Additional Learner Support Payments Expected for Full Year, for all aims of the learner. ALS payment data definition Yes
L_ALS_PAYMENT_ACM1 to L_ALS_PAYMENT_ACM12

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

Sum of Additional Learner Support payments in academic month 12 for all aims of the learner.
ALS payment data definition Yes
L_ALS_PAYMENT_Y2D Sum of Additional Learner Support payments in year to date for all aims of the learner. ALS payment data definition Yes
L_ATYPE In Year Aim Type for a Learner Aim Type Yes Yes
L_BAL_PAYMENT_EFY Sum of Balance Payment Expected for Full Year for all aims of the learner. ER Balancing payment data definition Yes
L_BAL_PAYMENT_ACM1 to L_BAL_PAYMENT_ACM12

Sum of Balance Payments in academic month 1 for all aims of the learner
to
Sum of Balance Payments in academic month 12 for all aims of the learner.

ER Balancing payment data definition Yes
L_BAL_PAYMENT_Y2D Sum of Balance Payment for year to date for all aims of the learner. ER Balancing payment data definition Yes
L_DISADV Learner Disadvantaged Disadvantaged Learner Yes Yes
L_FIRST_FULLLEVEL2 First Full Level 2 Learner First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Yes Yes
L_FIRST_FULLLEVEL2_ACHIEVE  First Full Level 2 Achievement Learner First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Yes Yes
L_FIRST_FULLLEVEL3 First Full Level 3 Learner First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Yes Yes
L_FIRST_FULLLEVEL3_ACHIEVE  First Full Level 3 Achievement Learner First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Yes Yes
L_FULLLEVEL2 Full Level 2 Learner Full Level 2 and 3 Yes Yes
L_FULLLEVEL2_ACHIEVE  Full Level 2 Achievement Learner Full Level 2 and 3 Achievement Yes Yes
L_FULLLEVEL3 Full Level 3 Learner Full Level 2 and 3 Yes Yes
L_FULLLEVEL3_ACHIEVE Full Level 3 Achievement Learner Full Level 2 and 3 Achievement Yes Yes
L_FUNDINGSOURCE Sources of funding for the learner Funding Sources Yes Yes
L_IL_IY Learner in learning in Year In Learning in Year Yes Yes
L_IL_ACM1 to L_IL_ACM12  Learner In-Learning academic month 1-12 Learner Level in Learning Yes
L_INYR_ACTUAL_GLH Actual In Year GLH Current Year Guided Learning Hours (CYGLH) Yes Yes
L_INYR_EXPECTED_GLH  Expected In Year GLH Current Year Guided Learning Hours (CYGLH) Yes Yes
L_IY_SLN_PAYMENT Learner Received SLN or Payment This Year To Date In Year SLN Payment Yes
L_JAN Learner active on 1 January in this year Active on Census Date Yes Yes
L_LARGE_EMP Large Employer Flags at Learner Level Large Employer Flag Yes Yes
L_MODE_B Learners mode of attendance Mode of Attendance Yes
L_NOTIONLEV Notional NVQ Level of Learner Notional NVQ Level Yes Yes
L_NOV Learner active on 1 November in this year Active on Census Date Yes Yes
L_OCT Learner active on 1 October in this year Active on Census Date Yes Yes
L_OP_PAYMENT_EFY Sum of On Programme Payment Expected for Full Year for all aims of the learner. On-programme Funding Data Definition Yes
L_OP_PAYMENT_ACM1 to L_OP_PAYMENT_ACM12

Sum of On Programme Payments in academic month1 for all aims of the learner
to
Sum of On Programme Payments in academic month 12 for all aims of the learner.

On-programme Funding Data Definition Yes
L_OP_PAYMENT_Y2D Sum of On Programme Payment for year to date for all aims of the learner. On-programme Funding Data Definition Yes
L_OSEGLH Expected daytime on-site GLH Expected Daytime On-Site Guided Learning Hours Yes Yes
L_PRIOR_SLN_PAYMENT  Learner Received an SLN or Payment in Previous Year(s) Prior SLN Payment Yes Yes
L_ProgLedApp Learner is undertaking a programme led apprenticeship Programme led Apprenticeship Yes Yes
L_QCF Qualifications and Credit Framework Learner Qualifications and Credit Framework Yes Yes
L_SFA_FUNDING Type of Skills Funding Agency Funding Funding Agency Yes
L_SFL Learner Counts Towards Skills For Life Target Skills for Life Flags Yes Yes
L_TO_DATE_SLN_PAYMENT  Learner generated SLN or received a Payment in Previous Years or In this Year To Date SLN Payment Yes
L_TOTAL_PAYMENT_EFY Payment Expected for Full Year. Total Funding Data Definition Yes

L_TOTAL_PAYMENT_ACM1 to L_TOTAL_PAYMENT_ACM12

 

Payment in academic month 1
to
Payment in academic month 12.

Total Funding Data Definition Yes
L_TOTAL_PAYMENT_Y2D Payment year to date. Total Funding Data Definition Yes
L_AIM_SLN_EFY SLN Expected for Full Year. Total Funding Data Definition Yes

L_AIM_SLN_ACM1 to L_AIM_SLN_ACM12

 

SLN in academic month 1
to
SLN in academic month 12.

Total Funding Data Definition Yes
L_AIM_SLN_Y2D SLN year to date. Total Funding Data Definition Yes
L_UPLF1112 11/12 Widening Participation Uplift Factor Based on Learner Postcode Widening Participation Uplift Factors Yes
L_YPLA_FUNDING Type of YPLA funding Funding Agency Yes
P_ACTIVE Programme Active Active Yes Yes
P_IL_IY Programme in learning in Year In Learning in Year Yes Yes
P_IY_SLN_PAYMENT Programme Generates SLN or receives and In Year Payment up to the current period In Year SLN Payment Yes
P_NVQ_ACH_DATE Achievement of NVQ Programme Achievement of NVQs Yes
P_PRIOR_SLN_PAYMENT  Programme generated SLN or received a Payment Prior to this Year Prior SLN Payment Yes Yes
P_ProgLedApp Programme is a programme led apprenticeship Programme led Apprenticeship Yes Yes
P_PROG_STATUS Status of NVQ Framework Programme Status Yes
P_TO_DATE_SLN_PAYMENT  Programme generated SLN or received a Payment in Previous Years or In this Year To Date SLN Payment Yes
TOTACT (temporary variable) The Actual number of days for the aim Attendance No No
TOTEXP (temporary variable) The Expected number of days for the aim Attendance No No



Date last modfied: 21st October 2011