DP_DDH_SYSTEM (SQL Table)	Index Back
One row system table Used for the Extract and Update processes in Demand Data History transfer from FDM to DP.

DP_DDH_SYSTEM

(SQL Table)

One row system table

Used for the Extract and Update processes in Demand Data History transfer from FDM to DP.

# 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_DDH_MAXMSGCHUNK Number(5,0) INTEGER NOT NULL Demand data history table --Number of History Transactions Retained. This field is stored in the System Table to indicate how many transactions are retained (for a given set of keys). For instance, if this value is set to 3- only 3 transactions are kept in the history table. This could be 1 add and 2 change. 1 add, 1 change and 1 delete. Etc. If the transaciton being stored is the 4th transaction, then the DP_DDH_RULE field (in the system table) will be used to indicate what we do with this row- dump this one or dump another transaction and insert this one (if so- which transaction do we delete).

4 DP_DDH_CONTROL Character(4) VARCHAR2(4) NOT NULL DP_DDH_CONTROL

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

6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	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_DDH_MAXMSGCHUNK	Number(5,0)	INTEGER NOT NULL	Demand data history table --Number of History Transactions Retained. This field is stored in the System Table to indicate how many transactions are retained (for a given set of keys). For instance, if this value is set to 3- only 3 transactions are kept in the history table. This could be 1 add and 2 change. 1 add, 1 change and 1 delete. Etc. If the transaciton being stored is the 4th transaction, then the DP_DDH_RULE field (in the system table) will be used to indicate what we do with this row- dump this one or dump another transaction and insert this one (if so- which transaction do we delete).
4	DP_DDH_CONTROL	Character(4)	VARCHAR2(4) NOT NULL	DP_DDH_CONTROL
5	DP_DDHUPD_DATE	Date(10)	DATE	DP_DDHUPD_DATE Default Value: %DATE
6	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description