Fully Funded Data Definition 2009/2010
A_FULLY_FUNDED
DATA DEFINITION
1. Fully Funded.
PURPOSE
2. To determine if an aim is fully funded or co-funded.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of Fully Funded.
| Field Name |
Label |
Dataset |
| A_FULLY FUNDED |
A_FULLY_FUNDED Aim fully funded |
Aims DLF Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_FULLY_FUNDED |
A_FULLY_FUNDED Aim fully funded |
Aims Standard File |
VALUES
5. The table below outlines the categories for A_FULLY_FUNDED
DETAILED DEFINITION
6. The Aim level Fully Funded flag is matched in from the Demand Led Funding dataset, relevant to the collection. For further information please refer to documentation available on the Funding Policy page. Where an aim exists in the aims file, but not the Demand Led Funding dataset, A_FULLY_FUNDED is set to 0.
Fully Funded Sample Code
1. The following SPSS code is provided to illustrate the Fully Funded data definition.
A_FULLY_FUNDED
2. The following table shows the steps required to derive A_FULLY_FUNDED
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Any |
Set A_FULLY_FUNDED = 0 |
|
| 2 |
If A_FULLY_FUNDED in Aims DLF File=1 |
Set A_FULLY_FUNDED = -1 |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A_FULLY_FUNDED contain a value |
None |
Set A_FULLY_FUNDED = -1 |
3. The following SPSS code illustrates how to derive A_FULLY_FUNDED.
|
GET FILE = …………Aims Data set.
SORT CASES BY L01 L03 A15 A26 A05.
MATCH FILES
/FILE = *
/TABLE = …..Aims DLF data set
/BY L01 L03 A15 A26 A05.
RECODE A_FULLY_FUNDED (SYSMIS=0)
VALUE LABELS A_FULLY_FUNDED
0 'No’
1 'Yes’. |
4. The following SQL code illustrates how to derive A_FULLY_FUNDED:
|
select
B.L01 as L01, B.L03 as L03, B.A05 as A05
, case when A.A_FULLY_FUNDED = 1 then 1 else 0 end as A_FULLY_FUNDED
from
ILR0910_E_AIMS_DLF A
join
ILR0910_E_AIMS B
on A.L01 = B.L01 and A.L03 = B.L03 |
Date last modified: 24th July 2009
