ETL_JOB_ID

NOT NULL

NUMBER

Unique identifier to represent a scheduled job

ETL_NAME

NOT NULL

VARCHAR2(64)

Name of the ETL identifying ETL process for different modules, for example, Common, Resource Management, Financial management or Time Management.

JOB_NAME

NOT NULL

VARCHAR2(64)

Name of the ETL module

JOB_TYPE

NOT NULL

NUMBER

Numeric value representing job type auto(0) or manual(1)

BATCH_ID

NOT NULL

NUMBER

Unique ID that corresponds to an ETL execution which is comprised of processing ETL for multiple modules, for example, Common, Resource Management, Financial Management or Time Management.

ETL_WINDOW_START_TIME

NULLABLE

DATE

The timestamp that indicates the beginning mark of CDC subscription window used when processing changes during scheduled job execution for incremental ETL

ETL_WINDOW_END_TIME

NULLABLE

DATE

The timestamp that indicates the ending mark of CDC subscription window used when processing changes during scheduled job execution for incremental ETL

EXEC_START_TIME

NULLABLE

DATE

The timestamp when the specific ETL module started execution

EXEC_END_TIME

NULLABLE

DATE

The timestamp when the specific ETL module finished execution

STATUS

NOT NULL

VARCHAR2(64)

Status of the individual ETL module indicating whether it completed, failed or running

DESCRIPTION

NULLABLE

VARCHAR2(200)

Description of the steps executed successfully in ETL module