ESTAB_TBL_USA(SQL Table) |
Index Back |
|---|---|
Establishments Record - USAEstablishments Record - USA |
| # | 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 | CERTIF_OFFICIAL | Character(11) | VARCHAR2(11) NOT NULL |
Certifying Official for EEO Reporting
Prompt Table: PERS_SRCH_GBL |
| 4 | COPY_HQ_VALUES | Character(1) | VARCHAR2(1) NOT NULL |
Field used for U.S. EEO Reporting. Indicator used to determine if the application should use the Certifying Official values from the HQ Unit.
Y/N Table Edit Default Value: N |
| 5 | CTL_ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Controlling Establishment ID
Prompt Table: ESTAB_HQ_VW |
| 6 | EMPLOY_APPR | Character(1) | VARCHAR2(1) NOT NULL | Employ Apprentices |
| 7 | SAME_BUSINESS | Character(1) | VARCHAR2(1) NOT NULL |
Major business activity same
3=No report last year N=No Y=Yes Default Value: Y |
| 8 | 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 |
| 9 | BUS_ACTIVITY_LINE1 | Character(40) | VARCHAR2(40) NOT NULL | Business Activity |
| 10 | BUS_ACTIVITY_LINE2 | Character(40) | VARCHAR2(40) NOT NULL | Business Activity |
| 11 | BUS_ACTIVITY_LINE3 | Character(40) | VARCHAR2(40) NOT NULL | Business Activity |
| 12 | BUS_ACTIVITY_LINE4 | Character(40) | VARCHAR2(40) NOT NULL | Business Activity |
| 13 | EEO_UNIT_NBR | Character(7) | VARCHAR2(7) NOT NULL | EEO Unit Number |
| 14 | NAICS | Character(6) | VARCHAR2(6) NOT NULL | North Amer Ind Class Sys |
| 15 | SIC | Character(4) | VARCHAR2(4) NOT NULL | Standard Industrial Classif |
| 16 | EEO_RPT_PREV_YR | Character(1) | VARCHAR2(1) NOT NULL |
EEO-1 Filed Previous Year
Default Value: N |
| 17 | EEO_MIN_100 | Character(1) | VARCHAR2(1) NOT NULL | EEO-1 Minimum 100 Employees |
| 18 | EEO_CO_AFFILIATED | Character(1) | VARCHAR2(1) NOT NULL | EEO-1 Company Affiliated |
| 19 | 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 |
| 20 | DUN_BRADSTREET_NBR | Character(9) | VARCHAR2(9) NOT NULL | Dun and Bradstreet Number |
| 21 | VETS_100_UNIT_NBR | Character(7) | VARCHAR2(7) NOT NULL | Vets 100 Unit Number |