To Date SLN Payment Data Definition 2009/2010
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 Standard File |
| A_PRIOR_SLN_PAYMENT | A_PRIOR_SLN_PAYMENT Has the aim Generated SLN or Received a Payment in Previous Years. | Aims Standard 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 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 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 Standard File |
VALUES
5. The table below outlines the categories for A_TO_DATE_SLN_PAYMENT, P_TO_DATE_SLN_PAYMENT, L_TO_DATE_SLN_PAYMENT
DETAILED DEFINITION
Aim Level
6.The Aim level to date 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 the documentation available on the Funding Policy page.
Programme Level
7. Programme level (P_TO_DATE_SLN_PAYMENT) is the highest value of has the aim generated an SLN or received a payment in this or previous years (A_TO_DATE_SLN_PAYMENT) for all of the learner’s aims within a programme.
Learner Level
8. Learner level (L_TO_DATE_SLN_PAYMENT) is the highest value of has the aim generated an SLN or received a payment in this or previous years (A_TO_DATE_SLN_PAYMENT) for all of the learner’s aims.
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_IY_SLN_PAYMENT + A_PRIOR_SLN_PAYMENT greater than 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_IY_SLN_PAYMENT,A_PRIOR_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’. |
4. The following SQL code illustrates how to derive A_TO_DATE_SLN_PAYMENT:
select L01, L03, A05
, case when A_IY_SLN_PAYMENT>0 or A_PRIOR_SLN_PAYMENT>0 then 1
else 0 end as A_TO_DATE_SLN_PAYMENT from ILR0910_E_AIMS |
5. The following SQL code illustrates how to derive P_TO_DATE_SLN_PAYMENT:
select L01, L03, A15, A26
, case when A15 is NULL or A15 in (-1, 99) then -1 else max(A_TO_DATE_SLN_PAYMENT) end as P_TO_DATE_SLN_PAYMENT from dbo.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_TO_DATE_SLN_PAYMENT:
select L01, L03, count(A05) as aims
, max(A_TO_DATE_SLN_PAYMENT) as L_TO_DATE_SLN_PAYMENT from ILR0910_E_AIMS
group by
L01, L03 order by L01, L03 |
Date last modified: 02nd December 2009
