1. Using Oracle Business Intelligence for Oracle Taleo Enterprise Edition
  2. Recruiting - EEO Gender By Stage Summary

Recruiting - EEO Gender By Stage Summary

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

Gender By Stage

Image showing a column chart

Configuration

The table shows report columns and syntax if any
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
Gender 
case 
	when "Candidate Regulations"."Gender"='Undisclosed' then 'Undisc.'  
	when "Candidate Regulations"."Gender" is not null then replace("Candidate Regulations"."Gender",'Gender - ','') 
	else 'Not Specified' 
end
Gender (Specified)

Selection steps are used to limit returned values to Male and Female.

case 
	when "Candidate Regulations"."Gender"='Undisclosed' then 'Undisc.'  
	when "Candidate Regulations"."Gender" is not null then replace("Candidate Regulations"."Gender",'Gender - ','') 
	else 'Not Specified' 
end
# Submissions "Candidate Counts"."# Submissions"

Filters

The table shows report filters
Name
Historical Reference Status Name is equal to / is in Hired; 1st Interview; Declined; Rejected; Reviewed; Offer; New

Is Max Standard USA EEO Form With Answer is equal to / is in Yes

OR

Gender is null
Submission Is Completed is equal to / is in Yes
Minimum Requirements Met is equal to / is in Yes
Recruiting - Summary Dashboard Prompt Listener

View Configurations

The table shows report configurations
Name Additional Information
All Values - Pct Stacked

Bars: # Submissions

Group By: Status

Vary Color By: Gender
Gender Specified - Pct Stacked

Bars: # Submissions

Group By: Status

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

Bars: # Submissions

Group By: Status

Vary Color By: Gender
Pivot Table

Measures: # Submissions

Rows: Status

Columns: Gender