Skills for Life Participation 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 is provided to illustrate the Skills for Life Participation data definition.

A_SFLPAR and A_SFLTYA

2 The following table shows the steps required to derive A_SFLPAR and A_SFLTYA.

Step

Condition

Action if true

Action if false

1

DOES A09 = ANY("00222873", "00222934","00222941","00236786", "00269334","CBS10002","CBS20002", "CBSE0002","CBSP0002","CNBS1002", "CNBS2002","CNBSE002")

Go to 7

Go to 2

2

IS A_SFLTYP NOT ANY(“U”,“X”)

Go to 7

Go to 3

3

DOES A_NOTION = ANY (“E”,”1”,”2”,”M”,”X”) AND A_LATYPE NOT ANY (“0003”,”0035”,”1327”) AND (A_SFL= “N”)

Go To 4

Set all A_SFLPAR A_SFLTYA to NULL

4

DOES A_SUBPRG = ANY (“9H”,”10A”,”10B”,”10C”)

Go to 7

Go to 5

5

DOES (A_LDCS) = ANY ("HD.", "HD.2","HD.3","HD.31","HD.32", "HD.33","HD.4","HD.41","RB.1", "RB.14","RB.16","KB.","FN.22", "FK.22","FN.221", "FN.222")

Go to 7

Go to 6

6

DOES A_LDCS = NUL AND A09_TITL CONTAINS ANY ("*reading*","*writing*","*spelling*", "*literacy*","*mathematics*", "*numeracy*","*arithmetic*")

Go to 7

Set all A_SFLPAR A_SFLTYA to NULL

7

DOES A09 = ANY("00231874","00222801", "00228846", "00236795","00240866", "00253789","00255169","10048546", "10048558","1004856X",)

Set all A_SFLPAR A_SFLTYA to NULL

Go to 8

8

IS A_SFLTYP = ANY(“U”,“X”)

Go to 9

CONCATREF = CONCAT A_NOTION & A_ A_SFLTYP & A_SFL Go To 21

9

DOES A09 = “00222873”

CONCATREF = CONCAT A_NOTION & “02” & A_SFL Go To 21

Go to 10

10

DOES A09) = ANY( “00222934”,”00222941”)

CONCATREF = CONCAT A_NOTION & “04 & A_SFL Go To 21

Go to 11

11

DOES A_SUBPRG = ANY (”10A”,”1E”)

CONCATREF = CONCAT A_NOTION & “02” & A_SFL Go To 21

Go to 12

12

DOES A_SUBPRG = ANY (“9A”,”9H”,”10B)

CONCATREF = CONCAT A_NOTION & “04 & A_SFL Go To 21

Go to 13

13

DOES A_SUBPRG = ”10C”

CONCATREF = CONCAT A_NOTION & “01” A_SFL Go To 21

Go to 14

14

DOES A_LDCS = ANY ("HD.","HD.2","HD.3","HD.31", ”HD31”,"HD.32","HD.33","KB.")

CONCATREF = CONCAT A_NOTION & “01” A_SFL Go To 21

Go to 15

15

DOES A_LDCS = ANY ("HD.4","RB.1","RB.14","RB.16")

CONCATREF = CONCAT A_NOTION & “02” & A_SFL Go To 21

Go to 16

16

