ACT_ MONTHS_IN_YEAR, EXP_MONTHS Data Definition

DATA DEFINITION

1. The actual number of months a learner is present during the year and the expected number of months a learner is present for Employer responsive provision.

RELEVANT COLLECTIONS

  • ILR (FE)

SOURCE DATA

2. The following variables are used as source data for the calculation of ACT_ MONTHS_IN_YEAR, EXP_MONTHS.

Field Name Label Dataset
Current_year_start* Start date of the current year (eg 1 August 2006 for 2006/07)  
Current_year_end* End date of the current year (eg 31 July 2007 for 2006/07)  
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
A34 Completion Status ILR learning aim dataset
A35 Learning outcome ILR learning aim dataset
IL_P1 to IL_P12 In learning count Derived as part of the calculation
A31_1 New Learning actual End date (A31 +1 day) Derived as part of the calculation
A28_1 New Learning planned end date (A28 + 1 day) Derived as part of the calculation
MONTHS_REMAINING The number of months between the learning planned end date and the Learning actual end date for learners who have completed early Derived as part of the calculation

DERIVED VARIABLES AND DATASETS

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

Field Name Label Dataset
ACTUAL_MONTHS_INYEAR The actual number of months spent in learning on the aim in the current year  
EXP_MONTH The expected number of months to be spent in learning on the aim in the current year.  

VALUES

4. The tables below outline the categories for ACT_ MONTHS_IN_YEAR, EXP_MONTHS

Values for ACT_MONTHS_IN_YEAR Label
1 -12 The actual number of months spent in learning on the aim in the current year.

Values for EXP_MONTHS Label
1 -12 The number of months expected to be spent in learning on the aim in the current year.

ACT_ MONTHS_IN_YEAR, EXP_MONTHS Sample Code

1. The following SPSS code is provided to illustrate the ACT_ MONTHS_IN_YEAR, EXP_MONTHS derived variables.

ACT_ MONTHS_IN_YEAR, EXP_MONTHS

2. The following table shows the steps required to derive ACT_ MONTHS_IN_YEAR, EXP_MONTHS

