CSO_BULK_UPDATE_DOC_DETAIL

This table defines every document that the user selected to be processed in bulk and contains the success/failure details of document updated by the Bulk Update batch job.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_BULK_UPDATE_DOC_DETAIL_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments	Status
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
CONTENT_CHANNEL_ID	VARCHAR2	32		This is the GUID reference to the ContentChannel to which the document belongs to.
CONTENT_TEXT_ID	VARCHAR2	32	Yes	This is the GUID reference to the ContentText that is supposed to be updated.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added.
DATE_MODIFIED	TIMESTAMP		Yes	This is the date that the record was modified - updated only once when bulk update job processes this document.
DOCUMENT_ID	VARCHAR2	50	Yes	This is the document ID of the document.
UPDATE_STATUS	VARCHAR2	50		A value which indicates the status of the update (e.g: UPDATED, FAILED) including any errors.	Obsolete
INDEX_MASTER_IDENTIFIERS	VARCHAR2	4000		The Master Identifier of the document after it was processed.
VERSION	VARCHAR2	10	Yes	The version (e.g.: 1.0) of the document.
LOCALE_ID	VARCHAR2	32		This is the GUID reference to the Locale to which the document belongs to.
BULK_REQUEST_ID	VARCHAR2	32	Yes	This is the GUID reference to the Bulk Update Request which owns this BulkUpdateDocDetail.
ADDITIONAL_INFO	VARCHAR2	4000		This column contains any additional information regarding the bulk update processing of the article this record represents.
WORK_UNIT_ID	VARCHAR2	32		This is the GUID reference to the task work unit, or batch, this bulk update document detail belongs to. The task work unit is stored in the CSO_TASK_WORK_UNITS TABLE.
STATUS	VARCHAR2	50		A value which indicates the status of the update (e.g: UPDATED, FAILED), including any errors, of the article that this record represents.
SUBSTATUS	VARCHAR2	50		A value which indicates a more specfic status of the update of the article that this record represents.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_BULK_UPDATE_DOC_DETAIL	cso_channel	CONTENT_CHANNEL_ID
CSO_BULK_UPDATE_DOC_DETAIL	cso_content_text	CONTENT_TEXT_ID
CSO_BULK_UPDATE_DOC_DETAIL	cso_locale	LOCALE_ID
CSO_BULK_UPDATE_DOC_DETAIL	cso_bulk_update_request	BULK_REQUEST_ID
CSO_BULK_UPDATE_DOC_DETAIL	cso_task_work_units	WORK_UNIT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_BULK_UPDATE_DOC_DETAIL_N1	Non Unique	Default	CONTENT_CHANNEL_ID
CSO_BULK_UPDATE_DOC_DETAIL_N2	Non Unique	Default	CONTENT_TEXT_ID
CSO_BULK_UPDATE_DOC_DETAIL_N3	Non Unique	Default	LOCALE_ID
CSO_BULK_UPDATE_DOC_DETAIL_N4	Non Unique	Default	BULK_REQUEST_ID
CSO_BULK_UPDATE_DOC_DETAIL_N5	Non Unique	Default	WORK_UNIT_ID
CSO_BULK_UPDATE_DOC_DETAIL_U1	Unique	Default	RECORD_ID