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