Standard AQ - Federal EEO Component 2 Reporting AQ

Report Description

This report gives Federal reporting of EEO-1 Component 2 information.

This report was created based on the specifications found on the EEOC.gov website.  The format of the report is found on the EEOC website: Format

 

mceclip0.png

 

 

Setup Required

 

Special Logic

Report throws following error message as result if EEO Mapping or Job Category Mapping has not been completed: 'Mapping Group "EEO Report Mapping" or Mapping Type "Job Category" is missing'

 If Job Position mapping is missing, then following error message is thrown: 'Missing Mapping in Admin Tools >> Import Export Mapping Section'

 

 

Parameters

Parameter Name

Options

Description

Supplier

 All Available Suppliers

 

Branch (Employee)

 All Available Branches

 

Date Type

Accounting Period Date, Week Worked Date, Check Date

 

Start Date

MM/DD/YYYY

 

End Date

MM/DD/YYYY

 

Status Code

Establishment Designation

1 = Single Establishment Employer
2 = Consolidated Report
3 = Headquarters Report
4 = Individual Establishment Report (50+ Employees – Not First Time Reporting)
5 = Special Reporting Procedure
6 = Establishment List Report (Fewer Than 50 Employees)
8 = Individual Establishment Report (Fewer Than 50 Employees)
9 = Individual Establishment Report (50+ Employees – First Time Reporting)

Unit Number

 

Should Be Reported Except for New Status Code 6, 8 And All Status Code 9 Records

UserID (8 digit identifier)

 

Unique 8-Digit Identifier for Entire Company Provided by NORC To Employer

QuestionB2C

1 = Yes; 2 = No

Was An EEO-1 Report Filed for This Establishment Last year?

QuestionD2

1 = Yes; 2 = No

Is this Establishment:

(1) Not Exempt as Provided for by 41 CFR 60-1.5

(2) A Prime Contractor or First-Tier Subcontractor; And

(3) Have A Contract, Subcontract, Or Purchase Order Amounting to $50,000 or More; Or Serve as A Depository of Government Funds

In any Amount; Or Is A Financial Institution Which Is an Issuing and Paying Agents for U.S. Savings bonds And or Savings Notes?

Show Employee Info

Yes / No

If Show Employee Info = Yes. Report Will Show Employee’s EEO Details, Along with Listed Parameters & Report Fields.
If Show Employee Info = No. Report Will Only Show Listed Parameters & Report Fields.

Transaction Types

All Transaction Types Entered

Ex) Regular, OT, DT, Salary, Bonus, Equipment, etc.

Exclude DH Orders?

Yes / No

If Yes, Excludes Candidates Associated with Direct Hire Orders

Ignore Missing Info Errors?

Yes / No

If No, Report Will Not Generate and List Errors to be Corrected for Missing Data.
If Yes, Report Will Generate and Ignore Missing Data as Blank Fields.

 

 

Report Fields

Field Name

Description

Following fields are shown in report for Show Employee Info = Yes

Supplier Name Description

Supplier Name Listed from Admin Tools > Employer

Payee ID

Employee’s ID in System

Employee Name

Employee’s Full Name

Job Title

Job Title on which Employee has Worked on for Selected Date Range

EEO Category

EEO Job Categories Are as Follows:

Executive/Senior Level Officials and Managers
First/Mid-Level Officials and Managers
Professionals
Technicians
Sales Workers
Administrative Support Workers

Craft Workers

Operatives
Laborers & Helpers
Service Workers

Payee Gross

Employee’s Gross Pay (total gross wages for the year, not the dates passed in the parameters entered)

Pay Band Minimum

Employee’s Minimum Pay Band Amount

Pay Band Max

Employee’s Maximum Pay Band Amount

EEO Category ID

EEO Job Category IDs Are as Follows:
1: Executive/Senior Level Officials and Managers
2: First/Mid-Level Officials and Managers
3: Professionals
4: Technicians
5: Sales Workers
6: Administrative Support Workers

7: Craft Workers

8: Operatives
9: Laborers & Helpers
10: Service Workers

 

Race Gender Code

Race/Ethnicity/Gender Codes are as Follows:

A: Hispanic or Latino Males
B: Hispanic or Latino Females
C: White Males
D: Black or African American Males
E: Native Hawaiian or Other Pacific Islander Females
F: Asian Males
G: Native American or Alaska Native Males
H: Two or More Races Males
I: White Females
J: Black or African American Females
K: Native Hawaiian or Alaska Native Females
N: Two or More Races Females
Z: Not Applicable (Type 6 Report Only)

