Programme Achievement of NVQs Data Definition 2008/2009

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 NameLabelDataset
    A10A10 LSC Funding StreamAims Standard File
    A15A15 Programme typeAims Standard File
    A26A26 Sector Framework of LearningAims Standard File
    A40A40 Achievement DateAims Standard File

    DERIVED VARIABLES AND DATASETS

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

    Field NameLabelDataset
    P_NVQ_ACH_DATEP_NVQ_ACH_DATE Achievement of NVQAims 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.

    StepConditionAction/Action if trueAction if false
    1Does A15 = 02, 03 or 10Go to 2Set A_NVQ_ACH_DATE_TEMP to Missing (Null Value)
    2Does A10 = 46Go to 3Set A_NVQ_ACH_DATE_TEMP to Missing (Null Value)
    3Is A40 > 0Set A_NVQ_ACH_DATE_TEMP to A40Set 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
    5Does A04 = 35 the Programme aim.P_NVQ_ACH_DATE = P_NVQ_ACH_DATE_TEMPSet 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).

    Date last modified: 9th Janary 2009