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_HASHPSCDBSCHEDQ(SQL Table) |
Index Back |
|---|---|
Dashboard Change QueueDashboard 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 |
| 18 | PT_CDB_SCHED_DTTM | DateTime(26) | TIMESTAMP | Datetime that an entry should be packaged and messaged to the dashboard. |