Sources of Funding Data Definition 2009/2010

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
A10 A10 LSC Funding stream Aims Standard File
A_ACTIVE A_ACTIVE Aim Active for the Current Academic Year Aims Standard File
L_ACTIVE L_ACTIVE Learner Active for the Current Academic Year Learner Standard File, 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 (A10=70). 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 (A05) 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=2 and NOLSCS=1 and LSCS=1. Set L_FUND=1 Go to 14
14 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 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 learner 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'.



4. The following SQL code illustrates how to derive L_FUND:

select

      L01, L03, count(A05) as aims
      , case when max(A_ACTIVE)=0 then -1
      when (max(LSC)+max(ESF)+max(NOLSC))=1 and max(NOLSC)=1 then 0
      when (max(LSC)+max(ESF)+max(NOLSC))=1 and max(LSC)=1 then 1
      when (max(LSC)+max(ESF)+max(NOLSC))=1 and max(ESF)=1 then 3
      when (max(LSC)+max(ESF)+max(NOLSC))=2 and max(ESF)=1 and max(NOLSC)=1 then 2
      when (max(LSC)+max(ESF)+max(NOLSC))=2 and max(ESF)=1 and max(LSC)=1 then 2
      when (max(LSC)+max(ESF)+max(NOLSC))=2 and max(LSC)=1 and max(NOLSC)=1 then 1
      when (max(LSC)+max(ESF)+max(NOLSC))=3 then 1 end as L_FUND

from
     (
     select

           L01, L03, A05
           , case when A_ACTIVE=1 and A10 in (10,21,22,45,46,80) then 1 else 0 end as LSC
           , case when A_ACTIVE=1 and A10=70 then 1 else 0 end as ESF
           , case when A_ACTIVE=1 and A10=99 then 1 else 0 end as NOLSC
           , A_ACTIVE

     from

          ILR0910_E_AIMS

     )T

group by

      L01, L03

order by

      L01, L03



Date last modified: 02nd December 2009