In Year SLN Payment Data Definition
A_IY_SLN_PAYMENT, P_IY_SLN_PAYMENT, L_IY_SLN_PAYMENT
DATA DEFINITION
1. In year SLN payment at learner, aim or programme level.
PURPOSE
2. To identify whether the aim, programme or learner generates a Standard Learner Number (SLN) or receives an in year payment up to the current period.
SOURCE DATA
3. The following variables are used as source data for the calculation of Year To Date SLN Payment data definition.
| Field Name |
Label |
Dataset |
| aim_SLN |
aim_SLN The Standard Learner Number for the aim for Learner responsive provision |
LR Aims DLF Standard File |
| aim_fund |
aim_fund Demand led funded Learning aim |
LR Aims DLF Standard File |
| emp_resp_sln |
emp_resp_sln The Standard Learner Number for the aim for Employer responsive provision |
ER Aims DLF File |
| a_demand_led_cat |
a_demand_led_cat Demand Led Category |
Aims DLF File |
| L_ACTIVE |
L_ACTIVE Learner Active for Current Academic year |
Aims Standard File, Learner Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following variable(s)
| Field Name |
Label |
Dataset |
| A_IY_SLN_PAYMENT |
A_IY_SLN_PAYMENT Does the Aim generate SLN or receive an In Year Payment, up to the current period |
Aims DLF File |
| P_IY_SLN_PAYMENT |
P_IY_SLN_PAYMENT Programme generates SLN or Receives and In Year Payment up to the Current Period |
Aims DLF File |
| L_IY_SLN_PAYMENT |
L_IY_SLN_PAYMENT Learner Received SLN or Payment This Year To Date |
Learner DLF File |
VALUES
5. The table below outlines the categories for A_IY_SLN_PAYMENT, P_IY_SLN_PAYMENT and L_IY_SLN_PAYMENT
| Value |
Label |
| 0 |
No |
| 1 |
Yes |
| -1 |
Not Applicable/Not Known |
In Year SLN Payment Sample Code
1. The following SPSS code is provided to illustrate the In Year SLN Payment data definition.
A_IY_SLN_PAYMENT, P_IY_SLN_PAYMENT, L_IY_SLN_PAYMENT
2. The following tables show the steps required to derive A_IY_SLN_PAYMENT, P_IY_SLN_PAYMENT, L_IY_SLN_PAYMENT
A_IY_SLN_PAYMENT
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Any |
Set A_IY_SLN_PAYMENT = 0 |
|
| 2 |
IF demand_led_cat=1 |
Goto 3 |
Go to 4 |
| 3 |
IF (aim_SLN>0 or aim_fund>0) |
Set A_IY_SLN_PAYMENT = 1 |
Set A_IY_SLN_PAYMENT = 0 |
| 4 |
IF demand_led_cat=2. |
Go to 5 |
Go to 6 |
| 5 |
IF (emp_resp_sln>0 or aim_fund>0) |
Set A_IY_SLN_PAYMENT = 1 |
Set A_IY_SLN_PAYMENT = 0 |
| 6 |
|
A_IY_SLN_PAYMENT = -1. |
|
P_IY_SLN_PAYMENT
| Step |
Condition |
Action/Action if true |
| 1 |
(Aggregate)
For all aims where the learner (L03), Provider (L01), Programme Type (A15) and Framework Code (A26) are the same. |
Set P_IY_SLN_PAYMENT to the maximum value of A_IY_SLN_PAYMENT. |
L_IY_SLN_PAYMENT
| Step |
Condition |
Action/Action if true |
| 1 |
(Aggregate)
For all aims where the learner (L03) and Provider (L01) are the same. |
Set L_IY_SLN_PAYMENT to the maximum value of A_IY_SLN_PAYMENT. |
| 2 |
Does L_ACTIVE = 0 |
Set L_IY_SLN_PAYMENT to -1 |
3. The following SPSS code illustrates how to derive A_IY_SLN_PAYMENT, P_IY_SLN_PAYMENT and L_IY_SLN_PAYMENT.
|
COMPUTE A_IY_SLN_PAYMENT=0.
DO IF demand_led_cat=1.
A_IY_SLN_PAYMENT=(aim_SLN>0 or aim_fund>0).
ELSE IF demand_led_cat=2.
A_IY_SLN_PAYMENT=(emp_resp_sln>0 or aim_fund>0).
ELSE.
A_IY_SLN_PAYMENT=-1.
END IF.
*Aggregate to programme level taking the maximum in year SLN payment value.
SORT CASES L01 L03 A15 A26.
AGGREGATE
/OUTFILE = *
MODE=ADDVARIABLES
/PRESORTED
/BREAK = L01 L03 A15 A26
/P_IY_SLN_PAYMENT= max(A_IY_SLN_PAYMENT).
VALUE LABELS A_IY_SLN_PAYMENT
0 'No’
1 'Yes’
*Aggregate to Learner level taking the maximum in year SLN payment value.
SORT CASES L01 L03.
AGGREGATE
/OUTFILE = *
/PRESORTED
/BREAK = L01 L03
/L_IY_SLN_PAYMENT= max(A_IY_SLN_PAYMENT).
|
Date last Modified : 25 February 2010
