Skip to Main Content
Return to Navigation

Using the Recruitment Analysis Dashboard - Recruiting Effectiveness Page

Use the Recruiting Effectiveness page to provide you with an overview of recruiting effectiveness metrics for your organization, including vacancy fill rates, time to fill analysis, and recruiting source effectiveness.

Navigation

select Dashboards, then select HCM, then select Human Capital Management, then select HCM: Recruitment Analysis, then select Recruiting Effectiveness

Image: Recruiting Effectiveness page

This example illustrates the fields and controls on the Recruiting Effectiveness page. You can find definitions for the fields and controls later on this page.

 Recruiting Effectiveness page

Usage

Reports

Dashboard Prompt

Provides you with an overview of recruiting effectiveness metrics for your organization, including vacancy fill rates, time to fill analysis, and recruiting source effectiveness.

This page is comprised of the following reports:

  • Vacancy Fill Rate report

  • Time to Fill report

  • Recruiting Source Effectiveness report

  • Vacancy Fill Rate Details report

  • Recruiting Source Effectiveness Detail report

Use the Recruiting Effectiveness page prompt to filter page results by:

  • Fiscal Year

  • Fiscal Quarter

  • Department

Vacancy Fill Rate Report

Use the Vacancy Fill Rate report, which enables you to analyze vacancy fill rates for your organization and view details about job openings count, hire count, and job fill rate percentage.

Image: Vacancy Fill Rate report

This example illustrates the fields and controls on the Vacancy Fill Rate report. You can find definitions for the fields and controls later on this page.

 Vacancy Fill Rate report

The Vacancy Fill Rate graph displays Fiscal Year, Fiscal Quarter data on the x-axis and Filled Position Count and Position Fill Rate data on the y-axis.

Report Column / Measure Name

Report Column / Measure Origin

Department

Department (D_DEPT) Dimension

Fiscal Year

Day (D_DAY) Dimension

Fiscal Quarter

Day (D_DAY) Dimension

Open Position Count

Recruitment (F_RCMNT) Fact

Filled Position Count

Recruitment (F_RCMNT) Fact

Position Fill Rate (%)

("Fact Recruitment"."Hire Count") /("Fact Job Opening"."Job Openings Count") * 100

Time to Fill Report

Use the Time to Fill report, which enables you to analyze the time it takes for various departments in your organization to fill a job opening.

Image: Time to Fill report

This example illustrates the fields and controls on the Time to Fill report. You can find definitions for the fields and controls later on this page.

 Time to Fill report

The Time to Fill graph displays Fiscal Year, Fiscal Quarter data on the x-axis and Average Open Position Duration (Days) data on the y-axis.

Report Column / Measure Name

Report Column / Measure Origin

Department

Department (D_DEPT) Dimension

Fiscal Year

Day (D_DAY) Dimension

Fiscal Quarter

Day (D_DAY) Dimension

Average Open Position Duration (Days)

Recruitment (F_RCMNT) Fact:

CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('090','100','110','120') THEN ( "Dimension Day Entry Date"."Entry Day Date"-"Dimension Day Status Date"."Status Day Date" ) ELSE NULL END

Recruiting Source Effectiveness Report

Use the Recruiting Source Effectiveness report, which enables you to analyze the effectiveness of your organization's recruiting sources and view details about the number of candidates hired by department, job, referral source and referral source percentage.

Image: Recruiting Source Effectiveness report

This example illustrates the fields and controls on the Recruiting Source Effectiveness report. You can find definitions for the fields and controls later on this page.

 Recruiting Source Effectiveness report

X,Y Axis Data

Referral Source Filter

The Recruiting Source Effectiveness graph displays Department and Job Description data on the x-axis and Number of Candidates, Number of Candidates Hired and % Hired from Source data on the y-axis.

Use this filter to view report results by the following referral sources:

  • Advertisement

  • Client Referral

  • Walk-In

  • Employee

  • Executive Referral

  • Former Employee

  • Job Fair

  • Open House

  • College Recruiting

  • Agency

Report Column / Measure Name

Report Column / Measure Origin

Department

Department (D_DEPT) Dimension

Fiscal Year

Day (D_DAY) Dimension

Fiscal Quarter

Day (D_DAY) Dimension

Job Code

Employee Job Code (D_EMPL_JOB) Dimension

Referral Source Category Description

Referral Source Category (D_REF_SRC_CAT) Dimension

Number of Candidates

Recruitment (F_RCMNT) Fact

Number of Candidates Hired

Recruitment (F_RCMNT) Fact

% Hired from Source

("Fact Recruitment"."Hire Count"/"Fact Recruitment"."Applicant Headcount")*100

Vacancy Fill Rate Details Report

Use the Vacancy Fill Rate Details report, which enables you to analyze job vacancy fill rates for various departments in your organization and view details about job openings count, hire count, and job fill rate percentage.

Image: Vacancy Fill Rate Details report, part 1

This example illustrates the fields and controls on the Vacancy Fill Rate Details report, part 1. You can find definitions for the fields and controls later on this page.

 Vacancy Fill Rate Details report, part 1

Image: Vacancy Fill Rate Details report, part 2

This example illustrates the fields and controls on the Vacancy Fill Rate Details report, part 2. You can find definitions for the fields and controls later on this page.

 Vacancy Fill Rate Details report, part 2

X,Y Axis Data

View By Filter

The Vacancy Fill Rate Details graph displays Fiscal Year data on the x-axis and Open Position Count, Filled Position Count and Position Fill Rate data on the y-axis.

Use this filter to view report results by:

  • Location

  • Job Family Description

  • Job Description (default)

  • Grade

Report Column / Measure Name

Report Column / Measure Origin

Fiscal Year

Day (D_DAY) Dimension

Fiscal Quarter

Day (D_DAY) Dimension

Department

Department (D_DEPT) Dimension

Location

Location (D_LOCATION) Dimension

Job Description

Employee Job Code (D_EMPL_JOB) Dimension

Job Family Description

Employee Job Code (D_EMPL_JOB) Dimension

Grade

Employee Job Code (D_EMPL_JOB) Dimension

Filled Position Count

Recruitment (F_RCMNT) Fact

Open Position Count

Recruitment (F_RCMNT) Fact

Position Fill Rate (%)

("Fact Recruitment"."Hire Count") /("Fact Job Opening"."Job Openings Count") * 100

Recruiting Source Effectiveness Detail Report

Use the Recruiting Source Effectiveness Detail report, which enables you to analyze recruiting source effectiveness for your organization.

Image: Recruiting Source Effectiveness Detail report

This example illustrates the fields and controls on the Recruiting Source Effectiveness Detail report. You can find definitions for the fields and controls later on this page.

 Recruiting Source Effectiveness Detail report

X,Y Axis Data

View By Filter

The Recruiting Source Effectiveness Detail graph displays Fiscal Year and Referral Source data on the x-axis and Percent Hired from Source data on the y-axis.

Use this filter to view report results by:

  • Location

  • Department

  • Job Series (default)

Report Column / Measure Name

Report Column / Measure Origin

Fiscal Year

Day (D_DAY) Dimension

Fiscal Quarter

Day (D_DAY) Dimension

Job Code

Employee Job Code (D_EMPL_JOB) Dimension

Referral Source Category Description

Referral Source Category (D_REF_SRC_CAT) Dimension

Hire Count

Recruitment (F_RCMNT) Fact

Applicant Head Count

Recruitment (F_RCMNT) Fact:

% Hired from Source

Fact Recruitment.Hire Count / Fact Recruitment.Applicant Head Count * 100