Start Period Data Definition 2008/2009
A_STARTP, E_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 |
| E08 | E08 Date Started ESF Co-Financing | ESF 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 |
| E_STARTP | E_STARTP - Period Started in | ESF Standard File |
VALUES
5. The table below outlines the categories for A_STARTP, E_STARTP
| Value | 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 |
| 99 | After 31 July 2009 |
DETAILED DEFINITION
6. If the Learning Start Date (A27) or Date Started ESF Co-Financing (E08) 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 SPSS 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/Action if true | Action if false |
|---|
| 1 | Does A_STARTP contain a value | None | Set A_STARTP = -1 |
3. The following SPSS code illustrates how to derive A_STARTP.
GET FILE=’……….Aims dataset’.
IF A27 < DATE.DMY(1,8, current academic year) A_STARTP=-99.
DO IF XDATE.YEAR(A27)=current academic year.
IF XDATE.MON(A27)=8 A_STARTP=1.
IF XDATE.MON(A27)=9 A_STARTP=2.
IF XDATE.MON(A27)=10 A_STARTP=3.
IF XDATE.MON(A27)=11 A_STARTP=4.
IF XDATE.MON(A27)=12 A_STARTP=5.
ELSE IF XDATE.YEAR(A27)=current academic year+1.
IF XDATE.MON(A27)=1 A_STARTP=6.
IF XDATE.MON(A27)=2 A_STARTP=7.
IF XDATE.MON(A27)=3 A_STARTP=8.
IF XDATE.MON(A27)=4 A_STARTP=9.
IF XDATE.MON(A27)=5 A_STARTP=10.
IF XDATE.MON(A27)=6 A_STARTP=11.
IF XDATE.MON(A27)=7 A_STARTP=12.
END IF.
IF A27 > DATE.DMY(31,7, current academic year+1) A_STARTP=99. VARIABLE LABELS A_STARTP "A_STARTP Period Started in".
VALUE LABELS A_STARTP -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"
99 “After 31 July current academic year “. |
E_STARTP
4. The following table shows the steps required to derive E_STARTP
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Is E08< 1 Aug Current Academic year | Set E_STARTP to -99 | Go to 2 |
| 2 | Is E08> 31 Jul Current Academic year | Set E_STARTP to 99 | Go to 3 |
| 3 | Is the month of E08 = Aug | Set E_STARTP to 1 | Go to 4 |
| 4 | Is the month of E08 = Sep | Set E_STARTP to 2 | Go to 5 |
| 5 | Is the month of E08 = Oct | Set E_STARTP to 3 | Go to 6 |
| 6 | Is the month of E08 = Nov | Set E_STARTP to 4 | Go to 7 |
| 7 | Is the month of E08 = Dec | Set E_STARTP to 5 | Go to 8 |
| 8 | Is the month of E08 = Jan | Set E_STARTP to 6 | Go to 9 |
| 9 | Is the month of E08 = Feb | Set E_STARTP to 7 | Go to 10 |
| 10 | Is the month of E08 = Mar | Set E_STARTP to 8 | Go to 11 |
| 11 | Is the month of E08 = Apr | Set E_STARTP to 9 | Go to 12 |
| 12 | Is the month of E08 = May | Set E_STARTP to 10 | Go to 13 |
| 13 | Is the month of E08 = Jun | Set E_STARTP to 11 | Go to 14 |
| 14 | Is the month of E08 = Jul | Set E_STARTP to 12 | |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does E_STARTP contain a value | None | Set E_STARTP = -1 |
5. The following SPSS code illustrates how to derive E_STARTP.
GET FILE=’……….ESF dataset’. IF E08 < DATE>DMY(1,8, current academic year) E_STARTP=-99.
DO IF XDATE.YEAR(E08)=current academic year.
IF XDATE.MON(E08)=8 E_STARTP=1.
IF XDATE.MON(E08)=9 E_STARTP=2.
IF XDATE.MON(E08)=10 E_STARTP=3.
IF XDATE.MON(E08)=11 E_STARTP=4.
IF XDATE.MON(E08)=12 E_STARTP=5.
ELSE IF XDATE.YEAR(E08)=current academic year+1.
IF XDATE.MON(E08)=1 E_STARTP=6.
IF XDATE.MON(E08)=2 E_STARTP=7.
IF XDATE.MON(E08)=3 E_STARTP=8.
IF XDATE.MON(E08)=4 E_STARTP=9.
IF XDATE.MON(E08)=5 E_STARTP=10.
IF XDATE.MON(E08)=6 E_STARTP=11.
IF XDATE.MON(E08)=7 E_STARTP=12.
END IF.
IF E08 > DATE.DMY(31,7, current academic year+1) E_STARTP=99. VARIABLE LABELS E_STARTP "E_STARTP Period Started in".
VALUE LABELS E_STARTP -99 "Before 1 August 04"
-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"
99 “After 31 July current academic year “. |
Date last modified: 19th January 2009
