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 NameField TypeColumn TypeDescription
PT_CDB_APP_CODECharacter(4)VARCHAR2(4) NOT NULLCode 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_IDCharacter(31)VARCHAR2(31) NOT NULLThis 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_CODECharacter(1)VARCHAR2(1) NOT NULLChange Type Field which is used in Dashboard Message Frame Work
A=Add
D=Delete
U=Update
PT_CDB_BULK_MSGCharacter(1)VARCHAR2(1) NOT NULLBulk Message Processing Indicator
PT_CDB_SENDDATMODECharacter(1)VARCHAR2(1) NOT NULLBulk Message Processing Indicator
I=Initial Send Data
S=Scheduled Send Data
T=Transaction Send Data
PT_CDB_KEYS_COUNTNumber(2,0)SMALLINT NOT NULLDashboard Object Keys Count
PT_CDB_KEY_1Character(50)VARCHAR2(50) NOT NULLDashboard Data Object Key 1
PT_CDB_KEY_2Character(50)VARCHAR2(50) NOT NULLDashboard Data Object Key 2
PT_CDB_KEY_3Character(50)VARCHAR2(50) NOT NULLDashboard Data Object Key 3
PT_CDB_KEY_4Character(254)VARCHAR2(254) NOT NULLDashboard Data Object Key 4
PT_CDB_KEY_4_HASHSigned Number(14,0)DECIMAL(13) NOT NULLDashboard Data Object Key 4 Hash Value
PT_CDB_PROCESSINGCharacter(1)VARCHAR2(1) NOT NULLDashboard Queue Table Record Processing Flag
PT_CDB_RETRY_COUNTNumber(3,0)SMALLINT NOT NULLRetry Count for Dashboard Messaging
PT_ROW_ADDED_DTTMDateTime(26)TIMESTAMPDatetime Added
PT_ROW_ADDED_OPRIDCharacter(30)VARCHAR2(30) NOT NULLAdded By
PT_ROW_MAINT_DTTMDateTime(26)TIMESTAMPLast Modified
PT_ROW_MAINT_OPRIDCharacter(30)VARCHAR2(30) NOT NULLLast Modified by
PT_CDB_SCHED_DTTMDateTime(26)TIMESTAMPDatetime that an entry should be packaged and messaged to the dashboard.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19