OKC_CLAUSE_DEVIATIONS_T

As the Contract Deviations are generated each time the user chooses to view them, they are stored in this table. This is to account for any change to the document directly. The user should also be able to indicate his/her preference to generate the Contract Deviations report and attach it in the approval workflow notification.

Details

• Schema: FUSION

• Object owner: OKC

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CLS_SEQUENCE_ID	NUMBER		18		The colum which holds the unique index for every run of the deviation report.
SCN_ID	NUMBER		18		The Section ID for the Clause
SOURCE_FLAG	VARCHAR2	1			T -> For Template
ARTICLE_ID	NUMBER		18		Clause ID on the business document
ARTICLE_VERSION_ID	NUMBER		18		Clause Version ID on the business document
REF_ARTICLE_ID	NUMBER		18		Ref Clause ID populated when a Std Clause is made non std
REF_ARTICLE_VERSION_ID	NUMBER		18		Ref Clause Version ID
DISPLAY_SEQUENCE	NUMBER				Display sequence for sections on deviations summary page.
LABEL	VARCHAR2	60			Clause Label
MANDATORY_FLAG	VARCHAR2	1			Mandatory Flag
STANDARD_FLAG	VARCHAR2	1			Required when Expert Data is dumped
ORIG_ARTICLE_ID	NUMBER		18		Original Clause ID in case of Alternate Clause
SEC_LABEL	VARCHAR2	60			Section Label
ART_SEQ_ID	NUMBER		18		ID from Okc_K_Articles_B table.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
OKC_CLAUSE_DEVIATIONS_T_N1	Non Unique	Default	CLS_SEQUENCE_ID