L_ALLYEARS_GLH, L_INYEAR_GLH, L_INYEAR_GLH_EMP_RES

DATA DEFINITION

1. Aggregates Guided Learning Hours to Learner level to derive Total GLH, and Employer Responsive total GLH

RELEVANT COLLECTIONS

  • ILR(FE)

SOURCE DATA

2. The following variables are used as source data for the calculation of L_ALLYEARS_GLH, L_INYEAR_GLH, L_INYEAR_GLH_EMP_RES.

Field Name Label Dataset
L01 Provider Number  
L03 Learner Reference Number  
L_AGEB Age of learner as at 31 August banded  
A_DEMAND_LED_CAT Demand Lead Category  
Aim_glh GLH for Aim  
Aim_inyear_glh Guided Learning Hours for an Aim within a Year  
Aim_inyear_glh_emp_resp Employer Responsive Aim Guided Learning Hours within a Year  

DERIVED VARIABLES AND DATASETS

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

Field Name Label Dataset
L_ALLYEARS_GLH Total Learner GLH for the duration of the learning aim  
L_INYEAR_GLH Total Learner GLH within a year  
L_INYEAR_GLH_EMP_RESP Total Learner Responsive GLH within a year  

L_ALLYEARS_GLH, L_INYEAR_GLH, L_INYEAR_GLH_EMP_RES Sample Code

1. The following SPSS code is provided to illustrate the L_ALLYEARS_GLH, L_INYEAR_GLH, L_INYEAR_GLH_EMP_RES data definition.

L_ALLYEARS_GLH, L_INYEAR_GLH, L_INYEAR_GLH_EMP_RES

2. he following table shows the steps required to derive L_ALLYEARS_GLH, L_INYEAR_GLH, L_INYEAR_GLH_EMP_RES

Step Condition Action if true Action if false
1 n/a Set l_allyears_glh to sum(aim_glh) for each aim with the same L01 L03 L_AGEB and A_DEMAND_LED_CAT combination n/a
2 n/a Set l_inyear_glh to sum(aim_inyear_glh) for each aim with the same L01 L03 L_AGEB and A_DEMAND_LED_CAT combination n/a
3 n/a Set l_inyear_glh_emp_resp to sum(aim_inyear_glh_emp_resp) for each aim with the same L01 L03 L_AGEB and A_DEMAND_LED_CAT combination n/a

3. The following SPSS code illustrates how to derive L_ALLYEARS_GLH, L_INYEAR_GLH, L_INYEAR_GLH_EMP_RES.

AGGREGATE

/OUTFILE = * MODE = ADDVARIABLES

/PRESORTED

/BREAK l01 L_AGEB A_DEMAND_LED_CAT l03

/l_allyears_glh = sum(aim_glh)

/l_inyear_glh = sum(aim_inyear_glh)

/l_inyear_glh_emp_resp = sum(aim_inyear_glh_emp_resp)

Date last modfied: 17th October 2008