Full Time Equivalent Data Definition 2008/2009

L_FTELP

DATA DEFINITION

1. Full Time Equivalent measure.

PURPOSE

2. Full Time Equivalents (FTEs) are a measure of volume for the purpose of measuring progress against targets. This measure is for use within the three year development plans and to assess the scale of provision. Note that FTEs are applicable to FE only and are derived differently to the DfES.

RELEVANT COLLECTIONS

  • ILR (LR)
  • ILR (UfI)

SOURCE DATA

3. The following variables are used as source data for the calculation of Full Time Equivalents.

Field NameLabelDataset
L_ACTIVEL_ACTIVE Learner Active for the current academic yearLearner Standard File
L_INYR_EXPECTED_GLHL_INYR_EXPECTED_GLH Expected In Year GLHLearner Standard File
L_MODE_BL_MODE_B Learners mode of attendanceLearner Standard File

DERIVED VARIABLES AND DATASETS

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

Field NameLabelDataset
L_FTELPL_FTELP Full Time Equivalent. Learner Standard File, Aims Standard File

VALUES
5. The table below outlines the categories for L_FTELP

ValueLabel
-1Not Applicable
0Not Known
1Learner is Full time Equivalent

DETAILED DEFINITION

6. The calculation of Full Time Equivalents (L_FTELP) takes into consideration the Activity of the Learner for Inclusion in Analysis (L_ACTIVE). Learners that are not Active (L_ACTIVE) are set to -1.

7. If a learner's Expected Current Year Guided Learning Hours (L_INYR_EXPECTED_GLH) is greater than 450, then they are regarded as being full time and have a Full Time Equivalent (L_FTELP) of 1.

8. If their Mode of Attendance (L_MODE_B) is Full-time Full-year (L_MODE_B=1), then they are regarded as being full time and have a Full Time Equivalent (L_FTELP) of 1.

9. If they are neither of these then the Full Time Equivalent (L_FTELP) is the ratio of their Expected Current Year Guided Learning Hours (L_INYR_EXPECTED_GLH) to 450 (i.e. L_INYR_EXPECTED_GLH /450).

10. Full Time Equivalent (L_FTELP) is capped at 1, so any values greater than 1 are reassigned the value of 1.

11. Where Full time equivalent (L_FTELP) has missing values, these are set to 0.


FULL TIME EQUIVALENT SAMPLE CODE

1. The following SPSS code is provided to illustrate the Full Time Equivalent data definition.

L_FTELP

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

StepConditionAction/Action if trueAction if false
1AnySet L_FTELP to -1.
Go to 2.
 
2Does L_ACTIVE =1Set L_FTELP= L_INYR_EXPECTED_GLH  /450.
Go to 3.
Set L_FTELP to -1
3Is L_FTELP>1Set L_FTELP to 1.
Go to 4.
 
4Does L_MODE_B=1Set L_FTELP = 1. Go to 5. 
5Is L_FTELP MissingSet L_FTELP = 0. 

StepConditionAction/Action if trueAction if false
1Does L_FTELP contain a valueNoneSet L_FTELP=-1

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

GET FILE ‘………..LEARNER data set’.
COMPUTE L_FTELP = -1.

/* For the purpose of this definition, a full time learner is one who has 450 cyglh.
DO IF L_ACTIVE=1.
COMPUTE L_FTELP = L_INYR_EXPECTED_GLH/450.
IF (L_FTELP>1) L_FTELP = 1.
IF l_MODE_B = 1 L_FTELP = 1.
RECODE L_FTELP(SYSMIS=0).
END IF.

RECODE L_FTELP (SYSMIS=-1).

FORMAT L_FTELP (F5.4).
VARIABLE LABELS L_FTELP ‘L_FTELP Full Time Equivalent’.

VALUE LABELS L_FTELP
-1 ‘Not Applicable’
0 ‘Not Known’
1 ‘Learner is Full’.


Date last modified: 10th February 2009