CMP_CWB_POST_LOG

Stores Post Process Log information.

Details

  • Schema: FUSION

  • Object owner: CMP

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMP_CWB_POST_LOG_PK

RUN_LOG_ID

Columns

Name Datatype Length Precision Not-null Comments
RUN_LOG_ID NUMBER 18 Yes Run Log Id
BUSINESS_GROUP_ID NUMBER 18 Yes BUSINESS_GROUP_ID
RUN_ID NUMBER 18 RUN_ID
REQUESTID NUMBER 18 REQUESTID
THREAD_ID NUMBER THREAD_ID
APP_NAME VARCHAR2 30 APP_NAME
LOG_TIMESTAMP TIMESTAMP Yes LOG_TIMESTAMP
PERSON_ID NUMBER 18 PERSON_ID
PERSON_EVENT_ID NUMBER 18 PERSON_EVENT_ID
PERSON_RUN_ID NUMBER 18 PERSON_RUN_ID
ROW_TYPE VARCHAR2 30 ROW_TYPE
COMPONENT_ID NUMBER 18 COMPONENT_ID
PLAN_ATTRIBUTE_ID NUMBER 18 PLAN_ATTRIBUTE_ID
ATTRIBUTE_ELEMENT_ID NUMBER 18 ATTRIBUTE_ELEMENT_ID
LOG_SOURCE VARCHAR2 250 Yes LOG_SOURCE
LOG_SEVERITY VARCHAR2 30 LOG_SEVERITY
APPLICATION_ID NUMBER APPLICATION_ID
MESSAGE_NAME VARCHAR2 30 MESSAGE_NAME
MESSAGE_TEXT VARCHAR2 240 MESSAGE_TEXT
MESSAGE_ADMIN_DETAILS VARCHAR2 4000 MESSAGE_ADMIN_DETAILS

Indexes

Index Uniqueness Tablespace Columns
CMP_CWB_POST_LOG_N1 Non Unique Default RUN_ID, PERSON_RUN_ID
CMP_CWB_POST_LOG_PK Unique Default RUN_LOG_ID