Pay Band Code

Pay Band Category Codes are as Follows:
1: $19,239 and under
2: $19,240 - $24,439
3: $24,440 - $30,679
4: $30,680 - $38,999
5: $39,000 - $49,919
6: $49,920 - $62,919
7: $62,920 - $80,079
8: $80,080 - $101,919
9: $101,920 - $128,959
10: $128,960 - $163,799
11: $163,800 - $207,999
12: $208,000 and over

Payee Hours

Employee Hours Worked For Year that is indicated in the date parameters

Race

Hispanic or Latino, Black or African American, Asian, White, Two or More Races, Native Hawaiian or Other Pacific Islander, American Indian or Alaska Native or I Do Not Wish to Answer

Gender

M = Males; F = Female; X = Non Binary

 

Following fields are shown in report for Show Employee Info = No

User ID

Unique 8-Digit Identifier for Entire Company Provided by NORC to Employer

Status Code

1 = Single Establishment Employer
2 = Consolidated Report
3 = Headquarters Report
4 = Individual Establishment Report (50+ Employees – Not First Time Reporting)
5 = Special Reporting Procedure
6 = Establishment List Report (Fewer Than 50 Employees)
8 = Individual Establishment Report (Fewer Than 50 Employees)
9 = Individual Establishment Report (50+ Employees – First Time Reporting)

Unit Number

Should Be Reported Except for New Status Code 6, 8 And All Status Code 9 Records

Unit Name

Supplier Short Name

Unit Address

Supplier Address

City

Supplier City Name

State

Supplier State Abbreviation

Zip Code

Supplier U.S. Postal Service Zip Code

County

Please note: Since there is no County Name in Supplier, this data will need to be added to the results when exported to Excel and prior to uploading to the EEOC. 

FEIN

Your Federal EIN (Tax ID) 9 Digits

NAICS Code

North American Industry Classification Listed from Admin Tools > Employer > Property > OSHA NAICS Code 6 Digits
Type 6 Report Use “999999”

Question B2C

Was An EEO-1 Report Filed for This Establishment Last year? 1 = Yes; 2 = No

 

Question D2

 

Is this Establishment:

(1) Not Exempt as Provided for by 41 CFR 60-1.5

(2) A Prime Contractor or First-Tier Subcontractor; And

(3) Have A Contract, Subcontract, Or Purchase Order Amounting to $50,000 or More; Or Serve as A Depository of Government Funds

In any Amount; Or Is A Financial Institution Which Is an Issuing and Paying Agents for U.S. Savings bonds And or Savings Notes?
1 = Yes; 2 = No

Job Category

Job Categories Are as Follows:

1: Executive/Senior Level Officials and Managers
2: First/Mid-Level Officials and Managers
3: Professionals
4: Technicians
5: Sales Workers
6: Administrative Support Workers

7: Craft Workers

8: Operatives
9: Laborers & Helpers
10: Service Workers
99: Not Applicable (Type 6 Report Only)

Race Ethnicity Gender

Race/Ethnicity/Gender Codes are as Follows:

A: Hispanic or Latino Males
B: Hispanic or Latino Females
C: White Males
D: Black or African American Males
E: Native Hawaiian or Other Pacific Islander Females
F: Asian Males
G: Native American or Alaska Native Males
H: Two or More Races Males
I: White Females
J: Black or African American Females
K: Native Hawaiian or Alaska Native Females
N: Two or More Races Females
Z: Not Applicable (Type 6 Report Only)

Annual Salary

Pay Band Category Codes are as Follows:

1: $19,239 and under
2: $19,240 - $24,439
3: $24,440 - $30,679
4: $30,680 - $38,999
5: $39,000 - $49,919
6: $49,920 - $62,919
7: $62,920 - $80,079
8: $80,080 - $101,919
9: $101,920 - $128,959
10: $128,960 - $163,799
11: $163,800 - $207,999
12: $208,000 and over
99: Total Employees (Type 6 Report Only)

Total Employees

Total Employees Per Category, No Negatives
Note: Filers Should not Report Rows where Number of Employees = 0

Total Hours

Total Hours per Category, No Negatives
Exception: Type 6 Report Which Will Report “-3”

 

 

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