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.