A_TODATE_QUALIFYING_SLN_PERIOD

DATA DEFINITION

1. Defines whether a learner counts as a start under the demand led Funding Method. This is defined as:
   Learning aim length Start period
   >= 24 weeks 6 weeks
   2 to 24 weeks 2 weeks
   <2 weeks 1 learning engagement

RELEVANT COLLECTIONS

ILR (FE)

SOURCE DATA

2. The following variables are used as source data for the calculation of A_TODATE_QUALIFYING_SLN_PERIOD.

Field Name	Label	Dataset
Inyear_course_prop	Proportion of the total days on the learning aim that are within the current academic year
Qual_course_length_exp*	The expected number of days on the learning aim that occur within the current academic year.
Qual_course_length_act*	The actual number of days on the learning aim that occur within the current academic year.
Period of grace*	The minimum number of days a learner must be in learning from the start of their course to attract funding.
A27	Learning Start date	ILR learning aim dataset
A28	Learning Planned End date	ILR learning aim dataset
A31	Learning actual end date	ILR learning aim dataset
A35	Learning outcome	ILR learning aim dataset
A10	LSC funding stream	ILR learning aim dataset

* temporary variables used in the calculation of A_TODATE_QUALIFYING_SLN_PERIOD.

DERIVED VARIABLES AND DATASETS

3. The definition produces the following derived variable(s)

Field Name	Label	Dataset
A_TODATE_QUALIFYING_SLN_PERIOD	Demand led funded Learner

VALUES

4. The table below outlines the categories for A_TODATE_QUALIFYING_SLN_PERIOD

A_TODATE_QUALIFYING_SLN_PERIOD Label Value	Description
1	Learning aim counts as a start under demand led funding
0	Learning aim does not count as a start under demand led funding

A_TODATE_QUALIFYING_SLN_PERIOD Sample Code

1. The following SPSS code is provided to illustrate the A_TODATE_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	Action if false
1	n/a	Set CURRENT_YEAR_START to the 1 August of the current academic year (eg 1/08/06) for 2006/7 then go to 2	n/a
2	n/a	Set CURRENT_YEAR_END to the 31 July of the current academic year (eg 31/07/07) for 2006/7 then go to 3	n/a
3	n/a	SET A_TODATE_QUALIFYING_SLN_PERIOD to 0 go to 4	n/a
4	n/a	SET QUAL_COURSE_LENGTH_EXP to the number of days resulting from [earlier of A28 and CURRENT_YEAR_END] – [Later of A27 AND CURRENT _YEAR START] + 1 go to 5	n/a
5	n/a	SET QUAL_COURSE_LENGTH_ACT to the number of days resulting from [earlier of A31 and CURRENT_YEAR_END] – [Later of A27 AND CURRENT _YEAR START] + 1 day then go to 6	n/a
6	n/a	Set PERIOD_OF_GRACE to 42 (i.e. six weeks) go to 7	n/a
7	Is the expected number of days on the learning aim that occur within the current academic year less than 14 day and is the proportion of the total days on the learning aim within the current academic year greater than zero and does the LSC funding stream = FE. (QUAL_COURSE_LENGTH_EXP < 14 AND INYEAR_COURSE_PROP > 0 AND A10 = 20 )	SET A_TODATE_QUALIFYING_SLN_PERIOD to 1 and go to 8	Go to 8
8	Is the expected number of days on the learning aim that occur within the current academic year less than 168 days and is the actual number of days that occur within the current academic year greater than or equal to 14 and does the LSC funding stream = FE. QUAL_COURSE_LENGTH_EXP < 168 AND QUAL_COURSE_LENGTH_ACT >= 14 AND A10 = 20)	SET A_TODATE_QUALIFYING_SLN_PERIOD to 1 and go to 9	Go to 9
9	Is the actual number of days on the learning aim that occur within the current academic year greater than or equal to the minimum required to count as a start (42 days) and does the LSC funding stream = FE. (QUAL_COURSE_LENGTH_ACT >=PERIOD OF GRACE AND DOES A10 = 20)	SET A_TODATE_QUALIFYING_SLN_PERIOD to 1 and go 10	Go to 10
10	Is the learning outcome achieved and is the proportion of the total days on the learning aim within the current academic year greater than zero does the learning actual end date occur within the current academic year. (A35 =1 AND INYEAR_COURSE_PROP>0 AND A31<=CURRENT_YEAR_END AND A31>= CURRENT_YEAR_START AND DOES A10=20)	SET A_TODATE_QUALIFYING_SLN_PERIOD to 1 and go to 11	Go to 11
11	Is the learning planned end date before the start of the current year (A28 < Current_year_start)	SET A_TODATE_QUALIFYING_SLN_PERIOD to 0 and go to 12	Go to 12
12	Has the learning aim been achieved and the actual learning aim end date is in the current academic year and the LSC funding stream for the aim is FE. IF (A35 = 1 and A31 <= current_year_end and A31 >= current_year_start and A10 = 20)	SET A_TODATE_QUALIFYING_SLN_PERIOD to 1 and go to 13	Go to 13
13	n/a	END	n/a

3. The following SPSS code illustrates how to derive A_TODATE_QUALIFYING_SLN_PERIOD.

Compute current_year_start = date.dmy(1, 8, 2006).
Compute current_year_end = date.dmy(31, 7, 2007).
FORMAT current_year_start current_year_end (DATE11).
COMPUTE A_TODATE_QUALIFYING_SLN_PERIOD = 0.
****Select using a 6 week period of grace.
COMPUTE qual_course_length_exp = MIN(CTIME.DAYS(a28),CTIME.DAYS(current_year_end))-MAX(CTIME.DAYS(a27),CTIME.DAYS(current_year_start)) + 1.
COMPUTE qual_course_length_act = MIN(CTIME.DAYS(a31),CTIME.DAYS(current_year_end))-MAX(CTIME.DAYS(a27),CTIME.DAYS(current_year_start)) + 1.
COMPUTE period_of_grace = 6 * 7.
DO IF (qual_course_length_exp < 14 AND inyear_course_prop > 0 AND a10 = 20).
COMPUTE A_TODATE_QUALIFYING_SLN_PERIOD = 1.
ELSE IF (qual_course_length_exp < 168 AND qual_course_length_act >= 14 AND a10 = 20).
COMPUTE A_TODATE_QUALIFYING_SLN_PERIOD = 1.
ELSE IF (qual_course_length_act >= period_of_grace AND a10 = 20).
COMPUTE A_TODATE_QUALIFYING_SLN_PERIOD = 1.
ELSE IF (A35 =1 AND inyear_course_prop > 0 and a31 <= current_year_end and a31 >= current_year_start AND A10 = 20).
COMPUTE A_TODATE_QUALIFYING_SLN_PERIOD = 1.
END IF.
IF (a28 < current_year_start) A_TODATE_QUALIFYING_SLN_PERIOD = 0.
IF (a35 = 1 and a31 <= current_year_end and a31 >= current_year_start and a10 = 20) A_TODATE_QUALIFYING_SLN_PERIOD = 1.

Date last modfied: 17th October 2008