KRML_PROCESS_MESSAGES

This table is used internally by the Reporting Meta Layer to keep track of messages to display in an RML synchronization report.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KRML_VIEWS

BATCH_NUMBER

BATCH_NUMBER

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

PROCESS_MESSAGE_ID

NOT NULL

NUMBER

System-generated identifier

MESSAGE_TYPE

NOT NULL

VARCHAR2(30)

Type of message (for RML synchronization report)

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

BATCH_NUMBER

NULLABLE

NUMBER

RML synchronization batch that this message belongs to

MESSAGE

NULLABLE

VARCHAR2(2000)

Text to include in the RML synchronization report

Indexes

Index Name

Index Type

Sequence

Column Name

KRML_PROCESS_MESSAGES_PK

UNIQUE

1

PROCESS_MESSAGE_ID

Sequences

Sequence Name

Sequence Type

KRML_PROCESS_MESSAGES_S

PROCESS_MESSAGE_ID