Location of the Delivery Provider (Learner Level) Data Definition 2009/2010
L_DPLLSC, L_DPWARD, L_DPWA01, L_DPWA03, L_DPREG, L_DPLA
Note: The ESF Standard FIle Dataset is not in use for 2009/2010 and where referenced for this variable in 2008/2009, has now been removed and this variable is marked as 'Amended' for 2009/2010.
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 and HE Standard Files |
| L_DPWARD |
L_DPWARD Local Authority Ward of the Delivery Location Postcode (1991 census) |
Learner, Aims and HE Standard Files |
| L_DPWA01 |
L_DPWA01Local Authority Ward of the Delivery Location Postcode (2001 census) |
Learner, Aims and HE Standard Files |
| L_DPWA03 |
L_DPWA03 Local Authority Ward of the Delivery Location Postcode (2003 census) |
Learner, Aims and HE Standard Files |
| L_DPREG |
L_DPREG Region of the Delivery Location Postcode |
Learner, Aims and HE Standard Files |
| L_DPLA |
L_DPLA Local Authority based on the Delivery Location Postcode |
Learner, Aims 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 is 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’. |
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 L_DPLA
,Pst_LLSC as L_DPLLSC
,Pst_WARD as L_DPWA03
,Pst_WARD_01 as L_DPWA01
,Pst_WARD_91 as L_DPWARD
from
dbo.ILR0910_E_LEARNER aims
left outer join
dbo.postcode0910 post
on aims.A23=post.pst_postcode
--L_DPREG
select
L01, L03
, case when L_DPLLSC=2 then 'NC'
when L_DPLLSC=3 then 'NS'
when L_DPLLSC>=60 and L_DPLLSC<=110 then 'EE'
when L_DPLLSC>=10 and L_DPLLSC<=50 then 'EM'
when L_DPLLSC>=120 and L_DPLLSC<=160 then 'GL'
when L_DPLLSC>=170 and L_DPLLSC<=200 then 'NE'
when L_DPLLSC>=210 and L_DPLLSC<=250 then 'NW'
when L_DPLLSC>=260 and L_DPLLSC<=310 then 'SE'
when L_DPLLSC>=320 and L_DPLLSC<=370 then 'SW'
when L_DPLLSC>=380 and L_DPLLSC<=430 then 'WM'
when L_DPLLSC>=440 and L_DPLLSC<=470 then 'YH'
when L_DPLLSC=490 then 'NO'
else 'NA' end as L_DPREG
from
dbo.ILR0910_E_LEARNER |
Date last modified: 07th January 2010
