Region of the Funding LSC Data Definition 2008/2009

L25_REG

DATA DEFINITION

1. Identify the region in which the funding LSC is located.

PURPOSE

2. This field classifies the region in which the funding LSC is located and is 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 Region of the funding LSC.

Field NameLabelDataset
L25LSC number of funding LSCLearner DLF Standard File

DERIVED VARIABLES AND DATASETS

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

Field NameLabelDataset
L25_REGL25 REG Region of the Funding LSCAims Standard File

VALUES

5. The table below outlines the categories for L25_REG

L25_REG valueLabel
NCNational Employer Service
EEEast of England
EMEast Midlands
GLGreater London
NENorth East
NWNorth West
SESouth East
SWSouth West
WMWest Midlands
YHYorkshire and the Humber
NONational Office
NANot Applicable
NSNational Apprenticeship Service

DETAILED DEFINITION

6. The LSC number of the local LSC which funds the learner (L25) is grouped under one of the regions (L25_REG): National Employer Service (NC), East (EE), East Midlands (EM), Greater London (GL), North East (NE), North West (NW), South East (SE), South West (SW), West Midlands (WM), Yorkshire & Humberside (YH), National Office (NO) and No funding LSC (NA).


Region of the Funding LSC Sample Code

1. The following SPSS code is provided to illustrate the Region of the Funding LSC data definition.

L25_REG

2. The following table shows the steps required to derive L25_REG

StepConditionAction/Action if trueAction if false
1If L25=2L25_REG=NC. Go to 2.
2If L25=3L25_REG=NSGo to 3.
3If L25 is in the inclusive range (60 to 110)L25_REG=EE. Go to 4.
4If L25 is in the inclusive range (10 to 50)L25_REG=EM. Go to 5.
5If L25 is in the inclusive range (120 to 160)L25_REG=GL. Go to 6.
6If L25 is in the inclusive range (170 to 200)L25_REG=NE. Go to 7.
7If L25 is in the inclusive range (210 to 250)L25_REG=NW. Go to 8.
8If L25 is in the inclusive range (260 to 310)L25_REG=SE. Go to 9.
9If L25 is in the inclusive range (320 to 370)L25_REG=SW. Go to 10.
10If L25 is in the inclusive range (380 to 430)L25_REG=WM. Go to 11.
11If L25 is in the inclusive range (440 to 470)L25_REG=YH. Go to 12.
12If L25=490L25_REG=NO. Go to 13.
13If no value in L25L25_REG=NA 

3. The following SPSS code illustrates how to derive L25_REG.

IF L25=2 L25_REG='NC'.

IF L25=3 L25 REG-'NS'.

IF RANGE(L25, 60, 110) L25_REG='EE'.

IF RANGE(L25, 10, 50) L25_REG='EM'.

IF RANGE(L25, 120, 160) L25_REG='GL'.

IF RANGE(L25, 170, 200) L25_REG='NE'.

IF RANGE(L25, 210, 250) L25_REG='NW'.

IF RANGE(L25, 260, 310) L25_REG='SE'.

IF RANGE(L25, 320, 370) L25_REG='SW'.

IF RANGE(L25, 380, 430) L25_REG='WM'.

IF RANGE(L25, 440, 470) L25_REG='YH'.

IF L25=490 L25_REG='NO'.

IF MISSING(L25) OR L25=-1 L25_REG='NA'.

VARIABLE LABELS L25_REG ‘L25_REG Region of the funding LLSC’.


Date last modified: 12th January 2009