POI_RULES
This table contains information about the rules that are run during the classification process. Rules can be run before (rule type is preprocessing) or after (rule type is postprocessing) the artificial intelligence or machine learning engine starts suggesting categories for each transaction.
Details
-
Schema: FUSION
-
Object owner: POI
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
POI_RULES_PK |
RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RULE_ID | NUMBER | 18 | Yes | Uniquely identifies the business rule. | |
| RULE_NAME | VARCHAR2 | 200 | Yes | Name of the defined business rule. | |
| DESCRIPTION | VARCHAR2 | 2000 | Description of the defined rule. | ||
| TYPE | VARCHAR2 | 30 | Yes | Type of rule defined for the rule. | |
| SEQUENCE | NUMBER | 18 | Yes | Sequence number given for the rule. | |
| CONDITION_TYPE | VARCHAR2 | 30 | Condition type of the defined rule. | ||
| ACTION_TYPE | VARCHAR2 | 30 | Action type of the defined rule. | ||
| ON_ATTRIBUTE | VARCHAR2 | 100 | Attribute name on which the rule has to be applied. | ||
| ACTION_CONDITION | VARCHAR2 | 100 | Action condition of the defined rule. | ||
| TO_ATTRIBUTE | VARCHAR2 | 100 | To attribute value of the defined rule. | ||
| TO_CONST_VALUE | VARCHAR2 | 100 | Constant value of the defined rule. | ||
| RUN_COUNT | NUMBER | 18 | Applied run count of the business rule. | ||
| LAST_RUN_DATE | DATE | Date on which rule was last run. | |||
| RUN_MESSAGE | VARCHAR2 | 100 | Message value on running the rule. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| SQL_CLAUSE | VARCHAR2 | 2000 | sql_clause value of the defined rule. | ||
| KB_TYPE | VARCHAR2 | 30 | Identifies the type of knowledge base. | ||
| DS_TYPE | VARCHAR2 | 30 | Identifies the type of data set. | ||
| START_DATE | DATE | Effective start date of the defined rule. | |||
| END_DATE | DATE | Effective end date of the defined rule. | |||
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POI_RULES_U1 | Unique | Default | RULE_ID |
| POI_RULES_U2 | Unique | Default | RULE_NAME, SEQUENCE |