The Vacancy Hire Success (Organization Hierarchy) Status Analytics workbook provides a status analysis comparing the changes in vacancy success across organizations in your enterprise, or across geographical areas. You can analyze the:

• Total number of openings recorded for vacancies.

• Total number of openings that have been filled.

This workbook also enables you to view the success of your recruitment activities.

The workbook calculates the total number of vacancy openings and the number of filled vacancies in a particular time period, to produce a vacancy success rate. Vacancy success is defined as the percentage of vacancy openings that are filled.

The workbook only includes vacancies that have a status of Closed and have an End Date within the selected time period.

The workbook only includes assignments that match the criteria selected in the workbook parameters. For example, an assignment must have the same budget measurement value as the worksheet parameter.

Business Questions

How many vacancies have there been in my enterprise within a specific geographical area?

How many of these vacancies have been filled? How does this compare with other geographical areas?

Parameters

Before running the 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

Use the following parameters to further restrict the values in the workbook:

• Area (Geography)

• Country (Geography)

• Region (Geography)

• Location (Geography)

• Job Category

• Job Name

• Grade Name

• Position Name

Worksheets

This workbook has the following worksheets:

• By Organization

• By Geography Area

The worksheets display one row for each grouping. For example, the by Organization worksheet displays one row per organization.

Headings and Calculations

All worksheets contain the following columns:

• A grouping column

  The heading depends on the selected worksheet, for example, in the by Organization worksheet, this column is named "Organization".

• Openings

  The number of openings for each group.

• Employee Starts

  The number of employee starts for each group. The worksheets calculate the Employee Starts total by totaling the employee assignments created to fill the vacancies.

• Success Rate Percent

  Displays the total workforce starts as a percentage of total workforce openings.

The worksheets count employee assignments using Workforce, enabling you to define the employee value of each assignment. See: Workforce Calculation