PSCDBMSGTEST

index back

Table saving message tests

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

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
SEQ_NUMNumber(3,0)SMALLINT NOT NULLSequence
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
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

Y/N Table Edit

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