Location of the Delivery Provider (Aim Level) Data Definition 2008/2009
A_DPLLSC, A_DPWARD, A_DPWA01, A_DPWA03, A_DPLA, A_DPREG
DATA DEFINITION
1. Identify the geographical areas in which the delivery provider is located, at aim level.
PURPOSE
2. These fields classify the geographical areas in which the delivery provider is located and are used in travel to learn analysis.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (UfI)
- ILR (ER)
- ILR (ESF SR)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of Location of the Delivery Provider (Aim Level).
| Field Name | Label | Dataset |
|---|
| A23 | A23 Delivery Location Postcode | Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name | Label | Dataset |
|---|
| A_DPLLSC | A_DPLLSC LLSC of the Aim Delivery Provider, based on the DP Postcode | Aims Standard File |
| A_DPWARD | A_DPWARD Local Authority Ward Code of the Aim Delivery Provider | Aims Standard File |
| A_DPWA01 | A_DPWA01 Local Authority Ward Code of the Aim Delivery Provider | Aims Standard File |
| A_DPWA03 | A_DPWA03 Local Authority Ward Code of the Aim Delivery povider | Aims Standard File |
| A_DPREG | A_DPREG Region of the Aim Delivery Provider, Based on the DP Postcode | Aims Standard File |
| A_DPLA | A_DPLA Local Authority based on the Aim DP Postcode | Aims Standard File |
VALUES
5. The table below outlines the categories for A_DPREG
| L25_REG value | Label |
|---|
| NC | National Employer Service |
| NS | National Apprenticeship Service |
| EE | East of England |
| EM | East Midlands |
| GL | Greater London |
| NE | North East |
| NW | North West |
| SE | South East |
| SW | South West |
| WM | West Midlands |
| YH | Yorkshire and the Humber |
| NO | National Office |
| NA | Not Applicable |
DETAILED DEFINITION
6. Delivery Location Postcode (A23) is matched to the postcode file for that year to obtain the LSC Office (A_DPLLSC), the region (A_DPREG), the Local Authority (A_DPLA) and the three local authority ward fields A_DPWARD, A_DPWA01 and A_DPWA03, that the delivery location is based in.
Location of the Delivery Provider (Aim Level) Sample Code
1. The following SPSS code is provided to illustrate the Location of the Delivery Provider (Aim Level) data definition.
A_DPLLSC, A_DPWARD, A_DPWA01, A_DPWA03, A_DPLA, A_DPREG
2. The following table shows the steps required to derive A_DPREG
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | If A_DPLLSC=2 | A_DPREG=NC | |
| 2 | If A_SPLLSC=3 | A_DPREG=NS | |
| 3 | If A_DPLLSC is in the inclusive range (60 to 110) | A_DPREG=EE | |
| 4 | If A_DPLLSC is in the inclusive range (10 to 50) | A_DPREG=EM | |
| 5 | If A_DPLLSC is in the inclusive range (120 to 160) | A_DPREG=GL | |
| 6 | If A_DPLLSC is in the inclusive range (170 to 200) | A_DPREG=NE | |
| 7 | If A_DPLLSC is in the inclusive range (210 to 250) | A_DPREG=NW | |
| 8 | If A_DPLLSC is in the inclusive range (260 to 310) | A_DPREG=SE | |
| 9 | If A_DPLLSC is in the inclusive range (320 to 370) | A_DPREG=SW | |
| 10 | If A_DPLLSC is in the inclusive range (380 to 430) | A_DPREG=WM | |
| 11 | If A_DPLLSC is in the inclusive range (440 to 470) | A_DPREG=YH | |
| 12 | If A_DPLLSC=490 | A_DPREG=NO | |
| 13 | If no value in A_DPLLSC | A_DPREG=NA | |
3. The following SPSS code illustrates how to match Location of the Delivery Provider fields on to the Learner data set.
GET FILE '………………..AIMS data set'.SORT CASES BY A23. /* Rename the delivery providers postcode so that it matches the name of the postcode field in the postcode file.
RENAME VARIABLES (A23=postcode).
MATCH FILES /FILE=*
/TABLE = '…………………………POSCTODE data set.sav'
/BY POSTCODE. /* Calculate the region and the llsc of the delivery provider from the LSC_91 field in the postcode file, only calculated for England.
RENAME VARIABLES (LLSC=A_DPLLSC) (LAUAcode=A_DPLA) (WARD_91=A_DPWARD) (WARD_01=A_DPWA01) (WARD_04=A_DPWA03) (POSTCODE=A23)
VARIABLE LABELS A_DPLLSC 'A_DPLLSC LLSC of the Aim Delivery Provider, based on the DP Postcode'
/A_DPWARD 'A_DPWARD Local Authority Ward Code of the Aim Delivery Provider'
/A_DPWA01 'A_DPWA01 Local Authority Ward Code of the Aim Delivery Provider'
/A_DPWA03 'A_DPWA03 Local Authority Ward Code of the Aim Delivery Provider'
/A_DPLA 'A_DPLA Local Authority Based on the Aim DP Postcode'. IF A_DPLLSC=2 A_DPREG='NC'.
If A_DPLLSC=3 A_DPREG='NS'.
IF RANGE(A_DPLLSC, 60, 110) A_DPREG='EE'.
IF RANGE(A_DPLLSC, 10, 50) A_DPREG='EM'.
IF RANGE(A_DPLLSC, 120, 160) A_DPREG='GL'.
IF RANGE(A_DPLLSC, 170, 200) A_DPREG='NE'.
IF RANGE(A_DPLLSC, 210, 250) A_DPREG='NW'.
IF RANGE(A_DPLLSC, 260, 310) A_DPREG='SE'.
IF RANGE(A_DPLLSC, 320, 370) A_DPREG='SW'.
IF RANGE(A_DPLLSC, 380, 430) A_DPREG='WM'.
IF RANGE(A_DPLLSC, 440, 470) A_DPREG='YH'.
IF A_DPLLSC=490 A_DPREG='NO'.
IF MISSING(A_DPLLSC) OR DPLLSC=-1 A_DPREG='NA'.
VARIABLE LABELS A_DPREG 'A_DPREG Region of the Aim Delivery Provider, Based on the DP Postcode' |
Date last modfied: 19th January 2009
