The Vacancy Hire Success (Organization Hierarchy) Template Analytics workbook provides two worksheets, one for investigating vacancy success over yearly periods, the other providing a detailed analysis of vacancy success in the workforce.
These worksheets help you to create reports to analyze the success of your recruitment activities. Recruitment success is defined as the percentage of vacancy openings that are filled.
The workbook calculates the total number of vacancy openings for each year, and how many of these have been filled.
The workbook uses the Budget Measurement Value to calculate the number of openings. The worksheet Openings column displays the number of Headcounts or Full Time Equivalents (depending on your Budget Measurement Value) represented by your vacancies.
The workbook only includes vacancies that have been closed within the selected time period.
The vacancy must also match all the selection criteria. For example, if you select an organization and a job, you must have entered an organization and job for the vacancy on the HRMS Requisition and Vacancy window.
The workbook calculates the Employee Starts total by totaling the employee assignments created to fill the vacancies. HRMS Intelligence counts employee assignments using Workforce, enabling you to define the employee value of each assignment.
The assignments created to fill the vacancy must match the criteria selected in the report, to appear in the Openings Filled total. For example, an assignment must have the same budget measurement value as the report parameters.
The success rate calculation is:
Total Workforce Measurement Value for all Employee Starts*100/Total Workforce Measurement Value for Openings
Before running the template worksheets you must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations - Yes/No
Workforce Measurement Type
The template includes the following optional parameters:
Area (Geography)
Country (Geography)
Region (Geography)
Location (Geography)
Job Category
Job Name
Grade Name
Position Name
This workbook has the following worksheets:
By Year
By Detail
The by Year worksheet enables you to see vacancy success for each year.
This worksheet contains the following columns:
Start Date
The start date of the time period.
End Date
The end date of the time period.
Year
The time period for which this worksheet is run.
Openings
The number of openings within the time period.
Employee Starts
The number of employee starts within the time period.
Success Rate Percent
Displays the vacancy success rate.
The Detail worksheet calculates the vacancy success rates for vacancies with the same opening and closing dates, for each organization, location, job, grade, and position.
This worksheet contains the following columns:
Vacancy Open Date
The date the vacancy opened.
Vacancy Close Date
The date the vacancy closed.
Openings
The number of openings within the vacancy open and close date, for each organization, location, job, grade, and position, calculated using the selected workforce measurement value.
Employee Starts
The number of employee starts for openings within the vacancy open and close date, for each organization, location, job, grade, and position, calculated using the selected workforce measurement value. The worksheets calculate the Employee Starts total by totaling the employee assignments created to fill the vacancies.
Success Rate Percent
Displays the vacancy success rate. Recruitment success is a calculation of the total workforce starts as a percentage of total workforce openings.
Organization
The organization that had the vacancy.
Location
The location where the vacancy occurred.
Job
The job for which the vacancy occurred.
Grade
The grade for which the vacancy occurred.
Position
The position for which the vacancy occurred.