New ESF Aim Data Definition 2008/2009
A_ESFTY
DATA DEFINITION
1. Indicates the New ESF aim. Replaces the type of ESF aim (used in previous years) as from 2007/08.
PURPOSE
2. This is a new derived variable is to distinguish between “old” ESF co-financed projects beginning prior to 2008 and “new” ESF co-financed projects which are funded from 2008 onwards.It is a Learning aims dataset derived variable.
3. The type of ESF projected is defined by the format of the project dossier number.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (UfI)
- ILR (ER)
- ILR (ESF SR)
SOURCE DATA
4. The following variables are used as source data for the calculation of the New ESF Aim data definition.
| Field Name | Label | Dataset |
|---|
| A01 | A01 Provider Number | ILR Learning Aims Dataset |
| A03 | A03 Learner Reference number | ILR Learning Aims Dataset |
| A05 | A05 Learning aim data set sequence | ILR Learning Aims Dataset |
| E01 | E01 Provider Number | ILR ESF Co-financing Dataset |
| E03 | E03 Learner Reference number | ILR ESF Co-financing Dataset |
| E05 | E05 Learning aim data set sequence | ILR ESF Co-financing Dataset |
| E22 | E22 Project Dossier Number | ILR ESF Co-financing Dataset |
VALUES
5. The table below outlines the categories for A_ESFTY
| A_ESFTY Label Value | Description |
|---|
| 1 | NEW ESF Co-financing |
| 2 | OLD ESF Co-financing |
| 9 | Not identified as ESF co-financed |
DETAILED DEFINITION
6. The variable should be derived as described below:
The variable requires the ESF co-financing dataset to be matched to the Learning aim dataset.
New ESF Type Sample Code
1. The following SPSS code is provided to illustrate the New ESF Aim data definition.
A_ESFTY
2. The following table shows the steps required to derive A_ESFTY
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | | Create Numeric Variable A_ESFTY=9.
Go to 2 | |
| 2 | Does the sixth Character in E22 = “L”. | Set A_ESFTY=1 | Go to 3 |
| 3 | Is the sixth Number in E22 >= “0”. | Set A_ESFTY=1 | |
3. The following SPSS code illustrates how to derive A_ESFTY.
/* MATCH IN ESF FILE or do on ESF file. comp A_ESFTY=9.
If UPCASE(substr(E22,6,1))="L" A_ESFTY=1.
If number(substr(E22,6,1),F1)>=0 A_ESFTY=2. |
Date last modified: 20th January 2009
