Skip to content

Print   Email  Share

2017 EEO-1 Survey
Data File Layout Components 1 and 2

(Download as an Excel file)

FIELD FIELD NAME POSITIONS LNGTH FIELD TYPE POSSIBLE VALUES & REMARKS
1 COMPANY NUMBER 1 - 7 7 AN UNIQUE IDENTIFIER FOR ENTIRE COMPANY (REQUIRED)
2 STATUS CODE 8 1 N INDICATES TYPE OF REPORT AS INDICATED IN PART A OF SF 100:
1 = SINGLE-ESTAB EMPLOYER MULTI-ESTAB COMPANIES:
2 = CONSOLIDATED REPORT
3 = HEADQUARTERS REPORT
4 = ESTABLISHMENT REPORT (50+ EMPLOYEES - NOT FIRST TIME REPORTING)
5 = SPECIAL REPORTING PROCEDURE
8 = STATUS CODE 8 REPORT (LESS THAN 50 EMPLOYEES)
9 = STATUS CODE 9 REPORT (FEWER THAN 50 EMPLOYEES - FIRST TIME REPORTING)
(REQUIRED)
3 UNIT NUMBER 9 - 15 7 AN REQUIRED EXCEPT FOR NEW STATUS CODE 8 AND ALL STATUS CODE 9 RECORDS
4 UNIT NAME 16 - 50 35 AN ESTABLISHMENT NAME (REQUIRED)
5 UNIT ADDRESS 51 - 84 34 AN ESTABLISHMENT ADDRESS (REQUIRED)
6 UNIT ADDRESS-2 85 - 109 25 AN EXTENDED ESTABLISHMENT ADDRESS TO INCLUDE SUITE NO., PO BOX, ETC. (OPTIONAL)
7 CITY NAME 110 - 129 20 A CITY NAME (REQUIRED)
8 STATE ABBREVIATION 130 - 131 2 A FIPS PUB 5-2(CENSUS) (REQUIRED)
9 ZIP CODE 132 - 136 5 N U.S. POSTAL SERVICE (REQUIRED)
10 QUESTION B.2.C 137 1 N WAS AN EEO-1 REPORT FILED FOR THIS ESTABLISHMENT LAST YEAR? 1=YES; 2=NO (REQUIRED)
11 QUESTION C.1 138 1 N DOES THE ENTIRE COMPANY HAVE AT LEAST 100 EMPLOYEES IN THE PAYROLL PERIOD FOR WHICH YOU ARE REPORTING? 1=YES; 2=NO (REQUIRED)
12 QUESTION C.2 139 1 N IS YOUR COMPANY AFFILIATED THROUGH COMMON OWNERSHIP AND/OR CENTRALIZED MANAGEMENT WITH OTHER ENTITIES IN AN ENTERPRISE WITH A TOTAL EMPLOYMENT OF 100 OR MORE? 1=YES; 2=NO (REQUIRED)
13 QUESTION C.3 140 1 N DOES THE COMPANY OR ANY OF ITS ESTABLISHMENTS (A) HAVE 50 OR MORE EMPLOYEES AND (B) IS NOT EXEMPT AS PROVIDED BY 41 CFR 60-1.5, AND EITHER (1) IS A PRIME GOVERNMENT CONTRACTOR OR FIRST-TIER SUBCONTACTOR, AND HAS A CONTRACT, SUBCONTRACT, OR PURCHASE ORDER AMOUNTING TO $50,000 OR MORE, OR (2) SERVES AS A DEPOSITORY OF GOVERNMENT FUNDS IN ANY AMOUNT OR IS A FINANCIAL INSTITUTION WHICH IS AN ISSUING AND PAYING AGENT FOR U.S. SAVINGS BONDS AND SAVINGS NOTES? 1=YES; 2=NO (REQUIRED)
14 DUN AND BRADSTREET IDENTIFICATION NUMBER 141 - 149 9 N IF THE RESPONSE TO QUESTION C.3 IS YES, PLEASE ENTER YOUR DUN AND BRADSTREET IDENTIFICATION NUMBER (REQUIRED IF AVAILABLE)
15 COUNTY NAME 150 - 167 18 A FIPS PUB 6-4 (CENSUS) (REQUIRED)
16 QUESTION D.1 168 - 183 16 N YEAR USED FOR COMPENSATION AND HOURS DATA: MMDDYYYYMMDDYYYY. TIME FRAME MUST BE FOR ONE YEAR ENDING IN THE SURVEY YEAR (REQUIRED)
17 NAICS CODE 184 - 189 6 N USE NAICS CODES FROM www.eeoc.gov/eeo1survey (REQUIRED)
18 TITLE OF CERTIFYING OFFICIAL 190 - 224 35 A (REQUIRED)
19 NAME OF CERTIFYING OFFICIAL 225 - 259 35 A (REQUIRED)
20 TELEPHONE NUMBER 260 - 269 10 N INCLUDE AREA CODE (REQUIRED)
21 EMAIL ADDRESS OF CERTIFYING OFFICIAL 270 - 309 40 AN REQUIRED IF AVAILABLE
22 MATRIX DATA NUMBER OF EMPLOYEES 310 - 11320 11011 N 121 LINES - 91 POSITIONS EACH
JOB CATEGORY 1.1 LINES 1-12 310 - 1401 1092 EXECUTIVE/SENIOR LEVEL OFFICIALS AND MANAGERS (Line No. 1.1, Section D, on EEO-1 Form)
JOB CATEGORY 1.1 LINE 1 310 - 400 91 $19,239 and under
COLUMN A 310 - 315 6 HISPANIC or LATINO MALES
COLUMN B 316 - 321 6 HISPANIC or LATINO FEMALES
COLUMN C 322 - 327 6 WHITE MALES
COLUMN D 328 - 333 6 BLACK or AFRICAN AMERICAN MALES
COLUMN E 334 - 339 6 NATIVE HAWAIIAN or OTHER PACIFIC ISLANDER MALES
COLUMN F 340 - 345 6 ASIAN MALES
COLUMN G 346 - 351 6 NATIVE AMERICAN or ALASKA NATIVE MALES
COLUMN H 352 - 357 6 TWO or MORE RACES MALES
COLUMN I 358 - 363 6 WHITE FEMALES
COLUMN J 364 - 369 6 BLACK or AFRICAN AMERICAN FEMALES
COLUMN K 370 - 375 6 NATIVE HAWAIIAN or OTHER PACIFIC ISLANDER FEMALES
COLUMN L 376 - 381 6 ASIAN FEMALES
COLUMN M 382 - 387 6 NATIVE AMERICAN or ALASKA NATIVE FEMALES
COLUMN N 388 - 393 6 TWO or MORE RACES FEMALES
COLUMN O 394 - 400 7 TOTAL MALE AND FEMALE
JOB CATEGORY 1.1 LINE 2 401 - 491 91 $19,240 - $24,439
JOB CATEGORY 1.1 LINE 3 492 - 582 91 $24,440 - $30,679
JOB CATEGORY 1.1 LINE 4 583 - 673 91 $30,680 - $38,999
JOB CATEGORY 1.1 LINE 5 674 - 764 91 $39,000 - $49,919
JOB CATEGORY 1.1 LINE 6 765 - 855 91 $49,920 - $62,919
JOB CATEGORY 1.1 LINE 7 856 - 946 91 $62,920 - $80,079
JOB CATEGORY 1.1 LINE 8 947 - 1037 91 $80,080 - $101,919
JOB CATEGORY 1.1 LINE 9 1038 - 1128 91 $101,920 - $128,959
JOB CATEGORY 1.1 LINE 10 1129 - 1219 91 $128,960 - $163,799
JOB CATEGORY 1.1 LINE 11 1220 - 1310 91 $163,800 - $207,999
JOB CATEGORY 1.1 LINE 12 1311 - 1401 91 $208,000 and over
JOB CATEGORY 1.2 LINES 13-24 1402 - 2493 1092 FIRST/MID-LEVEL OFFICIALS AND MANAGERS (Line No. 1.2 , Section D, on EEO-1 Form)
JOB CATEGORY 2 LINES 25-36 2494 - 3585 1092 PROFESSIONALS
JOB CATEGORY 3 LINES 37-48 3586 - 4677 1092 TECHNICIANS
JOB CATEGORY 4 LINES 49-60 4678 - 5769 1092 SALES WORKERS
JOB CATEGORY 5 LINES 61-72 5770 - 6861 1092 ADMINISTRATIVE SUPPORT WORKERS
JOB CATEGORY 6 LINES 73-84 6862 - 7953 1092 CRAFT WORKERS
JOB CATEGORY 7 LINES 85-96 7954 - 9045 1092 OPERATIVES
JOB CATEGORY 8 LINES 97-108 9046 - 10137 1092 LABORERS AND HELPERS
JOB CATEGORY 9 LINES 109-120 10138 - 11229 1092 SERVICE WORKERS
LINE 121 11230 - 11320 91 TOTAL EMPLOYEES FOR JOB CATEGORIES 1 THRU 10 (1.1 THRU 9 ON EEO-1 FORM)
23 MATRIX DATA NUMBER OF HOURS 11321 - 27925 16605 N 120 LINES - 137 POSITIONS EACH 121st LINE - 165 POSITIONS
JOB CATEGORY 1.1 LINES 1-12 11321 - 12964 1644 EXECUTIVE/SENIOR LEVEL OFFICIALS AND MANAGERS (Line No. 1.1, Section D, on EEO-1 Form)
JOB CATEGORY 1.1 LINE 1 11321 - 11457 137 $19,239 and under
COLUMN A 11321 - 11329 9 HISPANIC or LATINO MALES
COLUMN B 11330 - 11338 9 HISPANIC or LATINO FEMALES
COLUMN C 11339 - 11347 9 WHITE MALES
COLUMN D 11348 - 11356 9 BLACK or AFRICAN AMERICAN MALES
COLUMN E 11357 - 11365 9 NATIVE HAWAIIAN or OTHER PACIFIC ISLANDER MALES
COLUMN F 11366 - 11374 9 ASIAN MALES
COLUMN G 11375 - 11383 9 NATIVE AMERICAN or ALASKA NATIVE MALES
COLUMN H 11384 - 11392 9 TWO or MORE RACES MALES
COLUMN I 11393 - 11401 9 WHITE FEMALES
COLUMN J 11402 - 11410 9 BLACK or AFRICAN AMERICAN FEMALES
COLUMN K 11411 - 11419 9 NATIVE HAWAIIAN or OTHER PACIFIC ISLANDER FEMALES
COLUMN L 11420 - 11428 9 ASIAN FEMALES
COLUMN M 11429 - 11437 9 NATIVE AMERICAN or ALASKA NATIVE FEMALES
COLUMN N 11438 - 11446 9 TWO or MORE RACES FEMALES
COLUMN O 11447 - 11457 11 TOTAL MALE AND FEMALE
JOB CATEGORY 1.1 LINE 2 11458 - 11594 137 $19,240 - $24,439
JOB CATEGORY 1.1 LINE 3 11595 - 11731 137 $24,440 - $30,679
JOB CATEGORY 1.1 LINE 4 11732 - 11868 137 $30,680 - $38,999
JOB CATEGORY 1.1 LINE 5 11869 - 12005 137 $39,000 - $49,919
JOB CATEGORY 1.1 LINE 6 12006 - 12142 137 $49,920 - $62,919
JOB CATEGORY 1.1 LINE 7 12143 - 12279 137 $62,920 - $80,079
JOB CATEGORY 1.1 LINE 8 12280 - 12416 137 $80,080 - $101,919
JOB CATEGORY 1.1 LINE 9 12417 - 12553 137 $101,920 - $128,959
JOB CATEGORY 1.1 LINE 10 12554 - 12690 137 $128,960 - $163,799
JOB CATEGORY 1.1 LINE 11 12691 - 12827 137 $163,800 - $207,999
JOB CATEGORY 1.1 LINE 12 12828 - 12964 137 $208,000 and over
JOB CATEGORY 1.2 LINES 13-24 12965 - 14608 1644 FIRST/MID-LEVEL OFFICIALS AND MANAGERS (Line No. 1.2 , Section D, on EEO-1 Form)
JOB CATEGORY 2 LINES 25-36 14609 - 16252 1644 PROFESSIONALS
JOB CATEGORY 3 LINES 37-48 16253 - 17896 1644 TECHNICIANS
JOB CATEGORY 4 LINES 49-60 17897 - 19540 1644 SALES WORKERS
JOB CATEGORY 5 LINES 61-72 19541 - 21184 1644 ADMINISTRATIVE SUPPORT WORKERS
JOB CATEGORY 6 LINES 73-84 21185 - 22828 1644 CRAFT WORKERS
JOB CATEGORY 7 LINES 85-96 22829 - 24472 1644 OPERATIVES
JOB CATEGORY 8 LINES 97-108 24473 - 26116 1644 LABORERS AND HELPERS
JOB CATEGORY 9 LINES 109-120 26117 - 27760 1644 SERVICE WORKERS
LINE 121 27761 - 27925 165 TOTAL HOURS FOR JOB CATEGORIES 1 THRU 10 (1.1 THRU 9 ON EEO-1 FORM)
COLUMN A 27761 - 27771 11 TOTAL HISPANIC or LATINO MALES
COLUMN B 27772 - 27782 11 TOTAL HISPANIC or LATINO FEMALES
COLUMN C 27783 - 27793 11 TOTAL WHITE MALES
COLUMN D 27794 - 27804 11 TOTAL BLACK or AFRICAN AMERICAN MALES
COLUMN E 27805 - 27815 11 TOTAL NATIVE HAWAIIAN or OTHER PACIFIC ISLANDER MALES
COLUMN F 27816 - 27826 11 TOTAL ASIAN MALES
COLUMN G 27827 - 27837 11 TOTAL AMERICAN INDIAN or ALASKAN NATIVE MALES
COLUMN H 27838 - 27848 11 TOTAL TWO or MORE RACES MALES
COLUMN I 27849 - 27859 11 TOTAL WHITE FEMALES
COLUMN J 27860 - 27870 11 TOTAL BLACK or AFRICAN AMERICAN FEMALES
COLUMN K 27871 - 27881 11 TOTAL NATIVE HAWAIIAN or OTHER PACIFIC ISLANDER FEMALES
COLUMN L 27882 - 27892 11 TOTAL ASIAN FEMALES
COLUMN M 27893 - 27903 11 TOTAL AMERICAN INDIAN or ALASKAN NATIVE FEMALES
COLUMN N 27904 - 27914 11 TOTAL TWO or MORE RACES FEMALES
COLUMN O 27915 - 27925 11 TOTAL MALE AND FEMALE
24 EIN 27926 - 27934 9 N YOUR FEDERAL EIN (TAX ID) 9 DIGITS