Recruiting - EEO Race By Stage Summary

The chart displays a distribution of candidates by race/ethnicity and historical recruiting status.

Race/Ethnicity 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
Race
case 
	when "Candidate Regulations"."Race"='Undisclosed' then 'Undisc.'  
	when "Candidate Regulations"."Race"='Not Specified' then 'N/S' 
	when "Candidate Regulations"."Race" is not null 
		then replace("Candidate Regulations"."Race",'Race - ','') else 'N/S' 
end 
|| ' (' || 
case 
	when "Candidate Regulations"."Ethnicity"='Undisclosed' then 'Undisc.' 
	when "Candidate Regulations"."Ethnicity"='Ethnicity - Not Hispanic Latino' then 'NHL' 
	when "Candidate Regulations"."Ethnicity"='Ethnicity - Hispanic Latino' then 'HL' 
	when "Candidate Regulations"."Ethnicity" is not null then replace("Candidate Regulations"."Ethnicity",'Ethnicity - ','') 
	else 'N/S' 
end
|| ')'
Race (Specified)

Selection Steps are used to remove N/S (N/S) and Undisc (N/S) values.

case 
	when "Candidate Regulations"."Race"='Undisclosed' then 'Undisc.'  
	when "Candidate Regulations"."Race"='Not Specified' then 'N/S' 
	when "Candidate Regulations"."Race" is not null 
		then replace("Candidate Regulations"."Race",'Race - ','') else 'N/S' 
end 
|| ' (' || 
case 
	when "Candidate Regulations"."Ethnicity"='Undisclosed' then 'Undisc.' 
	when "Candidate Regulations"."Ethnicity"='Ethnicity - Not Hispanic Latino' then 'NHL' 
	when "Candidate Regulations"."Ethnicity"='Ethnicity - Hispanic Latino' then 'HL' 
	when "Candidate Regulations"."Ethnicity" is not null then replace("Candidate Regulations"."Ethnicity",'Ethnicity - ','') 
	else 'N/S' 
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

Race 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: Race

Race/ Ethnicity Specified - Pct Stacked

Bars: # Submissions

Group By: Status

Vary Color By: Race (Specified)

All Values - Nb Log Stacked

Bars: # Submissions

Group By: Status

Vary Color By: Race

Pivot Table

Measures: # Submissions

Rows: Status

Columns: Race