ESF Standard File



Note:
This page is from an older version of the Data Dictionary and may therefore contain information that is now out of date. It is included here for reference only.

1 The European Social Fund (ESF) Co-financing data set has one row per ESF co-financed aim.

Purpose

2 The ESF Standard File is used for the analysis of ESF co-financed aims and learners.

3 This dataset is part of the following collections

  • The Standard Files Collection

Detailed definition

4 The standard files are created by running the 'standard code' on the raw data collected using the Individualised Learner Record (ILR). The standard code introduces a number of derived variables to the data which are stored in the standard files. The data is converted to both SPSS and Crystal format for analysis and reporting.

5 There is an ESF co-financing record in the ESF standard file for each learning aim which may be eligible for LSC ESF co-financing and each learning aim that is matched to such funding. There is a one to one relationship between the learning aim and the ESF standard file, using L01, L03 and A05.

6 The table below shows the fields within the ESF Standard File.

7 Where the variable name is of the form 'Lxx', 'Axx' or Exx (where xx is a two digit number) then this is taken from the field of the same name in the Individualised Learner Record (ILR) datasets. The definition of each variable is given in the ILR specification. The hyperlink will take you to the ILR page where you can view the latest specification.

8 The definitions for the ESF standard file Derived Variables (those with 'E_' prefix) and some learner level Derived Variables (those with 'L_' prefix) can be found by following the hyperlinks in the last column of the table.

Figure 1 Fields in the ESF Standard File

Field name Description Derived Variable/Data Definition

COLLECTION

Collection (FE, WBL, ESFSE, UFI, ACL)

PERIOD

Period of the year this file relates to

Period

L01

Provider Number

L03

Learner Reference Number

A05

Learning aim data set sequence

E02

Contract/Allocation Type

E04

Data set identifier code

E06

ESF co-financing data set sequence

E07

HE data sets

E08

Date started ESF co-financing

E09

Planned end date for ESF co-financing

E10

Date ended ESF co-financing

E11

Industrial sector of learner's employer

E12

Employment status on day before starting ESF project

E13

Learner's employment status

E14

Length of unemployment before starting ESF project

E15

Type and size of learner's employer

E16 a

Addressing gender stereotyping (1 of 5)

E16 b

Addressing gender stereotyping (2 of 5)

E16 c

Addressing gender stereotyping (3 of 5)

E16 d

Addressing gender stereotyping (4 of 5)

E16 e

Addressing gender stereotyping (5 of 5)

E17 a

Main co-financing activity (1 of 5)

E17 b

Main co-financing activity (2 of 5)

E17 c

Main co-financing activity (3 of 5)

E17 d

Main co-financing activity (4 of 5)

E17 e

Main co-financing activity (5 of 5)

E18 a

Delivery mode (1 of 4)

E18 b

Delivery mode (2 of 4)

E18 c

Delivery mode (3 of 4)

E18 d

Delivery mode (4 of 4)

E19 a

Support measures to be accessed by the learner (1 of 5)

E19 b

Support measures to be accessed by the learner (2 of 5)

E19 c

Support measures to be accessed by the learner (3 of 5)

E19 d

Support measures to be accessed by the learner (4 of 5)

E19 e

Support measures to be accessed by the learner (5 of 5)

E20 a

Learner background (1 of 3)

E20 b

Learner background (2 of 3)

E20 c

Learner background (3 of 3)

E21

Support measures for learners with disabilities

E22

Project dossier number

E23

Local project number

E24

Unique learner number

E25

UK provider reference number

E_IL_P1

DV - Is the ESFSE record in learning in period 1

In Learning

E_IL_P2

DV - Is the ESFSE record in learning in period 2

In Learning

E_IL_P3

DV - Is the ESFSE record in learning in period 3

In Learning

E_IL_P4

DV - Is the ESFSE record in learning in period 4

In Learning

E_IL_P5

DV - Is the ESFSE record in learning in period 5

In Learning

E_IL_P6

DV - Is the ESFSE record in learning in period 6

In Learning

E_IL_P7

DV - Is the ESFSE record in learning in period 7

In Learning

E_IL_P8

DV - Is the ESFSE record in learning in period 8

In Learning

E_IL_P9

DV - Is the ESFSE record in learning in period 9

In Learning

E_IL_P10

DV - Is the ESFSE record in learning in period 10

In Learning

E_IL_P11

DV - Is the ESFSE record in learning in period 11

In Learning

E_IL_P12

DV - Is the ESFSE record in learning in period 12

In Learning

E_ILPY2D

DV - Average number of periods in-learning in current year to date

In Learning

E_ILAVY2

DV - Number of periods in-learning in current year, year to date

In Learning

E_LEAVEP

DV - Period ESF SE record Left in

Leave Period

E_STARTP

DV - Period ESF SE record started in

Start Period

L11

Date of birth

L12

Ethnicity

