Metrics - Youth-Transitions/resources GitHub Wiki

We calculate a set of measures (metrics) for individuals from age 16 that summarise their education and labour market participation from age 16 (the year after compulsory schooling ends) upwards.

In the fft.metrics.sql script we calculate both annual and monthly measures. Annual metrics are provided in both "long" format (one row per individual per measure per year) in fft.metrics and "wide" format (one row per individual per year) in fft.metrics_wide. Annual metrics are calculated on the basis of both academic and tax years.

Monthly metrics (one row per individual per month) are loaded into fft.metrics_monthly. You can define the number of months for which to calculate monthly metrics for at the start of the script. The version provided sets this value at 24 (in other words, the two years following the year in which individuals turn 16).

The measures we calculate include:

• Days enrolled at school (based on School Census)
• Days enrolled in further education (based on ILR)
• Days enrolled in higher education (based on HESA)
• Days in employment (based on employment data)
• Days on out-of-work benefits (based on benefits data)
• Days in receipt of other (not out-of-work) benefits
• Days in education (based on NCCIS)
• Days in training, including apprenticeships (based on NCCIS)
• Days in employment (based on NCCIS)
• Days in self-employment (based on NCCIS)
• Days in custody (based on NCCIS)
• Days not in education employment and training (NEET) but active in the labour market (based on NCCIS)
• Days not in education employment and training (NEET) and inactive in the labour market (based on NCCIS)

Processing

To complete this process successfully, the source data relating to those metrics of interest must have been processed first. Any data not in the form created by the related example script will not be included in the metrics (but the non-existence of a source will not cause the fft.metrics.sql script to fail). Metrics maximally depends on:

• School Census
  • create the fft.census_details table
    • post-load processing, to calculate best guess entry and leaving dates in the fft.census_dates table
• ILR
  • the fft.ilr_aims table
• HESA
  • the fft.hesa table
• Employment
  • the fft.employment table
  • the fft.earnings table
• Benefits
  • the fft.benefits table
• NCCIS
  • the fft.nccis table
• Determining a Cohort
  • the fft.cohort table