PSCDBMSGTEST

(SQL Table)
 Index Back

Table saving message tests

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

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

5 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.
6 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
7 PT_CDB_BULK_MSG Character(1) VARCHAR2(1) NOT NULL Bulk Message Processing Indicator

Y/N Table Edit

8 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
9 PT_CDB_KEY_1 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 1
10 PT_CDB_KEY_2 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 2
11 PT_CDB_KEY_3 Character(50) VARCHAR2(50) NOT NULL Dashboard Data Object Key 3
12 PT_CDB_KEY_4 Character(254) VARCHAR2(254) NOT NULL Dashboard Data Object Key 4