Share this page

# RPT_ETL_JOB

This table stores the detail information of the jobs ran for incremental ETL

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
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

## Indexes

This table uses no indexes.

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: