ESTAB_TBL

(SQL Table)
 Index Back

Establishment Codes

U.S. only. Use ESTAB_TBL to record company data needed to produce an EEO-1 employer information report, if required, to meet U.S. government equal employment opportunity reporting requirements. PeopleSoft's standard report PER016 is the EEO-1 report. You should create a separate record for each 'establishment' in your company. You must designate one establishment as the 'headquarters unit'.

  • Related Language Record: ESTAB_TBL_LANG

  • Parent Record Of ESTAB_US_SBR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 HQUNIT Character(1) VARCHAR2(1) NOT NULL Headquarters Unit

    Y/N Table Edit

    Default Value: N

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description
    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    12 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    13 CITY Character(30) VARCHAR2(30) NOT NULL City
    14 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    15 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    16 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    17 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    18 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    19 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    20 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    21 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    22 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    23 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    24 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    25 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    26 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    27 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    28 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
    29 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    30 CTL_ESTABID Character(12) VARCHAR2(12) NOT NULL Controlling Establishment ID
    31 EMPLOY_APPR Character(1) VARCHAR2(1) NOT NULL Employ Apprentices
    32 SAME_BUSINESS Character(1) VARCHAR2(1) NOT NULL Major business activity same
    3=No report last year
    N=No
    Y=Yes

    Default Value: Y

    33 SAME_LOCATION Character(1) VARCHAR2(1) NOT NULL Location same as last year
    3=No report last year
    N=No
    Y=Yes

    Default Value: Y

    34 BUS_ACTIVITY_LINE1 Character(40) VARCHAR2(40) NOT NULL Business Activity
    35 BUS_ACTIVITY_LINE2 Character(40) VARCHAR2(40) NOT NULL Business Activity
    36 BUS_ACTIVITY_LINE3 Character(40) VARCHAR2(40) NOT NULL Business Activity
    37 BUS_ACTIVITY_LINE4 Character(40) VARCHAR2(40) NOT NULL Business Activity
    38 EEO_UNIT_NBR Character(7) VARCHAR2(7) NOT NULL EEO Unit Number
    39 NAICS Character(6) VARCHAR2(6) NOT NULL North Amer Ind Class Sys
    40 SIC Character(4) VARCHAR2(4) NOT NULL Standard Industrial Classif
    41 EEO_RPT_PREV_YR Character(1) VARCHAR2(1) NOT NULL EEO-1 Filed Previous Year

    Default Value: N

    42 EEO_MIN_100 Character(1) VARCHAR2(1) NOT NULL EEO-1 Minimum 100 Employees
    43 EEO_CO_AFFILIATED Character(1) VARCHAR2(1) NOT NULL EEO-1 Company Affiliated
    44 EEO_GOV_CONTRACTOR Character(1) VARCHAR2(1) NOT NULL EEO-1 Gov't Contractor Type
    B=Both Prime & Sub Contractor
    N=Not Applicable
    P=EEO Prime Contractor
    S=EEO Subcontractor

    Default Value: N

    45 DUN_BRADSTREET_NBR Character(9) VARCHAR2(9) NOT NULL Dun and Bradstreet Number
    46 VETS_100_UNIT_NBR Character(7) VARCHAR2(7) NOT NULL Vets 100 Unit Number
    47 SIREN_CD_FRA Character(9) VARCHAR2(9) NOT NULL SIREN Code

    Default Value: COMPANY_TBL.SIREN_CD_FRA

    48 NIC_CODE_FRA Character(5) VARCHAR2(5) NOT NULL NIC Code
    49 APE_INDSTRY_CD_FRA Character(4) VARCHAR2(4) NOT NULL APE Code
    50 URSSAF_CD_FRA Character(4) VARCHAR2(4) NOT NULL URSSAF Code (FRA)
    51 URSSAF_NM_FRA Character(20) VARCHAR2(20) NOT NULL URSSAF #
    52 ASSEDIC_NM_FRA Character(20) VARCHAR2(20) NOT NULL ASSEDIC #
    53 ANNUAL_REPORT_FRA Character(1) VARCHAR2(1) NOT NULL Annual Report Declaration

    Y/N Table Edit

    Default Value: Y

    54 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Default Value: COMPANY_TBL.LABOR_AGREEMENT

    Prompt Table: EMPL_CTG
    Set Control Field: REG_REGION

    55 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    56 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
    57 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account #
    58 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    59 CRAM_ID Character(4) VARCHAR2(4) NOT NULL CRAM Fund ID
    60 TDS_DECLARED Character(1) VARCHAR2(1) NOT NULL TDS Declared Establishment

    Y/N Table Edit

    Default Value: Y

    61 TDS_ESTABID Character(5) VARCHAR2(5) NOT NULL Declared Establishment
    62 TRANSPORT_RT Number(19,6) DECIMAL(18,6) NOT NULL Transport Rate
    63 BASE_SCHEME_FRA Character(3) VARCHAR2(3) NOT NULL Mandatory Base Scheme
    64 LIABILITY_TAX_FRA Character(2) VARCHAR2(2) NOT NULL Tax on Salary Liability - FRA
    01=Yes
    02=No
    65 ESTAB_ACTIVITY_FRA Character(36) VARCHAR2(36) NOT NULL Establishment Activity
    66 MEDICAL_ORG_FRA_CD Character(3) VARCHAR2(3) NOT NULL Medical Organism Code - FRA

    Prompt Table: MED_ORG_FRA_TBL

    67 ESTAB_CONTACT_ID Character(11) VARCHAR2(11) NOT NULL Establishment Contact ID: this employee ID is the contact for his establishment.
    68 FONGECIF_CD_FRA Character(6) VARCHAR2(6) NOT NULL FONGECIF Code

    Prompt Table: TRN2483_VDRFFVW

    69 GPFR_DA_CLS_DT Date(10) DATE Establishment Close date
    70 CLOSE_DT_FRA Date(10) DATE Establishment Close date
    71 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    72 INSUR_COMP_CD_ESP Character(5) VARCHAR2(5) NOT NULL Insurance Company Code

    Prompt Table: INSUR_COMP_ESP

    73 WAGE_ZONE_MEX Character(4) VARCHAR2(4) NOT NULL Wage Zone for Mexico
    10=A Economic Zone
    20=B Economic Zone
    30=C Economic Zone
    74 IMS_RISK_FCT_MEX Number(9,7) DECIMAL(8,7) NOT NULL Risk factor for IMSS Location Table Mexico
    75 IMS_ZONE_MEX Character(4) VARCHAR2(4) NOT NULL Wage Zone for IMSS Location Table Mexico
    76 IMS_SUBZONE_MEX Character(4) VARCHAR2(4) NOT NULL Subzone for IMSS Location Table Mexico
    77 IMS_SECTOR_MEX Number(5,0) INTEGER NOT NULL IMSS Sector IMSS Location Table Mexico
    78 BUILDING_MEX Character(10) VARCHAR2(10) NOT NULL Building for IMSS Location Table Mexico
    79 GUIDE_NBR_MEX Character(6) VARCHAR2(6) NOT NULL GUIDE FOR IMSS Location Table Mexico