Standard AQ - Federal EEO Reporting Data File 1

What is the EEO-1 Component 1 Report?

Since 1966, the EEOC has required EEO-1 filers to submit demographic data on an annual basis. All private employers that are covered by Title VII of the Civil Rights Act of 1964, 42 U.S.C. 2000e, et. seq., as amended (Title VII) and that have 100 or more employees are required to file the EEO-1 Component 1 Report. In addition, the Office of Federal Contract Compliance Programs (OFCCP) regulations require certain federal contractors to file the EEO-1 Component 1 if they have 50 or more employees and are not exempt as provided for by 41 CFR 60-1.5.

Employers meeting the reporting thresholds have a legal obligation to submit annual workforce data on their employees by race/ethnicity, sex and job category. The data include seven race/ethnicity categories and 10 job categories. EEO-1 Component 1 data are used by the EEOC to investigate charges of employment discrimination against employers and to provide information about the employment status of minorities and women.

 

The following employers are required to file the EEO-1 Component 1 Report annually:

  1. Private employers (who are subject to Title VII of the Civil Rights Act of 1964, as amended) with 100 or more employees; OR
  2. Private employers subject to Title VII who have fewer than 100 employees and are owned or affiliated with another company, or there is centralized ownership, control or management (such as central control of personnel policies and labor relations) so that the group legally constitutes a single enterprise, and the entire enterprise employs a total of 100 or more employees.
  3. Federal contractors who (1) are not exempt as provided for by 41 CFR 60-1.5; (2) have 50 or more employees; (3) are prime contractors or first-tier subcontractors; and (4) have a contract, subcontract, or purchase order amounting to $50,0000 or more; OR
  4. Federal contractors that serve as depositories of Government funds in any amount; or are financial institutions that are issuing and paying agents for U.S. savings bonds and savings notes.

Picture1.png

 

Parameters

Parameter Name

Options

Description

Supplier

All available Suppliers

 

Branch

All available Branches

 

Date Type

Accounting Period Date, Week Worked, Check Date

 

Start Date

 

 

End Date

 

 

Ignore "Missing Info" Errors?

Yes / No (Default)

Yes = Report will pull any completed data without errors.

No = Report will not pull any data & will display all errors to be corrected. If all errors are corrected - complete data pull will display.

 

 

Error Message View when Ignore "Missing Info" Errors = No w/ Various errors requiring correction:

 

Capture.PNG


The following fields require a value entered into the employer supplier property:


(Admin Tools > Employer > Supplier Property > Property = Federal_EEO_Reporting_Data_File1)

- Was an EEO-1 report filed for this establishment last year?
- Company ID
- Status Code

Picture2.png

 

Setup Required

  • This AQ requires mapping: https://support.avionte.com/hc/en-us/articles/218393358
  • This AQ requires a Supplier Property called OSHA NAICS Code.
  • Note* - Do NOT include a header row with export upload as it will cause an error. The name of the file does not matter as long as the file has the extension of .txt or .csv. 

 

 

Report Fields

Field Name

Description

Company ID

Unique Identifier For Entire Company. Should be 7 characters. *Supplier Property*

Status Code

1 = Single-establishment employer *Supplier Property*

Company ID

For single-establishment companies, this is the same as Field 1.

Company Name

 

Company Address Line 1

Company Address Line 1 (Physical address – no PO Box)

Company Address Line 2

Extended Company Address To Include Suite No., PO Box, Etc.

City Name

City Name

State Abbreviation 

Please use the state abbreviations defined in FIPS Pub 5-2(Census)

Zip Code

US Postal Service

Was an EEO-1 report filed for this establishment last year?

1 or Y for Yes; 2 or N for No. *Supplier Property*

At Least 100 Employees

N/A - Field is not mandatory. These questions are now answered in the Online Filing System BEFORE the upload files are processed and the entries in the upload file will be ignored. 

Total Employment 100 or More?

N/A - Field is not mandatory. These questions are now answered in the Online Filing System BEFORE the upload files are processed and the entries in the upload file will be ignored.

Has 50 or More Employees

N/A - Field is not mandatory. These questions are now answered in the Online Filing System BEFORE the upload files are processed and the entries in the upload file will be ignored.

Dun & Bradstreet Number

N/A - Field Not Required

County Name

N/A - Field Not Required

Dates of Workforce Snapshot Pay Period Used

Workforce Snapshot Pay Period Used For The Report in format of MMDDYYYYMMDDYYYY. Time Frame May Be Any Pay Period In October, November Or December Of The Report Year and must be less than 31 days.

NAICS Code

*Supplier Property*

Title of Certifying Official 

N/A - Field Not Required

Name of Certifying Official 

N/A - Field Not Required

Telephone Number

N/A - Field Not Required

Email Address of Certifying Official

N/A - Field Not Required

EIN (or FEIN)

Your Federal EIN Number (Tax Id)

 

Review the Data File 1 Matrix Reference

 

Matrix Data V-GD 11 groupings of 91 characters each that correspond to the rows on the paper form.  If a field is zero (0) the field can be left NULL.  A further detailed, breakdown of the individual data elements of Field 22 is provided in the tab “Data File 1 Matrix Reference.” 
Row 1 V-AJ Executive/Senior Level Officials and Managers
Column A V Hispanic or Latino Males
Column B W Hispanic or Latino Females
Column C X White Males
Column D Y Black or African American Males
Column E Z Native Hawaiian or Other Pacific Islander Males
Column F AA Asian Males
Column G AB American Indian or Alaska Native Males
Column H AC Two or More Races Males
Column I AD White Females
Column J AE Black or African American Females
Column K AF Native Hawaiian or Other Pacific Islander Females
Column L AG Asian Females
Column M AH American Indian or Alaska Native Females
Column N AI Two or More Races Females
Column O AJ Total Males and Females for the Respective Row
Row 2 AK-AY First/Mid-Level Officials and Managers
Row 3 AZ-BN Professionals
Row 4 BO-CC Technicians
Row 5 CD-CR Sales Workers
Row 6 CS-DG Administrative Support Workers
Row 7 DH-DV Craft Workers
Row 8 DW-EK Operatives
Row 9 EL-EZ Laborers and Helpers
Row 10 FA-FO Service Workers
Row 11 FP-GD Individual Column Totals for Rows 1-10

 

3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or an approval by [The author] of any of the products, services or opinions of the corporation or organization or individual. [The author] bears no responsibility for the accuracy, legality or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.