Type of ESF Aim 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 Type of ESF Aim data definition

A_ESF

2 The following table shows the steps required to derive A_ESF

Step	Condition	Action if true	Action if false
1	Set A_ESF to 0
2	Does A10=70 and A09= XESF0001	Set A_ESF to 2	Go to 3
3	Does A10=80 and A09=XMAT0001	Set A_ESF to 2	Go to 4
4	Does A06=1 and A10<>70	Set A_ESF to 3	Go to 5
5	Does A06=1 and A10 = 70	Set A_ESF to 4	Go to 6
6	Does A06=1 or A10 = 70 and A_ESF=0 and no other funding streams for the learner	Set A_ESF to 1

3 The following SPSS code illustrates how to derive A_ESF

GET FILE ‘……………AIMS data set’.

/* Create 8 new funding stream variables based on the values in A10.
IF A10=10 ACL=1.
IF A10=20 FE=1.
IF A10=30 SIXF=1.
IF ANY(A10,40,41,42) WBL=1.
IF A10=60 TTG=1.
IF A10=70 ESF=1.
IF A10=80 OTH=1.
IF A10=99 NOLSC=1.
RECODE ACL TO NOLSC (SYSMIS=0).

/*Aggregate the live aims to learner level to create 7 learner funding stream variables, store them in a temporary file and match the file back on to aims file.
SORT CASES L01 L03 A05.
TEMPORARY.
SELECT IF A_LIVE_B > 1.
AGGREGATE OUTFILE =’……………………………FUND.SAV’
 /PRESORTED
 /BREAK=L01 L03
 /ACLS FES SIXFS WBLS TTGS ESFS OTHS NOLSCS=MAX(ACL FE SIXF WBL TTG ESF OTH NOLSC).

MATCH FILE /FILE=*
 /TABLE=’……………………………FUND.SAV’
 /BY L01 L03.
COMPUTE TOTAL=SUM (ACLS TO NOLSCS).

/*Recalculates whether or not ESF funding to take into account the ESF data in WBL.
DO IF A_LIVE_B > 1.
 COMPUTE A_ESF=0.
 IF TOTAL=1 AND ESFS=1 A_ESF=1.
 IF A10=40 AND ESFS=0 AND A06=1 A_ESF=3.
 IF A10=41 AND ESFS=0 AND A06=1 A_ESF=3.
 IF A10=42 AND ESFS=0 AND A06=1 A_ESF=3.
 IF A10=20 AND ESFS=0 AND A06=1 A_ESF=3.
 IF WBLS=1 AND ESFS=0 AND A06=1 A_ESF=3.
 IF FES=1 AND ESFS=0 AND A06=1 A_ESF=3.
 IF A10=20 AND ESFS=0 AND A06=1 A_ESF=3.
 IF TTGS=1 AND ESFS=0 AND A06=1 A_ESF=3.
 IF A10=80 AND ESFS=0 AND A06=1 A_ESF=3.
 IF A10=99 AND ESFS=0 AND A06=1 A_ESF=3.
 IF A10=70 AND WBLS=1 AND A06=1 AND TOTAL=2 A_ESF=4.
 IF A10=70 AND FES=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=70 AND OTHS=1 AND A06=1 AND TOTAL=2 A_ESF=4.
 IF A10=70 AND NOLSCS=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=20 AND ESFS=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=40 AND ESFS=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=41 AND ESFS=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=42 AND ESFS=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=60 AND ESFS=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=80 AND ESFS=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=99 AND ESFS=1 AND A06=1 AND TOTAL >= 2 A_ESF=4.
 IF A10=70 AND UPCASE(A09)="XESF0001" AND A15=99 A_ESF=2.
 IF A10=80 AND UPCASE(A09)="XMAT0001" AND A15=99 A_ESF=2.
END IF.

VARIABLE LABELS A_ESF 'DV - Type of ESF Aim'.
VALUE LABELS a_esf
 0 'Not an ESF Funded Aim'
 1 'ESF Beneficiary funding'
 2 'ESF short event Record'
 3 'ESF Matched funding' 
 4 'ESF enhanced funding'.

Creator	Analysis and MI Team
Date issued	26 September 2006
Date created	9 December 2005
Document ref.	\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-typeofesfaimsamplecode-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