To Date SLN Payment Data Definition
A_TO_DATE_SLN_PAYMENT, P_TO_DATE_SLN_PAYMENT, L_TO_DATE_SLN_PAYMENT
DATA DEFINITION
1. To date 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 this year or in previous years.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of the To Date SLN Payment Data Definition.
| 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 |
| A_PRIOR_SLN_PAYMENT |
A_PRIOR_SLN_PAYMENT Has the aim Generated SLN or Received a Payment in Previous Years. |
Aims DLF File |
DERVIED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_TO_DATE_SLN_PAYMENT |
A_TO_DATE_SLN_PAYMENT Aim generated SLN or received a Payment in Previous Years or In this Year |
Aims DLF Standard File |
| P_TO_DATE_SLN_PAYMENT |
P_TO_DATE_SLN_PAYMENT Programme generated SLN or received a Payment in Previous Years or In this Year |
Aims DLF Standard File |
| L_TO_DATE_SLN_PAYMENT |
L_TO_DATE_SLN_PAYMENT Learner generated SLN or received a Payment in Previous Years or In this Year |
Aims and Learner DLF Standard Files |
VALUES
5. The table below outlines the categories for A_TO_DATE_SLN_PAYMENT, P_TO_DATE_SLN_PAYMENT, L_TO_DATE_SLN_PAYMENT
To Date SLN Payment Sample Code
1. The following SPSS code is provided to illustrate the To Date SLN Payment Data Definition.
A_TO_DATE_SLN_PAYMENT, P_TO_DATE_SLN_PAYMENT, L_TO_DATE_SLN_PAYMENT
2. The following table shows the steps required to derive A_TO_DATE_SLN_PAYMENT, P_TO_DATE_SLN_PAYMENT, L_TO_DATE_SLN_PAYMENT
A_TO_DATE_SLN_PAYMENT
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is Sum of A_PRIOR_SLN_PAYMENT and A_IY_SLN_PAYMENT > 0? |
SET A_TO_DATE_SLN_PAYMENT = 1.
|
SET A_TO_DATE_SLN_
PAYMENT = 0. |
P_TO_DATE_SLN_PAYMENT
| Step |
Condition |
Action/Action if true |
| 1 |
Is A15 MISSING or A15=-1 or A15=99 |
Set P_TO_DATE_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_TO_DATE_SLN_PAYMENT to the maximum value of A_TO_DATE_SLN_PAYMENT.
|
L_TO_DATE_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_TO_DATE_SLN_PAYMENT to the maximum value of A_TO_DATE_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_TO_DATE_SLN_PAYMENT, P_TO_DATE_SLN_PAYMENT, L_TO_DATE_SLN_PAYMENT.
|
GET FILE = …………Aims Data set.
SORT CASES BY L01 L03 A15 A26 A05.
MATCH FILES
/FILE = *
/TABLE = ….. ER Aims DLF Data set
/BY L01 L03 A15 A26 A05.
COMPUTE A_TO_DATE_SLN_PAYMENT = (SUM(A_PRIOR_SLN_PAYMENT,A_IY_SLN_PAYMENT)>0).
*Aggregate to programme level taking the maximum to date SLN payment value.
SORT CASES L01 L03 A15 A26.
AGGREGATE
/OUTFILE = *
MODE=ADDVARIABLES
/PRESORTED
/BREAK = L01 L03 A15 A26
/P_TO_DATE_SLN_PAYMENT= max(A_TO_DATE_SLN_PAYMENT).
VALUE LABELS P_TO_DATE_SLN_PAYMENT
0 'No’
1 'Yes’
/A_TO_DATE_SLN_PAYMENT
0 'No’
1 'Yes’.
*Aggregate to Learner level taking the maximum to date SLN payment value.
SORT CASES L01 L03.
AGGREGATE
/OUTFILE = *
/PRESORTED
/BREAK = L01 L03
/L_TO_DATE_SLN_PAYMENT= max(A_TO_DATE_SLN_PAYMENT).
RECODE L_TO_DATE_SLN_PAYMENT (SYSMIS=-1)
VALUE LABELS L_TO_DATE_SLN_PAYMENT
0 'No’
1 'Yes’. |
Page Last Modified: 26 February 2010
