Train to Gain Data Definition 2009/2010
A_TTGAIN, L_TTGAIN, A_TTGBROKE
DATA DEFINITION
1. Train to Gain identifiers for aims and learners.
PURPOSE
2. For analysis of Train to Gain Learners and Aims.
RELEVANT COLLECTIONS
ILR (ER)
SOURCE DATA
3. The following variables are used as source data for the calculation of the Train to Gain Identifiers.
| Field Name |
Label |
Dataset |
| A10 |
A10 LSC Funding stream |
Aims Standard File |
| A15 |
A15 Programme type |
Aims Standard File |
| A_ACTIVE |
A_ACTIVE Aim Active for the Current Academic Year |
Aims Standard File |
| A46a |
A46a National learning aim Monitoring |
Aims Standard File |
| A46b |
A46b National learning aim Monitoring |
Aims Standard File |
| A54 |
A54 Broker Contract Number |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_TTGAIN |
A_TTGAIN Train to Gain Aim |
Aims Standard File |
| A_TTGBROKE |
A_TTGBROKE Train to Gain Brokerage |
Aims Standard File |
| L_TTGAIN |
L_TTGAIN Train to Gain Learner |
Learner Standard File |
VALUES
5. The table below outlines the categories for A_TTGAIN, L_TTGAIN
| Value |
Label |
| -1 |
Not Applicable/Not Known* |
| 0 |
No |
| 2 |
Yes |
*Applies to system missing values and where there are non-active aims. Only applicable at learner level.
6. The table below outlines the categories for A_TTGBROKE
| Value |
Label |
| 0 |
Not Brokered |
| 1 |
Fully Brokered |
| 2 |
Not Fully Brokered |
DETAILED DEFINITION
Aim Level
7. A Train to Gain learner is an adult learner whose learning is enabled, sponsored or facilitated by their employer. Train to Gain learners are funded from the Employer Responsive allocation.
8. Funded Train to Gain Aims (A_TTGAIN) are identified where the LSC Funding Stream is flagged as being Employer Responsive (A10= 45 or 46).
9. Employer Responsive Aims are identified as being Train to Gain (A_TTGAIN) where the Programme type is not an Apprenticeship (A15 <> 02, 03 and 10) AND the aim is not part of the Employability Skills Programme (A46a <> 83 AND A46b <> 83).
10. Train to Gain data in 09/10 is returned via the Employer Responsive route only, therefore the value ‘1 – Train to Gain like learner’ Applicable to the old FE collection is now redundant.
11. An aim is Fully Brokered (A_TTGBROKE = 1) when the aims if flagged 10s being Train to Gain (A_TTGAIN>0) and has valid Broker contract (A54 <>9999999999), if the Broker contract=9999999999, then the aim is Not Fully Brokered ((A_TTGBROKE = 2).
Learner Level
12. If the learner is undertaking a Train to Gain Aim (A_TTGAIN) as part of any of their aims then the learner is considered to be a Train to Gain Learner and is assigned a value of 2 (the highest value in A_TTGAIN) in the Learner level Train to Gain Flag (L_TTGAIN). This excludes those aims that are not included for analytical purposes (using A_ACTIVE).
Train to Gain Sample Code
1. The following SPSS code is provided to illustrate the Train to Gain data definition.
A_TTGAIN, L_TTGAIN
2. The following table shows the steps required to derive A_TTGAIN, L_TTGAIN
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A10=(45 or 46) |
Go to 2 |
Set A_TTGAIN to 0 |
| 2 |
Is A15 <> 2,3 or 10 AND A46a <> 83 AND A46b <> 83 |
Set A_TTGAIN 2. Go to 3 |
Set A_TTGAIN to 0 |
| 3 |
Does A_ACTIVE=1 |
Go to 4 |
Set L_TTGAIN to -1 |
| 4 |
(Aggregation)
For all aims where the Learner (L03) and provider (L01) are the same. |
L_TTGAIN is the maximum value of all of the aims in A_TTGAIN. |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_TTGAIN contain a value |
None |
Set L_TTGAIN = -1 |
3. The following SPSS code illustrates how to derive A_TTGAIN, L_TTGAIN.
|
*Create A_TTGAIN Variable and set value to 0.
*If the aim is active and the funding stream is Employer Responsive or Employer Responsive aim and not an apprenticeship then A_TTGAIN is set to 2.
COMPUTE A_TTGAIN=0.
IF ANY(A10,45,46) and NOT (ANY(A15,2,3,10)) AND NOT (ANY(83,A46a,A46b)) A_TTGAIN = 2.
VARIABLE LABELS A_TTGAIN ‘A_TTGAIN Train to Gain Aim’.
VALUE LABELS A_TTGAIN
*/Note Value 1 – Train to Gain like learner is no longer applicable from 08/09.
-1 'Not Applicable/Not Known'
0 'No'
2 'Yes'.
SELECT IF A_ACTIVE=1.
*/Aggregate to learner level.
SORT CASES L01 L03.
aggregate
/outfile =’…..L_TTGAIN.SAV’ *
/presorted
/break = L01 L03
/L_TTGAIN = max(A_TTGAIN).
GET FILE=’………LEARNER Dataset’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’…… L_TTGAIN.SAV’
/BY L01 L03.
RECODE L_TTGAIN (SYSMIS=-1). |
4. The following SQL code illustrates how to derive A_TTGAIN:
|
select
L01, L03, A05
, case when A10 in (45,46) and A15 not in (2,3,10) and A46a<>83 and A46b<>83 then 2
else 0 end as A_TTGAIN
from
ILR0910_E_AIMS |
5. The following SQL code illustrates how to derive L_TTGAIN:
|
select
B.L01, B.L03
, case when L_TTGAIN_qry is NULL then -1
else L_TTGAIN_qry end as L_TTGAIN
from
(
select
L01, L03, count(A05) as aims
, max(A_TTGAIN) as L_TTGAIN_qry
from
ILR0910_L01_AIMS
where A_ACTIVE=1
group by
L01, L03, A_ACTIVE
)T
right outer join
ILR0910_L01_LEARNER B
on T.L01=B.L01 and T.L03=B.L03
order by
L01, L03 |
A_TTGBROKE
6. The following table shows the steps required to derive A_TTGBROKE
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is A_TTGAIN>0 |
Go to 2 |
Set A_TTGBROKE=0 |
| 2 |
Does A54 have a value |
Go to 3 |
|
| 3 |
Does A54 <> 9999999999 |
Set A_TTGBROKE to 1 |
Go to 4. |
| 4 |
Does A54 = 9999999999 |
Set A_TTGBROKE to 2 |
|
7. The following SPSS code illustrates how to derive A_TTGBROKE.
|
*/Create A_TTGBROKE Variable and set value to 0.
*/If the learner is a Train to Gain learner and a Broker No. is provided, then ATTGBROKE is set to 1.
*/If the learner is a Train to Gain learner and the Broker No. is 9999999999, A_TTGBROKE is set to 2.
COMPUTE A_TTGBROKE = 0.
IF (A_TTGAIN =2 and (A54 <> "NA" and A54 <> '9999999999')) A_TTGBROKE = 1.
IF (A_TTGAIN =2 and (A54 <> "" and A54 <> '9999999999')) A_TTGBROKE = 2.
VARIABLE LABELS A_TTGBROKE ‘ A_TTGBROKE Train to Gain Brokerage’.
VALUE LABELS A_TTGBROKE
0 'Not Brokered'
1 'Fully Brokered'
2 'Not fully Brokered'. |
8. The following SQL code illustrates how to derive A_TTGBROKE:
|
select
L01, L03, A05
, case when max(A_TTGAIN)>0 and max(A54) is not NULL and max(A54)<>'9999999999' then 1
when max(A_TTGAIN)>0 and max(A54)='9999999999' then 2
else 0 end as A_TTGBROKE
from
ILR0910_E_AIMS
group by
L01, L03, A05
order by
L01, L03, A05 |
Date last modified: 02nd December 2009
