Skills for Life (SFL) LEITCH Numeracy Achievers Data Definition 2010/11

A_SFL_LEITCH_NUM_ACH, L_SFL_LEITCH_NUM _ACH

DATA DEFINITION

1. LEITCH Numeracy Achievement Skills for Life at aim or learner level.

PURPOSE

2. To identify whether a Skills for Life aim counts as an achievement under the Leitch Numeracy Entry level target.

RELEVANT COLLECTIONS

  • ILR (LR)
  • ILR (ER)
  • ILR (UFI)
  • ILR (ESF SR)
  • ILR (ASL)

SOURCE DATA

3. The following variables are used as source data for the calculation of Skills for Life LEITCH Numeracy Achievers.

Field Name Label Dataset
A_ACTIVE A_ACTIVE Aim Active for the current academic year Aims Standard File
A_SFLTY A_SFLTY Skills For Life Type Aims Standard File
A_NOTION A_NOTION Notional NVQ Level Analytical LAD
A_SFL A_SFL Counts towards Skills For Life Target Aims Standard File
A_OPROV A_OPROV Aim other provision Aims Standard File
A35 A35 Learning Outcome Aims Standard File

DERIVED VARIABLES AND DATASETS

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

Field Name Label Dataset
A_SFL_LEITCH_NUM _ACH A_SFL_LEITCH_NUM_ACH  Leitch Skills For Life Numeracy Achiever Aims Standard File
L_SFL_LEITCH_NUM _ACH L_SFL_LEITCH_NUM_ACH  Leitch Skills For Life Numeracy Achiever Aims Standard File

VALUES

5. The table below outlines the categories for A_SFL_LEITCH_NUM_ACH and L_SFL_LEITCH_NUM_ACH

Value Label
-1 Not Applicable/Not Known*  
0 No
1 Yes

*Applies to system missing values and where there are non-active aims. Only applicable at learner level.

DETAILED DEFINITION

Aim Level

6. An aim counts towards the LEITCH Numeracy Entry level skills for life achievement target where the aim is a Numeracy SFL type (A_SFLTY = 2), the LAD indicates that the Notional NVQ level is Entry (A_NOTION=E), it counts towards the Skills for Life target (A_SFL=1), it is not other provision (A_OPROV=0) and the aim has been Achieved (A35=1).

Learner Level
7. If the learner has any aims that count towards the LEITCH Numeracy Achievement target (A_SFL_LEITCH_NUM_ACH) then the learner is considered to be a LEITCH Numeracy Skills for Life Achievement Learner (L_SFL_LEITCH_NUM_ACH = 1). Only aims that are Active in the current academic year (A_ACTIVE=1) are included in the calculation.

Skills for Life (SFL) LEITCH Numeracy Achievers Sample Code

1. The following SQL code is provided to illustrate the SFL LEITCH Numeracy Achievers data definition.

A_SFL_LEITCH_NUM_ACH L_SFL_LEITCH_NUM_ACH

2. The following table shows the steps required to derive A_SFL_LEITCH_NUM_ACH L_SFL_LEITCH_NUM_ACH

Step Condition Action/Action if true Action if false
1 N/A Set A_SFL_LEITCH_NUM_ACH to 0 N/A
2 Does A_SFLTY = 2 And A_NOTION = “E” And A_SFL = 1
And A_OPROV = 0 And A35 = 1 		Set A_SFL_LEITCH_NUM_ACH to 1. Go to 3 Go to 3
3 Does L_ACTIVE = 1 Go to 4. Set
L_SFL_LEITCH_NUM_ACH to -1
4 Does the learner have any aims where A_SFL_LEITCH_NUM_ACH = 1 Set L_SFL_LEITCH_NUM_ACH to 1 Set L_SFL_LEITCH_NUM_ACH to 0

Step Condition Action/Action if true Action if false
1 Does L_SFL_LEITCH_NUM_ACH contain a value None Set L_SFL_LEITCH_NUM_ACH = -1

3. The following SQL code illustrates how to derive A_SFL_LEITCH_NUM_ACH:

select

      L01, L03, A05
      , case when A_SFLTY = 2 and A_NOTION = 'E' and a.A_SFL = 1 and A_OPROV = 0 and A35 = 1 then 1
      else 0 end as A_SFL_LEITCH_NUM_ACH

from

     ILR0910_E_AIMS a
     join
     LAD_0910 b

          on a.A09 = b.A09


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

select

      B.L01, B.L03
      , case when L_SFL_LEITCH_NUM_ACH_qry is NULL then -1 else L_SFL_LEITCH_NUM_ACH_qry end as L_SFL_LEITCH_NUM_ACH

from
     (
     select

           L01, L03, count(A05) as aims
      , max(A_SFL_LEITCH_NUM_ACH) as L_SFL_LEITCH_NUM_ACH_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

      B.L01, B.L03


Date last modified: 09th August 2010