RUN_DP_DDHXTRCT(SQL Table) |
Index Back |
|---|---|
Demand History Run ControlRun Control Table is also used as a log for Demand Data History 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. Date Initials Reference # Description 02/07/08 TH ICE 1699320000 Modified to allow for multiple parallel process to improve performance |
| # | 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_DDHUPD_DTTM | DateTime(26) | TIMESTAMP |
datetime of last update to demand_history table
Default Value: %DateTime |
| 4 | DP_DDH_BI | Character(1) | VARCHAR2(1) NOT NULL |
DP_DDH_BI
Y/N Table Edit Default Value: N |
| 5 | DP_DDH_SO | Character(1) | VARCHAR2(1) NOT NULL |
DP_DDH_SO
Y/N Table Edit Default Value: N |
| 6 | DP_DDH_IN | Character(1) | VARCHAR2(1) NOT NULL |
DP_DDH_IN
Y/N Table Edit Default Value: N |
| 7 | DP_DDH_OM | Character(1) | VARCHAR2(1) NOT NULL |
DP_DDH_OM
Y/N Table Edit Default Value: N |
| 8 | DP_DDH_PL | Character(1) | VARCHAR2(1) NOT NULL |
DP_DDH_PL
Y/N Table Edit Default Value: N |
| 9 | DP_DDH_PR | Character(1) | VARCHAR2(1) NOT NULL |
DP_DDH_PR
Y/N Table Edit Default Value: N |
| 10 | DP_DDH_TR | Character(1) | VARCHAR2(1) NOT NULL |
DP_DDH_TR
Y/N Table Edit Default Value: N |
| 11 | DP_DDHUPD_DATE | Date(10) | DATE |
DP_DDHUPD_DATE
Default Value: %DATE |
| 12 | DP_DDHUPD_DATE_FR | Date(10) | DATE | DP_DDHUPD_DATE_FR |
| 13 | DP_DDHUPD_DATE_TO | Date(10) | DATE |
DP_DDHUPD_DATE_TO
Default Value: %Date |
| 14 | DP_DDH_EXEC | Number(3,0) | SMALLINT NOT NULL | Process execution flag: 1 = executed by user 0 = executed by recurrence. This field used by demand history processes to determine when the select date windows should be automatically incremented if this is a scheduled process or if the select date windows should be taken directly from the run control table, without manipulation. |
| 15 | 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 |
| 16 | DP_FCST_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Kit Option
B=Both N=Components Y=Product Kits Default Value: N |
| 17 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 18 | DP_PARALLEL_PRCS | Number(3,0) | SMALLINT NOT NULL |
Date Initials Reference # Description
03/01/07 RCW ICE-1506124000 Created for performance enhancements in Forecast Calculation routines
Default Value: 1 |