OKC_TERMS_DEVIATIONS_T
Temporary Table to store Contract Standard Deviations data
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
OKC_TERMS_DEVIATIONS_T_PK |
DEVIATION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
DEVIATION_ID | NUMBER | 18 | Yes | Primary key column. | |
DEVIATION_CATEGORY | VARCHAR2 | 30 | Deviation Category | ||
DEVIATION_CODE | VARCHAR2 | 240 | Deviation rule name | ||
DEVIATION_CATEGORY_MEANING | VARCHAR2 | 80 | Deviation Category Meaning | ||
DEVIATION_CODE_MEANING | VARCHAR2 | 2000 | Deviation rule description | ||
DEVIATION_CATEGORY_PRIORITY | NUMBER | Deviation Category Priority | |||
SEQUENCE_ID | NUMBER | 18 | Yes | Unique Sequence ID generated every time the deviations report is run. | |
SCN_ID | NUMBER | 18 | Section ID | ||
SECTION_HEADING | VARCHAR2 | 300 | Section Heading | ||
DOC_ARTICLE_ID | NUMBER | 18 | Document Clause ID | ||
DOC_ARTICLE_VERSION_ID | NUMBER | 18 | Document Clause Version ID | ||
LABEL | VARCHAR2 | 60 | Clause Label | ||
SCN_LABEL | VARCHAR2 | 60 | Section Label | ||
ARTICLE_TITLE | VARCHAR2 | 450 | Clause Title | ||
REF_ARTICLE_ID | NUMBER | 18 | Reference Clause ID | ||
REF_ARTICLE_VERSION_ID | NUMBER | 18 | Reference Clause Version ID | ||
MANDATORY_FLAG | VARCHAR2 | 1 | Mandatory Flag | ||
ARTICLE_STATUS | VARCHAR2 | 30 | Clause Status | ||
COMPARE_TEXT_FLAG | VARCHAR2 | 1 | Compare Text Flag | ||
ORIG_ARTICLE_ID | NUMBER | 18 | Original Clause ID | ||
ART_SEQ_ID | NUMBER | 18 | ID from okc_k_articles_b | ||
LOCK_TEXT_MOD_FLAG | VARCHAR2 | 1 | Lock text Modified flag | ||
DISPLAY_SEQUENCE | NUMBER | Display sequence for sections on deviations summary page. | |||
DOCUMENT_TYPE | VARCHAR2 | 30 | Document type | ||
DOCUMENT_ID | NUMBER | 18 | Document Id | ||
SCN_SEQUENCE | NUMBER | Section Sequence | |||
RULE_ID | NUMBER | 18 | Rule_Id of a deviation rule | ||
DEVIATION_TYPE | VARCHAR2 | 1 | Identifies the deviation type. P: Policy Deviation C: Clause Deviation | ||
LINE_NUMBER | VARCHAR2 | 250 | Unique line number | ||
ITEM_NAME | VARCHAR2 | 2000 | Item name | ||
ITEM_DESCRIPTION | VARCHAR2 | 2000 | Item Description | ||
OBJECT_TYPE | VARCHAR2 | 30 | Indicates if LHS of condition is Variable or Question. | ||
OBJECT_CODE | VARCHAR2 | 40 | Variable code or Question id | ||
OBJECT_DESCRIPTION | VARCHAR2 | 2000 | Variable name or Question prompt | ||
DOCUMENT_VALUE | VARCHAR2 | 2000 | Value in the current document | ||
ARTICLE_DESCRIPTION | VARCHAR2 | 2000 | Clause description | ||
DEVIATION_APPROVAL_FLAG | VARCHAR2 | 1 | This flag is used to identify the deviations used in contract approval rules. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
OKC_TERMS_DEVIATIONS_T | okc_xprt_rule_hdrs_all | RULE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
OKC_TERMS_DEVIATIONS_T_N1 | Non Unique | Default | SEQUENCE_ID |
OKC_TERMS_DEVIATIONS_T_U1 | Unique | Default | DEVIATION_ID |