ETL_STREAM

This table stores stream, source entity, and target entity mapping information. This table is under the schema that contains metadata.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Field Name

Null?

Field Type

Field Description

STREAM_ITEM_ID

Not null

INT

Stream item ID

SOURCE_ENTITY_ID

Nullable

INT

Source entity ID

TARGET_ENTITY_ID

Not null

INT

Target entity ID

STREAM_ID

Not null

INT

Stream ID

CONTENT_PACK_ID

Not null

INT

Content pack ID

SOURCE_PRODUCT

Not null

Varchar(50)

Source product name, such as PPM

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.