Demo - https://tabanalytics.data.england.nhs.uk/#/projects/1272
Previous Actions :
Questions from Data Analytics Team
Application Counts Questions:
As not all records have a status of ‘Applied’, for Application Counts an ApplicationID with any status except ‘In Progress’, 'Application withdrawn before submission' is considered to be an application. Are there any other statuses which should not be included? Distinct List of Application Statuses.csv
Application Status of ‘Longlist Unsuccessful’ produces a record with a NULL Grade. Is this expected? Should those with this status be excluded from Application Counts completely or just those with NULL Grades?
Should all NULL Grades be excluded from Application Counts no matter the status?
For Offer Year 2025-2026, why for some specialties is there already a ‘Round 2’ present? Why do some specialties have a Round 2 but not a Round 1
Null grades examples sent to Chad to investigate - Comments from Christopher Baily
“If admins run a "Longlist process by status" process, then this will change the status of any "In progress" applications to "longlist unsuccessful", hence why that status appears in there.”
Clarification required
Medical round grouping using newly added fields -
- Looking at the data quality of the fields. WorkingJira Legacy server System Jira serverId 4c843cd5-e5a9-329d-ae88-66091fcfe3c7 key TIS21-6785
Fill rate dashboard modifications suggested -
Regional view, different slicing of data - These will be ticketed and completed
Cross over applications - Further details of crossover applicant behaviour (how many applied for the same specialty in other offer years / other offer rounds in the same offer year/ applied for different specialties in different offer years & rounds) - Work to be ticketed and completed
Questions from Data Analytics Team
Priority of the above?
Q&A / Feedback