RPT_EVENT_LOG_DETAIL

This table stores the detail logging information from various steps performed during FULL ETL and incremental ETL process. Information in this table can be used for debugging, troubleshooting problems that occur during FULL ETL or incremental ETL process.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

EVENT_LOG_ID

NOT NULL

NUMBER

Unique identifier to represent an event log detail

EVENT_TIME

NOT NULL

DATE

The time stamp indicating when the event occurred

MODULE_NAME

NULLABLE

VARCHAR2(512)

Name of the module that generated the event

FUNC_NAME

NULLABLE

VARCHAR2(256)

The SQL procedure name which logged the event

FILE_NAME

NULLABLE

VARCHAR2(512)

Name of the file where the SQL procedure is defined that generated the event

LINE_NO

NULLABLE

NUMBER

Line number in the file where the SQL procedure has logged the event

MSG

NULLABLE

VARCHAR2(1024)

The descriptive message of the error or information

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.