CSO_GSR_DOC_DETAIL

This table defines every document that the user selected to be updated by GFR and contains the success/failure details of document updated/published by GFR.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_GSR_DOC_DETAIL_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
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 GFR Replacer processes this document.
DOCUMENT_ID	VARCHAR2	50	Yes	This is the document ID of the document before it was processed by GSR.
REPLACE_STATUS	VARCHAR2	50	Yes	A value which indicates the status of the GFR Replacer (e.g: FAILED_LOCKED) including any errors.
INDEX_MASTER_IDENTIFIERS	VARCHAR2	4000		The Master Identifier of the document after it was processed.
LOCALE_ID	VARCHAR2	32		This is the GUID reference to the Locale to which the document belongs to.
NUM_REPLACEMENTS	NUMBER			This is the number of replacements that were made in this document.
DOC_STATUS	VARCHAR2	50		The status (e.g: UNPUBLISHED) of the document after it was processed. Null if not yet processed.
GSR_REQUEST_ID	VARCHAR2	32	Yes	This is the GUID reference to the GFR Request which owns this GSRDocDetails.
VERSION	VARCHAR2	10	Yes	The version (e.g.: 1.0) of the document before and after it was processed.
WORKFLOW_STEP_ID	VARCHAR2	32		This is the GUID reference to the WorkflowStep to which the document belongs to.
GSR_DOC_TRANSLATION_INFO_ID	VARCHAR2	32		This is the GUID for the GSRDOCTRANSLATIONINFO, if set.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_GSR_DOC_DETAIL	cso_channel	CONTENT_CHANNEL_ID
CSO_GSR_DOC_DETAIL	cso_content_text	CONTENT_TEXT_ID
CSO_GSR_DOC_DETAIL	cso_locale	LOCALE_ID
CSO_GSR_DOC_DETAIL	cso_gsr_request	GSR_REQUEST_ID
CSO_GSR_DOC_DETAIL	cso_workflow_step	WORKFLOW_STEP_ID
CSO_GSR_DOC_DETAIL	cso_gsr_doc_trans_info	GSR_DOC_TRANSLATION_INFO_ID

Indexes

Index	Uniqueness	Columns
CSO_GSR_DOC_DETAIL_U1	Unique	RECORD_ID
CSO_GSR_DOC_DETAIL_N2	Non Unique	CONTENT_TEXT_ID
CSO_GSR_DOC_DETAIL_N5	Non Unique	WORKFLOW_STEP_ID
CSO_GSR_DOC_DETAIL_N1	Non Unique	CONTENT_CHANNEL_ID
CSO_GSR_DOC_DETAIL_N3	Non Unique	LOCALE_ID
CSO_GSR_DOC_DETAIL_N4	Non Unique	GSR_REQUEST_ID
CSO_GSR_DOC_DETAIL_N6	Non Unique	GSR_DOC_TRANSLATION_INFO_ID