OKC_AI_EXPERT_RECOMMENDATIONS
Stores Contract Expert policy clause recommendations and auto-applied actions for contract terms.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OKC_AI_EXPERT_RECOMMEND_PK |
ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 18 | Yes | Unique identifier of the expert policy clauses. | |
| RULE_ID | NUMBER | 18 | Rule id of expert policy. | ||
| RULE_NAME | VARCHAR2 | 240 | Rule name of expert policy. | ||
| RULE_DESCRIPTION | VARCHAR2 | 1000 | Rule description of expert policy. | ||
| RULE_EXEC_MODE | VARCHAR2 | 30 | Rule execution mode of expert policy. Possible values are AUTO_APPLIED and RECOMMENDATION. | ||
| CLAUSE_ACTION | VARCHAR2 | 20 | Add or replace action on the expert clause. Possible values are ADD and REPLACE. | ||
| ARTICLE_VERSION_ID | NUMBER | 18 | Expert clause article version id. Foreign key to okc_article_versions. | ||
| OLD_ARTICLE_VERSION_ID | NUMBER | 18 | Replaced clause article version id. Foreign key to okc_article_versions. | ||
| K_ARTICLE_ID | NUMBER | 18 | Expert clause id. Foreign key to okc_k_articles_b. | ||
| STATUS | VARCHAR2 | 20 | Expert clause action execution status into contract terms. Possible values are ACCEPTED and NOT_ACCEPTED. | ||
| WARNING_MESSAGE | VARCHAR2 | 1000 | Warning or error message encountered in expert clause action execution. | ||
| DOCUMENT_ID | NUMBER | 18 | Yes | Business document id. Foreign key to okc_template_usages. | |
| DOCUMENT_TYPE | VARCHAR2 | 30 | Yes | Business document type. Foreign key to okc_template_usages. | |
| MAJOR_VERSION | NUMBER | 18 | Yes | Major version. Foreign key to okc_template_usages. | |
| 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_AI_EXPERT_RECOMMENDATIONS | okc_article_versions | ARTICLE_VERSION_ID |
| OKC_AI_EXPERT_RECOMMENDATIONS | okc_article_versions | OLD_ARTICLE_VERSION_ID |
| OKC_AI_EXPERT_RECOMMENDATIONS | okc_k_articles_b | K_ARTICLE_ID |
| OKC_AI_EXPERT_RECOMMENDATIONS | okc_template_usages | DOCUMENT_ID, DOCUMENT_TYPE, MAJOR_VERSION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_AI_EXPERT_RECOMMEND_N1 | Non Unique | Default | ARTICLE_VERSION_ID, OLD_ARTICLE_VERSION_ID |
| OKC_AI_EXPERT_RECOMMEND_N2 | Non Unique | Default | CLAUSE_ACTION, STATUS |
| OKC_AI_EXPERT_RECOMMEND_N3 | Non Unique | Default | DOCUMENT_ID, DOCUMENT_TYPE, MAJOR_VERSION |
| OKC_AI_EXPERT_RECOMMEND_PK | Unique | Default | ID |