1 Status of NVQ / Framework.
Purpose
2 The status field identifies the status of frameworks and standalone National Vocational Qualifications (NVQs), with regards to achievement and completion, for example.
Relevant Collections
Source Data
3 The following variables are used as source data for the calculation of Status of NVQ / Framework.
Field Name | Label |
A10 | LSC Funding Stream |
A31 | Learning Actual End Date |
A40 | Achievement Date |
A43 | Sector Framework Achievement Date |
L39 | Destination |
A_ACHIEVE | DV - NVQ Achieved Only on Aims File |
Derived Variables and Datasets
4 The definitions produces the following derived variable(s)
Field Name | Label | Dataset |
A_STATUS | Status of NVQ / Framework | Frameworks and Aims Standard File |
Detailed definition
5 A_status calculates values for the status of the framework, 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 framework records (A10=50).
6 If the framework record doesn't have a value in the learning actual end date (A31), then set status to continuing (0).
7 If the framework record doesn't have a value in the learning actual end date (A31), but they have achieved an NVQ, then set status to NVQ achieved, continuing (5).
8 If the framework record has a value in the learning actual end date (A31), doesn't have a value in the framework achievement date (A43), but has achieved the NVQ, then set the status to NVQ Achieved (4).
9 If the framework record has a value in the learning actual end date (A31), bit there is no value in the framework achievement date (A43), and has not achieved the NVQ, , i.e. has the value 0 in the field a_nvqach then set status to No Achievement (6).
10 If the learner destination is set to continuing or awaiting (L39=3 or 4), and the framework record doesn't have a value in the learning actual end date (A31), then set status to either Continuing Framework awaiting aim start (2) or 'Framework Complete Awaiting confirmation of achievements' (3) accordingly.
11 If the status of the framework record is no achievement, and the value in the learning actual end date (A31) is equal to the value in the temporary field tran_date, then it is assumed that the learner has transferred off this framework, and so the record is marked as a transfer (7).
12 If the framework record has a value in the achievement date field (A43), then set status to Framework Achieved (1).
Value | Label |
0 | Continuing |
1 | Framework achieved |
2 | Continuing framework awaiting aim start |
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 |
Sample Code
14 The following sample code is available
