RUN_DP_DDHUPD (SQL Table)	Index Back
Internal Demand Data Updates Run 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.

RUN_DP_DDHUPD

(SQL Table)

Internal Demand Data Updates

Run 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_SPECS_ID Character(20) VARCHAR2(20) NOT NULL DP_SPECS_ID
Prompt Table: DP_INTUPD_SPECS

4 DP_DDHUPD_DTTM DateTime(26) TIMESTAMP datetime of last update to demand_history table
Default Value: %DateTime

5 DP_DDHUPD_DATE Date(10) DATE DP_DDHUPD_DATE
Default Value: %DATE

6 DP_DDHUPD_DATE_FR Date(10) DATE NOT NULL DP_DDHUPD_DATE_FR

7 DP_DDHUPD_DATE_TO Date(10) DATE NOT NULL DP_DDHUPD_DATE_TO

8 DP_DESCR Character(30) VARCHAR2(30) NOT NULL DP_DESCR

9 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.

10 DP_ADJ_REASON Character(8) VARCHAR2(8) NOT NULL DP_ADJ_REASON
Prompt Table: DP_ADJ_REASN_VW

11 DP_ADJ_COMMENT Character(50) VARCHAR2(50) NOT NULL DP_ADJ_COMMENT

12 DP_RETRY_COUNT Number(3,0) SMALLINT NOT NULL DP_RETRY_COUNT

13 DP_PROCEED_BTN Character(1) VARCHAR2(1) NOT NULL Proceed

#	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_SPECS_ID	Character(20)	VARCHAR2(20) NOT NULL	DP_SPECS_ID Prompt Table: DP_INTUPD_SPECS
4	DP_DDHUPD_DTTM	DateTime(26)	TIMESTAMP	datetime of last update to demand_history table Default Value: %DateTime
5	DP_DDHUPD_DATE	Date(10)	DATE	DP_DDHUPD_DATE Default Value: %DATE
6	DP_DDHUPD_DATE_FR	Date(10)	DATE NOT NULL	DP_DDHUPD_DATE_FR
7	DP_DDHUPD_DATE_TO	Date(10)	DATE NOT NULL	DP_DDHUPD_DATE_TO
8	DP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	DP_DESCR
9	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.
10	DP_ADJ_REASON	Character(8)	VARCHAR2(8) NOT NULL	DP_ADJ_REASON Prompt Table: DP_ADJ_REASN_VW
11	DP_ADJ_COMMENT	Character(50)	VARCHAR2(50) NOT NULL	DP_ADJ_COMMENT
12	DP_RETRY_COUNT	Number(3,0)	SMALLINT NOT NULL	DP_RETRY_COUNT
13	DP_PROCEED_BTN	Character(1)	VARCHAR2(1) NOT NULL	Proceed