Provision Mix Sample Code

Note: This page is from an older version of the Data Dictionary and may therefore contain information that is now out of date. It is included here for reference only.

1 The following pseudo code and SPSS code is provided to illustrate the Provision Mix data definition.

A_PROVMIX

2 The following table shows the steps required to derive A_PROVMIX

Step	Condition	Action if true	Action if false
1	Does A_FUN_ST= 01, 02, 03 or 06	Set A_PROVMIX to 10	Go to 2
2	Does A_FUN_ST= 04	Set A_PROVMIX to 40	Go to 3
3	Does A_NOTION= 3 or X and A09_TITL contain ‘Access’	Set A_PROVMIX to 41	Go to 4
4	Does A_PROVMIX = 0 and A_AWARDB= ‘None’ and A_ENG_S2= DC, E, EP, F, FP, G, GP, J, JP, N, NC, U, X or Y	Set A_PROVMIX to 20	Go to 5
5	Does A_PROVMIX = 0 and A_ENG_S2= C, CP, D, DP, DC, E, EP, F, FP, G, GP, J, JP, N, NC, U or X	Set A_PROVMIX to 30	Go to 6
6	Does A_LATYPE= 1327 and A_KSCODE = 3	Set A_PROVMIX to 50	Go to 7
7	Does A_LATYPE= 1413 and A_FUN_ST= 98	Set A_PROVMIX to 60	Go to 8
8	Does A_LATYPE= 1413 and A_FUN_ST<> 98	Set A_PROVMIX to 61	Go to 9
9	Does A_SFL = Y and A_FUN_ST= 98	Set A_PROVMIX to 70	Go to 10
10	Does A_SFL = Y and A_FUN_ST<> 98	Set A_PROVMIX to 71	Go to 11
11	Does A_PROVMIX = 20 and A09_TITL does not contain ‘Teach’ or ‘Tutor’ and A_SUBPRG= 9H or 10B	Set A_PROVMIX to 80	Go to 12
12	Does A_PROVMIX = 20 and A09_TITL does not contain ‘Teach’ or ‘Tutor’ and A_SUPRCL= FK.222 or FK.222	Set A_PROVMIX to 80	Go to 13
13	Does A_PROVMIX = 20 and A09_TITL does not contain ‘Teach’ or ‘Tutor’ and A09_TITL contains ‘ESOL’	Set A_PROVMIX to 80	Go to 14
14	Does A_PROVMIX = 20 and A09_TITL does not contain ‘Teach’ or ‘Tutor’ and A09_TITL contains ‘English’ and ‘Language’ and either ‘Foreign’, ’’Other’ or Second	Set A_PROVMIX to 80	Go to 15
15	Does A_PROVMIX = 20 and A09_TITL does not contain ‘Teach’ or ‘Tutor’ and A09_TITL contains ‘CCSE’	Set A_PROVMIX to 80	Go to 16
16	Does A_PROVMIX = 30 and A09_TITL does not contain ‘Teach’ or ‘Tutor’ and A_SUBPRG= 9H or 10B	Set A_PROVMIX to 90	Go to 17
17	Does A_PROVMIX = 30 and A09_TITL not contain ‘Teach’ or ‘Tutor’ and A_SUPRCL= FK.222 or FK.222	Set A_PROVMIX to 90	Go to 18
18	Does A_PROVMIX = 30 and A09_TITL contains ‘ESOL’ A09_TITL not contain ‘Teach’ or ‘Tutor’	Set A_PROVMIX to 90	Go to 19
19	Does A_PROVMIX = 30 and A09_TITL not contain ‘Teach’ or ‘Tutor’, and A09_TITL contains ‘English’ and ‘Language’ and either Foreign, Other or Second and A09_TITL does not contain ‘Teach’	Set A_PROVMIX to 90	Go to 20
20	Does A_PROVMIX = 30 and A09_TITL contains ‘CSE and A09_TITL not contain ‘Teach’ or ‘Tutor’	Set A_PROVMIX to 90	Go to 21
21	Does A_PROVMIX = 20 or 30 and a_pwfc= F	Set A_PROVMIX to 72	Go to 22
22	Does A_PROVMIX = 20 or 30 and A_SUPRCL= HD.2, HD.21, HD.3, HD.31, HD.32, HD.33, HD.4 or HD.41	Set A_PROVMIX to 73	Go to 23
23	Does A_PROVMIX = 20 or 30 and A_NOTION= E, 1, 2, X, M or U and A_SUBPRG= 10A, 10B or 10C.	Set A_PROVMIX to 73	Go to 24
24	Does A_PROVMIX = 20 or 30 and A_NOTION= E, 1, 2, X, M or U and A_SUBPRG= 99X or NA and A09_TITL contain ‘Literacy’ or ‘Numeracy’	Set A_PROVMIX to 73	Go to 25
25	Does A09=CSC30001 or XSC30001	Set A_PROVMIX to 110	Go to 26
26	Does A09=CSC30002, CSC30003, CSC30004, XSC30002, XSC30003, XSC30004, XSC300D2, XSC300D3, XSC300D4 or begins with CDT	Set A_PROVMIX to 120	Go to 27
27	Does A09=CSC60002, CSC60003, CSC60004 XSC60002, XSC60003, XSC60004	Set A_PROVMIX to 130	Go to 28
28	Does A09=CSC6000A, CSC6000B, CSC6000C, CSC6000D, CSC6000E, XSC6000A, XSC6000B, XSC6000C, XSC6000D, XSC6000E	Set A_PROVMIX to 140	Go to 29
29	Does A09 begin with CUNE	Set A_PROVMIX to 150	Go to 30
30	Does A09=begin with CUNA or XUN	Set A_PROVMIX to 180	Go to 31
31	Does A09=begin with C9OP or X9OP	Set A_PROVMIX to 200	Go to 32
32	Does A_PROVMIX = 20 and A_NOTION= 4, 5 or H	Set A_PROVMIX to 160	Go to 33
33	Does A_PROVMIX = 30 and A_NOTION= 4, 5 or H	Set A_PROVMIX to 170	Go to 34
34	Does A_PROVMIX = 0 and A_ENG_S2= A, AP, B or BP or (A_ENG_S2= Y and A_AWARDB <> None)	Set A_PROVMIX to 100	Go to 35
35	Does A09_TITL contain ‘NVQ/GNVQ’	Set A_PROVMIX to 190	Go to 36
36	Does A_PROVMIX <> 10, 40, 41 or 220 and A_SUBPRG= 9B	Set A_PROVMIX to 210	Go to 37
37	Does A_PROVMIX <> 10, 40 or 220 and A_SUBPRG= 99X and A09_TITL contain (FLIC)	Set A_PROVMIX to 210	Go to 38
38	Does A_PROVMIX = 10 and A_SUBPRG= 9B	Set A_PROVMIX to 220	Go to 39
39	Does A_PROVMIX = 210 and A_FUN_ST <> '98' or <> '99'	Set A_PROVMIX to 220	Go to 40
40	Does A_AWARDB= UFI	Set A_PROVMIX to 230	Set A_PROVMIX to 999

