Prior SLN Payment Data Definition
A_PRIOR_SLN_PAYMENT, P_PRIOR_SLN_PAYMENT, L_PRIOR_SLN_PAYMENT
DATA DEFINITION
1. Prior SLN payment at learner, aim or programme level.
PURPOSE
2. To identify whether the aim, programme or learner has generated a Standard Learner Number (SLN) or received a SLN payment in previous years.
SOURCE DATA
3. The following variables are used as source data for the calculation of Prior SLN Payment data definition.
| Field Name |
Label |
Dataset |
| prev_aim_SLN* |
This is the aim_SLN calculated for the previous 3 years of the aim |
Aims DLF File |
| prev_aim_fund* |
This is the aim_FUND calculated for the previous 3 years of the aim |
Aims DLF File |
| a_demand_led_cat |
Category used for DLF calculation purposes |
Aims DLF File |
| Prev_emp_resp_sln* |
This is the emp_resp_sln calculated for the previous 3 years of the aim |
Aims DLF File |
* - These variables are derived exactly the same way as
AIM_SLN, AIM_FUND and EMP_RESP_SLN. Except,
prev_INYEAR_COURSE_PROP is used instead of
INYEAR_COURSE_PROP in the derivation of the source variables required for the derivation of prev_AIM_SLN, prev_AIM_FUND and prev_EMP_RESP_SLN.
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_PRIOR_SLN_PAYMENT |
A_PRIOR_SLN_PAYMENT Has the Aim generated SLN or received a Payment in Previous Years |
Aims DLF File |
| P_PRIOR_SLN_PAYMENT |
P_PRIOR_SLN_PAYMENT Programme generated SLN or received a Payment Prior to this Year |
Aims DLF File |
| L_PRIOR_SLN_PAYMENT |
L_PRIOR_SLN_PAYMENT Learner Received an SLN or Payment in Previous Year(s) |
Learner DLF File |
VALUES
5. The table below outlines the categories for A_PRIOR_SLN_PAYMENT, P_PRIOR_SLN_PAYMENT and L_PRIOR_SLN_PAYMENT
| Value |
Label |
| 0 |
No |
| 1 |
Yes |
| -1 |
Not Available/Not Applicable |
Prior SLN Payment Sample Code
1. The following SPSS code is provided to illustrate the Prior SLN Payment data definition.
A_PRIOR_SLN_PAYMENT, P_PRIOR_SLN_PAYMENT, L_PRIOR_SLN_PAYMENT
2. The following table shows the steps required to derive A_PRIOR_SLN_PAYMENT, P_PRIOR_SLN_PAYMENT, L_PRIOR_SLN_PAYMENT
A_PRIOR_SLN_PAYMENT
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Any |
Set A_PRIOR_SLN_PAYMENT = 0 |
|
| 2 |
Is demand_led_cat=1? |
Goto 3 |
Go to 4 |
| 3 |
Is (prev_aim_SLN>0 or prev_aim_fund>0)? |
Set A_PRIOR_SLN_PAYMENT = 1 |
Set A_PRIOR_SLN_PAYMENT = 0 |
| 4 |
Is demand_led_cat=2? |
Go to 5 |
Go to 6 |
| 5 |
Is (Prev_emp_resp_sln>0 or prev_aim_fund>0)? |
Set A_PRIOR_SLN_PAYMENT = 1 |
Set A_PRIOR_SLN_PAYMENT = 0 |
| 6 |
|
A_PRIOR_SLN_PAYMENT = -1. |
|
P_PRIOR_SLN_PAYMENT
| Step |
Condition |
Action/Action if true |
| 1 |
Is A15 MISING OR A15= -1 or A15=99 |
Set P_PRIOR_SLN_PAYMENT to -1 |
| 2 |
(Aggregate)
For all aims where the learner (L03), Provider (L01), Programme Type (A15) and Framework Code (A26) are the same. |
Set P_PRIOR_SLN_PAYMENT to the maximum value of A_PRIOR_SLN_PAYMENT. |
L_PRIOR_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_PRIOR_SLN_PAYMENT to the maximum value of A_PRIOR_SLN_PAYMENT. |
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_PRIOR_SLN_PAYMENT contain a value |
None |
Set L_PRIOR_SLN_PAYMENT = -1 |
3. The following SPSS code illustrates how to derive A_PRIOR_SLN_PAYMENT, P_PRIOR_SLN_PAYMENT, L_PRIOR_SLN_PAYMENT.
|
COMPUTE A_PRIOR_SLN_PAYMENT=0.
DO IF demand_led_cat=1.
A_PRIOR_SLN_PAYMENT=(prev_aim_SLN>0 or prev_aim_fund>0).
ELSE IF demand_led_cat=2.
A_PRIOR_SLN_PAYMENT=(Prev_emp_resp_sln>0 or prev_aim_fund>0).
ELSE.
A_PRIOR_SLN_PAYMENT=-1.
END IF.
*Aggregate to programme level taking the maximum prior SLN payment value.
SORT CASES L01 L03 A15 A26.
AGGREGATE
/OUTFILE = *
MODE=ADDVARIABLES
/PRESORTED
/BREAK = L01 L03 A15 A26
/P_PRIOR_SLN_PAYMENT= max(A_PRIOR_SLN_PAYMENT).
VALUE LABELS P_PRIOR_SLN_PAYMENT
0 'No’
1 'Yes’
/A_PRIOR_SLN_PAYMENT
0 'No’
1 'Yes’.
*Aggregate to Learner level taking the maximum prior SLN payment value.
SORT CASES L01 L03.
AGGREGATE
/OUTFILE = *
/PRESORTED
/BREAK = L01 L03
/L_PRIOR_SLN_PAYMENT= max(A_PRIOR_SLN_PAYMENT).
RECODE L_PRIOR_SLN_PAYMENT (SYSMIS=-1)
VALUE LABELS L_PRIOR_SLN_PAYMENT
0 'No’
1 'Yes’ |
Date Last Modified: 03 March 2010
