To Date Qualifying SLN Period Data Definition 2009/2010
A_TODATE_QUALIFYING_SLN_PERIOD
DATA DEFINITION
1. Aim to date qualifying SLN period.
PURPOSE
2. To identify aims that pass the qualifying period in any year to be eligible to generate SLN.
These variables were defined in the MI views specification in 2008/09. New variables have been added to display the expected payments and SLN for the full year.
Note that these variables should still be calculated for the entitlement aims produced by the funding calculation, which are identified by A05=99.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of To Date Qualifying SLN Period.
| Field Name |
Label |
Dataset |
| SLN_INST_START |
SLN Instalment Start indicator. |
ILR_ER_FUNDING_AIM funding calculation output table |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
A_TODATE_QUALIFYING
_SLN_PERIOD |
A_TODATE_QUALIFYING_SLN_PERIOD Aim Passes the Qualifying Period in Any Year to be Eligible to Generate SLN |
Aims Standard File |
VALUES
5. The table below outlines the categories for A_TODATE_QUALIFYING_SLN_PERIOD
DETAILED DEFINITION
6.
This variable is dependant on output from the funding calculation. The funding calculation must have completed before this variable is derived.
If the value of the SLN_INST_START variable in the ILR_ER_FUNDING_AIM funding calculation table is set to 1, then the value of A_TODATE_QUALIFYING_SLN_PERIOD is set to 1. Otherwise, the value of A_TODATE_QUALIFYING_SLN_PERIOD is set to 0.
To Date Qualifying SLN Period Sample Code
1. The following SPSS code is provided to illustrate the To Date Qualifying SLN Period data definition.
A_TODATE_QUALIFYING_SLN_PERIOD
2. The following table shows the steps required to derive A_TODATE_QUALIFYING_SLN_PERIOD
| Step |
Condition |
Action/Action if true |
| 1 |
Any |
Set A_TODATE_QUALIFYING_SLN_PERIOD = 0 in Aims File |
| 2 |
If SLN_INST_START (from the ILR_ER_FUNDING_AIM funding calculation output table) = 1 |
Set A_TODATE_QUALIFYING_SLN_PERIOD = 1 in Aims File |
3. The following SPSS code illustrates how to derive A_TODATE_QUALIFYING_SLN_PERIOD on to the Aims data set..
|
GET FILE = …………Aims Data set.
SORT CASES BY L01 L03 A15 A26 A05.
MATCH FILES
/FILE = *
/TABLE = …..Aims DLF data set
/BY L01 L03 A15 A26 A05.
COMPUTE A_TODATE_QUALIFYING_SLN_PERIOD=0.
COMPUTE A_TODATE_QUALIFYING_SLN_PERIOD = (SLN_INST_START=1).
RECODE A_TODATE_QUALIFYING_SLN_PERIOD (MISSING=0).
VALUE LABELS A_TODATE_QUALIFYING_SLN_PERIOD
0 'No’
1 'Yes’. |
4. The following SQL code illustrates how to derive A_TODATE_QUALIFYING_SLN_PERIOD:
|
select
L01, L03, A15, A26, A05
, case when SLN_INST_START=1 then 1 else 0 end as A_TODATE_QUALIFYING_SLN_PERIOD
from
ILR0910_E_AIMS A
left outer join
ILR_ER_FUNDING_AIM B
on A.L01=B.L01 and A.L03=B.L03 and A.A05=B.A05
group by
L01, L03, A15, A26, A05
order by
L01, L03, A15, A26, A05 |
Date last modified: 07th December 2009
