Share this page

# ETL_GENERATED_ARTIFACT

This table stores generated SQL code and related information of every step while running FlowEngine. This table is under the schema that contains management tables.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Field Name | Null? | Field Type | Field Description
--- | --- | --- | ---
STREAM_ID | Not null | int | Stream ID
STREAM_TYPE | Nullable | Varchar(100) | Two stream types are supported: SOURCE TARGET
ETL_STEP | Nullable | Varchar(20) | Should be the same as ETL steps defined in the ETL Template Engine
ARTIFACT_CONTENT | Nullable | Varchar(50000) | Generated SQL
CONTENT_PACK_ID | Nullable | int | Content pack ID
REGISTERED_BY | Nullable | VARCHAR(10) | The following values are supported: SYSTEM OOTB CUSTOMIZATION
MD_CREATETIME | Nullable | datetime | Date when the record is created
MD_LASTMODDDATE | Nullable | datetime | Date when the record is updated

## Projections

This table uses no projections.

## 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: