AIM_INYEAR_GLH_EMP_RESP

DATA DEFINITION

1. The GLH for the aim to be used in the SLN calculation for Employer Responsive provision.

RELEVANT COLLECTIONS

  • ILR(FE)

SOURCE DATA

2. The following variables are used as source data for the calculation of AIM_INYEAR_GLH_EMP_RESP.

Field Name Label Dataset
Current_year_start Start date of the current year (eg 1 August 2006 for 2006/07)  
Current_year_end End date of the current year (eg 31 July 2007 for 2006/07)  
A_TODATE_QUALIFYING_SLN_PERIOD Defines whether a learner counts as a start under the demand led Funding Method.  
ACT_MONTHS_INYEAR The actual number of months spent in learning on the aim in the current year  
EXP_MONTH The expected number of months to be spent in learning on the aim in the current year.  
AIM_GLH The Listed Guided Learning hours for an AIM  
A35 Learning outcome ILR learning aim dataset
A31 Learning actual end date ILR learning aim dataset
A34 Completion Status ILR learning aim dataset
A10 LSC funding stream ILR learning aim dataset

DERIVED VARIABLES AND DATASETS

3. The definition produces the following derived variable(s)

Field Name Label Dataset
AIM_INYEAR_GLH_EMP_RESP The GLH for the aim to be used in the SLN calculation for Employer Responsive provision  


AIM_INYEAR_GLH_EMP_RESP Sample Code

1. The following SPSS code is provided to illustrate the AIM_INYEAR_GLH_EMP_RESP data definition.

AIM_INYEAR_GLH_EMP_RESP

2. The following table shows the steps required to derive AIM_INYEAR_GLH_EMP_RESP

Step Condition Action if true Action if false
1 n/a Set CURRENT_YEAR_START to the 1 August of the current academic year (eg 1/08/06) for 2006/7 then go to 2 n/a
2 n/a Set CURRENT_YEAR_END to the 31 July of the current academic year (eg 31/07/07) for 2006/7 then go to 3 n/a
3 n/a Set AIM_INYEAR_GLH_EMP_RESP to 0 Go to 4
4 Does the Aim has count as a start for demand led funding and has the Learner not transferred to another Aim(A_TODATE_QUALIFYING_SLN_PERIOD =1 and A34 <> 4) Set AIM_INYEAR_GLH_EMP_RESP to 0.75 *(ACT_MONTHS_IN_YEAR / EXP_MONTHS * AIM_GLH) Go to 5
5 Has the aim has been achieved and the Actual Learning end date occurs in the current year and the Funding Stream is FE. (IF a35 = 1 and a31 <= current_year_end and a31 >= current_year_start and a10 = 20) Set AIM_INYEAR_GLH_EMP_RESP to 0.25*AIM_GLH + AIM_INYEAR_GLH_EMP_RESP Go to 6
6 n/a End  

3. The following SPSS code illustrates how to derive AIM_INYEAR_GLH_EMP_RESP.

COMPUTE aim_inyear_glh_emp_resp = 0.

IF (A_TODATE_QUALIFYING_SLN_PERIOD = 1 and A34 <> 4) aim_inyear_glh_emp_resp = 0.75*(act_months_inyear/exp_months * aim_glh).

IF (a35 = 1 and a31 <= current_year_end and a31 >= current_year_start and a10 = 20) aim_inyear_glh_emp_resp = 0.25*aim_glh + aim_inyear_glh_emp_resp.

Date last modfied: 17th October 2008