Log of Amendments to Derived Variables 2008/2009

INTRODUCTION

The following table details the changes made to all derived variables for 2008/2009, including the status of the variable at the start of the period, followed by the dates and details of any further amendments made during the course of the year.

To view the data definition of the variable, click on the variable name. Deleted variables are linked to the relevant data definition in the Previous Years section. All variables still in use are linked to the current version of the definition, held in the 2008/2009 Data Dictionary.

GLOBAL AMENDMENTS

The following amendments have been applied to all relevent derived variables.
21/1/09 - Amended to reflect changes in the handling of missing data.

			Details of any further amendments made:
Derived Variable	08/09 Status	Reason for Status	Date of amend-ment	Amend-ment Made	Reason for Amend-ment
A_15_2	Deleted	Codes used in ILR Field A46 no longer valid.
A_ACHIEVE	Deleted	Standalone NVQs (ILR Field A15) no longer identifiable.
A_ACT_A	Deleted	Census dates no longer applicable. Replaced by new DV
A_ACT_B	Deleted	Census dates no longer applicable. Replaced by new DV
A_ACTIVE	New	Replaces the live definition used in previous years.	10/10/08	Label amended.
A_AGEST	Existing
A_AGESTB	Existing
A_AGESTBAND	New	New age bands.	10/10/08	Label amended.
A_ATYPE	Amended	Amended to include new Aim types in the LAD.
A_DPLA	Existing		10/10/08	Label amended.
A_DPLLSC	Existing		10/10/08	Label amended.
A_DPREG	Amended	Amended to use LLSC of the Delivery Provider	10/10/08	Amendment to label
A_DPREG	Amended	Amended to use LLSC of the Delivery Provider	21/1/09	Amended to include National Apprenticeship Service (NAS)
A_DPWA01	Existing		10/10/08	Label amended.
A_DPWA03	Existing		10/10/08	Label amended.
A_DPWA03	Existing			Changed reference to Ward_03 file to Ward_04.	Correction
A_DPWARD	Existing		10/10/08	Label amended.
A_ESF	Deleted	Census dates no longer applicable.
A_ESFTY	Existing		30/09/08	Addition of syntax in spec
A_EXP_A	Deleted	Census dates no longer applicable.
A_EXP_B	Deleted	Census dates no longer applicable.
A_FE_PROVMIX _MATRIX	Amended	Amended to use ASL provision type field.	30/09/08	Amended to include values 110, 120, 130 and value 998 dropped.
				Change to numeric format
			21/11/08	Syntax amended to reflect system changes to the handling of missing values	Correction
A_FE_PROVMIX _MATRIX _SUMM	Amended	Amended to include Skills for Life categories, exclude entitlement and to cover ASL.	30/09/08	Amended to include values 110, 120, 130 and value 998 dropped.
				Extra step added into table to cover ASL and 999.
				Amendment to label
A_FFA	Existing
A_FRANCH	Existing		10/10/08	Label amended.
A_FULLY _FUNDED	New	Funding requirement	02/10/08	Added
A_FUNDED _AGE_BAND	New	Funding requirement	02/10/08	Added to Age definition
A_IL_IY	New	Funding Requirement	10/10/08	Label amended.
A_IL_P1-P12	Existing		30/09/08	Syntax amended.
A_IL_P1-P12	Existing			Label amended.
A_ILAVY2	Existing
A_ILPY2D	Existing		10/10/08	Label amended.
A_INYR _ACTUAL_GLH	New	Replaces current years guided learning hours DV	30/09/08	year_exp and year_act changed in syntax to match table.
A_INYR _EXPECTED _GLH	New	Replaces current years guided learning hours DV	30/09/08	year_exp and year_act changed in syntax to match table.
			30/10/08	Label amended.
			11/2/09	Label corrected.	Correction
