PSCDBMSGTEST

index back

Table saving message tests

This record saves message testing settings. It is used by RBD_MSG_TEST.

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
DESCR Character(30) VARCHAR2(30) NOT NULL 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

Y/N Table Edit

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_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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19