Programme Achievement of NVQs Data Definition 2009/2010

P_NVQ_ACH_DATE

DATA DEFINITION

1. Achievement of NVQ or other equivalent competency based learning aim within an Apprenticeship.

PURPOSE

2. To identify whether an NVQ or equivalent competency based learning aim has been achieved. This is for ER only.

RELEVANT COLLECTIONS

  • ILR (ER)

    • SOURCE DATA

    3. The following variables are used as source data for the calculation of Achievement of NVQ.

    Field Name Label Dataset
    A10 A10 LSC Funding Stream Aims Standard File
    A15 A15 Programme type Aims Standard File
    A26 A26 Sector Framework of Learning Aims Standard File
    A40 A40 Achievement Date Aims Standard File
    A04 A04 Dataset Identifier Code Aims Standard File

    DERIVED VARIABLES AND DATASETS

    4. The definitions produces the following derived variable(s)

    Field Name Label Dataset
    P_NVQ_ACH_DATE P_NVQ_ACH_DATE Achievement of NVQ Aims Standard File

    DETAILED DEFINITION

    5. P_NVQ_ACH_DATE indicates that an NVQ has been achieved at Programme level, by going through the following stages:

    • If the aim is an Apprenticeship (A15 = 02, 03 or 10).
    • Where the LSC funding stream is Employer responsive main funded aim (A10 = 46). This is used to identify the NVQ aim. NVQs are no longer identifiable as standalone aims via the main delivery method ILR field (A18).
    • Where an Achievement date is given (A40 > 0).
    • If the above is true A_NVQ_ACH_DATE is set to be the Achievement date (A40).

    6. An aggregation to learner by Provider by Programme type by Framework code level then takes the maximum achievement date.

    7. If the learner has a Programme aim (A04 = 35) then P_NVQ_ACH_DATE is populated with the achievement date from A_NVQ_ACH_DATE_TEMP.

    Programme Achievement of NVQs Sample Code

    1. The following pseudo and SPSS code is provided to illustrate the Achievement of NVQs data definition.

    P_NVQ_ACH_DATE

    2. The following tables show the steps required to derive P_NVQ_ACH_DATE For Apprenticeships.

    Step Condition Action/Action if true Action if false
    1 Does A15 = 02, 03 or 10 Go to 2 Set A_NVQ_ACH_DATE_TEMP to Missing (Null Value)
    2 Does A10 = 46 Go to 3 Set A_NVQ_ACH_DATE_TEMP to Missing (Null Value)
    3 Is A40 > 0 Set A_NVQ_ACH_DATE_TEMP to A40 Set A_NVQ_ACH_DATE_TEMP to Missing (Null Value)
    4 (Aggregation)
    For all aims where L01, L03, A15 and A26 are the same.    		 P_NVQ_ACH_DATE_TEMP is the maximum Date of all of the aims in A_NVQ_ACH_DATE_TEMP
    Go to 5    		 Go to 5
    5 Does A04 = 35 the Programme aim. P_NVQ_ACH_DATE = P_NVQ_ACH_DATE_TEMP Set P_NVQ_ACH_DATE to Missing (Null Value)

    3. The following SPSS code illustrates how to derive P_NVQ_ACH_DATE.

    */Achievement of NVQ.
    */Creates a temporary NVQ achievement variable to equal the achievement date in A40
    */If the Programme type is an Apprenticeship and the funding stream is Employer responsive main funded aim and an achievement date is greater than 0.
    If (Any (A15,02,03,10) and A10 = 46 and A40 > 0) A_NVQ_ACH_DATE_TEMP = A40.

    */Aggregate to learner,provider level. Taking the maximum achievement date for each programme type by framework code.

    SORT CASES L01 L03 A15 A26.

    AGGREGATE
       /OUTFILE = * 
      /PRESORTED
      /BREAK = L01 L03 A15 A26
      /P_NVQ_ACH_DATE_TEMP= max(A_NVQ_ACH_DATE_TEMP).

    */Takes the Temporary Programme achievement date and creates a new variable P_NVQACH_DATE with this date, if it is a programme aim.
    If A04=35 P_NVQ_ACH_DATE=P_NVQ_ACH_DATE_TEMP.
    VARIABLE LABELS P_NVQ_ACH_DATE ‘P_NVQ_ACH_DATE - Achievement of NVQ’.

    FORMAT P_NVQ_ACH_DATE (DATE11).



    4. The following SQL code illustrates how to derive P_NVQ_ACH_DATE_TEMP:

    select

          L01, L03, A15, A26
          , case when A04=35 then max(A_NVQ_ACH_DATE_TEMP) else -1 end as P_NVQ_ACH_DATE

    from
         (
         select

               L01, L03, A04, A15, A26
               , case when A15 in (2,3,10) and A10=46 and A40 is not NULL then A40 end as A_NVQ_ACH_DATE_TEMP

         from

              ILR0910_E_AIMS

         )T

    --to group at programme level
    group by

          L01, L03, A15, A26, A04

    order by

          L01, L03, A15, A26



    Date last modified: 02nd December 2009