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_currentAimEpisodeLStatusis 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.