CSO_PIPELINE_ITEM_STATUS

This table contains Status for each of the Items in the Pipeline that require it. Data in here will be short-lived as it is processed and removed by the Pipeline Service.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CSO_PIPELINE_ITEM_STATUS_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RECORD_ID	VARCHAR2	32		Yes	Unique Primary Key for this table.
PIPELINE_ITEM_ID	VARCHAR2	32		Yes	ID of the Pipeline Item to which this Status belongs.
PROCESSED_COUNT	NUMBER		8	Yes	Number of items processed for this parent item.
FAILED_COUNT	NUMBER		8	Yes	Number of items that failed to process for this parent item.
TOTAL_COUNT	NUMBER		8	Yes	Total number of items to be processed for this parent item.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_PIPELINE_ITEM_STATUS	cso_pipeline_items	PIPELINE_ITEM_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_PIPELINE_ITEM_STATUS_F1	Non Unique	Default	PIPELINE_ITEM_ID
CSO_PIPELINE_ITEM_STATUS_PK	Unique	Default	RECORD_ID