CSO_GSR_SEARCH_RESULT

This table contains initial GFR results identified by a lucene search

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_GSR_SEARCH_RESULT_PK	SESSION_ID, INSTANCE, CONTENT_TEXT_ID

Columns

Name	Datatype	Length	Not-null	Comments
SESSION_ID	VARCHAR2	32	Yes	This is the WebObjects Session Id.
INSTANCE	NUMBER		Yes	This is the Application instance number.
CONTENT_TEXT_ID	VARCHAR2	32	Yes	This is the Reference to the ContentText table.
DOCUMENT_ID	VARCHAR2	50		This is the Document Id for this record.
VERSION	VARCHAR2	21		This is the Version for this record.
LOCALE_CODE	VARCHAR2	64		This is the Reference to the Locale.
LOCALE_DESC	VARCHAR2	100		This is the Locale Description for this record.
WORKFLOW_STEP_ID	VARCHAR2	32		This is the GUID reference to the WorkflowStep to which the document belongs to.
WORKFLOW_STEP_NAME	VARCHAR2	1000		This is the Workflow Step Name for this record.
CONTENT_CHANNEL_ID	VARCHAR2	32		This is the GUID reference to the ContentChannel to which the document belongs to.
CHANNEL_NAME	VARCHAR2	1000		This is the Channel Name for this record.
INDEX_MASTER_IDENTIFIERS	VARCHAR2	4000		The Master Identifier of the document currently.
SELECTED	CHAR	1		This is the selected flag for this record.
NO_SUCH_COLUMN	CHAR	1		This is the no Such Column for this record.
GSR_DOC_DETAIL_GUID	VARCHAR2	32	Yes	Pre-generated GSRDocDetail GUId.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_GSR_SEARCH_RESULT	cso_content_text	CONTENT_TEXT_ID

Indexes

Index	Uniqueness	Columns
CSO_GSR_SEARCH_RESULT_U1	Unique	SESSION_ID, INSTANCE, CONTENT_TEXT_ID
CSO_GSR_SEARCH_RESULT_N1	Non Unique	CONTENT_TEXT_ID