Prior SLN Payment Data Definition 2009/2010
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.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (ER)
- ILR (UFI)
- ILR (ESF SR)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of Prior SLN Payment data definition.
| 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 Standard File |
| A15 |
A15 Programme Type |
Aims Standard File |
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 Standard File |
| P_PRIOR_SLN_PAYMENT |
P_PRIOR_SLN_PAYMENT Programme generated SLN or received a Payment Prior to this Year |
Aims Standard File |
| L_PRIOR_SLN_PAYMENT |
L_PRIOR_SLN_PAYMENT Learner Received an SLN or Payment in Previous Year(s) |
Aims and Learner Standard File |
VALUES
5. The table below outlines the categories for A_PRIOR_SLN_PAYMENT, P_PRIOR_SLN_PAYMENT and L_PRIOR_SLN_PAYMENT
DETAILED DEFINITION
Aim Level
6. The Aim level prior Standard Learner Number payment is matched in from the Demand Led Funding dataset relevant to the Collection (Employer Responsive or Learner Responsive). For further information, please refer to documentation available on the Funding Policy page.
Programme Level
7. Programme level (P_PRIOR_SLN_PAYMENT) is the highest value of has the aim generated an SLN or received a prior payment (A_PRIOR_SLN_PAYMENT) for all of the learner’s aims within a programme.
Learner Level
8. Learner level (L_PRIOR_SLN_PAYMENT) is the highest value of has the aim generated an SLN or received a prior payment (A_PRIOR_SLN_PAYMENT) for all of the learner’s aims.
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 |
| 1 |
Any |
Set A_PRIOR_SLN_PAYMENT = 0 |
| 2 |
If A_PRIOR_SLN_PAYMENT in Aims DLF File=1 |
Set A_PRIOR_SLN_PAYMENT = 1 in Aims File |
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.
|
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.
*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’ |
4. The following SQL code illustrates how to derive A_PRIOR_SLN_PAYMENT:
|
select
b.L01, b.L03, b.A05
, a.A_PRIOR_SLN_PAYMENT as A_PRIOR_SLN_PAYMENT
from
ILR0910_E_AIMS_DLF a
left outer join
ILR0910_E_AIMS b
on a.L01 = b.L01 and a.L03 = b.L03 and a.A05 = b.A05 |
5. The following SQL code illustrates how to derive P_PRIOR_SLN_PAYMENT:
|
select
L01, L03, A15, A26
, case when A15 is NULL or A15 in (-1, 99) then -1 else max(A_PRIOR_SLN_PAYMENT) end as P_PRIOR_SLN_PAYMENT
from
ILR0910_E_AIMS
group by
L01, L03, A15, A26
order by
L01, L03, A15, A26 |
6. The following SQL code illustrates how to derive L_PRIOR_SLN_PAYMENT:
|
select
L01, L03, count (A05) as Aims
, max(A_PRIOR_SLN_PAYMENT) as L_PRIOR_SLN_PAYMENT
from
ILR0910_E_AIMS
group by
L01, L03
order by
L01, L03 |
Date last modified: 07th December 2009