L13

Sex

L14

Learning difficulties and/or disabilities and/or health problems

L15

Disability

L16

Learning difficulty

L17

Home Postcode

L22

Current Postcode

L25

LSC number of funding LSC

L33

Disadvantage uplift factor (FE)

L35

Prior attainment level

L36

Learner status on last working day before learning (WBL)

L39

Destination (WBL)

L44

NCS delivery LSC number

L_ACT_B

DV - Actual current year GLH using 1 Oct 1 Feb 15 May

Current Year Guided Learning Hours

L_AGE

DV - Age of the learner as at 31 August 2003

Age

L_AGEB

DV - Age of the learner as at 31 August 2003 banded

Age

L_ATYPE

DV - In-year aim type of the learner

Aim Type

L_SFL

DV - 1/0 flag to indicate if the learner is a basic skills learner or not

Skills for Life

L_DISADV

DV - 1/0 flag to indicate IF the learner is considered to be disadvantaged or not

Disadvantaged Learner

L_DPLLSC

DV - LLSC of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number

Location of the Delivery Provider (Learner level)

L_DPREG

DV - Region of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number

Location of the Delivery Provider (Learner level)

L_DPLA

DV - Local Authority based on the Learner DP postcode

Location of the Delivery Provider (Learner level)

L_DPWA01

DV - Local Authority ward code of the Delivery Provider (2001 census)

Location of the Delivery Provider (Learner level)

L_DPWA03

DV - Local Authority ward code of the Delivery Provider (2003 census)

Location of the Delivery Provider (Learner level)

L_DPWARD

DV - Local Authority ward code of the Delivery Provider (1991 census)

Location of the Delivery Provider (Learner level)

L_EXP_B

DV - Expected current year GLH using 1 Oct 1 Feb 15 May

Current Year Guided Learning Hours

L_FRANCH

DV - does the learner have any franchised aims (1/0 flag)

Franchised Aim

L_FTELP

DV - Full time equivalent learner profile method i.e expected learner cyglh/450, up to a maximum value of 1 FTE.

Full Time Equivalent

L_FULLLEVEL2

DV - Full NVQ level 2 learner flag

Full Level 2 & 3

L_FULLLEVEL3

DV - Full NVQ level 3 learner flag

Full Level 2 & 3

L_FUND

DV - Sources of funding for the learner

Source of Funding

L_OCT

DV - Learner was active on 1 Oct in this year

Active on Census Date

L_LIVE_B

DV - Status of aim for inclusion in analysis using 1 Oct as first census date (Method B)

Status for Inclusion in Analysis

L_LLLSC

DV - Home LSC of the Learner, based on the Learner postcode

Location of the Learner

L_LREG

Home Region of the Learner, based on the Learner postcode

Location of the Learner

L_LLA

DV - Local Authority based on the Learner postcode

Location of the Learner

L_LWAR01

DV - Local Authority ward code of the Learner (2001 census)

Location of the Learner

L_LWAR03

DV - Local Authority ward code of the Learner (2003 census)

Location of the Learner

L_LWARD

DV - Local Authority ward code of the Learner (1991 census)

Location of the Learner

L_MODE_B

DV - Learners mode attendance using 1 Nov, 1 Feb, 15 May (Method B)

Mode of Attendance

L_NVQLEV

DV - NVQ level of the learner

Notional NVQ Level

L_LIS_FG

DV - LIS Funding Flag

LIS Funding Generated

L_PLLSC

DV - LLSC based on the 1-1 'owner' relationship UPIN to LLSC

Location of the Provider

L_PREG

DV - Region of the Owning Provider, based on the Learner postcode

Location of the Provider

L_PLA

DV - Local Authority based on the Provider postcode

Location of the Provider

L_PWAR01

DV - Local Authority ward code of the Owning Provider (2001 census)

Location of the Provider

L_PWAR03

DV - Local Authority ward code of the Owning Provider (2003 census)

Location of the Provider

L_PWARD

DV - Local Authority ward code of the Owning Provider (1991 census)

Location of the Provider

L_UPLF56

DV - 05/06 Widening participation uplift factor based on learners postcode prior to enrolling

Widening Participation Uplift Factors

L_UPLF67

DV - 06/07 Widening participation uplift factor based on learners postcode prior to enrolling

Widening Participation Uplift Factors

L_TTGAIN

DV - Train to Gain Learner

Train to Gain

Creator

Analysis and MI Team

Date issued

26 September 2006

Date created

29 November 2005

Document ref.

G:\Organisational Data\DCA\A&MI\Documentation\web data dictionary\200607\Datasets\nat-esfstandardfile-report-26sep2006.doc

LSC office

Learning and Skills Council
Cheylesmore House Quinton Road Coventry CV1 2WT
T 0845 019 4170 F 024 7682 3675 www.lsc.gov.uk

Last Modified: 27 Sep 06