B0180 EEO-4

Purpose

The purpose of this Report Description is to explain how to generate a report with demographic information such as ethnic origin and gender.

Report Description

This report provides demographic information such as ethnic origin and gender along with EEO Categories. The report provides Headcount and New Hire Actions count details by Function Group, EEO Category and Race/Ethnicity.

Report Location

PA: EEO-4

Report Uses

• This report is required by the Federal Equal Employment Opportunity Commission (EEOC) and submitted by OSHR every two years for all state agencies including DOT.  DOT submits the report independently, including only their staff, on an annual basis.
• The report is useful in providing required reporting data to Federal on employment totals, employees job category and salary by sex and race/ethnic groups as of June 30.

How to Generate This Report

This report is generated after selecting values for the mandatory prompts.  All mandatory prompts must have values selected before the Run Icon can be used to generate the report. Mandatory prompts can be identified as mandatory by the exclamation mark inside of the yellow-orange triangle, the square with the checkmark, or the display of (Mandatory).  Detailed instructions for interaction with each prompt can be found on the Crystal Report Prompt List on the OSC website.

The Mandatory prompts for this report are: 

• Organizational Unit
• Year Cycle Ended (Single Value, Mandatory)

Initial Layout

The EEO-4 report provides demographic Information such as ethnic origin and gender along with Federal EEO Categories and Function Groups.

EEO-4 Continued…

EEO-4 Continued…

EEO-4 Continued…

The report also shows the Statewide Totals of the Headcounts and New Hire Actions count details by Race and Ethnicity.  This information is provided at the end of the report. 

Special Report Considerations/Features

• Only active employees are included on this report.
• Personnel Area 8701-School of Science & Math is excluded from the report.
• Employees with unknown gender, ethnic origin, or EEO Category are excluded.
• EEO-4 Function Groups included in the report are:

• The following positions are excluded:

[60012763]	Exec Dir Agric Finance Authority
[60012868]	Exec Dir Of The Tobacco Trust Fund Comm
[60080498]	Chief Deputy Commissioner Of Banks
[60080524]	Deputy Commissioner Of Banks
[60080638]	Commissioner
[60080639]	Commissioner
[60080640]	Commissioner
[60080641]	Commissioner

•  The following Statutory Exemption Types are excluded in the report:

• The following criteria are used to map Personnel Areas to EEO-4 Function Groups.

Personnel Area Key	Personnel Area Text	EEO-4 Function Group Key	EEO-4 Function Group Text
201	Judicial Branch	1	Financial Administration
301	Governor's Office	1	Financial Administration
310	State Budget & Management	1	Financial Administration
401	Lt Governor's Office	1	Financial Administration
501	Secretary of State	1	Financial Administration
601	State Auditor	1	Financial Administration
0701	State Treasurer	1	Financial Administration
801	Public Instruction	1	Financial Administration
901	Justice	1	Financial Administration
0905	Justice - SBI	4	Police Protection
1001	Agriculture Consumer Services	6	Natural Resources
1101	Labor	1	Financial Administration
1201	Insurance	1	Financial Administration
1301	Administration	1	Financial Administration
1401	State Controller	1	Financial Administration
1501	Transportation	2	Streets and Highways
1601	Environment Natural Resources	6	Natural Resources
1701	Wildlife Resources Commission	6	Natural Resources
1801	Juvenile Justice Delinq Prev	11	Corrections
1901	Public Safety	4	Police Protection
4001	Military and Veterans Affairs	1	Financial Administration
4101	Information Technology	1	Financial Administration
4105	DIT EBS	1	Financial Administration
4201	Correction	11	Corrections
4301	Commerce	1	Financial Administration
4305	Commerce - DES & DWS	14	Employment Security State Government
4401	Employment Security Commission	14	Employment Security State Government
4501	Revenue	1	Financial Administration
4601	Cultural Resources	6	Natural Resources
4701	Crime Control & Public Safety	4	Police Protection
4705	CCPS-Highway Patrol	4	Police Protection
5001	Community Colleges	1	Financial Administration
5201	Adult Correction	11	Corrections
6101	Education Lottery	1	Financial Administration
6701	Administrative Hearings	1	Financial Administration
2001/ BusArea 2X00	Health Human Services	3	Public Welfare
2001/ BusArea 3X00	Health Human Services	7	Hospitals & Sanatoriums
2005/ BusArea 2X00	HHS - 403(b) Participants	3	Public Welfare
2005/ BusArea 3X00	HHS - 403(b) Participants	7	Hospitals & Sanatoriums
6A01	State Health Plan	1	Financial Administration
B001	Barber Exam	1	Financial Administration
B005	Cosmetic Arts	1	Financial Administration
B010	Opticians	1	Financial Administration
B015	Psychology	1	Financial Administration
B020	Auctioneer Licensing	1	Financial Administration
B025	Elections	1	Financial Administration
B030	State Ethics	1	Financial Administration
Z101	State Personnel	1	Financial Administration
Z105	OSHR Temporary Solutions	1	Financial Administration

• The following filter criteria are used to determine Full-Time employees.
  • Exclude Employee Groups
    • O - Supplemental Staff
    • X - Supplemental Staff Grant
• Include the following Employee Subgroups for Full-Time.

• The following Employee Subgroups are used to determine Other Than Full-Time employees.

• The following filter criteria is used to determine New Hires.
• Exclude the following Employee Subgroups.

• Include the following Action Type/Action Reasons.