PPM_SERVICE_MESSAGE_RECORDS

This table stores the information for JMS message process results.

Foreign Keys

This table does not include any foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
MESSAGE_RECORD_ID	NOT NULL	NUMBER	System-generated identifier
SERVICE_RECORD_ID	NOT NULL	NUMBER	Identifier of the background service to which the record is linked
MESSAGE_PROCESS_DATE	NOT NULL	DATE	Date when the JMS message was processed
MESSAGE_PROCESS_SEQ	NOT NULL	NUMBER	How many times the JMS message has been processed
MESSAGE_PROCESS_TYPE	NOT NULL	VARCHAR2(255)	Type of the message process result
SUMMARY		VARCHAR2(4000)	Summary of the message process result
VERSION	NOT NULL	NUMBER	System-generated version
CREATED_BY	NOT NULL	NUMBER	Identifier of the user who created the record
CREATION_DATE	NOT NULL	DATE	Date when the record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier of the user who last updated the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date when the record as last updated

Indexes

This table does not include any indexes.

Sequences

Sequence Name	Sequence Type
PPM_SERVICE_MESSAGE_RECORDS_S	MESSAGE_RECORD_ID