Leave Period Data Definition 2009/2010
A_LEAVEP
DATA DEFINITION
1. Indicates the period a learner left the aim.
PURPOSE
2. To identify the monthly period that an aim ended in.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of Period a Learner Left the Aim.
| Field Name |
Label |
Dataset |
| A31 |
A31 Learning Actual End Date |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_LEAVEP |
A_LEAVEP Period Left in |
ER Aims Standard File |
VALUES
5. The table below outlines the values for A_LEAVEP
A_LEAVEP
Values |
Label |
| -99 |
Before 1 August 2008 |
| 1 |
Period 1 |
| 2 |
Period 2 |
| 3 |
Period 3 |
| 4 |
Period 4 |
| 5 |
Period 5 |
| 6 |
Period 6 |
| 7 |
Period 7 |
| 8 |
Period 8 |
| 9 |
Period 9 |
| 10 |
Period 10 |
| 11 |
Period 11 |
| 12 |
Period 12 |
| 50 |
Continuing |
| 99 |
After 31 July 2009 |
DETAILED DEFINITION
6. If the Learning Actual End Date (A31) of the aim occurs during the period, then that period is determined to be the period that the aim ended in.
Leave Period Sample Code
1. The following SPSS code is provided to illustrate the Leave Period data definition.
A_LEAVEP
2. The following table shows the steps required to derive A_LEAVEP
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is A31< 1 Aug Current Academic year |
Set A_LEAVEP to -99 |
Go to 2 |
| 2 |
Is A31> 31 Jul Current Academic year + 1 |
Set A_LEAVEP to 99 |
Go to 3 |
| 3 |
Is the month of A31 = Aug |
Set A_ LEAVEP to 1 |
Go to 4 |
| 4 |
Is the month of A31 = Sep |
Set A_ LEAVEP to 2 |
Go to 5 |
| 5 |
Is the month of A31 = Oct |
Set A_ LEAVEP to 3 |
Go to 6 |
| 6 |
Is the month of A31 = Nov |
Set A_ LEAVEP to 4 |
Go to 7 |
| 7 |
Is the month of A31 = Dec |
Set A_ LEAVEP to 5 |
Go to 8 |
| 8 |
Is the month of A31 = Jan |
Set A_ LEAVEP to 6 |
Go to 9 |
| 9 |
Is the month of A31 = Feb |
Set A_ LEAVEP to 7 |
Go to 10 |
| 10 |
Is the month of A31 = Mar |
Set A_ LEAVEP to 8 |
Go to 11 |
| 11 |
Is the month of A31 = Apr |
Set A_ LEAVEP to 9 |
Go to 12 |
| 12 |
Is the month of A31 = May |
Set A_ LEAVEP to 10 |
Go to 13 |
| 13 |
Is the month of A31 = Jun |
Set A_ LEAVEP to 11 |
Go to 14 |
| 14 |
Is the month of A31 = Jul |
Set A_ LEAVEP to 12 |
Go to 15 |
| 15 |
Else |
Set A_ LEAVEP to 50 |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A_ LEAVEP contain a value |
None |
Set A_ LEAVEP = -1 |
3. The following SPSS code illustrates how to derive A_LEAVEP.
|
GET FILE=’……….Aims dataset’.
DO IF XDATE.YEAR(A31)=current academic year.
IF XDATE.MON(A31)=8 A_LEAVEP=1.
IF XDATE.MON(A31)=9 A_LEAVEP=2.
IF XDATE.MON(A31)=10 A_LEAVEP=3.
IF XDATE.MON(A31)=11 A_LEAVEP=4.
IF XDATE.MON(A31)=12 A_LEAVEP=5.
ELSE IF XDATE.YEAR(A31)=current academic year+1.
IF XDATE.MON(A31)=1 A_LEAVEP=6.
IF XDATE.MON(A31)=2 A_LEAVEP=7.
IF XDATE.MON(A31)=3 A_LEAVEP=8.
IF XDATE.MON(A31)=4 A_LEAVEP=9.
IF XDATE.MON(A31)=5 A_LEAVEP=10.
IF XDATE.MON(A31)=6 A_LEAVEP=11.
IF XDATE.MON(A31)=7 A_LEAVEP=12.
END IF.
IF MISSING(A31) A_LEAVEP=50.
IF A31<DATE.DMY(1,8,current academic year) A_LEAVEP=-99.
IF A31>DATE.DMY(31,7,current academic year+1) A_LEAVEP=99.
VARIABLE LABELS A_LEAVEP "A_LEAVEP Period Left in"
VALUE LABELS A_LEAVEP -99 "Before 1 August current academic year"
1 "Period 1"
2 "Period 2"
3 "Period 3"
4 "Period 4"
5 "Period 5"
6 "Period 6"
7 "Period 7"
8 "Period 8"
9 "Period 9"
10 "Period 10"
11 "Period 11"
12 "Period 12"
50 "Continuing"
99 "After 31 July current academic year". |
4. The following SQL code illustrates how to derive A_LEAVEP:
|
select
L01, L03, A05
, case when A31<'1 august 2009' then -99
when A31>'31 july 2010' then 99
when datepart(month,A31)=8 then 1
when datepart(month,A31)=9 then 2
when datepart(month,A31)=10 then 3
when datepart(month,A31)=11 then 4
when datepart(month,A31)=12 then 5
when datepart(month,A31)=1 then 6
when datepart(month,A31)=2 then 7
when datepart(month,A31)=3 then 8
when datepart(month,A31)=4 then 9
when datepart(month,A31)=5 then 10
when datepart(month,A31)=6 then 11
when datepart(month,A31)=7 then 12
else 50 end as A_LEAVEP
from
dbo.ILR0910_E_AIMS |
Date last modified: 02nd December 2009
