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 |