Sources of Funding Data Definition 2008/2009
L_FUND
DATA DEFINITION
1. Sources of Funding for the Learner.
PURPOSE
2. The funding category for learners is used to identify LSC funded learners for general analysis purposes and for use in the Council’s Statistical First Release (SFR) publication.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (UfI)
- ILR (ASL)
- ILR (ER)
- ILR (ESF SR)
SOURCE DATA
3. The following variables are used as source data for the calculation of Sources of Funding for the Learner.
| Field Name | Label | Dataset |
|---|
| A06 | A06 ESF Co-Financing Data Sets | Aims Standard File |
| A10 | A10 LSC Funding stream | Aims Standard File |
| A_ACTIVE | A_ACTIVE Aim Active for the Current Academic Year | Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name | Label | Dataset |
|---|
| L_FUND | L_FUND Sources of Funding for the Learner | Learner, Aims, ESF and HE Standard Files |
VALUES
5. The table below outlines the categories for L_FUND
| L_FUND Value | Label |
|---|
| 0 | No LSC Funding for the Learner |
| 1 | LSC only Funding for the Learner |
| 2 | LSC & ESF Co-Financing Funding for the Learner |
| 3 | ESF Co-Financing Only for the Learner |
| -1 | Not Applicable/Not Known* |
DETAILED DEFINITION
6. The calculation of Sources of Funding for the Learner (L_FUND) is predominantly based on LSC Funding Stream (A10) and where the aim is active in the current academic year.
7. If a learner has no aims that receive LSC funding then they are counted as being No LSC Funding for the Learner (L_FUND=0).
8. If a learner only has aims that receive LSC funding then the learner is LSC only Funding (L_FUND=1), although it is possible for them to have aims that receive no LSC funding.
9. If a learner has a combination of LSC funded and ESF funding then they are classed as LSC and ESF CO-Financing Funding for the Learner (L_FUND=2).
10. If the only funding the learner’s aims receive is ESF funding, then they are classed as ESF Co-Financing Only (L_FUND=3).
Sources of Funding Sample Code
1. The following SPSS code is provided to illustrate the DATA DEFINITION data definition.
L_FUND
2. The following table shows the steps required to derive L_FUND
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does A_ACTIVE=1 | Go to 2 | Set LSC=0Set ESF=0Set NOLSC=0 |
| 2 | Does the Learner have any aims where A10=10, 21, 22, 45, 46, 80. | Set LSC=1.
Go to 3 | Go to 3 |
| 3 | Does the Learner have any ESF funded aims or attached ESF data sets (A10=70 or A06=1). | Set ESF=1.
Go to 4 | Go to 4 |
| 4 | Does the learner have any aims where A10=99. | Set NOLSC=1.
Go to 5 | Go to 5 |
| 5 | (Aggregate) For all aims where the Provider (L01) and Learner (L03) are the same. | LSCS is the maximum value of all of the aims in LSC.
ESFS is the maximum value of all of the aims in ESFS.
NOLSCS is the maximum value of all of the aims in NOLSC.
(for above variables aim with highest data set sequence (A04) is taken)
Go to 6 | |
| 6 | N/A | Create a Numeric Variable TOTAL = Sum of LSCS, ESFS and NOLSCS.
Go to 7. | |
| 7 | N/A | Create Numeric Variable L_FUND = -1.
Go to 8 | |
| 8 | Does TOTAL = 1 and NOLSCS=1. | Set L_FUND=0. | Go to 9 |
| 9 | Does TOTAL=1 and LSCS=1. | Set L_FUND=1. | Go to 10 |
| 10 | Does TOTAL=1 and ESFS=1. | Set L_FUND=3. | Go to 11 |
| 11 | Does TOTAL=2 and ESFS=1 and NOLSCS=1. | Set L_FUND=2. | Go to 12 |
| 12 | Does TOTAL=2 and ESFS=1 and LSCS=1. | Set L_FUND=2. | Go to 13 |
| 13 | Does TOTAL=3. | Set L_FUND=2. | |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does L_FUND contain a value | None | Set L_FUND = -1 |
| 2 | Does L_ACTIVE = 0 | Let L_FUND = -1 | None |
3. The following SPSS code illustrates how to derive L_FUND.
GET FILE …………….AIMS data set. /* Create three dichotomous variables one for each of the funding streams.
IF any(A10,10, 21, 22, 45,46, 80) LSC=1.
IF A10=70 or A06=1 ESF=1.
IF A10=99 NOLSC=1.
RECODE LSC TO NOLSC (SYSMIS=0). /* If the aims aren't active set the new variables to zero, so that they don't count in the aggregation.
DO IF A_ACTIVE=0.
RECODE LSC TO NOLSC (1=0).
END IF. SORT CASES L01 L03 A05. /* Aggregate to leaner level so that there is only one value per funding stream per learner
/* Exclude those aims which are not included for analytical purposes.
AGGREGATE OUTFILE =*
MODE=ADDVAR
/PRESORTED
/BREAK=L01 L03
/LSCS ESFS NOLSCS=MAX(LSC ESF NOLSC). /* Create a variable total which will indicate the number of different funding sources a learner has.
COMPUTE TOTAL=SUM (LSCS TO NOLSCS). COMPUTE L_FUND=-1.
IF TOTAL=1 AND NOLSCS=1 L_FUND=0. IF TOTAL=1 AND LSCS=1 L_FUND=1.
IF TOTAL=2 AND NOLSCS=1 AND LSCS=1 L_FUND=1. IF TOTAL=1 AND ESFS=1 L_FUND=3. IF TOTAL=2 AND ESFS=1 AND NOLSCS=1 L_FUND=2.
IF TOTAL=2 AND ESFS=1 AND LSCS=1 L_FUND=2. IF TOTAL=3 L_FUND=2.
IF L_ACTIVE=0 L_FUND=-1
RECODE L_FUND (SYSMIS=-1)
VARIABLE LABELS L_FUND 'L_FUND Sources of Funding for the Learner'.
VALUE LABELS L_FUND
0 'No LSC Funding for the Learner'
1 'LSC Only Funding for the Learner'
2 'LSC & ESF Co-Financing Funding for the Learner'
3 'ESF Co-Financing Only for the Learner'
-1 'Not Applicable/Not Known'. |
Date last modified: 16th January 2009
