Leave Period Data Definition 2008/2009

A_LEAVEP, E_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

  • ILR (ER)
  • ILR (ESF SR)

    SOURCE DATA

    3. The following variables are used as source data for the calculation of Period a Learner Left the Aim.

    Field NameLabelDataset
    A31A31 Learning Actual End DateAims Standard File
    E10E10 Date Ended ESF Co-FinancingESF Standard File

    DERIVED VARIABLES AND DATASETS

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

    Field NameLabelDataset
    A_LEAVEPA_LEAVEP Period Left inER Aims Standard File
    E_LEAVEPE_LEAVEP Period Left inESF Standard File

    VALUES

    5. The table below outlines the values for A_LEAVEP, E_LEAVEP

    A_LEAVEP
    Values    		Label
    -99Before 1 August 2008
    1Period 1
    2Period 2
    3Period 3
    4Period 4
    5Period 5
    6Period 6
    7Period 7
    8Period 8
    9Period 9
    10Period 10
    11Period 11
    12Period 12
    99After 31 July 2009

    DETAILED DEFINITION

    6. If the Learning Actual End Date (A31) or Date Ended ESF Co-Financing (E10) 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

    StepConditionAction/Action if trueAction if false
    1Is A31< 1 Aug Current Academic yearSet A_LEAVEP to -99Go to 2
    2Is A31> 31 Jul Current Academic year + 1Set A_LEAVEP to 99Go to 3
    3Is the month of A31 = AugSet A_ LEAVEP to 1 Go to 4
    4Is the month of A31 = SepSet A_ LEAVEP to 2 Go to 5
    5Is the month of A31 = OctSet A_ LEAVEP to 3 Go to 6
    6Is the month of A31 = NovSet A_ LEAVEP to 4 Go to 7
    7Is the month of A31 = DecSet A_ LEAVEP to 5 Go to 8
    8Is the month of A31 = JanSet A_ LEAVEP to 6 Go to 9
    9Is the month of A31 = FebSet A_ LEAVEP to 7 Go to 10
    10Is the month of A31 = MarSet A_ LEAVEP to 8 Go to 11
    11Is the month of A31 = AprSet A_ LEAVEP to 9 Go to 12
    12Is the month of A31 = MaySet A_ LEAVEP to 10 Go to 13
    13Is the month of A31 = JunSet A_ LEAVEP to 11 Go to 14
    14Is the month of A31 = JulSet A_ LEAVEP to 12 Go to 15
    15ElseSet A_ LEAVEP to 50

    StepConditionAction/Action if trueAction if false
    1Does A_ LEAVEP contain a valueNoneSet 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".

    E_LEAVEP

    4. The following table shows the steps required to derive E_LEAVEP

    StepConditionAction/Action if trueAction if false
    1Is E10< 1 Aug Current Academic yearSet E_LEAVEP to -99Go to 2
    2Is E10> 31 Jul Current Academic year + 1Set E_LEAVEP to 99Go to 3
    3Is the month of E10 = AugSet E_ LEAVEP to 1 Go to 4
    4Is the month of E10 = SepSet E_ LEAVEP to 2 Go to 5
    5Is the month of E10 = OctSet E_ LEAVEP to 3 Go to 6
    6Is the month of E10 = NovSet E_ LEAVEP to 4 Go to 7
    7Is the month of E10 = DecSet E_ LEAVEP to 5 Go to 8
    8Is the month of E10 = JanSet E_ LEAVEP to 6 Go to 9
    9Is the month of E10 = FebSet E_ LEAVEP to 7 Go to 10
    10Is the month of E10 = MarSet E_ LEAVEP to 8 Go to 11
    11Is the month of E10 = AprSet E_ LEAVEP to 9 Go to 12
    12Is the month of E10 = MaySet E_ LEAVEP to 10 Go to 13
    13Is the month of E10 = JunSet E_ LEAVEP to 11 Go to 14
    14Is the month of E10 = JulSet E_ LEAVEP to 12 Go to 15
    15ElseSet E_ LEAVEP to 50 

    StepConditionAction/Action if trueAction if false
    1Does E_LEAVEP contain a valueNoneSet E_LEAVEP = -1

    5. The following SPSS code illustrates how to derive A_LEAVEP, E_LEAVEP.

    GET FILE=’……….Aims dataset’.
    DO IF XDATE.YEAR(E10)=current academic year.
     IF XDATE.MON(E10)=8 E_LEAVEP=1.
     IF XDATE.MON(E10)=9 E_LEAVEP=2.
     IF XDATE.MON(E10)=10 E_LEAVEP=3.
     IF XDATE.MON(E10)=11 E_LEAVEP=4.
     IF XDATE.MON(E10)=12 E_LEAVEP=5.
    ELSE IF XDATE.YEAR(E10)=current academic year+1.
     IF XDATE.MON(E10)=1 E_LEAVEP=6.
     IF XDATE.MON(E10)=2 E_LEAVEP=7.
     IF XDATE.MON(E10)=3 E_LEAVEP=8.
     IF XDATE.MON(E10)=4 E_LEAVEP=9.
     IF XDATE.MON(E10)=5 E_LEAVEP=10.
     IF XDATE.MON(E10)=6 E_LEAVEP=11.
     IF XDATE.MON(E10)=7 E_LEAVEP=12.
    END IF.
    IF MISSING(E10) E_LEAVEP=50.
    IF E10<date.DMY(1,8,current academic year) E_LEAVEP=-99.
    IF E10>DATE.DMY(31,7,current academic year+1) E_LEAVEP=99.

    VARIABLE LABELS E_LEAVEP "E_LEAVEP Period Left in"
    VALUE LABELS E_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".


    Date last modified: 19th January 2009