Location of the Delivery Provider (Aim Level) Data Definition 2009/2010
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_DPLLSC=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' |
4. The following SPSS code illustrates how to match Location of the Delivery Provider fields on to the Learner data set.
|
select
L01, L03, A05
,Pst_LOCAL_AUTHORITY as A_DPLA
,Pst_LLSC as A_DPLLSC
,Pst_WARD as A_DPWA03
,Pst_WARD_01 as A_DPWA01
,Pst_WARD_91 as A_DPWARD
from
dbo.ILR0910_E_AIMS aims
left outer join
dbo.postcode0910 post
on aims.A23=post.pst_postcode
--A_DPREG
select
L01, L03, A05
, case when A_DPLLSC=2 then 'NC'
when A_DPLLSC=3 then 'NS'
when A_DPLLSC>=60 and A_DPLLSC<=110 then 'EE'
when A_DPLLSC>=10 and A_DPLLSC<=50 then 'EM'
when A_DPLLSC>=120 and A_DPLLSC<=160 then 'GL'
when A_DPLLSC>=170 and A_DPLLSC<=200 then 'NE'
when A_DPLLSC>=210 and A_DPLLSC<=250 then 'NW'
when A_DPLLSC>=260 and A_DPLLSC<=310 then 'SE'
when A_DPLLSC>=320 and A_DPLLSC<=370 then 'SW'
when A_DPLLSC>=380 and A_DPLLSC<=430 then 'WM'
when A_DPLLSC>=440 and A_DPLLSC<=470 then 'YH'
when A_DPLLSC=490 then 'NO'
else 'NA' end as A_DPREG
from
dbo.ILR0910_E_AIMS
|
Date last modfied: 07th January 2010
