Location of the Delivery Provider (Learner Level) Data Definition 2008/2009
L_DPLLSC, L_DPWARD, L_DPWA01, L_DPWA03, L_DPREG, L_DPLA
DATA DEFINITION
1. Identify the geographical areas in which the delivery provider is located, at learner 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 (Learner Level).
|
Field Name
|
Label
|
Dataset
|
| L_A23 |
L_A23 Learner Level Delivery Location Postcode |
Learner Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
|
Field Name
|
Label
|
Dataset
|
| L_DPLLSC |
L_DPLLSC LLSC of the Delivery Location Postcode |
Learner, Aims, ESF and HE Standard Files |
| L_DPWARD |
L_DPWARD Local Authority Ward of the Delivery Location Postcode (1991 census) |
Learner, Aims, ESF and HE Standard Files |
| L_DPWA01 |
L_DPWA01Local Authority Ward of the Delivery Location Postcode (2001 census) |
Learner, Aims, ESF and HE Standard Files |
| L_DPWA03 |
L_DPWA03 Local Authority Ward of the Delivery Location Postcode (2003 census) |
Learner, Aims, ESF and HE Standard Files |
| L_DPREG |
L_DPREG Region of the Delivery Location Postcode |
Learner, Aims, ESF and HE Standard Files |
| L_DPLA |
L_DPLA Local Authority based on the Delivery Location Postcode |
Learner, Aims, ESF and HE Standard Files |
VALUES
5. The table below outlines the categories for L_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. Refer to Learner Level Delivery Location Postcode (L_A23) data definition for information on how it's derived.
7. The Learner Level Delivery Location Postcode (L_A23) is matched to the postcode file for that year to obtain the Local Office (L_DPLLSC), the region (L_DPREG), Local Authority (L_DPLA) and the three local authority ward fields L_DPWARD, L_DPWA01 and L_DPWA03, that the delivery location is based in.
8. Refer to Learner Level Delivery Location Postcode (L_A23) data definition for information on how it is derived.
Location of the Delivery Provider (Learner Level) Sample Code
1. The following SPSS code is provided to illustrate the Location of the Delivery Provider (Learner Level) data definition.
L_DPLLSC, L_DPWARD, L_DPWA01, L_DPWA03, L_DPREG, L_DPLA
2. The following table shows the steps required to derive L_DPREG
|
Step
|
Condition
|
Action/Action if true
|
Action if false
|
| 1 |
If L_DPLLSC=2 |
L_DPREG=NC |
|
| 2 |
If L_DPLLSC=3 |
L_DPREG=NS |
|
| 3 |
If L_DPLLSC is in the inclusive range (60 to 110) |
L_DPREG=EE |
|
| 4 |
If L_DPLLSC is in the inclusive range (10 to 50) |
L_DPREG=EM |
|
| 5 |
If L_DPLLSC is in the inclusive range (120 to 160) |
L_DPREG=GL |
|
| 6 |
If L_DPLLSC is in the inclusive range (170 to 200) |
L_DPREG=NE |
|
| 7 |
If L_DPLLSC is in the inclusive range (210 to 250) |
L_DPREG=NW |
|
| 8 |
If L_DPLLSC is in the inclusive range (260 to 310) |
L_DPREG=SE |
|
| 9 |
If L_DPLLSC is in the inclusive range (320 to 370) |
L_DPREG=SW |
|
| 10 |
If L_DPLLSC is in the inclusive range (380 to 430) |
L_DPREG=WM |
|
| 11 |
If L_DPLLSC is in the inclusive range (440 to 470) |
L_DPREG=YH |
|
| 12 |
If L_DPLLSC=490 |
L_DPREG=NO |
|
| 13 |
If no value in L_DPLLSC |
L_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 ‘………………..LEARNERS data set’.
SORT CASES BY L_A23.
/* Rename the delivery providers postcode so that it matches the name of the postcode field in the postcode file.
RENAME VARIABLES (L_A23=postcode).
MATCH FILES /FILE=*
/TABLE = ‘…………………………POSCTODE data set.sav’
/BY POSTCODE.
RENAME VARIABLES (LLSC=L_DPLLSC) (LAUAcode=L_DPLA) (WARD_91=L_DPWARD) (WARD_01=L_DPWA01) (WARD_04=L_DPWA03) (POSTCODE=L_A23) (LSC_91=XLSC_91).
VARIABLE LABELS L_DPLLSC 'L_DPLLSC LLSC of the Delivery Location Postcode'
/L_DPWARD 'L_DPWARD Local Authority Ward of the Delivery Location Postcode (1991 Census)'
/L_DPWA01 'L_DPWA01 Local Authority Ward of the Delivery Location Postcode (2001 Census)'
/L_DPWA03 'L_DPWA03 Local Authority Ward of the Delivery Location Postcode (2003 Census)'.
/L_DPLA ‘L_DPLA Local Authority based on the Delivery Location Postcode’.
IF L_DPLLSC=2 L_DPREG='NC'.
If L_DPLLSC=3 L_DPREG='NS'.
IF RANGE(L_DPLLSC, 60, 110) L_DPREG='EE'.
IF RANGE(L_DPLLSC, 10, 50) L_DPREG='EM'.
IF RANGE(L_DPLLSC, 120, 160) L_DPREG='GL'.
IF RANGE(L_DPLLSC, 170, 200) L_DPREG='NE'.
IF RANGE(L_DPLLSC, 210, 250) L_DPREG='NW'.
IF RANGE(L_DPLLSC, 260, 310) L_DPREG='SE'.
IF RANGE(L_DPLLSC, 320, 370) L_DPREG='SW'.
IF RANGE(L_DPLLSC, 380, 430) L_DPREG='WM'.
IF RANGE(L_DPLLSC, 440, 470) L_DPREG='YH'.
IF L_DPLLSC=490 L_DPREG='NO'.
IF MISSING(L_DPLLSC) OR L_DPLLSC=-1 L_DPREG='NA'.
RECODE L_DPLLSC (SYSMIS=-1).
VARIABLE LABELS L_DPREG= ‘Region of the Delivery Location Postcode / L44 NCS delivery LSC number’.
|
Date last modified: 19th January 2009
