Equal Employment Opportunity - EEO1 Report
#


Overview#

REEO1 provides capability for users to generate an interface file to report the EEO-1 Equal Employment Opportunity Data to the US Equal Employment Opportunity Commission. This is a report that may be required for U.S. private companies. The REEO1 process supports the filing of both a single-Establishment Employer and Multi-Establishment Employer.

Please refer to the following EEO web sites for government instructions.

http://www.eeoc.gov/index.html

The EEO-1 Data File format can be obtained in the following website:

http://www.eeoc.gov/eeo1survey/datafile.html

After REEO1 is run, an EEO-1 Data File is generated. The user needs to login to the following EEO website to upload the file to the government.

http://www.eeoc.gov/eeo1survey/index.html

EE0-1 Single and Multi-establishment Required Set Up#

IMUF - Define User Fields#

The REEO1 utalizes system created user defined fields on found on both the P2K_CM_LOCATIONS and P2K_CM_ENTITY_DETAILS tables.

These fields will be created the first time REEO1 is launched. Users should therefore run the REEO1 first prior to completing the additional required set up.

User field NamePromptTableField Value TypeLexicon
EEO1_UNIT_NUMBEREEO1 Unit NumberP2K_CM_LOCATIONSChar
EEO1_FIRST_TIME_REPOEEO1 First Time ReportingP2K_CM_LOCATIONSCharX_Y_OR_N
EEO1_Q_B_2_CEEO1 Question B.2.CP2K_CM_LOCATIONSCharX_Y_OR_N
EEO1_Q_C_1EEO1 Question C.1P2K_CM_LOCATIONSCharX_Y_OR_N
EEO1_Q_C_2EEO1 Question C.2P2K_CM_LOCATIONSCharX_Y_OR_N
EEO1_Q_C_3EEO1 Question C.3P2K_CM_LOCATIONSCharX_Y_OR_N
EEO1_DUN_BRADSTREET_NREE01 Dun & Bradstreet NumberP2K_CM_LOCATIONSNumber
EEO1_NAICS_CODEEEO1 Naics CodeP2K_CM_LOCATIONSNumber
EE01_COMPANY_NUMBEREEO1 Company NumberP2K_CM_ENTITY_DETAILSChar

IDTX - Define Tax Jurisdictions #

There must be a tax jurisdiction defined for the EEO-1 report. The jurisdiction must be defined at the county level as this will be the county name to report on the EEO-1 Data File.

IDLN - Define Locations #

Each location to be reported for EE0-1 must have a JURISDICTION_NAME associated that has been defined at the county level.
  • The following user defined fields can be populated if needed
User field NamePromptMandatoryDetails
EEO1_UNIT_NUMBEREEO1 Unit NumberNo
EEO1_FIRST_TIME_REPOEEO1 First Time ReportingNo
EEO1_Q_B_2_CEEO1 Question B.2.CNo
EEO1_Q_C_1EEO1 Question C.1No
EEO1_Q_C_2EEO1 Question C.2No
EEO1_Q_C_3EEO1 Question C.3No
EEO1_DUN_BRADSTREET_NREE01 Dun & Bradstreet NumberNo
EEO1_NAICS_CODEEEO1 Naics CodeNo

IDEN - Define Entities#

The LOCATION_CODE associated to Entity must have a tax jurisdiction defined at the county level on IDTX. The EEO1 Company Number user field must be populated as it is required in the EE01 data file. The location code associated to entity must be one of the locations defined with the county Jursidiction. The EEO1 Company Number user field must be populated as it is required in the EE01 data file.

IDEN - Define Entities#

The LOCATION_CODE associated to Entity must have a tax jurisdiction defined at the county level on IDTX. The EEO1 Company Number userfield must be populated as it is required in the EE01 data file.
User field NamePromptMandatoryDetails
EE01_COMPANY_NUMBEREEO1 Company NumberNo

