Prompt Table: PSCDBAPPCODE
PT_CDB_OBJTYPE_IDPT_CDB_CHNG_CODEA=Add
D=Delete
U=Update
I=Initial Send Data
S=Scheduled Send Data
T=Transaction Send Data
PT_CDB_KEY_1PT_CDB_KEY_2PT_CDB_KEY_3PT_CDB_KEY_4_HASHPSCDBCHNGQ |
index back |
|---|---|
Dashboard Change Queue |
| 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 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |