Large Employer Data Definition 2010/11
A_LARGE_EMP, L_LARGE_EMP
DATA DEFINITION
1. Large Employer Flags at Aim and Learner Level.
PURPOSE
2. To assist in monitoring provision to learners employed by large employers.
RELEVANT COLLECTIONS
SOURCE DATA
3. The following variables are used as source data for the calculation of Large Employer Flags.
| Field Name |
Label |
Dataset |
| LARGE_EMPLOYER_FACTOR |
Large Employer Factor from funding calculation |
ILR_ER_FUNDING_AIM funding output table |
| A_ACTIVE |
A_ACTIVE Aim Active for the current academic year |
Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definitions produce the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_LARGE_EMP |
A_LARGE_EMP Aim level Large Employer Flag |
Aims Standard File |
| L_LARGE_EMP |
L_LARGE_EMP |
Learner Standard File, Aims Standard File, Framework and Aims Standard File, HE Standard File |
VALUES
5. The table below outlines the values for L_LARGE_EMP and A_LARGE_EMP
| L_LARGE_EMP and A_LARGE_EMP 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. If the LARGE_EMPLOYER_FACTOR from the funding calculation is greater than 1 then set A_LARGE_EMP to 1. Otherwise set it to 0.
7. If the learner has a large employer flag (A_LARGE_EMP) for any aim then the learner has a value of 1 in the Large Employer learner flag (L_LARGE_EMP). This excludes those aims that are not included for analytical purposes (using A_ACTIVE).
Large Employer Flag Sample Code
1. The following pseudo code and SPSS code is provided to illustrate the Large Employer data definition.
A_LARGE_EMP, L_LARGE_EMP
2. The following tables show the steps required to derive L_LARGE_EMP and A_LARGE_EMP
A_LARGE_EMP
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is LARGE_EMPLOYER_FACTOR greater than 1? |
Set A_LARGE_EMP to 1 |
Set A_LARGE_EMP to 0. |
L_LARGE_EMP
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Is A_ACTIVE=1. |
Go to 2 |
Set L_LARGE_EMP to -1 |
| 2 |
Is any A_LARGE_EMP =1 |
Set L_LARGE_EMP to 1, Go to 3 |
Set L_LARGE_EMP to 0, Go to 3 |
| 3 |
Are all A_LARGE_EMP =-1 |
Set L_LARGE_EMP to -1. |
|
| Step |
Condition |
Action/Action if true |
Action if false |
| 1 |
Does L_LARGE_EMP to contain a value |
None |
Set L_LARGE_EMP to = -1. |
| 2 |
Does L_ACTIVE=0 |
Set L_LARGE_EMP to = -1 |
None |
3. The following SQL code illustrates how to derive A_LARGE_EMP and L_LARGE_EMP.
|
--A_LARGE_EMP
select
case when f.LARGE_EMPLOYER_FACTOR IS NOT NULL and
f.LARGE_EMPLOYER_FACTOR > 1 then 1 else 0 end as A_LARGE_EMP
from
AIMS_FILE as a
left outer join
ILR_ER_FUNDING_AIM as f
on a.L01=f.L01 and a.L03=f.L03 and A.A05=f.A05
--L_LARGE_EMP
select
B.L01, B.L03
, case when L_LARGE_EMP_qry is NULL then -1 else L_LARGE_EMP_qry end as L_LARGE_EMP
from
(
select
L01, L03, count(A05) as aims
, max(A_LARGE_EMP) as L_LARGE_EMP_qry
from
AIMS_FILE
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: 15 December 2010
