Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

  • Local Office

    Aggregate/ Row-level data

    Columns to be included

    Filters/ Sortable by

    Comments

    Application Status/Window at any point during the Recruitment Round

    • By specialty

    • Track progress of applications from Applied> Longlisted > Declined > Shortlisted > Offered > Offer Accepted

    • Pseudonymised applicant data

    Static - after recruitment round ended

    Dynamic - before recruitment round closes

    High

    View file
    nameOriel2_HEE_RecruitmentNationalReporting_Proposal_5458_V3 - Signed (1).pdf

    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

    • Cumulative count of applicants per status

    • Non-cumulative count of applicants per status

    • Pseudonymised applicant data

    Static - after recruitment round ended

    Dynamic - before recruitment round closes

    Low - No current functionality

    Overseas Sponsorship Team

    • National

    • Local Office

    • Training Programme

    • Date advertised

    • Date opened

    • Date closed

    • Number of applicants applied

    • Number of applicants longlisted   

    • Number of applicants shortlisted

    • Number of applicants offered

    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

    • Pseudonymised applicant data

    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:

    • by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics

    • Pseudonymised applicant data

    • Crossover count at application

    • Crossover at application as a percentage

    • Crossover count of those who accept

    • Each of the above reports also have the count of applicants, applications (generally the same as applicants other than where devolved nations run their own recruitment eg. NI CST) and unique applicants by specialty (potentially using the Oriel Applicant ID as the pseudonymised unique identifier)

    Static - after recruitment round ended

    Dynamic - before recruitment round closes

    • Medium - High (will be re recruitment reform next years)

    • Used to inform changing recruitment processes.

    Included in 9 as well. Either keep it separate or include in 9.

    Core vacancies/posts advertised -

    • by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics/ Competition ratios

    • Posts filled, comparisons over the years

    • Posts re-advertised (avoid double counting)

    • Dual training programme sub-specialty etc.

    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

    • Pseudonymised applicant data

    • Flag for investigation by any of the EDI pertinent information

    • Specialty/Local Office/Nation/Region/CoQ

    Static - after recruitment round ended

    Dynamic - before recruitment round closes

    High

    • MDRS - Used most often for FOIs

    • Specialty

    • Vacancy (to discount local vacancies)

    • Unique applicants

    • Recruitment round

    Doesn’t exist in UK reporting so FOIs only past 2 years of data.

    Where are people applying from?

    • where people are geographically based and where they are applying to

    • where people are qualified from and where they are applying to

    • Pseudonymised applicant data

    • By address fields

    • By Country of Qualification

    • By previous work History

    • By Preferences (region, sub-regions, sectors etc.)

    Static - after recruitment round ended

    Dynamic - before recruitment round closes

    Medium

    • National team mostly

    • Some FOIs

    Applicants behaviours during the application window

    • Just around application numbers rather than the stage of application (1)

    • Pseudonymised applicant data

    • How many applications?

    • How many unique applications by specialty?

    • How many cross-overs?

    • Include applications in progress, i.e. not submitted

    • Include Protective Characteristics

    Static - after recruitment round ended

    Dynamic - before recruitment round closes

    High (for medical)

    • MDRS - Useful throughout the application window to try to estimate numbers without going to Oriel

    Date submitted field (ability to look at applications submitted per day)

    CCT Programme Completers

    This report provides projected number of PGDiTs completing a programme for future years based on data added to TIS system. The projected number of PGDiTs are based on the start date & length of programme that is registered on TIS

    The report tab also provides programme completers from academic year 2016-17 based on the programme completing date or based on last review date.  

    Dynamic

    Based on the following:
    https://tabanalytics.data.england.nhs.uk/#/site/TISPIDDATA/views/CCTOutcomeNew/ProgrammeCompleters-Historic