In Year Qualifying SLN Period Data Definition 2010/11

A_IY_QUALIFYING_SLN_PERIOD

DATA DEFINITION

1. Aim in year qualifying SLN period.

PURPOSE

2. To identify aims that pass the qualifying period in year to be eligible to generate Standard Learner Number (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

ILR (LR)
ILR (ER)

SOURCE DATA

3. The following variables are used as source data for the calculation of In Year Qualifying SLN Period.

Field Name	Label	Dataset
SLN_START	SLN Start Indicator	ILR_LR_FUNDING_AIM and ILR_ER_FUNDING_AIM tables from the funding calculation

DERIVED VARIABLES AND DATASETS

4. The definition produces the following Derived Variables

Field Name	Label	Dataset
A_IY_QUALIFYING_SLN_PERIOD	A_IY_QUALIFYING_SLN_PERIOD Aim Passes In Year Qualifying Period to be Eligible to Generate SLN	Aims Standard File

VALUES

5. The table below outlines the categories for A_IY_QUALIFYING_SLN_PERIOD

Value	Label
0	No
1	Yes

DETAILED DEFINITION

6. The aim level in year qualifying SLN period flag is matched in from the Demand Led Funding dataset, relevant to the collection. For further information please refer to documentation available on the Funding Policy page.

In Year Qualifying SLN Period Sample Code

1. The following SPSS code is provided to illustrate the In Year Qualifying SLN Period data definition.

A_IY_QUALIFYING_SLN_PERIOD

2. The following table shows the steps required to derive A_IY_QUALIFYING_SLN_PERIOD

Step	Condition	Action/Action if true
1	Any	Set A_IY_QUALIFYING_SLN_PERIOD= 0
2	If SLN_START (from the funding calculation output)=1	Set A_IY_QUALIFYING_SLN_PERIOD= 1 in Aims File

3. The following SQL code illustrates how to derive A_IY_QUALIFYING_SLN_PERIOD:

SELECT A.L03 , A.L01 , A.A05 , case when SLN_START_IND = 1 then 1 else 0 end as A_IY_QUALIFYING_SLN_PERIOD FROM ER_FUNDING_AIM A left outer join ILR0910_E_AIMS B on A.L01 = B.L01 and A.L03 = B.L03

SELECT

     A.L03 , A.L01
     , A.A05
     , case when SLN_START_IND = 1 then 1 else 0 end as A_IY_QUALIFYING_SLN_PERIOD

FROM

ER_FUNDING_AIM A

left outer join

ILR0910_E_AIMS B

on A.L01 = B.L01 and A.L03 = B.L03

Date last modified: 9th August 2010