EE0-1 Multi-Establishment Required Set Up#

This set up is only required if you are a multi-establishment employer. Records will need to be created on the IDOL screen with the following ORG_LEVEL_TYPE found on the lexicon X_ORG_LEVEL_TYPE

Saved ValueDisplayed Value
E1EEO Headquarter
E2EEO Locn Establishment

If you have only the single location to report, this set up is not required.

IDOL Define Organizational Levels#

  • EEO Headquarter - User must enter one entry with this Org Level Type (typically this will be the location code found on the IDEN)
IDOL FieldDetails
Org Level TypeEEO Headquarter
Org Level CodeEnter your own organization level code, may be your company name
DescriptionEnter your own description
Parent EntityMust enter the Entity Name that this EEO Headquarter is reporting for
Parent Org LevelLeave this blank for EEO Headquarter
Managing PositionNot required for this report
Must list all Departments that have a matching location code to be reported.

  • EEO Locn Establishment - For each additional location to be reported,users must create an entry with this type
IDOL FieldDetails
Org Level TypeEEO Locn Establishment
Org Level CodeEnter your own organization level code. The EEO Location code must also be entered on the IDLN
DescriptionEnter your own description
Parent EntityBlank
Parent Org LevelEnter the Org Level Code from IDOL EEO Headquarter above
Managing PositionNot required for this report
user must list all Departments that belong to this EEO Locn Establishment

Report Parameters & Filters#

Report Parameters
EntityMandatory, LOV Available
This field limits the report to a single entity.
Date Range From/ToDate, LOV Available
This date range will be used to identify the dates that the employees will be pulled from to generate the report. Employees who are active within this date range will be included in the report.
As OfDate, LOV Available
This date indicates the date that the employee's demographic records will be examined “as of”. It should be set to the Date Range To value, to ensure consistency of data.
Sort People ByOptional, LOV Available
This field indicates how the information will be sorted.
Pay Period UsedMandatory, Manual. Enter pay period number.
Certified TitleMandatory, Manual
This field displays the title of the individual who has certified the information in the report.
Certified ByMandatory, Manual
This field indicates the name of the individual who has certified the information in the report.
Telephone NumberMandatory, Manual
This field provides a telephone number for the individual who certified the report information.
Create Errors FileOptional, Yes or No, LOV available
Create Dump FileOptional, Yes or No, LOV available
Details in Dump FileOptional, Yes or No, LOV available
Directory NameOptional Manual
EEO1 File NameOptional Manual
User CommentOptional, Text
This field holds the user-supplied comment which will appear in the header of all pages of the report.
Exception LevelMandatory, LOV available
You may select the level of logging desired: ‘Exceptions Only’, ‘User Trace’, ‘Internal Level’ ‘Legislation’, ‘UserCalc Trace’, ‘Program Trace’ or Utility Trace.

Report Filters
People List CodeOptional, Multiple Selection Available, LOV Available
This field will limit the report to the people lists selected.
Person CodeOptional, Multiple Selection Available, LOV Available
This field will limit the report to the people selected.
Org Level TypeOptional, Lexicon Available
This will limit the report to the organization level type selected.
Note:Org Level Type MUST be specified IF you are using the Sort Option of Org Level OR if you want to filter by Org Levels.
Org LevelOptional, Multiple Selection Available, LOV Available
This will limit the report to the organization levels selected.
DepartmentOptional, Multiple Selection Available, LOV Available
This will limit the report to the departments selected.
AuthorizationOptional, Multiple Selection Available, LOV Available
This will limit the report to the authorization levels selected.
UnitOptional, Multiple Selection Available, LOV Available
This field will limit the report to the units selected.
GroupOptional, Multiple Selection Available, LOV Available
This field will limit the report to the groups selected.
Status TypesOptional, Multiple Selection Available, LOV Available
This field will limit the report to the status types selected.


Notes #

Click to create a new notes page