Franchised Aim Data Definition 2009/2010
L_FRANCH, A_FRANCH
DATA DEFINITION
1. Flag indicating that learner has a franchised aim.
PURPOSE
2. This is a flag that indicates if a learner is undertaking at least one franchised learning aim.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of Flag indicating that learner is undertaking a franchised aim.
| Field Name |
Label |
Dataset |
| A21 |
A21 Franchised Out and Partnership Arrangements |
Aims Standard File |
| A_ACTIVE |
A_ACTIVE Aim Active for the current academic year |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_FRANCH |
A_FRANCH Franchised Aim |
Learner, Aims, ESF and HE Standard Files |
| L_FRANCH |
L_FRANCH Franchised Aims |
Learner, Aims, ESF and HE Standard Files |
VALUES
5. The table below outlines the categories for L_FRANCH, A_FRANCH
| Value |
Label |
| -1 |
Not Applicable/Not Known* |
| 0 |
No |
| 1 |
Yes |
*Applies to system missing values and where there are non-active aims. Only applicable at learner level.
DETAILED DEFINITION
6. This variable indicates whether any aim for the learner is franchised. For every aim, the calculation looks at Franchised Out or Partnership Arrangement (A21).
7. This excludes those aims that are not included for analytical purposes (using A_ACTIVE).
8. Note that where Franchised Out or Partnership Arrangement (A21) has a value of 27, an aim is exempt from the FE funding franchised discount but Does the Learner Have Any Franchised Aims (L_FRANCH) can still have a value of 1.
Franchised Aim Sample Code
1. The following SPSS code is provided to illustrate the Franchised Aim data definition.
L_FRANCH, A_FRANCH
2. The following table shows the steps required to derive A_FRANCH
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Do any A21=(NULL,0,99) |
Set A_FRANCH to 0 |
Set A_FRANCH to 1 |
3. The following table shows the steps required to derive L_FRANCH
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does A_ACTIVE=1 |
Go to 2. |
Set L_FRANCH=-1 |
| 2 |
(Aggregate)
For all aims where the Provider (L01) and Learner (L03) are the same. |
Set L_FRANCH to be the maximum value of the aims in A_FRANCH. |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_FRANCH contain a value |
None |
Set L_FRANCH = -1 |
| 2 |
Does L_ACTIVE=0 |
Set L_FRANCH=-1 |
None |
4. The following SPSS code illustrates how to derive L_FRANCH, A_FRANCH.
|
GET FILE ‘……….AIMS dataset’.
COMPUTE A_FRANCH=1.
IF Any(A21,99,NULL,0) A_FRANCH=0.
SELECT IF A_ACTIVE = 1.
VALUE LABELS A_FRANCH
-1 'Not Applicable/Not Known'
0 ‘No’
1 ‘Yes’.
AGGREGATE OUTFILE=….L_FRANCH.SAV
/PRESORTED
/BREAK=L01 L03
/L_FRANCH=MAX(A_FRANCH).
GET FILE ‘…………Learner data set’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’…… L_FRANCH.SAV’
/BY L01 L03.
RECODE L_FRANCH (SYSMIS=-1). |
5. The following SQL code illustrates how to derive A_FRANCH:
|
select
L01, L03, A05
, case when A21 is NULL or A21 in (0,99) then 0 else 1 end as A_FRANCH
from
LR_AIMS |
6. The following SQL code illustrates how to derive L_FRANCH:
|
select
B.L01, B.L03
, case when L_FRANCH_qry is NULL then -1 else L_FRANCH_qry end as L_FRANCH
from
(
select
L01, L03, count(A05) as aims
, max(A_FRANCH) as L_FRANCH_qry
from
ILR0910_L01_AIMS
where A_ACTIVE=1
group by
L01, L03, A_ACTIVE
)T
right outer join
ILR0910_L01_LEARNER B
on T.L01=B.L01 and T.L03=B.L03
order by
B.L01, B.L03 |
Date last modified: 08th December 2009
