Programme Status Data Definition 2009/2010
P_PROG_STATUS
DATA DEFINITION
1. Status of NVQ /Programme.
PURPOSE
2. The status field identifies the status of National Vocational Qualifications (NVQs) within (Apprenticeships) programmes, with regards to achievement and completion, for example.
RELEVANT COLLECTIONS
ILR (ER)
SOURCE DATA
3. The following variables are used as source data for the calculation of Status of NVQ / Programme.
| Field Name |
Label |
Dataset |
| A04 |
A04 Data Set Identifier Code |
Aims Standard File |
| A15 |
A15 Programme type |
Aims Standard File |
| A31 |
A31 Learning Actual End Date |
Aims Standard File |
| A34 |
A34 Completion Status |
Aims Standard File |
| A35 |
A35 Learning Outcome |
Aims Standard File |
| A40 |
A40 Achievement Date |
Aims Standard File |
| A50 |
A50 Reason Learning Ended |
Aims Standard File |
| P_NVQ_ACH_DATE |
P_NVQ_ACH_DATE Achievement of NVQ |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definitions produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| P_PROG_STATUS |
P_PROG_STATUS Status of NVQ Framework |
Aims Standard File |
VALUES
5. The table below outlines the categories for P_PROG_STATUS:
| P_PROG_STATUS |
Label |
| -1 |
Not Applicable/ Not Known |
| 0 |
Continuing |
| 1 |
Framework achieved |
2 |
Continuing framework awaiting aim start [removed] |
| 3 |
Framework complete awaiting confirmation of achievements |
| 4 |
NVQ achieved |
| 5 |
NVQ achieved, continuing framework |
| 6 |
No achievement |
| 7 |
Transfer |
| 8 |
Transfer to a new programme at the same provider |
| 9 |
Transfer to a new provider |
| 10 |
Transfer to a new provider forced by LSC intervention |
| 11 |
Learner is taking a planned break from learning |
| 12 |
NVQ achieved but learner is now taking a planned break from learning on the framework |
| 13 |
Withdrawn |
DETAILED DEFINITION
6. P_PROG_STATUS calculates values for the status of the Programme, following some logical rules. These calculations are carried out in a specific order, as some of the earlier values may be overwritten if the later conditions are satisfied. This is only carried out for Apprenticeships at Programme level (A15 = 2, 3 or 10 and A04=35 for which status is set to 7 - Transfer).
7. If the learning actual end date (A31) is missing then status is set to 0 – continuing.
8. If achievement date (A40 > 0) is given then status is set to 1 – Framework Achieved.
9. If the learning actual end date is given and the learning outcome is exam taken but result not yet known or learning activities complete but exam not yet taken (A35 = 4 or 5) and an achievement date (A40) is missing, then status is set to 3 - Framework complete awaiting confirmation of achievements.
10. If the Programme level NVQ achievement date is greater than 0 (P_NVQ_ACH_DATE > 0) and the learning actual end date is greater than 0 (A31 > 0) and the achievement date (A40) is missing then status is set to 4 - NVQ achieved.
11. If the Programme level NVQ achievement date is greater than 0 (P_NVQ_ACH_DATE > 0) and the learning actual end date (A31) is missing then status is set to 5 - NVQ achieved, continuing framework.
12. If the learning actual end date is given (A31 > 0) and both the achievement date (A40) and Programme level NVQ achievement date (P_NVQ_ACH_DATE) is missing then status is set to 6 - No achievement.
13. If the programme aim is a transfer (A34 = 3) then status is set to 13 - Withdrawn.
14. If the programme aim is a transfer or there are changes in learning within the same programme type and sector at the same Provider (A34 = 4 or 5) then status is set to 8 - Transfer to a new programme at the same provider.
15. If reason learning ended is transferred to another employer/provider/local LSC in the same programme type (A50 = 2) then status is set to 9 - Transfer to a new provider.
16. If reason learning ended is transferred between providers due to intervention by the LSC (A50 = 7) then status is set to 10 - Transfer to a new provider forced by LSC intervention.
17. If there is an agreed break in learning (A34=6) for the programme aim then status is set to 11 - Learner is taking a planned break from learning.
18. If there is an agreed break in learning (A34=6) for the programme aim and Programme level NVQ achievement date is greater than 0 (P_NVQ_ACH_DATE > 0) then status is set to 11 - Learner is taking a planned break from learning.
Programme Status Sample Code
1. The following pseudo and SPSS code is provided to illustrate the Programme Status data definition.
P_PROG_STATUS
2. The following tables show the steps required to derive P_PROG_STATUS for Apprenticeships.
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Any |
Set P_PROG_STATUS = -1 |
|
| 2 |
If A15 = 2,3 or 10 and A04 = 35 |
Set P_PROG_STATUS = 7.Go to 3 |
|
| 3 |
Does A31 = Missing |
Set P_PROG_STATUS = 0 |
Go to 4 |
| 4 |
Is A40 > 0 |
Set P_PROG_STATUS = 1 |
Go to 5 |
| 5 |
Is (A31 > 0 and does A35 =4 or 5 and Is A40 = missing) |
Set P_PROG_STATUS = 3 |
Go to 6 |
| 6 |
Is P_NVQ_ACH_DATE > 0 and A31 > 0 and A40 is missing |
Set P_PROG_STATUS = 4 |
Go to 7 |
| 7 |
Is P_NVQ_ACH_DATE > 0 and A31 = missing |
Set P_PROG_STATUS = 5 |
Go to 8 |
| 8 |
Is (A31 > 0 and A40 = missing and P_NVQ_ACH_DATE = missing) |
Set P_PROG_STATUS = 6 |
Go to 9 |
| 9 |
Does A34 = 3 |
Set P_PROG_STATUS = 13 |
Go to 10 |
| 10 |
Does A34 = 4 or 5 |
Set P_PROG_STATUS = 8 |
Go to 11 |
| 11 |
Does A50 =2 |
Set P_PROG_STATUS = 9 |
Go to 12 |
| 12 |
Does A50 = 7 |
Set P_PROG_STATUS = 10 |
Go to 13 |
| 13 |
Does A34 = 6 |
Set P_PROG_STATUS = 11 |
Go to 14 |
| 14 |
Does A34 = 6 and P_NVQ_ACH_DATE > 0 |
Set P_PROG_STATUS = 12 |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does P_PROG_STATUS contain a value |
None |
Set P_PROG_STATUS = -1 |
3. The following SPSS code illustrates how to derive P_PROG_STATUS.
|
*P_PROG_STATUS Created and set to -1 - Not Applicable.
*/Calculate P_PROG_STATUS for only Apprenticeship (Apprenticeship, Advanced Apprenticeship and Higher level apprenticeship) programme aims. P_PROG_STATUS is 7.
*/If the learning actual end date is missing P_PROG_STATUS is 0.
*/If achievement date is given then P_PROG_STATUS is 1.
*/If the learning actual end date is given and the learning outcome is exam taken but result not yet known or learning activities complete but exam not yet taken and the achievement date is missing,P_PROG_STATUS is 3.
*/If the Programme level NVQ achievement date is greater than 0 and the learning actual end date is greater than 0 and the achievement date is missing, P_PROG_STATUS is 4.
*/If the Programme level NVQ achievement date is greater than 0 and the learning actual end date is missing, P_PROG_STATUS is 5.
*/If the learning actual end date is given and both the achievement date and Programme level NVQ achievement date is missing, P_PROG_STATUS is 6.
*/If the programme aim is a transfer, P_PROG_STATUS is 13.
*/If the programme aim is a transfer or there are changes in learning within the same programme type and sector at the same Provider, P_PROG_STATUS is 8.
*/If reason learning ended is transferred to another employer/provider/local LSC in the same programme type, P_PROG_STATUS is 9.
*/If reason learning ended is transferred between providers due to intervention by the LSC P_PROG_STATUS is 10.
*/If there is an agreed break in learning for the programme aim, P_PROG_STATUS is 11.
*/If there is an agreed break in learning for the programme aim and Programme level NVQ achievement date is greater than 0, P_PROG_STATUS is 11.
COMP P_PROG_STATUS=-1.
DO IF ANY(A15,2,3,10) and A04=35.
COMP P_PROG_STATUS=7.
IF MISSING(A31) OR A31=-1 P_PROG_STATUS=0.
IF A40>0 P_PROG_STATUS=1.
IF A31>0 AND ANY(A35,4,5) AND MISSING(A40) P_PROG_STATUS=3.
IF P_NVQ_ACH_DATE>0 AND A31>0 AND MISSING(A40) P_PROG_STATUS=4.
IF P_NVQ_ACH_DATE>0 AND MISSING(A31) P_PROG_STATUS=5.
IF A31>0 AND MISSING(A40) AND MISSING(P_NVQ_ACH_DATE) P_PROG_STATUS=6.
IF A34=3 P_PROG_STATUS=13.
IF ANY(A34,4,5) P_PROG_STATUS=8.
IF A50=2 P_PROG_STATUS=9.
IF A50=7 P_PROG_STATUS=10.
IF A34=6 P_PROG_STATUS=11.
IF A34=6 AND P_NVQ_ACH_DATE>0 P_PROG_STATUS=12.
END IF.
Variable labels P_PROG_STATUS ‘P_PROG_STATUS Status of NVQ Framework’
Value labels P_PROG_STATUS -1 ‘Not Applicable/ Not Known ‘
0 ‘Continuing ‘
1 ‘Framework achieved ‘
3 ‘Framework complete awaiting confirmation of achievements ‘
4 ‘NVQ achieved ‘
5 ‘NVQ achieved, continuing framework ‘
6 ‘No achievement ‘
7 ‘Transferred /Withdrawn ‘
8 ‘Transfer to a new programme at the same provider ‘
9 ‘Transfer to a new provider ‘
10 ‘Transfer to a new provider forced by LSC intervention ‘
11 ‘Learner is taking a planned break from learning ‘
12 ‘NVQ achieved but learner is now taking a planned break from learning on the framework ‘
13 ‘Withdrawn ‘. |
4. The following SQL code illustrates how to derive P_PROG_STATUS:
|
select
L01, L03, A15, A26
, case when max(A15) in (2,3,10) and max(A04)=35 and max(A40)>0 then 1
when max(A15) in (2,3,10) and max(A04)=35 and max(A34)=3 then 13
when max(A15) in (2,3,10) and max(A04)=35 and max(A34) in (4,5) then 8
when max(A15) in (2,3,10) and max(A04)=35 and max(A50)=2 then 9
when max(A15) in (2,3,10) and max(A04)=35 and max(A50)=7 then 10
when max(A15) in (2,3,10) and max(A04)=35 and max(A34)=6 then 11
when max(A15) in (2,3,10) and max(A04)=35 and max(A34)=6 and max(P_NVQ_ACH_DATE) is not null then 12
when max(A15) in (2,3,10) and max(A04)=35 and max(A31) is not null and max(A40) is null and max(P_NVQ_ACH_DATE) is null then 6
when max(A15) in (2,3,10) and max(A04)=35 and max(P_NVQ_ACH_DATE) is not null and max(A31) is null then 5
when max(A15) in (2,3,10) and max(A04)=35 and max(A31) is null then 0
when max(A15) in (2,3,10) and max(A04)=35 and max(P_NVQ_ACH_DATE) is not null and max(A31) is not null and max(a40) is null then 4
when max(A15) in (2,3,10) and max(A04)=35 and max(A31) is not null and max(A35) in (4,5) and max(A40) is null then 3
when max(A15) in (2,3,10) and max(A04)=35 then 7
else -1 end as P_PROG_STATUS
from
ILR0910_E_AIMS
group by
L01, L03, A15, A26
order by
L01, L03, A15, A26 |
Date last modified: 07th December 2009
