OPRIDPrompt Table: OPRID_VW
RUN_CNTL_IDPrompt Table: PRCSRUNCNTL
DP_CONFIGVIEWPrompt Table: DP_RECCFGVW_VW
DP_RUN_CNTL_UAF(SQL Table) |
Index Back |
|---|---|
User Forecast Run ControlUser Forecast Adjustment Detail Run Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: PRCSRUNCNTL |
| 3 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_RECCFGVW_VW |
| 4 | DP_CONFIGLEVEL | Number(2,0) | SMALLINT NOT NULL | DP_CONFIGLEVEL |
| 5 | DP_RECONFORMATCODE | Character(10) | VARCHAR2(10) NOT NULL | Collabaration Display Template |
| 6 | DP_CALCADJERROR | Character(1) | VARCHAR2(1) NOT NULL | Calculate User Adjusted Forecast Error |
| 7 | DP_CALCADJWEIGHT | Character(1) | VARCHAR2(1) NOT NULL | Calculate User Adjusted Forecast Weight |