EEOUNIT

EEO Establishment

The EEO Establishment file maintains the headquarters and any establishment records for EEO as defined in PA93.1 (EEO-1 Company).
UPDATED BY
PA390 PA392 PA393 PA93.1 PA93.2 PA93.5
PA93.6

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EEO-COMPANY
Element: Company Hr		Numeric 4
PA93.1 PA93.2
PA93.5 PA93.6
EEO-ESTBLSH-NBR
Element: Estblsh Nbr		Alpha 9
This field contains the unit establishment number.
PA93.1 PA93.2
PA93.5 PA93.6
EEO-UNIT-TYPE
Element: Unit Type		Alpha 1
This field contains the unit type.
E = Establishment
H = Headquarters
D = Default
" " = Employer ID
PA93.1 PA93.2
PA93.5 PA93.6
EEO-REPORT-TYPE
Element: Report Type		Alpha 1
This field contains the EEO-1 report type indicator.
M = Multi-establishment
S = Single Establishment
PA93.1 PA93.5
EEO-NAME
Element: Name		Alpha 30 (Lower Case)
This field contains the establishment name.
PA93.1 PA93.2
PA93.5 PA93.6
EEO-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of unit address information.
PA93.1 PA93.2
PA93.5 PA93.6
EEO-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the second line of unit address information.
PA93.1 PA93.2
PA93.5 PA93.6
EEO-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
Contains the third line of address information.
EEO-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
Contains the fourth line of address information.
EEO-CITY
Element: City		Alpha 18 (Lower Case)
This field contains the city of the unit address.
PA93.1 PA93.2
PA93.5 PA93.6
EEO-STATE
Element: State		Alpha 2
This field contains the state of the unit address.
PA93.1 PA93.2
PA93.5 PA93.6
EEO-ZIP
Element: Zip		Alpha 10
This field contains the postal code of the unit address.
PA93.1 PA93.2
PA93.5 PA93.6
EEO-DEFAULT-NBR
Element: Default Nbr		Alpha 9
This field contains the default establishment number.
EEO-COMP-PRE
Element: Comp Pre		Alpha 6
This field contains the EEO prefix of the company.
PA93.1 PA93.2
EEO-COMP-SUF
Element: Comp Suf		Alpha 1
This field contains the EEO suffix of the unit.
PA93.1 PA93.2
EEO-UNIT-PRE
Element: Unit Pre		Alpha 6
This field contains the EEO prefix of the unit.
PA93.1 PA93.2
EEO-UNIT-SUF
Element: Unit Suf		Alpha 1
Unit EEO suffix.
PA93.1 PA93.2
EEO-SIC-NUMBER
Element: Sic Number		Alpha 6
This field contains the SIC (Standard Industry Code) number assigned by the government for the unit.
PA93.1 PA93.2
EEO-DUNS-1
Element: Duns 1		Alpha 2
This field contains the first Dun & Bradstreet number of the unit.
PA93.1 PA93.2
EEO-DUNS-2
Element: Duns 2		Alpha 3
This field contains the second Dun & Bradstreet number of the unit.
PA93.1 PA93.2
EEO-DUNS-3
Element: Duns 3		Alpha 4
This field contains the third Dun & Bradstreet number of the unit.
PA93.1 PA93.2
EEO-REPORT-DATE
Element: Report Date		Numeric 8 (yyyymmdd)
This field contains the date when EEO-1 report totals were last updated.
PA390
EEO-TOT-EMP
Element: Tot Emp		Numeric 7
This field contains the total number of employees.
PA390
EEO-MALE-WH
Element: Male Wh		Numeric 5
This field contains the total number of white males.
PA390
EEO-MALE-B
Element: Male B		Numeric 5
This field contains the total number of black males.
PA390
EEO-MALE-HI
Element: Male Hi		Numeric 5
This field contains the total number of Hispanic males.
PA390
EEO-MALE-AS
Element: Male As		Numeric 5
This field contains the total number of Asian males.
PA390
EEO-MALE-AN
Element: Male An		Numeric 5
This field contains the number of American Indian males.
PA390
EEO-FEMALE-WH
Element: Female Wh		Numeric 5
This field contains the total number of white females.
PA390
EEO-FEMALE-B
Element: Female B		Numeric 5
This field contains the total number of black females.
PA390
EEO-FEMALE-HI
Element: Female Hi		Numeric 5
This field contains the total number of Hispanic females.
PA390
EEO-FEMALE-AS
Element: Female As		Numeric 5
This field contains the total number of Asian females.
PA390
EEO-FEMALE-AN
Element: Female An		Numeric 5
This field contains the total number of American Indian females.
PA390
EEO-EIN
Element: Ein		Numeric 9
EIN (Employer Identification Number) for IRS on EEO-1 reports.
PA93.1 PA93.2
EEO-VETS
Element: Vets		Alpha 20
Contains the VETS 100 number.
PA93.1 PA93.2
EEO-B2C
Element: B2c		Alpha 1
Box number B2C - "Was an EEO-1 report filed for this establishment last year?"
N = No
Y = Yes
PA93.1 PA93.2
EEO-C1
Element: C1		Alpha 1
Box C1 - "Does the entire company have at least 100 employees in the payroll period for which you are reporting?"
N = No
Y = Yes
PA93.1 PA93.2
EEO-C2
Element: C2		Alpha 1
Box C2 - "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?"
N = No
Y = Yes
PA93.1 PA93.2
EEO-C3
Element: C3		Alpha 1
Box C3 - "Does the company or any of its establishment (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 subcontractor, 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?"
N = No
Y = Yes
PA93.1 PA93.2
EEO-D2
Element: D2		Alpha 1
Box D2 - "Does the establishment employ apprentices?"
N = No
Y = Yes
PA93.1 PA93.2
EEO-E1-1
Element: E1 1		Alpha 42 (Lower Case)
Box E1 Line 1 - "What is the major activity of this establishment?"
PA93.1 PA93.2
EEO-E1-2
Element: E1 2		Alpha 42 (Lower Case)
Box E1 Line 2
PA93.1 PA93.2
EEO-E1-3
Element: E1 3		Alpha 42 (Lower Case)
Box E1 Line 3
PA93.1 PA93.2
EEO-E1-4
Element: E1 4		Alpha 42 (Lower Case)
Box E1 Line 4
PA93.1 PA93.2
EEO-COUNTRY-CODE
Element: Country Code		Alpha 2
Contains the country for the establishment.
EEO-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
PA93.1 PA93.2
PA93.5 PA93.6
EEO-NAICS
Element: Naics		Alpha 6
PA93.1 PA93.2
EEO-CERT-OFF
Element: Cert Off		Numeric 9
PA93.2
EEO-CONTACT-TYPE
Element: Contact Type		Alpha 10
PA93.2
EEO-MALE-HP
Element: Male Hp		Numeric 5
PA390
EEO-MALE-TR
Element: Male Tr		Numeric 5
PA390
EEO-FEMALE-HP
Element: Female Hp		Numeric 5
PA390
EEO-FEMALE-TR
Element: Female Tr		Numeric 5
PA390


EEOUNIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EEOSET1 COMPANY
ESTBLSH-NBR
PA390 PA392
PA393 PA93.1
PA93.2 PA93.4
PA93.5 PA93.6
EEOSET2 COMPANY
UNIT-TYPE
ESTBLSH-NBR
KeyChange
PA390 PA392
PA393 PA93.1
PA93.2 PA93.5
PA93.6


EEOUNIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
EEO-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Contact Type PCODES Required
When EEO-CONTACT-TYPE !=Spaces
"NT"->PCO-TYPE
EEO-CONTACT-TYPE->PCO-CODE
Country INSTCTRYCD Required
When (EEO-COUNTRY-CODE !=Spaces )
EEO-COUNTRY-CODE->INT-COUNTRY-CODE


EEOUNIT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Eeo Detail EEODETAIL Delete Restricted
EEO-COMPANY->EOD-COMPANY
EEO-ESTBLSH-NBR->EOD-ESTBLSH-NBR
  EOD-PROCESS-LEVEL
  EOD-DEPARTMENT
  EOD-LOCAT-CODE

File created: Thu Jun 09 11:22:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.