A_IY SLN_ PAYMENT	New	Funding Requirement
A_IY _QUALIFYING _SLN_PERIOD	New	Funding requirement	02/10/08	Added
A_JAN	Existing
A_L2WID	Existing		30/09/08	A_ACTIVE selection removed.	Correction
A_L2WID	Existing			Label amended.
A_L3WID	Existing		30/09/08	A_ACTIVE selection removed.	Correction
A_L3WID	Existing			Label amended.
A_LEAVEP	Amended	New values added for aims that fall outside the 12 months.
A_LEVEL2E	Deleted	Not used
A_LIS_FG	Deleted	Replaced by SLN flag.
A_LIVE_A	Deleted	Already removed.
A_LIVE_B	Deleted	Census dates no longer applicable.
A_NOV	Existing
A_NVQLEV	Amended	Include new Active definition in calculation	21/11/08	Syntax amended to reflect system changes to the handling of missing values	Correction
A_OCT	Existing
A_OPROV	Existing		10/10/08	Label amended.
A_PRIOR_SLN _PAYMENT	New	Funding Requirement
A_PROVMIX	Deleted	No longer applicable.
A_SFL	Amended	Include new Active definition in calculation
A_SFL_LEITCH _LIT	New	Measure new target.	30/09/08	Variables amended to use A_SFL.
				A_ACTIVE selection removed.	Correction.
				Label amended
A_SFL_LEITCH _LIT_ACH	New	Measure new target.	30/09/08	Variables amended to use A_SFL.
				Amended to count active GCSE aims grades D to G and partial key skills at level 1.
				A_ACTIVE selection removed.	Correction.
				Label amended.
A_SFL_LEITCH _NUM	New	Measure new target.	30/09/08	Variables amended to use A_SFL.
				A_ACTIVE selection removed.	Correction.
				Label amended
A_SFL_LEITCH _NUM_ACH	New	Measure new target.	30/09/08	Variables amended to use A_SFL
				amended to count all entry level aims.
				A_ACTIVE selection removed.	Correction.
				Label amended