3 The following SPSS code illustrates how to derive A_PROVMIX

/* Calculate the NVQ Marker.
COMPUTE A_PROVMIX = 0.

/* WITHIN NQF (SECTION 96, 97 AND COMPONENTS)
/* If any quals are 'section 96 only', 'section 97' only or 'section 96 and section 97' .
/* in terms of funding status assign flag of 10.
IF (ANY (A_FUN_ST,'01','02','03','06')) A_PROVMIX = 10.

/* ACCESS TO HE PROGRAMMES (QAA RECOGNISED)
/* If any quals are 'QAA (Quality Assurance Agency for Higher Education) recognised'.
/* in terms of funding status assign flag of 40.
IF (A_FUN_ST = '04') A_PROVMIX = 40.

/* ACCESS TO HE PROGRAMMES (NOT QAA RECOGNISED)
/* If any quals are level 3 (or X) Access courses assign flag of 41.
IF ((A_PROVMIX = 0) AND (ANY(A_NOTION,'3','X')) AND (INDEX (LOWER (A09_TITL),'ACCESS') > 0)) A_PROVMIX = 41.

/* NOT WITHIN NQF (INTERNALLY CERTIFICATED)
/* If any quals have no awarding body assigned to them and. 
/* are in the schedule 2 categories listed then assign flag of 20.
IF (A_PROVMIX = 0 AND A_AWARDB = 'NONE' AND ANY (A_ENG_S2,'DC','E','EP','F','FP','G','GP','J','JP','N','NC','U','X','Y')) A_PROVMIX = 20.

/* NOT WITHIN NQF (EXTERNALLY ACCREDITED)
/* If any quals do have an awarding body assigned to them and. 
/* are in the schedule 2 categories listed then assign flag of 30.
IF (A_PROVMIX = 0 AND ANY (A_ENG_S2,'DC','E','EP','F','FP','G','GP','J','JP','N','NC','U','X')) A_PROVMIX = 30.

/* If any quals are in any of the following schedule 2 categories.
/* assign a flag of 30.
IF (A_PROVMIX = 0 AND ANY (A_ENG_S2,'C','CP','D','DP')) A_PROVMIX = 30.

/* WIDER KEY SKILLS
/* If wider key skills assign flag of 50.
IF ((A_LATYPE = '1327') AND (A_KSCODE = '3')) A_PROVMIX = 50.

/* GCE A2 LEVEL
/* If A2 and funding status says 'other provision' assign flag of 60.
/* If A2 and funding status does not say 'other provision' assign flag of 61.
IF ((A_LATYPE = '1413') AND (A_FUN_ST = '98')) A_PROVMIX = 60.
IF ((A_LATYPE = '1413') AND (A_FUN_ST <> '98')) A_PROVMIX = 61.

/* SKILLS FOR LIFE (COUNTING TOWARDS THE TARGET)
/* If basic skills target flag says yes and funding status says 'other provision' assign flag of 70.
/* If basic skills target flag says yes and funding status does not say 'other provision' assign flag of 71.
IF ((A_SFL = 'Y') AND (A_FUN_ST = '98')) A_PROVMIX = 70.
IF ((A_SFL = 'Y') AND (A_FUN_ST <> '98')) A_PROVMIX = 71.

/* ESOL (INTERNALLY CERTIFICATED)
/* If quals in certain sub-programme areas/ superclass codes that are NOT teaching quals.
/* or have ESOL in title and are internally certificated assign flag of 80.
IF (((ANY (A_SUBPRG,'9H','10B')) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0))) AND A_PROVMIX = 20) A_PROVMIX = 80.
IF (((ANY (A_SUPRCL,'FK.221','FK.222')) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0))) AND A_PROVMIX = 20) A_PROVMIX = 80.
IF (((INDEX (UPCASE (A09_TITL),'ESOL') > 0) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0))) AND A_PROVMIX = 20) A_PROVMIX = 80.
IF ((INDEX (LOWER (A09_TITL),'ENGLISH') > 0) AND (INDEX (LOWER (A09_TITL),'LANGUAGE') > 0) AND ((INDEX (LOWER (A09_TITL),'FOREIGN') > 0) OR (INDEX (LOWER (A09_TITL),'OTHER') > 0) OR (INDEX (LOWER (A09_TITL),'SECOND') > 0)) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0)) AND A_PROVMIX = 20) A_PROVMIX = 80.
IF (((INDEX (UPCASE (A09_TITL),'(CCSE)') > 0) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0))) AND A_PROVMIX = 20) A_PROVMIX = 80.

/* ESOL (EXTERNALLY ACCREDITED)
/* If quals in certain sub-programme areas/ superclass codes that are NOT teaching quals.
/* or have ESOL in title and are externally accredited assign flag of 90.
IF (((ANY (A_SUBPRG,'9H','10B')) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0))) AND A_PROVMIX = 30) A_PROVMIX = 90.
IF (((ANY (A_SUPRCL,'FK.221','FK.222')) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0))) AND A_PROVMIX = 30) A_PROVMIX = 90.
IF (((INDEX (UPCASE (A09_TITL),'ESOL') > 0) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0))) AND A_PROVMIX = 30) A_PROVMIX = 90.
IF ((INDEX (LOWER (A09_TITL),'ENGLISH') > 0) AND (INDEX (LOWER (A09_TITL),'LANGUAGE') > 0) AND ((INDEX (LOWER (A09_TITL),'FOREIGN') > 0) OR (INDEX (LOWER (A09_TITL),'OTHER') > 0) OR (INDEX (LOWER (A09_TITL),'SECOND') > 0)) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) AND (INDEX (LOWER (A09_TITL),'TUTOR') = 0)) AND A_PROVMIX = 30) A_PROVMIX = 90.
IF (((INDEX (UPCASE (A09_TITL),'(CCSE)') > 0) AND ((INDEX (LOWER (A09_TITL),'TEACH') = 0) OR (INDEX (LOWER (A09_TITL),'TUTOR') = 0))) AND A_PROVMIX = 30) A_PROVMIX = 90.

/* SKILLS FOR LIFE (NOT COUNTING TOWARDS THE TARGET)
/* If any quals have programme weighting factor code of 'F' and provision is.
/* not within NQF nor Access to HE assign flag of 72.
IF ((A_PWFC = 'F') AND (ANY (A_PROVMIX,20,30))) A_PROVMIX = 72.

/* ADULT BASIC EDUCATION
/* If in any of the superclass codes or sub programme areas listed below and.
/* provision is not within NQF nor Access to HE assign flag of 73.
IF ((ANY (A_SUPRCL,'HD.2','HD.21','HD.3','HD.31','HD.32','HD.33','HD.4','HD.41')) AND (ANY (A_PROVMIX,20,30))) A_PROVMIX = 73.
IF ((ANY (A_NOTION,'E','1','2','X','M','U')) AND (ANY (A_PROVMIX,20,30)) AND (ANY (A_SUBPRG,'10A','10B','10C'))) A_PROVMIX = 73.
IF ((ANY (A_NOTION,'E','1','2','X','M','U')) AND (ANY (A_PROVMIX,20,30)) AND (ANY (A_SUBPRG,'99X','NA')) AND ((INDEX (LOWER (A09_TITL),'NUMERACY') > 0) OR (INDEX (LOWER (A09_TITL),'LITERACY') > 0))) A_PROVMIX = 73.

/* 3 GLH ITC COURSES
/* If the qual is either of the two 3 glh ITC courses below assign flag of 110.
IF (ANY (A09,'CSC30001','XSC30001')) A_PROVMIX = 110.

/* 3 GLH BASIC SKILLS COURSES
/* If the qual is any of the nine 3 glh basic skills courses below or begins 'CDT' assign flag of 120.
IF (ANY (A09,'CSC30002','CSC30003','CSC30004','XSC30002','XSC30003','XSC30004', 'XSC300D2','XSC300D3','XSC300D4')) A_PROVMIX = 120.
IF (SUBSTR (A09,1,3) = 'CDT') A_PROVMIX = 120.

/* 6 GLH BASIC SKILLS COURSES
/* If the qual is any of the six 6 glh basic skills courses below assign flag of 130.
IF (ANY (A09,'CSC60002','CSC60003','CSC60004','XSC60002','XSC60003','XSC60004')) A_PROVMIX = 130.

/* 6 GLH OTHER COURSES
/* If the qual is any of the ten 6 glh other courses below assign flag of 130.
IF (ANY (A09,'CSC6000A','CSC6000B','CSC6000C','CSC6000D','CSC6000E','XSC6000A', 'XSC6000B','XSC6000C','XSC6000D','XSC6000E')) A_PROVMIX = 140.

/* OTHER QUALIFICATIONS STARTING 'CUNE'
/* If any quals start 'CUNE' assign flag of 150.
IF (SUBSTR (A09,1,4) = 'CUNE') A_PROVMIX = 150.

/* OTHER QUALIFICATIONS STARTING 'CUNA' AND 'XUN'
/* If any quals start 'XUN' or 'CUNA' assign flag of 180.
IF (SUBSTR (A09,1,3) = 'XUN') A_PROVMIX = 180.
IF (SUBSTR (A09,1,4) = 'CUNA') A_PROVMIX = 180.

/* OTHER PROVISION CODES STARTING 'C9OP' AND 'X90P')
/* If any quals start 'C9OP' or 'X9OP' assign flag of 200.
IF (ANY (SUBSTR (A09,1,4),'C9OP','X9OP')) A_PROVMIX = 200.

/* HIGHER LEVEL QUALS
/* If any quals are level 4 or above and outside the NQF then assign flag of either.
/* 160 (internally certificated) or 170 (externally accredited).
IF ((ANY (A_PROVMIX,20,30)) AND (ANY (A_NOTION,'4','5','H'))) A_PROVMIX = A_PROVMIX + 140.

/* SCHEDULE 2 (FORMERLY NQF)
/* If quals are outside of all previously defined categories and schedule 2a or 2b.
/* or 'Y' with no awarding body assign flag of 100.
IF ((A_PROVMIX = 0) AND (ANY (A_ENG_S2,'A','AP','B','BP'))) A_PROVMIX = 100.
IF ((A_PROVMIX = 0) AND (A_ENG_S2 = 'Y') AND (A_AWARDB <> 'NONE')) A_PROVMIX = 100.

/* NVQ/ GNVQ ADDITIONAL UNITS
/* If title includes 'NVQ/GNVQ' then assign flag of 190.
IF (INDEX (UPCASE (A09_TITL),'NVQ/GNVQ') > 0) A_PROVMIX = 190.

/* MODERN FOREIGN LANGUAGES (DELIVERED AS OTHER PROVISION)
/* If outside NQF and in sub-programme area 9B or if unknown sub-programme area.
/* and title includes 'FLIC' assign flag of 210.
IF (((A_PROVMIX <> 10) AND (A_PROVMIX <> 40) AND (A_PROVMIX <> 41) AND (A_PROVMIX <> 220)) AND (A_SUBPRG = '9B')) A_PROVMIX = 210.
IF ((INDEX (UPCASE (A09_TITL),'(FLIC)') > 0) AND (A_SUBPRG = '99X') AND ((A_PROVMIX <> 10) AND (A_PROVMIX <> 40) AND (A_PROVMIX <> 220))) A_PROVMIX = 210.

/* MODERN FOREIGN LANGUAGES (DELIVERED WITHIN THE NQF)
/* If inside NQF and in sub-programme area 9B assign flag of 220.
IF ((A_PROVMIX = 10) AND (A_SUBPRG = '9B')) A_PROVMIX = 220.
IF ((A_PROVMIX = 210) AND ((A_FUN_ST <> '98') AND (A_FUN_ST <> '99'))) A_PROVMIX = 220.

/* UNIVERSITY FOR INDUSTRY
/* If awarding body is 'UFI' assign flag of 230.
IF (A_AWARDB = 'UFI') A_PROVMIX = 230.

Creator	Analysis and MI Team
Date issued	1 March 2006
Date created	1 March 2006
Document ref.	\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-provisionmixsamplecode-report-01mar2006.doc
LSC office	Learning and Skills Council Cheylesmore House Quinton Road Coventry CV1 2WT T 0845 019 4170 F 024 7682 3675 www.lsc.gov.uk/

Last Modified: 6 Mar 06