DOES A_LDCS = ANY (FN.22","FK.22","FN.221", "FN.222")

CONCATREF = CONCAT A_NOTION & “03 & A_SFL Go To 21

Go to 17

17

IS A_BSTYPE / A_SFLTYP NOT NULL

Go to 18

Set all A_SFLPAR A_SFLTYA to NULL

18

DOES A09_TITL CONTAIN "*literacy*"

CONCATREF = CONCAT A_NOTION & “01” A_SFL Go To 21

Go to 19

19

DOES A09_TITL CONTAIN "*numeracy*"

CONCATREF = CONCAT A_NOTION & “02” & A_SFL Go To 21

Go to 20

20

DOES A09_TITL CONTAIN "*ESOL*"

CONCATREF = CONCAT A_NOTION & “03 & A_SFL Go To 21

Set all A_SFLPAR A_SFLTYA to NULL

21

IS CONCATREF <> NULL

SET A_SFLPAR = 1 AND allocate value from table below using CONCATREF

Set all A_SFLPAR A_SFLTYA to NULL

3 The following table shows the lookup values used in step 21 of the derivation of A_SFLPAR and A_SFLTYA.

CONCATREF

A_SFLTYA

A_SFLTYA Description

1 01 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

1 02 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

1 03 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

1 04 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

1 05 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

1 06 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

1 07 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

1 08 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

1 09 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

1 10 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

1 11 Yes

9

GCSE English Language, Level 1 (Grade D -G)

1 12 Yes

10

GCSE Mathematics, Level 1 (Grade D -G)

1 13 Yes

7

Key Skills - Communication, Level 1

1 14 Yes

8

Key Skills - Application of Number, Level 1

1 01 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

1 02 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

1 03 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

1 04 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

1 05 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

1 06 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

1 07 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

1 08 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

1 09 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

1 10 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

1 11 No

9

GCSE English Language, Level 1 (Grade D -G)

1 12 No

10

GCSE Mathematics, Level 1 (Grade D -G)

1 13 No

7

Key Skills - Communication, Level 1

1 14 No

8

Key Skills - Application of Number, Level 1

2 01 Yes

11

Literacy, Level 2, Awarding Body

2 02 Yes

12

Numeracy, Level 2, Awarding Body

2 03 Yes

13

Language, Level 2, Awarding Body

2 04 Yes

13

Language, Level 2, Awarding Body

2 05 Yes

11

Literacy, Level 2, Awarding Body

2 06 Yes

12

Numeracy, Level 2, Awarding Body

2 07 Yes

13

Language, Level 2, Awarding Body

2 08 Yes

11

Literacy, Level 2, Awarding Body

2 09 Yes

12

Numeracy, Level 2, Awarding Body

2 10 Yes

13

Language, Level 2, Awarding Body

2 11 Yes

16

GCSE English Language, Level 2 (Grade A* -C)

2 12 Yes

17

GCSE Mathematics, Level 2 (Grade A* -C)

2 13 Yes

14

Key Skills - Communication, Level 2

2 14 Yes

15

Key Skills - Application of Number, Level 2

2 01 No

24

Literacy, Level 2, No Awarding Body

2 02 No

25

Numeracy, Level 2, No Awarding Body

2 03 No

26

Language, Level 2, No Awarding Body

2 04 No

26

Language, Level 2, No Awarding Body

2 05 No

24

Literacy, Level 2, No Awarding Body

2 06 No

25

Numeracy, Level 2, No Awarding Body

2 07 No

26

Language, Level 2, No Awarding Body

2 08 No

24

Literacy, Level 2, No Awarding Body

2 09 No

25

Numeracy, Level 2, No Awarding Body

2 10 No

26

Language, Level 2, No Awarding Body

2 11 No

16

GCSE English Language, Level 2 (Grade A* -C)

2 12 No

17

GCSE Mathematics, Level 2 (Grade A* -C)

2 13 No

14

Key Skills - Communication, Level 2

2 14 No

15

Key Skills - Application of Number, Level 2

E 01 Yes

1

Literacy, Entry Level, Awarding Body

E 02 Yes

2

Numeracy, Entry Level, Awarding Body

E 03 Yes

3

Language, Entry Level, Awarding Body

E 04 Yes

3

Language, Entry Level, Awarding Body

E 05 Yes

1

Literacy, Entry Level, Awarding Body

E 06 Yes

2

Numeracy, Entry Level, Awarding Body

E 07 Yes

3

Language, Entry Level, Awarding Body

E 08 Yes

1

Literacy, Entry Level, Awarding Body

E 09 Yes

2

Numeracy, Entry Level, Awarding Body

E 10 Yes

3

Language, Entry Level, Awarding Body

E 01 No

18

Literacy, Entry Level, No Awarding Body

E 02 No

19

Numeracy, Entry Level, No Awarding Body

E 03 No

20

Language, Entry Level, No Awarding Body

E 04 No

20

Language, Entry Level, No Awarding Body

E 05 No

18

Literacy, Entry Level, No Awarding Body

E 06 No

19

Numeracy, Entry Level, No Awarding Body

E 07 No

20

Language, Entry Level, No Awarding Body

E 08 No

18

Literacy, Entry Level, No Awarding Body

E 09 No

19

Numeracy, Entry Level, No Awarding Body

E 10 No

20

Language, Entry Level, No Awarding Body

M 01 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

M 02 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

M 03 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

M 04 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

M 05 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

M 06 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

M 07 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

M 08 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

M 09 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

M 10 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

M 01 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

M 02 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

M 03 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

M 04 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

M 05 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

M 06 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

M 07 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

M 08 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

M 09 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

M 10 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

X 01 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

X 02 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

X 03 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

X 04 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

X 05 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

X 06 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

X 07 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

X 08 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

X 09 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

X 10 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

X 01 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

X 02 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

X 03 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

X 04 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

X 05 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

X 06 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

X 07 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

X 08 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

X 09 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

X 10 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

U 01 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

U 02 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

U 03 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

U 04 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

U 05 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

U 06 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

U 07 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

U 08 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

U 09 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

U 10 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

U 01 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

U 02 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

U 03 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

U 04 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

U 05 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

U 06 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

U 07 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

U 08 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

U 09 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

U 10 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

U 01 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

U 02 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

U 03 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

U 04 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

U 05 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

U 06 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

U 07 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

U 08 Yes

4

Literacy, Level 1, Mixed or Not Applicable, Awarding Body

U 09 Yes

5

Numeracy, Level 1, Mixed or Not Applicable, Awarding Body

U 10 Yes

6

Language, Level 1, Mixed or Not Applicable, Awarding Body

U 01 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

U 02 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

U 03 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

U 04 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

U 05 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

U 06 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

U 07 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

U 08 No

21

Literacy, Level 1, Mixed or Not Applicable, No Awarding Body

U 09 No

22

Numeracy, Level 1, Mixed or Not Applicable, No Awarding Body

U 10 No

23

Language, Level 1, Mixed or Not Applicable, No Awarding Body

Creator

Analysis and MI Team

Date issued

26 September 2006

Date created

10 March 2006

Document ref.

\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-skillsforlifeparticipationsamplecode-report-26sep2006.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: 26 Sep 06