OPRIDRUN_CNTL_IDPrompt Table: DP_VIEW4USER_VW
B=Build Caption and Description
C=Build Caption Only
D=Build Description Only
Default Value: C
Default Value: 0
B=BU Items Inventory
M=Master Item Table
Default Value: B
RUN_DP_CAPDESC(SQL Table) |
Index Back |
|---|---|
RunCtl/Log DmandDataHis UpdateRun Control Table is also used as a log for Demand Data Hisotry Updates. Each row is inserted by either Process Scheduler when running routine processes or by the Demand Data Update Component (user initiated). It is updated by AE to log activity per process initiated. |
| # | 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 | DP_CONFIGVIEW | Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_VIEW4USER_VW |
| 4 | DP_BUILDCAPDESC | Character(1) | VARCHAR2(1) NOT NULL |
DP_BUILDCAPDESC
B=Build Caption and Description C=Build Caption Only D=Build Description Only Default Value: C |
| 5 | DP_CONFIGLEVEL | Number(2,0) | SMALLINT NOT NULL |
DP_CONFIGLEVEL
Default Value: 0 |
| 6 | DP_CUSTOM_FLD_FROM | Character(1) | VARCHAR2(1) NOT NULL |
DP_CUSTOM_FLD_FROM
B=BU Items Inventory M=Master Item Table Default Value: B |
| 7 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |