This page is to capture the requirements of a suite of TIS based Tableau reports to be published in the NHS England’s main Tableau page to give wider access to aggregated reports.
Reporting Requirements
No. | Report Name/Summary | Detailed Description | Report Type - Dynamic/Static | Priority (L/M/H) | Target Users/ Audience/ Nations National Specialty | Aggregate/ Row-level data | Columns to be included | Filters/ Sortable by | Comments | Application Status/Window at any point during the Recruitment Round
|
| Static - after recruitment round ended Dynamic - before recruitment round closes | High
| Historical Application Status trends after the Recruitment Round that is currently available via Scotland reporting system. | Lift and shift Scotland system. Pseudonymised applicant data | Static - after recruitment round ended | Dependent on having UK reporting | Evidence of Recruitment Activity |
| Static - after recruitment round ended Dynamic - before recruitment round closes | Low - No current functionality | Overseas Sponsorship Team
|
| Used for UKVI audit. Number required for each cohort (August 2024, etc). | Core recruitment data by applicant demographics/protected characteristics - by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics |
| Static - after recruitment round ended Dynamic - before recruitment round closes | Medium - Only currently have nationality and CoQ | Table showing count of crossover applications within and across rounds for each vacancy, this can be filtered:
|
| Static - after recruitment round ended Dynamic - before recruitment round closes |
|
| Included in 9 as well. Either keep it separate or include in 9. | Core vacancies/posts advertised -
|
| Static - after recruitment round ended Dynamic - before recruitment round closes | Highest (for fill rates April 2024 potentially) | Equality and Diversity Monitoring - applicable for all applicants and their reports |
| Static - after recruitment round ended Dynamic - before recruitment round closes | High | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Doesn’t exist in UK reporting so FOIs only past 2 years of data. | Where are people applying from?
|
| Static - after recruitment round ended Dynamic - before recruitment round closes | Medium |
| Applicants behaviours during the application window
|
| Static - after recruitment round ended Dynamic - before recruitment round closes | High (for medical) |
| Date submitted field (ability to look at applications submitted per day) CCT Programme Completers | Dynamic | Based on the following: | |||||||||||||||||||||||||||||||