Caseload dashboard calculations and data filters

Overview

This page has the details of the Caseload dashboard calculations. Navigate to the sections linked below to see the relevant calculation details.

  • Assessor Overview
    • Caseloads
    • Total leavers
    • Leavers with full achievement
    • Leavers without achievement
    • Leaners on 'break in learning'
    • Learners still on programme but past planned end date
    • Learners currently on programme and 'in funding'
    • Number of learners with no ILR or privately funded
    • Learners with excluded / unknown ILR and one or more aims
  • Caseload by Assessor
    • Average number of days on programme
    • Average days since last learning plan activity
    • Learners with no learning plan in the last 60 days
    • Learners on "break in learning"
  • Overview by Program Status
    • Learners with active Aptem subscription
    • Active programme status
    • Onboarding
    • Non-starter
    • Early leaver
    • On break status
    • Entered EPA status
  • Occupancy Report
    • Page Filters
    • Live learners
    • Completed learners
    • Learners on a "break"
    • Withdrawn learners
    • In learning but awaiting result [EPA]
    • Number of expired / cancelled accounts with valid open aims
  • Data Checks
    • Count of user names containing text "test"
    • Number of expired / cancelled accounts with valid open aims
    • Learners with no ILR aims
    • Learners with only excluded aims
    • Learners 'in learning' ILR but programme status is not active
    • Learners ILR status is 'leaver' but programme is active
    • Learners with current aims where funding model is 99
  • Data Filters

Assessor Overview

Caseloads

The caseloads table has two measures: 'Live learners' and 'Learners excluded from or with no ILR'. Live learners are all users in the 'Past end date' column with a status of 'in funding' or 'Past end date'.

  • 'In funding' means the user's actual end date is blank and their planned end date is in the future.

  • 'Past end date' means the user's planned end date is in the past and they haven't yet completed or left the programme.

Total leavers

Total leavers are all users in the 'Past end date' column with a status of 'leaver'.

  • 'Leaver' means the user's ILR aims status is greater than 1, showing they've completed or left the programme.

Leavers with full achievement

Leavers with full achievement are the total of all users with a 1 in the 'positive outcome' column.

  • 'Positive outcome' covers users with an actual end date, an outcome code of 1, and a status that isn't 'unknown', 'excluded' or blank.

Leavers without achievement

Leavers without achievement are the total of all users with a 1 in the 'negative outcome' column whose learning status isn't 'break in learning'.

  • 'Negative outcome' covers users with an actual end date, an outcome code of 3, a status that isn't 'unknown', 'excluded' or blank, and a learning status that isn't 'break in learning'.

Learners on 'break in learning'

Learners on 'break in learning' are the total of all users with a learning status of 'break in learning'.

  • 'Break in learning' means the user's ILR aims status is 6.

Learners still on programme but past planned end date

These are all users in the 'Past end date' column with a status of 'Past end date'.

  • 'Past end date' means the user's planned end date is in the past and they haven't yet completed or left the programme.

Learners currently on programme and 'in funding'

These are all users in the 'Past end date' column with a status of 'in funding'.

  • 'In funding' means the user's actual end date is blank and their planned end date is in the future.

Number of learners with no ILR or privately funded

This is all users with a main aim of 0, meaning they don't have a main aim.

Learners with excluded / unknown ILR and one or more aims

This is all users with a main aim of 1 who are in the 'Past end date' column with a status of 'Unknown/Excluded ILR'.

  • 'Unknown/Excluded ILR' means the user's ILR summary status is unknown, excluded or blank.

Caseload by Assessor

Average number of days on programme

The average of 'days on programme to date' for users whose status is 'in learning'.

Average days since last learning plan activity

The average of 'days since last submission' for users whose status is 'in learning'.

Date of last submission

The date of last submission to the learning plan (and the days since last submission) only takes account of learning plan components that have a "complete by" of today or earlier. This is expected, and matches the logic in the Users OData feed, where the expected number of components completed is based on component "complete by" dates.

If a learner submits evidence to a component with no "complete by" date, or with a "complete by" date in the future, it isn't reflected in the date of last submission. To make sure a learner's latest evidence shows in this report, check that the learning plan components have a "complete by" date set.

Learners with no learning plan activity in the last 60 days

Users whose status is 'in learning' and whose 'days since last submission' is more than 60.

Learners on 'break in learning'

The total of all users with a learning status of 'break in learning'.

  • 'Break in learning' means the user's ILR aims status is 6.

Overview by Programme Status

Learners with active Aptem subscription

A count of all users who aren't past their end date or excluded from the ILR.

Active programme status

Active learners whose UserProgram_Status is 'active'.

Onboarding

Active learners whose UserProgram_Status is 'onboarding'.

Non-starter

Active learners whose UserProgram_Status is 'non-starter'.

Early leaver

Active learners whose UserProgram_Status is 'EarlyLeaver'.

On break status

Active learners whose UserProgram_Status is 'OnIllnessBreak', 'OnOtherBreak', 'OnMaternityBreak' or 'OnBreak'.

Entered EPA status

Active learners whose UserProgram_Status is 'EnteredEpa'.

Occupancy Report

Page filters

The page filters have been removed. You can include or exclude cancelled and archived learners, along with other user types, using the Subscription filter in the report.

Live learners

All learners whose lk_currentAimEpisodeLStatus is 'In learning'.

  • lk_currentAimEpisodeLStatus is the Learning_Status of the user's current ILR aim.

Completed learners

All learners whose lk_currentAimEpisodeLStatus is 'Completed'.

Learners on a 'break'

All learners whose lk_currentAimEpisodeLStatus is 'Break in Learning'.

Withdrawn learners

All learners whose lk_currentAimEpisodeLStatus is 'Withdrawn'.

In learning but awaiting result [EPA]

All learners with a CombinedStatus_lkip of '1_8', meaning a status of 1 and an outcome of 8.

Number of expired / cancelled accounts with valid open aims

A count of all users with a subscription status of 'expired', 'cancelled' or 'archived' and an open aim of 1 or more.

Data Checks

Count of user names containing text "test"

Counts all users whose full name (users[FullName]) contains the word "test".

Number of expired / cancelled accounts with valid open aims

A count of all users with a subscription status of 'expired', 'cancelled' or 'archived' and an open aim of 1 or more.

Learners with no ILR aims

Counts all users with a CurrentProgAimStatus of 'no aims', meaning their count of aims is 0.

Learners with only excluded aims

Counts all users with a CurrentProgAimStatus of 'Current excluded aims [no other aims]', 'NonCurrent excluded aims' or 'Current excluded [other invalid]'. These statuses are set from the aims data in the allaims column.

Learners 'in learning' ILR but programme status is not active

Uses the Count_ProgStatusMismatch measure: a count of users who are in learning but have a programme status that isn't active.

Learners ILR status is 'leaver' but programme is active

Uses the Count_ProgStatusMismatch2 measure: a count of users whose programme status is active ('active', 'onboarding' or 'enteredEPA') but whose ILR status is 'Withdrawn' or 'Completed'.

Learners with current aims where funding model is 99

A count of all users with a CurrentProgAimStatus of 'current included aims' or 'current included aims with excluded aims', and a funding model code of 99.

Was this article helpful?
0 out of 0 found this helpful