Full Time Equivalent Data Definition 2009/2010
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
SOURCE DATA
3. The following variables are used as source data for the calculation of Full Time Equivalents.
| Field Name |
Label |
Dataset |
| L_ACTIVE |
L_ACTIVE Learner Active for the current academic year |
Learner Standard File |
| L_INYR_EXPECTED_GLH |
L_INYR_EXPECTED_GLH Expected In Year GLH |
Learner Standard File |
| L_MODE_B |
L_MODE_B Learners mode of attendance |
Learner Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| L_FTELP |
L_FTELP Full Time Equivalent. |
Learner Standard File, Aims Standard File |
VALUES
5. The table below outlines the categories for L_FTELP
| Value |
Label |
| -1 |
Not Applicable |
| 0 |
Not Known |
| 1 |
Learner 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
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Any |
Set L_FTELP to -1.
Go to 2. |
|
| 2 |
Does L_ACTIVE =1 |
Set L_FTELP= L_INYR_EXPECTED_GLH /450.
Go to 3. |
Set L_FTELP to -1 |
| 3 |
Is L_FTELP>1 |
Set L_FTELP to 1.
Go to 4. |
|
| 4 |
Does L_MODE_B=1 |
Set L_FTELP = 1. Go to 5. |
|
| 5 |
Is L_FTELP Missing |
Set L_FTELP = 0. |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_FTELP contain a value |
None |
Set 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’. |
4. The following SQL code illustrates how to derive L_FTELP:
|
select
L01, L03
, case when max(L_FTELP_qry)>1 then 1 else max(L_FTELP_qry) end as L_FTELP
from
(
select
L01, L03
, case when max(L_ACTIVE) = 1 and max(L_MODE_B) = 1 then 1
when max(L_ACTIVE) = 1 then max(L_INYR_EXPECTED_GLH)/450
else -1 end as L_FTELP_qry
from
LR_LEARNER
group by
L01, L03
)T
group by
L01, L03
order by
L01, L03 |
Date last modified: 08th December 2009
