1. Using Oracle Business Intelligence for Oracle Taleo Enterprise Edition
  2. Recruiting - Pipeline Summary

Recruiting - Pipeline Summary

The chart provides a quantitative and qualitative summary of the candidate pipeline on requisitions across various dimensions.

Image showing a bubblechart

Report Columns

The table shows report columns and syntax if any
Name Syntax
Dimension
Status

Statuses are binned into the following categories: 0. New - Incomplete, 1. New - Complete, 2. Review, 3. Interview, 4. Testing, 5. Offer, NS.

CASE  
	WHEN "Submission CSW Status - Current"."Current Reference Status Name" || ' - ' || "Submission General Info"."Submission Is Completed" 
		= 'New - No' 
		THEN '0. New - Incomplete' 
	WHEN "Submission CSW Status - Current"."Current Reference Status Name" || ' - ' || "Submission General Info"."Submission Is Completed" 
		= 'New - Yes' 
		THEN '1. New - Complete' 
	WHEN "Submission CSW Status - Current"."Current Reference Status Name" || ' - ' || "Submission General Info"."Submission Is Completed" 
		IN ('Reviewed - No', 'Reviewed - Yes') 
		THEN '2. Review' 
	WHEN "Submission CSW Status - Current"."Current Reference Status Name" || ' - ' || "Submission General Info"."Submission Is Completed" 
		IN ('1st Interview - No', '1st Interview - Yes') 
		THEN '3. Interview' 
	WHEN "Submission CSW Status - Current"."Current Reference Status Name" || ' - ' || "Submission General Info"."Submission Is Completed" 
		IN ('Testing - No', 'Testing - Yes') 
		THEN '4. Testing' 
	WHEN "Submission CSW Status - Current"."Current Reference Status Name" || ' - ' || "Submission General Info"."Submission Is Completed" 
		= 'Offer - Yes' 
		THEN '5. Offer' 
	ELSE 'NS'
END
# Submissions "Candidate Counts"."# Submissions"
# New Complete 
FILTER("Candidate Counts"."# Submissions Currently New" 
USING (("Submission General Info"."Submission Is Completed"='Yes') 
AND ("Submission Prescreening Results"."Minimum Requirements Met"='Yes')))
# New Incomplete 
FILTER("Candidate Counts"."# Submissions Currently New" 
USING (("Submission General Info"."Submission Is Completed"='No') 
AND ("Submission Prescreening Results"."Minimum Requirements Met"='Yes')))
# Review "Candidate Counts"."# Submissions Currently in Review"
# Intv. "Candidate Counts"."# Submissions Currently In 1st Intv."
# Offer "Candidate Counts"."# Submissions Currently In Offer"
# Testing "Candidate Counts"."# Submissions Currently In Testing"
% Ace cast("Candidate Counts"."# Submissions Ace"/"Candidate Counts"."# Submissions" as double) * 100
% Min Requirements Met cast("Candidate Counts"."# Submissions Min. Requirements Met" / "Candidate Counts"."# Submissions" as double) * 100

View By: Dimension

Short sentence or paragraph to describe the configuration table.

The table shows report view columns and syntax if any
Name Syntax
Organization Level 1 Name "Requisition Organization"."Organization Level1 Name"
Organization Level 2 Name "Requisition Organization"."Organization Level2 Name"
Location Level 1 Name "Requisition Primary Location"."Location Level1 Name"
Location Level 2 Name "Requisition Primary Location"."Location Level2 Name"
Job Field Level 1 Name "Requisition Job Field"."Job Field Level1 Name"
Job Field Level 2 Name "Requisition Job Field"."Job Field Level2 Name"
Hiring Manager "Requisition Hiring Manager"."Hiring Manager Name"
Recruiter "Requisition Recruiter"."Recruiter Name"
Job Level "Requisition Profile"."Req. Job Level"
Job Type "Requisition Profile"."Req. Job Type"
Justification "Requisition Identification"."Justification"
Degree "Submission Education History"."Submission Education Degree Type"
Source Type "Submission Source"."Submission Source Type (Display As)"
Internal/External Submission 
CASE WHEN "Submission General Info"."Submission Is Internal" 
= 'Yes' THEN 'Internal' ELSE 'External' END
Submission Medium "Submission General Info"."Submission Medium"
Gender "Candidate Regulations"."Gender"
Race "Candidate Regulations"."Race"

View Configurations

The table shows view configurations
Name Additional Information
Pipeline Quality

Horizonal Axis: % Min Requirements Met

XY(Vertical Axis): % Ace

XY(Bubble Size): # Submissions

Vary Color By: Dimension
Submissions by Stage

Bars: # New Incomplete, # New Complete, # Review, # Intv., # Testing, # Offer

Group By: Dimension

Report Filters

The table shows report filters
Name
Current Status is equal to / is in Sourcing
Has Unlimited Openings is equal to / is in No
Current Reference Status Name is equal to / is in 1st Interview; New; Reviewed; Testing; Offer
Recruiting - Open Req. Dashboard Prompt Listener