1. Using Oracle Analytics for Oracle Taleo Enterprise Edition
  2. Recruiting - Candidate Age by Stage Summary

Recruiting - Candidate Age by Stage Summary

The chart displays a distribution of candidates by age band and historical recruiting status.

Candidate Age Band By Stage

Image showing a column chart

Report Fields

Name Syntax
Status 
case 
	when "Submission CSW Status - Historical"."Historical Reference Status Name" 
		= 'New' 
		then '1. New'  
	when "Submission CSW Status - Historical"."Historical Reference Status Name" 
		= 'Reviewed' 
		then '2. Rev.'  
	when "Submission CSW Status - Historical"."Historical Reference Status Name" 
		= '1st Interview' 
		then '3. Intv' 
	when "Submission CSW Status - Historical"."Historical Reference Status Name" 
		= 'Offer' 
		then '4. Offer'  
	when "Submission CSW Status - Historical"."Historical Reference Status Name" 
		= 'Hired' 
		then '5. Hired' 
	when "Submission CSW Status - Historical"."Historical Reference Status Name" 
		= 'Rejected' 
		then '6. Rejected'  
	when "Submission CSW Status - Historical"."Historical Reference Status Name" 
		= 'Declined' 
		then '7. Declined' 
end
Age 
case 
	when TimeStampDiff(SQL_TSI_YEAR,"Candidate Identification"."Date of Birth","Submission Dates"."Submission Completed Date") < 40 
		then 'Under 40' 
	when TimeStampDiff(SQL_TSI_YEAR,"Candidate Identification"."Date of Birth","Submission 	Dates"."Submission Completed Date") >= 40 
		then 'Over 40' 
	else 'N/S' 
end
Age (Specified)

Selection Steps are utilized to remove N/S records.

case 
	when TimeStampDiff(SQL_TSI_YEAR,"Candidate Identification"."Date of Birth","Submission Dates"."Submission Completed Date") < 40 
		then 'Under 40' 
	when TimeStampDiff(SQL_TSI_YEAR,"Candidate Identification"."Date of Birth","Submission 	Dates"."Submission Completed Date") >= 40 
		then 'Over 40' 
	else 'N/S' 
end
# Submissions "Candidate Counts"."# Submissions"

Filters

Name
Historical Reference Status Name is equal to / is in Hired; 1st Interview; Declined; Rejected; Reviewed; Offer; New
Submission Is Completed is eqal to / is in Yes
Minimum Requirements Met is equal to / is in Yes
Recruiting - Summary Dashboard Prompt Listener

View Configurations

Name Additional Information
All Values - Pct Stacked

Bars: # Submissions

Group By: Status

Vary Color By: Age
Specified Age - Pct Stacked

Bars: # Submissions

Group By: Status

Vary Color By: Age (Specified)
All Values - Nb Log Stacked

Bars: # Submissions

Group By: Status

Vary Color By: Age
Pivot Table

Measures: # Submissions

Rows: Status

Columns: Age