PERIOD Data Definition 2009/2010

PERIOD

DATA DEFINITION

1. The latest period that the dataset contains.

PURPOSE

2. The period denotes the most recent month of data included in the dataset. Please note that this is only current to ER and ESF SR.

RELEVANT COLLECTIONS

  • ILR (LR)
  • ILR (ER)
  • ILR (UfI)
  • ILR (ESF SR)
  • ILR (ASL)

SOURCE DATA

3. The following variables are used as source data for the calculation of the Period data definition.

Field Name Label Dataset
Collection Collection (LR, ER, ESF SR, UFI, ASL) Aims Standard File

DERIVED VARIABLES AND DATASETS

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

Field Name Label Dataset
PERIOD PERIOD Collection Period Data Contains Learner, Aims, ESF and HE Standard Files

VALUES

5. The table below outlines the categories for PERIOD

Collection Month Period Number
August 1
September 2
October 3
November 4
December 5
January 6
February 7
March 8
April 9
May 10
June 11
July 12

DETAILED DEFINITION

6. For ER and ESF there are 12 collections per year, the Period field identifies the most recent month of data included in the dataset.

7. Note that this means previous period’s data are also included, for example, a dataset with a period value of 8 (PERIOD=8) would have data for periods 1 to 8 inclusive.

8. The month that each period relates to is summarised in the Values table above.

9. The following SPSS code illustrates how to derive PERIOD.

GET FILE = …………Aims Data set.
SORT CASES BY L01 L03 A05.
MATCH FILES
/FILE = *
/TABLE = ….. Aims Data set
/BY L01 L03 A05.

/*Create a temporary variables COLL5 and COLL13 to assist in the calculation of PERIOD by segregating the different collections.
COMPUTE COLL5=0.
COMPUTE COLL13=0.

IF ANY(CHAR.SUBSTR(COLLECTION,1,1),'C','F','U') COLL5=1.
IF ANY(CHAR.SUBSTR(COLLECTION,1,1),'W','S') COLL13=1.

IF COLL5=1 AND CHAR.SUBSTR(COLLECTION,3,1)='1' PERIOD=3.
IF COLL5=1 AND CHAR.SUBSTR(COLLECTION,3,1)='2' PERIOD=6.
IF COLL5=1 AND CHAR.SUBSTR(COLLECTION,3,1)='3' PERIOD=9.
IF COLL5=1 AND CHAR.SUBSTR(COLLECTION,3,1)='4' PERIOD=12.
IF COLL5=1 AND CHAR.SUBSTR(COLLECTION,3,1)='5' PERIOD=12.

IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='01' PERIOD=1.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='02' PERIOD=2.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='03' PERIOD=3.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='04' PERIOD=4.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='05' PERIOD=5.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='06' PERIOD=6.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='07' PERIOD=7.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='08' PERIOD=8.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='09' PERIOD=9.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='10' PERIOD=10.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='11' PERIOD=11.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='12' PERIOD=12.
IF COLL13=1 AND CHAR.SUBSTR(COLLECTION,2,2)='13' PERIOD=12.

EXECUTE.



10. The following SQL code illustrates how to derive PERIOD:

select

      L01, L03, A05
      , case when SUBSTRING(COLLECTION,2,2)='01' and COLL5=1 then 3
      when SUBSTRING(COLLECTION,2,2)='02' and COLL5=1 then 6
      when SUBSTRING(COLLECTION,2,2)='03' and COLL5=1 then 9
      when SUBSTRING(COLLECTION,2,2)='04' and COLL5=1 then 12
      when SUBSTRING(COLLECTION,2,2)='05' and COLL5=1 then 12
      when SUBSTRING(COLLECTION,2,2)='01' and COLL13=1 then 1
      when SUBSTRING(COLLECTION,2,2)='02' and COLL13=1 then 2
      when SUBSTRING(COLLECTION,2,2)='03' and COLL13=1 then 3
      when SUBSTRING(COLLECTION,2,2)='04' and COLL13=1 then 4
      when SUBSTRING(COLLECTION,2,2)='05' and COLL13=1 then 5
      when SUBSTRING(COLLECTION,2,2)='06' and COLL13=1 then 6
      when SUBSTRING(COLLECTION,2,2)='07' and COLL13=1 then 7
      when SUBSTRING(COLLECTION,2,2)='08' and COLL13=1 then 8
      when SUBSTRING(COLLECTION,2,2)='09' and COLL13=1 then 9
      when SUBSTRING(COLLECTION,2,2)='10' and COLL13=1 then 10
      when SUBSTRING(COLLECTION,2,2)='11' and COLL13=1 then 11
      when SUBSTRING(COLLECTION,2,2)='12' and COLL13=1 then 12
      when SUBSTRING(COLLECTION,2,2)='13' and COLL13=1 then 13
      end as PERIOD

from
     (
     select

           L01, L03, A05, COLLECTION
           , case when LEFT(COLLECTION,1) in ('W','S') then 1 else 0 end as COLL13
           , case when LEFT(COLLECTION,1) in ('C','F','U') then 1 else 0 end as COLL5

     from

           ILR0910_E_AIMS
     )T


Date last modified: 14th December 2009