Active on Census Date Data Definition

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 Flag indicating aim or learner active on relevant census date in this year.

Purpose

2 To identify aims and learners that were active on the analytical census dates (1 October, 1 November and 1 January). Note: these dates are for analytical purposes, and are not the funding census dates

Relevant Collections

  • ILR (FE)
  • ILR (UfI)
  • ILR (ACL)
  • ILR (WBL)
  • ILR (ESF SR)
  • ILR (TtG)

Source Data

3 The following variables are used as source data for the calculation of Flag indicating aim or learner active on relevant census date in this year.

Field Name

Label

A27

Learning Start Date

A28

Learning Planned End Date

A31

Learning Actual End Date

A34

Completion Status

A_LIVE_B

DV - Status of aim for inclusion in analysis using 1 Oct as first census date

Derived Variables and Datasets

4 The definitions produces the following derived variable(s)

Field Name

Label

Dataset

A_OCT

DV - Aim was active on 1 October in this year

Aims Standard File

A_NOV

DV - Aim was active on 1 November in this year

Aims Standard File

A_JAN

DV - Aim was active on 1 January in this year

Aims Standard File

L_OCT

DV - Learner was active on 1 October in this year

Learner Standard File, Aims Standard File, Framework and Aims Standard File

L_NOV

DV - Learner was active on 1 November in this year

Learner Standard File

L_JAN

DV - Learner was active on 1 January in this year

Learner Standard File

Detailed definition

5 If the Learning Start Date (A27) for the aim is on the census date, then the aim is active on the census date (e.g. for 1 October, A_OCT=1).

6 If the Learning Start Date (A27) for the aim is before the census date and the Learning Actual End Date (A31) is after the census date, then the aim is active on the census date.

7 If the Learning Start Date (A27) for the aim is before the census date and the Learning Planned End Date (A28) is on or after the census date and there is no Learning Actual End Date (A31), then the aim is active on the census date.

8 If the Learning Start Date (A27) for the aim is before the census date, and the Learning Planned End Date (A28) is before the start of the academic year (1 August), but there is no Learning Actual End Date (A31), then the aim is active on the census date.

9 If the Learning Start Date (A27) for the aim is before the census date, and there is no Learning Planned End Date (A28) and no Learning Actual End Date (A31) and the Completion Status (A34) is either missing or has a value of 1 (the learner is continuing or intending to continue the learning activities leading to the learning aim), then the aim is active on the census date.

10 To work out if a learner was active at the particular census points. We look at all the aims and if any of them are active on the relevant census date then the learner is marked as being active on that census date.

11 For FE, UfI and ACL we exclude those aims that are not included for analytical purposes (using A_LIVE_B).

Sample Code

12 The following sample code is available

Creator Analysis and MI Team
Date issued

29 September 2006

Date created

9 November 2005

Document ref.

G:\Organisational Data\DCA\A&MI\Documentation\web data dictionary\200607\DataDefinitions\nat-activeoncensusdatedatadefinition-report-29sep2006.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: 29 Sep 06