RUN_CNTL_REG(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 | FROMDATE | Date(10) | DATE | From Date |
4 | THRUDATE | Date(10) | DATE | End Date |
5 | ASOFDATE | Date(10) | DATE | As of Date |
6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
7 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL | Calendar Year |
8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
9 | 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 |
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 | OUTPUT_CSV | Character(1) | VARCHAR2(1) NOT NULL |
Also ouput CSV File
Y/N Table Edit Default Value: N |
14 | INCLUDE_HEADERS | Character(1) | VARCHAR2(1) NOT NULL |
Include Column Headers
Y/N Table Edit Default Value: N |
15 | V100_CURRENT | Character(1) | VARCHAR2(1) NOT NULL |
Run for Current Information
Y/N Table Edit Default Value: Y |
16 | V100_HISTORY_YR | Character(4) | VARCHAR2(4) NOT NULL |
History Year to Run for
Prompt Table: V100_HISTPRMPT |
17 | TELEPHONE_NBR | Character(15) | VARCHAR2(15) NOT NULL | Telephone Number |
18 | EEO_REPORT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
EEO Report Run Type
GOVT=Govt. Report Run INFO=Informational Report Run Default Value: INFO |
19 | INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table: OSHA_301_INC_VW |
20 | DATE_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Run report using
1=As of Date 2=From/Thru Dates Default Value: 1 |
21 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: OSHA_301_PRMPT |
22 | PRINT_SUMMARY | Character(1) | VARCHAR2(1) NOT NULL |
A summary page is optional for the user. This is a checkbox to select whether or not a user needs the summary page.
Y/N Table Edit Default Value: N |
23 | V100_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VETS-100 Report Type
A=VETS-100A B=VETS-100 C=VETS-4212 Default Value: B |
24 | V100_HIST_RPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VETS-100 History Report Type
A=VETS-100A B=VETS-100 C=VETS-4212 |