Sources of Funding Data Definition 2010/11

L_FUND

DATA DEFINITION

1. Sources of Funding for the Learner.

PURPOSE

2. The funding category for learners is used to identify funded learners for general analysis purposes and for use in the Council’s Statistical First Release (SFR) publication.

RELEVANT COLLECTIONS

ILR (LR)
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 Funding model	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 YPLA/Skills Funding Agency Funding for the Learner
1	YPLA/Skills Funding Agency only Funding for the Learner
2	YPLA/Skills Funding Agency & 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 YPLA/Skills Funding Agency Funding model (A10) and where the aim is active in the current academic year.

7. If a learner has no aims that receive YPLA/Skills Funding Agency funding then they are counted as being No YPLA/Skills Funding Agency Funding for the Learner (L_FUND=0).

8. If a learner only has aims that receive YPLA/Skills Funding Agency funding then the learner is YPLA/Skills Funding Agency only Funding (L_FUND=1), although it is possible for them to have aims that receive no YPLA/Skills Funding Agency funding.

9. If a learner has a combination of YPLA/Skills Funding Agency funded and ESF funding then they are classed as YPLA/Skills Funding Agency 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 SQL code is provided to illustrate the L_FUND 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, 81, 82.	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 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,81.82) 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

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,81.82) 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

group by

L01, L03

order by

L01, L03

Date last modified: 22 December 2010