HR_EEO1_C2_RUN(SQL Table) |
Index Back |
|---|---|
US Run Control RegulatoryThis is the run control record to be used for all new or revised regulatory or compliance reports. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL |
Calendar Year
Prompt Table: HR_EEO1_CONFIG |
| 5 | FROMDATE | Date(10) | DATE | From Date |
| 6 | THRUDATE | Date(10) | DATE | End Date |
| 7 | RUN_SCOPE | Character(1) | VARCHAR2(1) NOT NULL |
Regulatory Report Scope
1=Establishments in Company 2=Single Establishment 3=HQ & Controlled Establishments 4=All Establishments Default Value: 1 |
| 8 | HR_EEO1_RUN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
EEO2 Component 2 Run Type
L=Load Data for Review R=Generate Report |
| 9 | HR_EEO1_RPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
EEO2 Component 2 Run Type
6=Establishment List Report 8=Individual Establishment Repor |
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 11 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 12 | CTL_ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Controlling Establishment ID
Prompt Table: ESTAB_HQ_VW |
| 13 | HR_EEO1_TYPE1 | Character(1) | VARCHAR2(1) NOT NULL | EEO1 Type1 Report |
| 14 | HR_EEO1_TYPE2 | Character(1) | VARCHAR2(1) NOT NULL | EEO1 Type 2 Report |
| 15 | HR_EEO1_TYPE3 | Character(1) | VARCHAR2(1) NOT NULL | EEO1 Type 3 Report |
| 16 | HR_EEO1_TYPE4 | Character(1) | VARCHAR2(1) NOT NULL | EEO1 Type 4 Report |
| 17 | HR_EEO1_TYPE5 | Character(1) | VARCHAR2(1) NOT NULL | EEO1 Type 5 Report |
| 18 | HR_EEO1_TYPE6 | Character(1) | VARCHAR2(1) NOT NULL | EEO1 Type 6 Report |
| 19 | HR_EEO1_TYPE8 | Character(1) | VARCHAR2(1) NOT NULL | EEO1 Type 8 Report |
| 20 | HR_EEO1_TYPE9 | Character(1) | VARCHAR2(1) NOT NULL | EEO1 Type 9 Report |
| 21 | HR_EEO1_CAL_BGN_DT | Date(10) | DATE | EEO1 Calendar End Date |
| 22 | HR_EEO1_CAL_END_DT | Date(10) | DATE | EEO1 Calendar End Date |