PSCDBCHNGQ (SQL Table)	Index Back
Dashboard Change Queue Dashboard data object change queue table. Used to record changes to data objects so they can be messaged to the Dashboard system.

PSCDBCHNGQ

(SQL Table)

Dashboard Change Queue

Dashboard data object change queue table. Used to record changes to data objects so they can be messaged to the Dashboard system.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PT_CDB_APP_CODE Character(4) VARCHAR2(4) NOT NULL Code of the application message to the dashboard. This may be used by the messaging framework as a mechanism to distribute messages to a JMS server.
Prompt Table: PSCDBAPPCODE

2 PT_CDB_OBJTYPE_ID Character(31) VARCHAR2(31) NOT NULL This object type is the ID for the data that is sent through the messaging framework. This usually, but not necessarily, is equivalent to a database record.

3 PT_CDB_CHNG_CODE Character(1) VARCHAR2(1) NOT NULL Change Type Field which is used in Dashboard Message Frame Work
A=Add
D=Delete
U=Update

4 PT_CDB_BULK_MSG Character(1) VARCHAR2(1) NOT NULL Bulk Message Processing Indicator

5 PT_CDB_SENDDATMODE Character(1) VARCHAR2(1) NOT NULL Bulk Message Processing Indicator
I=Initial Send Data
S=Scheduled Send Data
T=Transaction Send Data

6 PT_CDB_KEYS_COUNT Number(2,0) SMALLINT NOT NULL Dashboard Object Keys Count

7 PT_CDB_KEY_1 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 1

8 PT_CDB_KEY_2 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 2

9 PT_CDB_KEY_3 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 3

10 PT_CDB_KEY_4 Character(254) VARCHAR2(254) NOT NULL Dashboard Data Object Key 4

11 PT_CDB_KEY_4_HASH Signed Number(14,0) DECIMAL(13) NOT NULL Dashboard Data Object Key 4 Hash Value

12 PT_CDB_PROCESSING Character(1) VARCHAR2(1) NOT NULL Dashboard Queue Table Record Processing Flag

13 PT_CDB_RETRY_COUNT Number(3,0) SMALLINT NOT NULL Retry Count for Dashboard Messaging

14 PT_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

15 PT_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By

16 PT_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Last Modified

17 PT_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Modified by

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PT_CDB_APP_CODE	Character(4)	VARCHAR2(4) NOT NULL	Code of the application message to the dashboard. This may be used by the messaging framework as a mechanism to distribute messages to a JMS server. Prompt Table: PSCDBAPPCODE
2	PT_CDB_OBJTYPE_ID	Character(31)	VARCHAR2(31) NOT NULL	This object type is the ID for the data that is sent through the messaging framework. This usually, but not necessarily, is equivalent to a database record.
3	PT_CDB_CHNG_CODE	Character(1)	VARCHAR2(1) NOT NULL	Change Type Field which is used in Dashboard Message Frame Work A=Add D=Delete U=Update
4	PT_CDB_BULK_MSG	Character(1)	VARCHAR2(1) NOT NULL	Bulk Message Processing Indicator
5	PT_CDB_SENDDATMODE	Character(1)	VARCHAR2(1) NOT NULL	Bulk Message Processing Indicator I=Initial Send Data S=Scheduled Send Data T=Transaction Send Data
6	PT_CDB_KEYS_COUNT	Number(2,0)	SMALLINT NOT NULL	Dashboard Object Keys Count
7	PT_CDB_KEY_1	Character(50)	VARCHAR2(50) NOT NULL	Dashboard Data Object Key 1
8	PT_CDB_KEY_2	Character(50)	VARCHAR2(50) NOT NULL	Dashboard Data Object Key 2
9	PT_CDB_KEY_3	Character(50)	VARCHAR2(50) NOT NULL	Dashboard Data Object Key 3
10	PT_CDB_KEY_4	Character(254)	VARCHAR2(254) NOT NULL	Dashboard Data Object Key 4
11	PT_CDB_KEY_4_HASH	Signed Number(14,0)	DECIMAL(13) NOT NULL	Dashboard Data Object Key 4 Hash Value
12	PT_CDB_PROCESSING	Character(1)	VARCHAR2(1) NOT NULL	Dashboard Queue Table Record Processing Flag
13	PT_CDB_RETRY_COUNT	Number(3,0)	SMALLINT NOT NULL	Retry Count for Dashboard Messaging
14	PT_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
15	PT_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
16	PT_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Last Modified
17	PT_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Modified by