HRINFO21 Vacancy and applicant data quality report

Data checking functionality of this report is split over three tabs (click to see more details):

Expand All

  1. Run this tab first, before any others.
  2. Action all red message in the recruitment module back office.
  3. Re-run this tab to check the changes have been entered correctly.
  • Checks vacancies advertised externally on or after the start of the academic year, (i.e. 1 August), to date
  • Returns one row per vacancy
  1. Run this second tab once you have cleared all the red errors from the advertised vacancy checking tab (Step 1).
  2. Action all red error messages following the Adding missing applicant status history, red messages indicate mandatory data are missing.
  3. Action the orange advisory messages if you wish, but this is not mandatory data for recruitment monitoring.
  4. Re-run tab to check the changes have been entered correctly.
  • This tab checks for the presence of the four mandatory applicant statuses
    • Applied 
    • Shortlisted
    • Offer Made / Offer Made – Personnel
    • Offer Accepted / Offer Accepted – Personnel)
  • Checks also for the non-mandatory, but useful, applicant status of ‘Invited for Interview 1’
  • Checks all vacancies advertised externally on or after the start of the academic year, (i.e. 1 August), to date, that are closed, that have outcomes (recruitment status) set to ‘Appointment Made’ or ‘No Appointment Made'
  • Returns one row per vacancy
  1. Run this tab last of all.
  2. Action all red error messages in the in the recruitment module back office.
  3. Re-run this tab to check the changes have been entered correctly.
  • Checks all vacancies created in Core Recruitment on or after the start of the academic year, (i.e. 1 August), to date that were not advertised externally
  • Includes vacancies created for administrative purposes such as regrading, direct appointments or new contracts
  • Non-advertised vacancies do not contribute to recruitment monitoring but still need closing down properly
  • Returns one row per vacancy
  • This tab is formatted using 'group sort' to provide an on-screen view of applicant statuses
  • Returns one row per applicant, so potentially multiple rows per vacancy
  • Returns applicant data for vacancies advertised externally on or after the start of the academic year, (i.e. 1 August), that are closed, that have outcome (recruitment stage) set to 'Appointment Made' or 'No Appointment Made'
  • If a vacancy does not appear here it may be because it has a data quality issue, which will be highlighted red in the first tab 'Step 1 - Advertised vacancy validation'
  • Ensure you have removed all red errors from the first tab in order to view all vacancies and applicants
  • This tab is formatted to provide a dataset for export and use in Excel (can be used to create Pivot Tables)
  • Returns one row per applicant, so potentially multiple rows per vacancy
  • Returns applicant data for vacancies advertised externally on or after the start of the academic year, (i.e. 1 August), that are closed, that have outcome (recruitment stage) set to 'Appointment Made' or 'No Appointment Made'
  • If a vacancy does not appear here it may be because it has a data quality issue, which will be highlighted red in the first tab 'Step 1 - Advertised vacancy validation'
  • Ensure you have removed all red errors from the first tab in order to view all vacancies and applicants
List of site pages