OKC_K_POLICY_DEVIATION
This table captures the policy deviation for a contract.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OKC_K_POLICY_DEVIATION_PK |
ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| ID | NUMBER | 18 | Yes | Unique identifier of the contract clauses policy deviations. | ||
| DEVIATING_CLAUSE_ID | NUMBER | 18 | Yes | Reference to the unique identifier of the contract deviating clauses. | ||
| DNZ_CHR_ID | NUMBER | 18 | Yes | Reference to the unique identifier of the contract header. | ||
| MAJOR_VERSION | NUMBER | 18 | Yes | Reference to the major version of the contract. | ||
| RULE_CODE | VARCHAR2 | 30 | Yes | Indicates rule code or number from policy deviation document used to generate the deviation for the current clause. | ||
| RULE_DESCRIPTION | VARCHAR2 | 240 | Rule description from policy deviation document used to generate the deviation for the current clause. | |||
| MATCHED_POSITION_CODE | VARCHAR2 | 30 | Yes | Indicates the matched position code from policy deviation document for the current clause. | ||
| ISSUE | VARCHAR2 | 4000 | LLM generated summary as to why it matched with a position and what is the issue with the matched position? | |||
| SEVERITY_CODE | VARCHAR2 | 30 | Yes | Indicates the risk code from policy deviation document corresponding to matched position. | ||
| STANDARD_POSITION_SUMMARY | VARCHAR2 | 4000 | Two lines of small AI/LLM summary of standard position column text. | Obsolete | ||
| ISSUE_NUMBER | NUMBER | 9 | This indicates the issue number in the negotiation document. | |||
| CHANGE_REQUEST_SUMMARY | CLOB | This stores the change request summary from the negotiation document. | ||||
| STATUS | VARCHAR2 | 20 | This indicates the status of the negotiation change request/policy deviation. | |||
| REJECTION_REASON | VARCHAR2 | 4000 | Stores the Rejection Reply in case of negotiation flow. | |||
| 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. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| OKC_K_POLICY_DEVIATION | okc_k_headers_all_b | DNZ_CHR_ID, MAJOR_VERSION |
| OKC_K_POLICY_DEVIATION | okc_deviating_clauses | DEVIATING_CLAUSE_ID |
| okc_policy_recommendation | okc_k_policy_deviation | POLICY_DEVIATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_K_POLICY_DEVIATION_N1 | Non Unique | Default | DNZ_CHR_ID, MAJOR_VERSION |
| OKC_K_POLICY_DEVIATION_N2 | Non Unique | Default | RULE_CODE |
| OKC_K_POLICY_DEVIATION_N3 | Non Unique | Default | SEVERITY_CODE, DNZ_CHR_ID, MAJOR_VERSION |
| OKC_K_POLICY_DEVIATION_N4 | Non Unique | Default | DEVIATING_CLAUSE_ID |
| OKC_K_POLICY_DEVIATION_PK | Unique | Default | ID |