CSO_BULK_UPDATE

Details

Schema: FUSION
Object owner: CSO
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_BULK_UPDATE_REQUEST_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
REQUEST_NUMBER	VARCHAR2	50			The human readable identifier of a bulk update request.
DATE_ADDED	TIMESTAMP			Yes	This is the datetime that the record was added.
DATE_STARTED	TIMESTAMP				This is the date and time that the bulk update request was actually started.
DATE_COMPLETED	TIMESTAMP				This is the datetime that the entire Bulk Update Request was completed - inserted only when it is allowed to run until completion.
DATE_MODIFIED	TIMESTAMP			Yes	This is the datetime that the record was modified - updated every time user stops/starts GFR job.
SCHEDULED_TIME	TIMESTAMP				This is the date and time that the bulk update request will be picked up to be processed.
REQUEST_STATE	NUMBER	7			A value which indicates the current state of this Bulk Update job e.g: Stopped, Running, Completed, etc.	Obsolete
STATUS	VARCHAR2	50			A value which indicates the current status of the bulk update request.
REQUEST_TYPE	NUMBER	7			A value which indicates the Bulk Update type.	Obsolete
TYPE	VARCHAR2	50			A value which indicates what kind of bulk update request this record is.
OPERATIONS	NUMBER		9		A value which indicates which operations (e.g. add categories, change owner, etc) are to be performed as part of the bulk update request.
SITE_ID	VARCHAR2	32		Yes	This is the GUID reference to the Site (Repository) in which this Bulk Update Request was made.
USER_ID	VARCHAR2	32			This is the obsolete GUID reference to the user who made the Bulk Update Request.
CONTENT_CHANNEL_ID	VARCHAR2	32			This is the GUID reference to the channel where the Bulk Update Request was made.	Obsolete
LAST_MODIFIED_BY	VARCHAR2	32			This is the obsolete GUID associate with the user who last modified the build update request.
PARAMETER_XML	CLOB				The job parameters marshalled as XMl.	Obsolete
STATUS_XML	CLOB				The job status marshalled as XML.	Obsolete
USER_PARTY_ID	NUMBER		18		This is the ID of the user who made the Bulk Update Request.
LAST_MODIFIED_BY_PARTY_ID	NUMBER		18		This is the ID of the user who last modified the build update request.
PARAMETER_DATA	CLOB				The bulk update request parameter data (i.e operations, values for operations, etc) that details the changes that will be performed.
STATUS_DATA	CLOB				The bulk update status data that contains the bulk update request processing information.
STRIPE_CD	VARCHAR2	30			The stripe code of the department that this bulk update request can modify articles in. In other words, only articles that belong to the department indicated here will be modified.
COMMENTS	VARCHAR2	2000			A value that contains a user's comments related to the bulk update request.
SELECTED_NUM	NUMBER		9		This value is the number of articles that were selected to be modified by this bulk update request.
SUCCESS_NUM	NUMBER		9		This value is the number of articles that were successfully modified by the bulk update request.
SKIPPED_NUM	NUMBER		9		This value is the number of articles that were explicitly skipped due to various reasons during the bulk update process.
ERROR_NUM	NUMBER		9		This value is the number of articles that resulted in an error when the bulk update process attempted to update.
CLUSTER_NAME	VARCHAR2	255			This value is used to describe the current cluster that this item is being processed in.
POD_NAME	VARCHAR2	255			This value is used to describe what current pod this is being processed in.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_BULK_UPDATE_REQUEST	cso_site	SITE_ID
cso_bulk_update_doc_detail	cso_bulk_update_request	BULK_REQUEST_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CSO_BULK_UPDATE_REQUEST_N1	Non Unique	Default	USER_PARTY_ID
CSO_BULK_UPDATE_REQUEST_N2	Non Unique	Default	LAST_MODIFIED_BY_PARTY_ID
CSO_BULK_UPDATE_REQUEST_N3	Non Unique	Default	SITE_ID
CSO_BULK_UPDATE_REQUEST_N4	Non Unique	Default	CONTENT_CHANNEL_ID	Obsolete
CSO_BULK_UPDATE_REQUEST_N5	Non Unique	Default	SCHEDULED_TIME
CSO_BULK_UPDATE_REQUEST_N6	Non Unique	Default	DATE_STARTED
CSO_BULK_UPDATE_REQUEST_N7	Non Unique	Default	DATE_COMPLETED
CSO_BULK_UPDATE_REQUEST_N8	Non Unique	Default	STATUS
CSO_BULK_UPDATE_REQUEST_N9	Non Unique	Default	TO_NUMBER("REQUEST_NUMBER")
CSO_BULK_UPDATE_REQUEST_U1	Unique	Default	RECORD_ID