Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EEOUNIT


                              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       The company number represents an
                       established company and is entered on
                       all function codes.

EEO-ESTBLSH-NBR        Alpha 9                                   PA93.1  PA93.2
EEO Establishment      This field contains the unit
Number                 establishment number.

EEO-UNIT-TYPE          Alpha 1                                   PA93.1  PA93.2
Element: EEO Unit Type This field contains the unit type.
                       E = Establishment
                       H = Headquarters
                       D = Default
                       " " = Employer ID

EEO-REPORT-TYPE        Alpha 1                                   PA93.1
Element: EEO Report TypThis 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: Address 1     This field contains the first line of
                       unit address information.

EEO-ADDR2              Alpha 30  (Lower Case)                    PA93.1  PA93.2
Element: Address 1     This field contains the second line of
                       unit address information.

EEO-ADDR3              Alpha 30  (Lower Case)                    PA93.1  PA93.2
Element: Address 1     Contains the third line of address
                       information.

EEO-ADDR4              Alpha 30  (Lower Case)                    PA93.1  PA93.2
Element: Address 1     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 or ProviThis field contains the state of the
                       unit address.

EEO-ZIP                Alpha 10                                  PA93.1  PA93.2
Element: Postal Code   This field contains the postal code of
                       the unit address.

EEO-DEFAULT-NBR        Alpha 9
Default                This field contains the default
Establishment Number   establishment number.

EEO-COMP-PRE           Alpha 6                                   PA93.1  PA93.2
EEO Company Number     This field contains the EEO prefix of
- Prefix               the company.

EEO-COMP-SUF           Alpha 1                                   PA93.1  PA93.2
EEO Company Number     This field contains the EEO suffix of
- Suffix               the unit.

EEO-UNIT-PRE           Alpha 6                                   PA93.1  PA93.2
EEO Unit Number -      This field contains the EEO prefix of
Prefix                 the unit.

EEO-UNIT-SUF           Alpha 1                                   PA93.1  PA93.2
EEO Unit Number -      Unit EEO suffix.
Suffix

EEO-SIC-NUMBER         Alpha 6                                   PA93.1  PA93.2
Element: EEO SIC NumberThis field contains the SIC (Standard
                       Industry Code) number assigned by the
                       government for the unit.

EEO-DUNS-1             Alpha 2                                   PA93.1  PA93.2
Dun & Bradstreet       This field contains the first Dun &
Number (1)             Bradstreet number of the unit.

EEO-DUNS-2             Alpha 3                                   PA93.1  PA93.2
Dun & Bradstreet       This field contains the second Dun &
Number (2)             Bradstreet number of the unit.

EEO-DUNS-3             Alpha 4                                   PA93.1  PA93.2
Dun & Bradstreet       This field contains the third Dun &
Number (3)             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
Non-Hispanic White     This field contains the total number of
Males                  white  males.

EEO-MALE-B             Numeric 5                                 PA390
Element: Black Males   This field contains the total number of
                       black males.

EEO-MALE-HI            Numeric 5                                 PA390
Element: Hispanic MalesThis field contains the total number of
                       Hispanic males.

EEO-MALE-AS            Numeric 5                                 PA390
Asian/Pacific          This field contains the total number of
Islander Males         Asian males.

EEO-MALE-AN            Numeric 5                                 PA390
American Native        This field contains the number of
Males                  American Indian males.

EEO-FEMALE-WH          Numeric 5                                 PA390
Non-Hispanic White     This field contains the total number of
Females                white females.

EEO-FEMALE-B           Numeric 5                                 PA390
Element: Black Females This field contains the total number of
                       black females.

EEO-FEMALE-HI          Numeric 5                                 PA390
Element: Hispanic FemalThis field contains the total number of
                       Hispanic females.

EEO-FEMALE-AS          Numeric 5                                 PA390
Asian/Pacific          This field contains the total number of
Islander Females       Asian females.

EEO-FEMALE-AN          Numeric 5                                 PA390
American Native        This field contains the total number of
Females                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.

                         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

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