AIM_FUND, L_AIM_FUND, AIM_SLN, A_TOTAL_SLN_Y2D AND EMP_RESP_SLN
DATA DEFINITION
1. AIM_FUND Defines a funded learning aim under the Demand Led Funding Method
2. L_AIM_FUND Defines a funded learner under the Demand Led Funding Method
3. AIM_SLN The Standard Learner Number for the aim for Learner responsive provision
4. EMP_RESP_SLN The Standard Learner Number for the aim for Employer responsive provision
5. A_TOTAL_SLN_Y2D The amount of SLN the aims has generated this year (up to the current period)
RELEVANT COLLECTIONS
SOURCE DATA
6. The following variables are used as source data for the calculation of AIM_FUND, L_AIM_FUND, A_TOTAL_SLN_Y2D, AIM_SLN AND EMP_RESP_SLN.
| Field Name |
Label |
Dataset |
| A_DEMAND_LED_CAT |
A_DEMAND_LED_CAT Demand Led Category |
Aims DLF File |
| AIM_SLN_Uncapped |
The Uncapped SLN value for Leaner responsive provision |
Aims DLF File |
| Aim_in_Year_GLH |
The guided learning hours for the aim which occur in the current year. |
Aims DLF File |
| Aim_Inyear_glh_emp_resp |
The guided learning hours for the aim which occur in the current year for employer responsive provision |
Aims DLF File |
| L_INYEAR_GLH |
Total Learner GLH within a year |
Learner DLF File |
| L_IN_YEAR_GLH_EMP_RESP |
Total Learner GLH within a year for employer responsive provision. |
Learner DLF File |
* temporary variables used in the calculation of AIM_FUND.
DERIVED VARIABLES AND DATASETS
7. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| AIM_FUND |
Demand led funded Learning aim |
Aims DLF File |
| Field Name |
Label |
Dataset |
| L_AIM_FUND |
Demand led funded Learner |
Learner DLF File |
| Field Name |
Label |
Dataset |
| AIM_SLN |
The Standard Learner Number for the aim for Learner responsive provision |
Aims DLF File |
| Field Name |
Label |
Dataset |
| EMP_RESP_SLN |
The Standard Learner Number for the aim for Employer responsive provision |
Aims DLF File
|
| Field Name |
Label |
Dataset |
| A_TOTAL_SLN_Y2D |
The amount of SLN the aims has generated this year (up to the current period) |
Aim DLF File |
VALUES
8. The table below outlines the categories for AIM_FUND and L_AIM_FUND
| AIM_FUND Label Value |
Description |
| 1 |
LSC funded learning aim under demand led funding |
| 0 |
Not an LSC funded learning aim under demand led funding |
| L_AIM_FUND Label Value |
Description |
| 1 |
LSC funded learner under demand led funding |
| 0 |
Not an LSC funded learner aim under demand led funding |
AIM_FUND, L_AIM_FUND, A_TOTAL_SLN_Y2D, AIM_SLN AND EMP_RESP_SLN Sample Code
1. The following SPSS code is provided to illustrate the AIM_FUND, L_AIM_FUND, AIM_SLN AND EMP_RESP_SLN data definition.
AIM_FUND, L_AIM_FUND, A_TOTAL_SLN_Y2D, AIM_SLN AND EMP_RESP_SLN
2. The following table shows the steps required to derive AIM_FUND, L_AIM_FUND, A_TOTAL_SLN_Y2D, AIM_SLN AND EMP_RESP_SLN
| Step |
Condition |
Action if true |
Action if false |
| 1 |
n/a |
Set AIM_FUND to 0 |
n/a |
| 2 |
n/a |
Set AIM_SLN_UNCAPPED to AIM_IN_YEARGLH/450 |
n/a |
| 3 |
n/a |
Set_AIM_SLN to AIM_INYEARGLH/450 * (the lower of (L_INYEAR_GLH and 1.75*450)/L_INYEAR_GLH |
n/a |
| 4 |
n/a |
Set EMP_RESP_SLN to AIM_INYEAR_GLH_EMP_RESP/ 450 (the minimum of (L_INYEAR_GLH_EMP_RESP and 1.75 * 450)/L_INYEAR_GLH_EMP_RESP). |
n/a |
| 5 |
Is the Demand Led Category Learner Responsive and the Learner responsive SLN for the aim greater than zero OR Is the Demand Led Category Employer Responsive and the Employer Responsive SLN greater than zero IF ((A_DEMAND_LED_CAT = 1 and AIM_SLN > 0) or (A_DEMAND_LED_CAT = 2 and emp_resp_sln > 0)) |
Set AIM_FUND to 1 |
Go to 6 |
| 6 |
n/a |
Set L_AIM_FUND to the maximum value of AIM_FUND for the learner. |
n/a |
| 7 |
If A_DEMAND_LED_CAT=1? |
Set A_TOTAL_SLN_Y2D=aim_SLN. |
Go to 8 |
| 8 |
If A_DEMAND_LED_CAT=2? |
Set A_TOTAL_SLN_Y2D=emp_resp_sln. |
|
3. The following SPSS code illustrates how to derive AIM_FUND, L_AIM_FUND, A_TOTAL_SLN_Y2D, AIM_SLN AND EMP_RESP_SLN.
|
Compute aim_fund=0.
Compute AIM_SLN_uncapped = aim_inyear_glh/450.
Compute AIM_SLN = aim_inyear_glh/450 * (MIN(l_inyear_glh , 1.75 * 450)/l_inyear_glh).
COMPUTE emp_resp_sln = aim_inyear_glh_emp_resp/450 * (MIN(l_inyear_glh_emp_resp, 1.75 * 450)/l_inyear_glh_emp_resp).
IF ((A_DEMAND_LED_CAT = 1 and AIM_SLN > 0) or (A_DEMAND_LED_CAT = 2 and emp_resp_sln > 0)) aim_fund = 1.
DO IF a_demand_led_cat=1.
COMP A_TOTAL_SLN_Y2D=aim_SLN.
ELSE IF a_demand_led_cat=2.
COMP A_TOTAL_SLN_Y2D=emp_resp_sln.
ELSE.
COMP A_TOTAL_SLN_Y2D=-1.
END IF.
VARIABLE LABELS aim_fund 'Aim recieves LSC funding under Demand Led Funding system'.
VALUE LABELS aim_fund 0 'No' 1 'Yes'.
AGGREGATE
/OUTFILE = * MODE = ADDVARIABLES
/PRESORTED
/break = l01 l03
/l_aim_fund = max(aim_fund) |
Date last modfied: 03rd March 2010