A_SFLP	Existing		30/09/08	Programme weighting factor determined by collection
A_SFLPAR	Deleted	Replaced in 07/08.
A_SFLTY	Amended	Amended to take account of new codes added in Learning Aims Database for Skills for Life type.
A_SFLTYA	Deleted	Replaced in 07/08.
~~A_SLN~~	~~Deleted~~	~~Replaced by new Derived Variables.~~
A_SSA_T1	Existing		10/10/08	Label amended.
A_SSA_T2	Existing		10/10/08	Label amended.
A_STARTP	Amended	New values for aims that fall outside the 12 period.	30/09/08	Change applied to steps 1 (<) and 2 (>) of table.
A_STATUS	Deleted	Standalone NVQs (ILR Field A15) no longer identifiable.
A_STREAM	Deleted	Funding streams no longer exist.
A_TO_DATE _SLN _PAYMENT	New	Funding Requirement	10/10/08	Label amended
A_TODATE _QUALIFYING _SLN_PERIOD	New	Funding requirement	02/10/08	Added
A_TODATE _QUALIFYING _SLN_PERIOD	New	Funding requirement		Label amended.
A_TTBROKE	Amended	Impacted by change to A_TTGAIN definition.	10/10/08	Amendment to label.
A_TTBROKE	Amended	Impacted by change to A_TTGAIN definition.	20/11/08	Syntax amended to reflect system changes to the handling of missing values	Correction
A_TTGAIN	Amended	Value 1 no longer applicable.	30/09/08	A_ACTIVE selection removed	Correction.
E_IL_P1-12	Existing
E_ILAVY2	Existing
E_ILPY2D	Existing		10/10/08	Label amended.
E_LEAVEP	Amended	New values for aims that fall outside the 12 periods.	30/09/08	Value 99 changed to 50 and steps 1(<) and 2 (>) of table changed.
E_STARTP	Amended	New values for aims that fall outside the 23 periods.	30/09/08	Change applied to steps 1 (<) and 2 (>) of table.
L_A23	Amended	Amended to comply with Demand Led Funding	30/09/08	ER Calculation to be the same as the LR version.
L_A23	Amended	Amended to comply with Demand Led Funding		Label amended.
L_ACT_B	Deleted	Census dates no longer applicable.
L_ACTIVE	New	Replaces the live definition used in previous years.	10/10/08	Label amended
L_ADDSUP	Amended	Amendment to calculation	30/09/08	Changed to be >-170 and >-501 in table and syntax.
L_ADDSUP	Amended	Amendment to calculation		Label amended.
L_AGE	Existing
L_AGEB	Existing
L_AGEBAND	New	New age bands.	10/10/08	Label amended
L_ATYPE	Amended	Amended to include new Aim types in the LAD.	30/09/08	Step removed from table and Syntax, max A_TYPE=10
L_DISADV	Existing		10/10/08	Label amended.
L_DPLA	Existing		10/10/08	Label amended.
L_DPLLSC	Existing		10/10/08	Label amended.
L_DPREG	Amended	Amended to use LLSC of the Delivery Provider	10/10/08	Label amended.
L_DPREG	Amended	Amended to use LLSC of the Delivery Provider	21/1/09	Amended to include National Apprenticeship Service (NAS)
L_DPWA01	Existing		10/10/08	Label amended.
L_DPWA03	Existing		10/10/08	Label amended.
L_DPWA03	Existing			Changed reference to Ward_03 file to Ward_04.	Correction
L_DPWARD	Existing		10/10/08	Label amended.
L_EXP_B	Deleted	Census dates no longer applicable.
L_FFA	Existing
L_FIRST _FULLLEVEL2	Amended	Amended to include Apprenticeships	10/10/08	Label amended.
L_FIRST _FULLLEVEL2 _ACHIEVE	Amended	Amended to include Apprenticeships	10/10/08	Label amended.
L_FIRST _FULLLEVEL3	Amended	Amended to include Apprenticeships	10/10/08	Label amended.
L_FIRST _FULLLEVEL3 _ACHIEVE	Amended	Amended to include Apprenticeships	10/10/08	Label amended.
L_FRANCH	Existing		10/10/08	Label amended.
L_FTELP	Amended	Amended to include new current year guided learning hours DVs and Active definition.	10/10/08	Label amended.
L_FULLLEVEL2	Amended	Amended to include Apprenticeships	30/09/08	A_ACTIVE selection applied.	Correction.
L_FULLLEVEL2	Amended	Amended to include Apprenticeships		Label amended.
L_FULLLEVEL2 _ACHIEVE	Amended	Amended to include Apprenticeships	30/09/08	A_ACTIVE selection applied.	Correction.
L_FULLLEVEL2 _ACHIEVE	Amended	Amended to include Apprenticeships		Label amended.
L_FULLLEVEL2 _COMPLETE	Amended	Amended to include Apprenticeships	30/09/08	A_ACTIVE selection applied.	Correction.
L_FULLLEVEL2 _COMPLETE	Amended	Amended to include Apprenticeships		Label amended.
L_FULLLEVEL3	Amended	Amended to include Apprenticeships	30/09/08	A_ACTIVE selection applied.	Correction.
L_FULLLEVEL3	Amended	Amended to include Apprenticeships		Label amended.
L_FULLLEVEL3 _ACHIEVE	Amended	Amended to include Apprenticeships	30/09/08	A_ACTIVE selection applied.	Correction.
L_FULLLEVEL3 _ACHIEVE	Amended	Amended to include Apprenticeships		Label amended.
L_FULLLEVEL3 _COMPLETE	Amended	Amended to include Apprenticeships	30/09/08	A_ACTIVE selection applied.	Correction.
L_FULLLEVEL3 _COMPLETE	Amended	Amended to include Apprenticeships		Label amended.
L_FUND	Amended	Amended to comply with Demand Led Funding
L_IL_IY	New	Funding Requirement	10/10/08	Label amended
L_IL_P1-12	Existing		30/09/08	Syntax amended.	Correction.
L_IL_P1-12	Existing			Label amended.
L_INYR _ACTUAL_GLH	New	Replaces current years guided learning hours DV	10/10/08	Label amended
L_INYR _EXPECTED _GLH	New	Replaces current years guided learning hours DV	10/10/08	Label amended
L_INYR _EXPECTED _GLH	New	Replaces current years guided learning hours DV	11/2/09	Label corrected	Correction
L_IY_SLN _PAYMENT	New	Funding Requirement	10/10/08	Label amended
L_JAN	Existing
L_LEVEL2E	Deleted	Not used
L_LIS_FG	Deleted	Replaced by SLN flag.
L_LIVE_A	Deleted	Census dates no longer applicable.
L_LIVE_B	Deleted	Census dates no longer applicable.
L_LLA	Existing		10/10/08	Label amended.
L_LLLSC	Existing		10/10/08	Label amended.
L_LREG	Amended	Amended to use home LSC of the learner.	10/10/08	Label amended.
L_LREG	Amended	Amended to use home LSC of the learner.	21/1/09	Amended to include National Apprenticeship Service (NAS)
L_LWAR01	Existing		10/10/08	Label amended.
L_LWAR03	Existing		10/10/08	Label amended.
L_LWAR03	Existing			Changed reference to Ward_03 file to Ward_04.	Correction
L_LWARD	Existing		10/10/08	Label amended.
L_MODE_A	Deleted	Census dates no longer applicable.
L_MODE_B	Amended	Census dates no longer applicable.	10/10/08	Label amended.
L_NOV	Existing
L_NVQLEV	Existing
L_OCT	Existing
L_OS1200	Existing		10/10/08	Label amended.
L_OSEGLH	Amended	Changes to ILR field A18 - main delivery method.	28/11/08	Syntax amended to reflect system changes to the handling of missing values	Correction
L_PLA	Existing
L_PLLSC	Existing
L_PREG	Amended	Amended to use Provider LSC of the Learner	21/1/09	Amended to include National Apprenticeship Service (NAS)
L_PRIOR_SLN _PAYMENT	New	Funding Requirement	10/10/08	Label amended
L_PWAR01	Existing		10/10/08	Label amended.
L_PWAR03	Existing		10/10/08	Label amended.
L_PWAR03	Existing			Changed reference to Ward_03 file to Ward_04.	Correction
L_PWARD	Existing		10/10/08	Label amended.
L_SFL	Existing		10/10/08	Label amended.
L_SFL	Existing			L_SFL changed to handle cases where all A_SFL are missing.
L_SFL_LEITCH _LIT	New	Measure new target.	30/09/08	A_ACTIVE selection applied.	Correction.
L_SFL_LEITCH _LIT_ACH	New	Measure new target.	30/09/08	A_ACTIVE selection applied.	Correction.
L_SFL_LEITCH _LIT_ACH	New	Measure new target.		Label amended
L_SFL_LEITCH _NUM	New	Measure new target.	30/09/08	A_ACTIVE selection applied.	Correction.
L_SFL_LEITCH _NUM	New	Measure new target.		Label amended
L_SFL_LEITCH _NUM_ACH	New	Measure new target.	30/09/08	A_ACTIVE selection applied.	Correction.
L_SFL_LEITCH _NUM_ACH	New	Measure new target.		Label amended
~~L_SLN~~	~~Deleted~~	~~Replaced by new Derived Variables.~~
L_TO_DATE _SLN _PAYMENT	New	Funding Requirement
L_TTGAIN	Amended	Value 1 no longer applicable. Includes new Active definition	30/09/08	A_ACTIVE selection applied.	Correction.
L_UPLF45	Deleted	No longer applicable.
L_UPLF56	Deleted	No longer applicable.
L_UPLF67	Existing		10/10/08	Label amended.
L_UPLF78	Existing		10/10/08	Label amended.
L_UPLF89	New	Uplift factors for 08/09	10/10/08	Label amended
L25_REG	New	Funding LSC region.
P_ACTIVE	New	Replaces the live definition used in previous years.	30/09/08	Recode of Values
P_ACTIVE	New	Replaces the live definition used in previous years.		Label amended
P_AVIL	New	To determine average in learning at programme level.
P_AVILY2D	New	To determine average in learning at programme level year to date.
P_IL_IY	New	Funding Requirement	30/09/08	Recode of Values
P_IL_IY	New	Funding Requirement		Label amended
P_IY_SLN _PAYMENT	New	Funding Requirement	10/10/08	Label amended
P_NVQ_ACH _DATE	New	Programme level DV which replaces A_ACHIEVE (see reason above).	10/10/08	Label amended
P_PRIOR_SLN _PAYMENT	New	Funding Requirement	10/10/08	Label amended.
P_PROG _STATUS	New	To determine status at programme level, for example, 'Framework Achieved'.	30/09/08	Syntax changed to match table.
P_PROG _STATUS	New			Label amended.
P_TO_DATE _SLN _PAYMENT	New	Funding Requirement	10/10/08	Label amended.
PERIOD	Existing		10/10/08	Label amended.
PRD_ACT temporary variable	Deleted	Census dates no longer applicable.
PRD_EXP temporary variable	Deleted	Census dates no longer applicable.
TEMPACT temporary variable	Deleted	Census dates no longer applicable.
TEMPEXP temporary variable	Deleted	Census dates no longer applicable.
TOTPDACT temporary variable	Deleted	Census dates no longer applicable.
TOTPDEXP temporary variable	Deleted	Census dates no longer applicable.
TOTACT (temporary variable)	New	New to current year guided learning hours definition.
TOTEXP (temporary variable)	New	New to current year guided learning hours definition.

Last date modified: 11th February 2009