Start Period Data Definition 2010/11
A_STARTP
DATA DEFINITION
1. Indicates the period a learner started the aim.
PURPOSE
2. To enable monitoring of the number of aims that learners started per period over the academic year.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of Period a Learner Started the Aim.
| Field Name |
Label |
Dataset |
| A27 |
A27 Learning Start Date |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_STARTP |
A_STARTP - Period Started in |
ER Aims Standard File |
VALUES
5. The table below outlines the categories for A_STARTP
| Value |
Label |
| -99 |
Before 1 August 2010 |
| 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 |
| 99 |
After 31 July 2011 |
| -1 |
Not Applicable/Not Known |
DETAILED DEFINITION
6. If the Learning Start Date (A27) of the aim occurs during the period, then that period is determined to be the period that the aim started in.
Start Period Sample Code
1. The following SQL code is provided to illustrate the Start Period data definition.
A_STARTP
2. The following table shows the steps required to derive A_STARTP
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is A27< 1 Aug Current Academic year |
Set A_STARTP to -99 |
Go to 2 |
| 2 |
Is A27> 31 Jul Current Academic year + 1 |
Set A_STARTP to 99 |
Go to 3 |
| 3 |
Is the month of A27 = Aug |
Set A_STARTP to 1 |
Go to 4 |
| 4 |
Is the month of A27 = Sep |
Set A_STARTP to 2 |
Go to 5 |
| 5 |
Is the month of A27 = Oct |
Set A_STARTP to 3 |
Go to 6 |
| 6 |
Is the month of A27 = Nov |
Set A_STARTP to 4 |
Go to 7 |
| 7 |
Is the month of A27 = Dec |
Set A_STARTP to 5 |
Go to 8 |
| 8 |
Is the month of A27 = Jan |
Set A_STARTP to 6 |
Go to 9 |
| 9 |
Is the month of A27 = Feb |
Set A_STARTP to 7 |
Go to 10 |
| 10 |
Is the month of A27 = Mar |
Set A_STARTP to 8 |
Go to 11 |
| 11 |
Is the month of A27 = Apr |
Set A_STARTP to 9 |
Go to 12 |
| 12 |
Is the month of A27 = May |
Set A_STARTP to 10 |
Go to 13 |
| 13 |
Is the month of A27 = Jun |
Set A_STARTP to 11 |
Go to 14 |
| 14 |
Is the month of A27 = Jul |
Set A_STARTP to 12 |
|
| Step |
Condition |
Action if true |
Action if false |
| 1 |
Does A_STARTP contain a value |
None |
Set A_STARTP = -1 |
3. The following SQL code illustrates how to derive A_STARTP:
|
select
L01, L03, A05
, case when A27<'1 august 2009' then -99
when A27>'31 july 2010' then 99
when datepart(month,A27)=8 then 1
when datepart(month,A27)=9 then 2
when datepart(month,A27)=10 then 3
when datepart(month,A27)=11 then 4
when datepart(month,A27)=12 then 5
when datepart(month,A27)=1 then 6
when datepart(month,A27)=2 then 7
when datepart(month,A27)=3 then 8
when datepart(month,A27)=4 then 9
when datepart(month,A27)=5 then 10
when datepart(month,A27)=6 then 11
when datepart(month,A27)=7 then 12
else -1 end as A_STARTP
from
ILR0910_E_AIMS |
Date last modified: 22 December 2010
