Train to Gain Data Definition 2008/2009

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

    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).

    10. Train to Gain data in 08/09 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 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 A_TTGAIN contain a value None Set A_TTGAIN = -1

    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)) 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 in 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).

    A_TTGBROKE

    4. 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  
    2 Does A54 have a value Go to 3  
    3 Does A54 <> 9999999999 Set A_TTGBROKE to 1  
    4 Does A54 = 9999999999 Set A_TTGBROKE to 2  

    5. 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'.

    Date last modified: 15th January 2009