CSO_C_BATCH_REQUEST

This table contains content batch requests.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_C_BATCH_REQUEST_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
CHANNEL_ID	VARCHAR2	32		Yes	This is the channel id of the batch.
OWNER_ID	VARCHAR2	32			This is the obsolete Owner id of the batch.
SITE_ID	VARCHAR2	32		Yes	The site id of the batch for this record.
NAME	VARCHAR2	100		Yes	The name of the batch for this record.
STATUS	VARCHAR2	1			A flag indicating SUCCESS or ERROR.
WORKFLOW_RESOLUTION	VARCHAR2	1			A flag to indicating the workflow resolution.
OVER_WRITE_TYPE	VARCHAR2	1			A flag to indicating the overwrite type.
DESCRIPTION	VARCHAR2	4000			This is the description of the batch.
DATE_COMPLETED	TIMESTAMP				This is the datetime that the entire batch was completed.
DATE_EXPORTED	TIMESTAMP				This is the datetime that the batch was exported.
DATE_ADDED	TIMESTAMP			Yes	This is the datetime that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP			Yes	This is the datetime that the record was modified.
OWNER_PARTY_ID	NUMBER		18		This is the Owner id of the batch.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_C_BATCH_REQUEST	cso_site	SITE_ID
CSO_C_BATCH_REQUEST	cso_channel	CHANNEL_ID
cso_c_batch_locale_owner	cso_c_batch_request	BATCH_REQUEST_ID
cso_c_batch_document	cso_c_batch_request	BATCH_REQUEST_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_C_BATCH_REQUEST_N1	Non Unique	Default	CHANNEL_ID
CSO_C_BATCH_REQUEST_N2	Non Unique	Default	OWNER_PARTY_ID
CSO_C_BATCH_REQUEST_N3	Non Unique	Default	SITE_ID
CSO_C_BATCH_REQUEST_U1	Unique	Default	RECORD_ID