Versions Compared

Key

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

This page captures the National Reporting Requirements for reports to be built from the Oriel Recruitment Dataset.

...

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

1.

Application Status/Window at any point during the Recruitment Round

  • 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

2.

Historical Application Status trends after the Recruitment Round that is currently available via Scotland reporting system.

To be confirmed through User Research

  • Pseudonymised applicant data

Static - after recruitment round ended

3.

Evidence of Recruitment Activity

  • Cumulative count of applicants per status

  • Non-

Dynamic Data PID - Not in NDW?2
  • cumulative count of applicants per status

  • Pseudonymised applicant data

Static - after recruitment round ended

Dynamic - before recruitment round closes

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

4.

Core recruitment data by applicants - by Specialty/ Grade/Nation/Region/Round/ Rounds/ Demographics

  • Pseudonymised applicant data

Static - after recruitment round ended

Dynamic - before recruitment round closes

35.

Table showing count of crossover applications within and across rounds for each vacancy, this can be filtered:

  • by

round, Specialty, specialty grouping . The report options are:
  • 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

3
  • (potentially using the Oriel Applicant ID as the pseudonymised unique identifier)

Static - after recruitment round ended

Dynamic - before recruitment round closes

6.

Core vacancies/posts advertised -

  • by

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

  • Posts filled, comparisons over the years

  • Posts re-advertised (avoid double counting)

4
  • Dual training programme sub-specialty etc.

Static - after recruitment round ended

Dynamic - before recruitment round closes

7.

Equality and Diversity Monitoring - applicable for all applicants and their reports

  • Pseudonymised applicant data

  • Flag for investigation by ethnicity any of the EDI pertinent information

  • Specialty/Local Office/Nation/Region/CoQ

  • Review GDPR

5Static - after recruitment round ended

Dynamic - before recruitment round closes

8.

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

6Static - after recruitment round ended

Dynamic - before recruitment round closes

9.

Applications Applicants behaviours during the application window?

  • Pseudonymised applicant data

  • How many applications?

  • How many unique applications by specialty?

  • How many cross-overs?

7.

Evidence of Recruitment Activity

  • Count of applicants per status

Static - after recruitment round ended

Overseas Sponsorship Team

Training Programme

Date advertised

Date opened

Date closed

Number of applicants applied

Number of applicants longlisted   

Number of applicants shortlisted

Number of applicants offeredDynamic - before recruitment round closes

Questions / Assumptions for Discussion

...