PSCDBSCHEDQ

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.

PeopleSoft Field Name Field Type Column Type Description
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

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.
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
PT_CDB_BULK_MSG Character(1) VARCHAR2(1) NOT NULL Bulk Message Processing Indicator
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
PT_CDB_KEYS_COUNT Number(2,0) SMALLINT NOT NULL Dashboard Object Keys Count
PT_CDB_KEY_1 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 1
PT_CDB_KEY_2 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 2
PT_CDB_KEY_3 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 3
PT_CDB_KEY_4 Character(254) VARCHAR2(254) NOT NULL Dashboard Data Object Key 4
PT_CDB_KEY_4_HASH Signed Number(14,0) DECIMAL(13) NOT NULL Dashboard Data Object Key 4 Hash Value
PT_CDB_PROCESSING Character(1) VARCHAR2(1) NOT NULL Dashboard Queue Table Record Processing Flag
PT_CDB_RETRY_COUNT Number(3,0) SMALLINT NOT NULL Retry Count for Dashboard Messaging
PT_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
PT_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
PT_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Last Modified
PT_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Modified by
PT_CDB_SCHED_DTTM DateTime(26) TIMESTAMP Datetime that an entry should be packaged and messaged to the dashboard.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19