Eligible for Learner Support Data Definition 2010/2011
L_ADDSUP
DATA DEFINITION
1. Flag signifying whether the learner is eligible for additional learner support.
PURPOSE
2. Indicates if the learner is eligible for additional learner support or not.
CURRENT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of Eligible for Additional Learner Support.
| Field Name |
Label |
Dataset |
| L31 |
L31 Additional Support Cost |
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_ADDSUP |
L_ADDSUPP Eligible for Learner Support |
Learner Standard File, Aims Standard File |
VALUES
5. The table below outlines the categories for L_ADDSUP
DETAILED DEFINITION
6. Where learners are part time (L_MODE_B>1) and their Additional Support Cost (L31) is greater than 170, they are eligible for additional support (L_ADDSUP=1).
7. Where learners are full time (L_MODE_B=1) and their Additional Support Cost (L31) is greater than 501 then they are eligible for additional support (L_ADDSUP=1).
8. Note that this is for statistical purposes only. A learner may have a value in Additional Support Cost (L31) that is greater than the above figures and still not be eligible for Additional Support funding through the FE funding calculation.
Eligible for Additional Learner Support Sample Code
1. The following SQL code is provided to illustrate the Eligible for Additional Learner Support data definition.
L_ADDSUP
2. The following table shows the steps required to derive L_ADDSUP
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Any |
Set L_ADDSUP to 0 |
|
| 2 |
Is L_MODE_B>=2 |
Go to 3 |
Go to 4 |
| 3 |
Is L31>=170 |
Set L_ADDSUP to 1 |
|
| 4 |
Does L_MODE_B=1 |
Go to 4 |
Go to 5 |
| 5 |
Is L31>=501 |
Set L_ADDSUP to 1 |
|
3. The following SQL code illustrates how to derive L_ADDSUP:
|
select
L01, L03
, case when (L_MODE_B>=2 and L31>=170) or (L_MODE_B=1 and L31>=501) then 1
else 0 end as L_ADDSUP
from
LR_LEARNER |
Date last modified: 23 December 2010
