OPRIDRUN_CNTL_IDPrompt Table: SP_BU_FS_NONVW
Default Value: %date
Default Value: %date
D=Date Range
R=Report Date
T=Today
Default Value: D
RUN_CNTL_RESETS(SQL Table) |
Index Back |
|---|---|
Run Control for IHB |
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 4 | START_DATE | Date(10) | DATE |
Start Date for Gen Standing PO
Default Value: %date |
| 5 | END_DATE | Date(10) | DATE |
End Date
Default Value: %date |
| 6 | TR_RPT_PARM_RFT | Character(1) | VARCHAR2(1) NOT NULL | Report Request Parameters |
| 7 | TR_DATE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Date Option
D=Date Range R=Report Date T=Today Default Value: D |