Step Condition Action/Action if true Action if false
4 Is the learning aim start date earlier than or on 30/09/06 AND is the learning planned end date later than or on 30/09/06 AND is the learner either continuing or has and actual end date of 30/09/06 or later.(IF A27 <= 30/09/06 AND A28 >= 30/09/06 AND (a34 = 1 OR A31 >= 30/09/06) Set il_P2 to 1 go to 5 Set il_P2 to 0 and go to 5
5 Is the learning aim start date earlier than or on 31/10/06 AND is the learning planned end date later than or on 31/10/06 AND is the learner either continuing or has and actual end date of 31/10/06 or later.(IF A27 <= 31/10/06 AND A28 >= 31/10/06 AND (a34 = 1 OR A31 >= 31/10/06) Set il_P3 to 1 go to 6 Set il_P3 to 0 and go to 6
6 Is the learning aim start date earlier than or on 30/11/06 AND is the learning planned end date later than or on 30/11/06 AND is the learner either continuing or has and actual end date of 30/11/06 or later.(IF A27 <= 30/11/06 AND A28 >= 30/11/06 AND (a34 = 1 OR A31 >= 30/11/06) Set il_P4 to 1 go to 7 Set il_P4 to 0 and go to 7
7 Is the learning aim start date earlier than or on 31/12/06 AND is the learning planned end date later than or on 31/12/06 AND is the learner either continuing or has and actual end date of 31/12/06 or later.(IF A27 <= 31/12/06 AND A28 >= 31/12/06 AND (a34 = 1 OR A31 >= 31/12/06) Set il_P5 to 1 go to 8 Set il_P5 to 0 and go to 8
8 Is the learning aim start date earlier than or on 31/01/07 AND is the learning planned end date later than or on 31/01/07 AND is the learner either continuing or has and actual end date of 31/01/07 or later.(IF A27 <= 31/01/07 AND A28 >= 31/01/07 AND (a34 = 1 OR A31 >= 31/01/07) Set il_P6 to 1 go to 9 Set il_P6 to 0 and go to 9
9 Is the learning aim start date earlier than or on 28/02/07 AND is the learning planned end date later than or on 28/02/07 AND is the learner either continuing or has and actual end date of 28/02/07 or later.(IF A27 <= 28/02/07 AND A28 >= 28/02/07 AND (a34 = 1 OR A31 >= 28/02/07) Set il_P7 to 1 go to 10 Set il_P7 to 0 and go to 10
10 Is the learning aim start date earlier than or on 31/03/07 AND is the learning planned end date later than or on 31/03/07 AND is the learner either continuing or has and actual end date of 31/03/07 or later.(IF A27 <= 31/03/07 AND A28 >= 31/03/07 AND (a34 = 1 OR A31 >= 31/03/07) Set il_P8 to 1 go to 11 Set il_P8 to 0 and go to 11
11 Is the learning aim start date earlier than or on 30/04/07 AND is the learning planned end date later than or on 30/04/07 AND is the learner either continuing or has and actual end date of 30/04/07 or later.(IF A27 <= 30/04/07 AND A28 >= 30/04/07 AND (a34 = 1 OR A31 >= 30/04/07) Set il_P9 to 1 go to 12 Set il_P9 to 0 and go to 12
12 Is the learning aim start date earlier than or on 31/05/07 AND is the learning planned end date later than or on 31/05/07 AND is the learner either continuing or has and actual end date of 31/05/07 or later.(IF A27 <= 31/05/07 AND A28 >= 31/05/07 AND (a34 = 1 OR A31 >= 31/05/07) Set il_P10 to 1 go to 13 Set il_P10 to 0 and go to 13
13 Is the learning aim start date earlier than or on 30/06/07 AND is the learning planned end date later than or on 30/06/07 AND is the learner either continuing or has and actual end date of 30/06/07 or later.(IF A27 <= 30/06/07 AND A28 >= 30/06/07 AND (a34 = 1 OR A31 >= 30/06/07) Set il_P11 to 1 go to 14 Set il_P11 to 0 and go to 14
14 Is the learning aim start date earlier than or on 31/07/07 AND is the learning planned end date later than or on 31/07/07 AND is the learner either continuing or has and actual end date of 31/07/07 or later.(IF A27 <= 31/07/07 AND A28 >= 31/07/07 AND (a34 = 1 OR A31 >= 31/07/07) Set il_P12 to 1 go to 15 Set il_P12 to 0 and go to 15
15 n/a Create a new Learning planned end date variable (A28_1) and a new learning actual end date variable (A31_1) and set them to the existing dates + 1 day (A28 + 1 day, A31 + 1 day). Go to 16 n/a
16 Calculate the number of months the learner is expected to be present for , adding an extra month if the original planned end date is the last day of the month. Set EXP_MONTHS to the difference in months between the new learning planned end date and the new (A28_1) and the learning aim start date (A27). Go to 17 n/a
17 Has the learner ended early. Completion status does not equal continuing and the learning planned end date is after the learning actual end date.(IF (A34 <> 1 AND A28 > A31). Set MONTHS_REMAINING to the difference in months between the new learning planned end date and the new (A28_1) and the new learning aim start date (A31_1). Go to 18 Set MONTHS_REMAINING to 0. Go to 18
18 n/a Set ACT_MONTHS_IN_YEAR to IL_P1 + IL_P2 + IL_P3 + IL_P4 + IL_P5 + IL_P6 + IL_P7 + IL_P8 + IL_P9 + IL_P10 + IL_P11 + IL_P12. n/a
18 Has the learner achieved in the current year.(IF (A35 = 1 AND A31 <= current_year_end AND A31 >= current_year_start). Set ACT_MONTHS_IN_YEAR to ACT_MONTHS_IN_YEAR + MONTHS_REMAINING go to 19 Go to 19
19 Does the learning aim start and finish in the same month and is not planned to finish on a month end. (IF the year of A28 = the year of A27 AND the month of A28 = Month of A27 AND EXP_MONTHS =0. Set EXP_MONTHS to 1 and Set ACT_MONTHS_IN_YEAR to 1. Go to 20. Go to 20
20 n/a END n/a

3. The following SPSS code illustrates how to derive ACT_ MONTHS_IN_YEAR, EXP_MONTHS.

IF (a27<=DATE.DMY(31,08,2006) AND a28>=DATE.DMY(31,08,2006) AND (a34 = 1 OR a31>=DATE.DMY(31,08,2006))) il_p1 = 1.

IF (a27<=DATE.DMY(30,09,2006) AND a28>=DATE.DMY(30,09,2006) AND (a34 = 1 OR a31>=DATE.DMY(30,09,2006))) il_p2 = 1.

IF (a27<=DATE.DMY(31,10,2006) AND a28>=DATE.DMY(31,10,2006) AND (a34 = 1 OR a31>=DATE.DMY(31,10,2006))) il_p3 = 1.

IF (a27<=DATE.DMY(30,11,2006) AND a28>=DATE.DMY(30,11,2006) AND (a34 = 1 OR a31>=DATE.DMY(30,11,2006))) il_p4 = 1.

IF (a27<=DATE.DMY(31,12,2006) AND a28>=DATE.DMY(31,12,2006) AND (a34 = 1 OR a31>=DATE.DMY(31,12,2006))) il_p5 = 1.

IF (a27<=DATE.DMY(31,01,2007) AND a28>=DATE.DMY(31,01,2007) AND (a34 = 1 OR a31>=DATE.DMY(31,01,2007))) il_p6 = 1.

IF (a27<=DATE.DMY(28,02,2007) AND a28>=DATE.DMY(28,02,2007) AND (a34 = 1 OR a31>=DATE.DMY(28,02,2007))) il_p7 = 1.

IF (a27<=DATE.DMY(31,03,2007) AND a28>=DATE.DMY(31,03,2007) AND (a34 = 1 OR a31>=DATE.DMY(31,03,2007))) il_p8 = 1.

IF (a27<=DATE.DMY(30,04,2007) AND a28>=DATE.DMY(30,04,2007) AND (a34 = 1 OR a31>=DATE.DMY(30,04,2007))) il_p9 = 1.

IF (a27<=DATE.DMY(31,05,2007) AND a28>=DATE.DMY(31,05,2007) AND (a34 = 1 OR a31>=DATE.DMY(31,05,2007))) il_p10 = 1.

IF (a27<=DATE.DMY(30,06,2007) AND a28>=DATE.DMY(30,06,2007) AND (a34 = 1 OR a31>=DATE.DMY(30,06,2007))) il_p11 = 1.

IF (a27<=DATE.DMY(31,07,2007) AND a28>=DATE.DMY(31,07,2007) AND (a34 = 1 OR a31>=DATE.DMY(31,07,2007))) il_p12 = 1.

RECODE il_p1 il_p2 il_p3 il_p4 il_p5 il_p6 il_p7 il_p8 il_p9 il_p10 il_p11 il_p12 (sysmis = 0) (else = copy).

*Create new planned and actual end date variables that are set one day after the actual variables (this helps with calculating year end values).

Compute a28_1 = a28 + 60*60*24.

Compute a31_1 = a31 + 60*60*24.

FORMAT a28_1 a31_1 (DATE11).

*Calculate the number of months the learner is expected to be present for, adding an extra month if they plan to end on the last day of the month.

COMPUTE exp_months = DATEDIFF(DATE.DMY(2,XDATE.Month(a28_1),XDATE.Year(a28_1)),DATE.DMY(1,XDATE.Month(a27),XDATE.Year(a27)),'months').

*If the learner ends early, calculate how many months are remaining (similar to above), but removing a month if the learner leaves on the last day of the month.

COMPUTE months_remaining = 0.

IF (a34 <> 1 AND a28 > a31) months_remaining = DATEDIFF(DATE.DMY(2,XDATE.Month(a28_1),XDATE.Year(a28_1)),DATE.DMY(1,XDATE.Month(a31_1),XDATE.Year(a31_1)),'months').

*Add up number of payment months qualified for in this year and add on a balancing payment.

COMPUTE act_months_inyear = il_p1 + il_p2 + il_p3 + il_p4 + il_p5 + il_p6 + il_p7 + il_p8 + il_p9 + il_p10 + il_p11 + il_p12.

IF (a35 = 1 and a31 <= current_year_end and a31 >= current_year_start) act_months_inyear = act_months_inyear + months_remaining.

*Courses that start and finish in the same month and are not planned to finish on a month end.

DO IF(XDATE.YEAR(a28)=XDATE.YEAR(a27) AND XDATE.MONTH(a28)=XDATE.MONTH(a27) AND exp_months = 0).

COMPUTE exp_months = 1.

COMPUTE act_months_inyear = 1.

END IF.

Date last modfied: 17th October 2008