CSO_GSR_REQUEST

Details

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

Primary Key

Name	Columns
CSO_GSR_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.
BYPASS_WORKFLOW	VARCHAR2	1		Yes	A flag to indicating whether the user wanted GFR to bypass workflow when updating/publishing content.
DATE_ADDED	TIMESTAMP			Yes	This is the datetime that the record was added.
DATE_COMPLETED	TIMESTAMP				This is the datetime that the entire GFR 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.
FIND_TEXT	VARCHAR2	500		Yes	This is the text that user wanted GFR to find.
MATCH_CASE	VARCHAR2	1		Yes	A flag to indicating whether the user wanted GFR to match the case when finding text.
MATCH_WHOLE_WORDS_ONLY	VARCHAR2	1		Yes	A flag to indicating whether the user wanted GFR to match whole words only when finding text.
NUM_DOCS_SELECTED	NUMBER			Yes	This is the number of documents that user selected and expects GFR to replace.
REPLACE_TEXT	VARCHAR2	500		Yes	This is the text that user wanted to replace with.
RETAIN_CASE	VARCHAR2	1		Yes	A flag to indicating whether the user wanted GFR to maintain the case in the original document when replacing.
REQUEST_STATE	NUMBER	7		Yes	A value which indicates the current state of this GFR job e.g: Stopped, Running, Completed, etc.
SITE_ID	VARCHAR2	32		Yes	This is the GUID reference to the Site (Repository) in which this GFR Request was made.
SUPPRESS_NOTIFICATION_TO_OWNER	VARCHAR2	1		Yes	A flag to indicate whether the user wanted GFR to suppress Publish Notifications to Owner.
SUPPRESS_SUBSCRIPTIONS	VARCHAR2	1		Yes	A flag to indicate whether the user wanted GFR to suppress Subscription Notifications.
SUPPRESS_TRANSLATION	VARCHAR2	1		Yes	A flag to indicate whether the user wanted GFR to suppress Translation Requests, Tasks, and Notifications.
USER_ID	VARCHAR2	32			This is the obsolete GUID reference to the user who made the GFR Request.
LAST_MODIFIED_BY	VARCHAR2	32		Yes	This is the obsolete GUID reference to the user who last modified the GFR Request.
USER_PARTY_ID	NUMBER		18		This is the party ID reference to the user who made the GFR Request.
LAST_MODIFIED_BY_PARTY_ID	NUMBER		18		This is the party ID reference to the user who last modified the GFR Request.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_GSR_REQUEST	cso_site	SITE_ID
cso_gsr_doc_detail	cso_gsr_request	GSR_REQUEST_ID
cso_gsr_request_locale	cso_gsr_request	GSR_REQUEST_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_GSR_REQUEST_N1	Non Unique	Default	USER_PARTY_ID
CSO_GSR_REQUEST_N2	Non Unique	Default	LAST_MODIFIED_BY_PARTY_ID
CSO_GSR_REQUEST_N3	Non Unique	Default	SITE_ID
CSO_GSR_REQUEST_U1	Unique	Default	RECORD_ID