FUN_WF_RULES
This table contains approval rule metadata and assignment information.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FUN_WF_RULES_PK |
RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RULE_ID | NUMBER | 18 | Yes | Rule identifier and primary key. | |
| PARTICIPANT_ID | NUMBER | 18 | Yes | Foreign key to FUN_WF_PARTICIPANTS table. | |
| RULE_ALIAS | VARCHAR2 | 1000 | Yes | Alias rule entered by a user from the BPM worklist application. | |
| RULE_NAME | VARCHAR2 | 1000 | Yes | This is alias without spaces. This is only internal to BPM and not exposed to users on the UI. | |
| RULE_DESCRIPTION | VARCHAR2 | 1000 | Approval rule description as entered by the user on UI / Spreadsheet. | ||
| RULE_INDEX | NUMBER | 18 | Yes | Serial number by which rules are displayed on the BPM worklist applcication. | |
| ACTIVE_FLAG | VARCHAR2 | 1 | Yes | Value to indicate whether rule is active or not. | |
| ADVANCE_MODE_FLAG | VARCHAR2 | 1 | Yes | Indicator of whether rule is in advance mode. | |
| TREE_MODE_FLAG | VARCHAR2 | 1 | Yes | Indicator of whether rule is in tree mode. | |
| RULE_PRIORITY_CODE | VARCHAR2 | 64 | Yes | Priority determines the order in which rules are evaluated in the ruleset. | |
| RULE_START_DATE | TIMESTAMP | Effective start date of the approval rule per the database time zone. | |||
| RULE_END_DATE | TIMESTAMP | Effective end date of the approval rule per the database time zone. | |||
| 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. | |
| 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. | ||
| SOURCE_CODE | VARCHAR2 | 30 | Source of the business condition. | ||
| SOURCE_ID | NUMBER | 18 | Used for mapping a rule to a Sensor ID / Dataset ID etc. | ||
| IMPLICIT_FLAG | VARCHAR2 | 1 | Used to determine whether a rule is implicit or not | ||
| SQL_FILTER | BLOB | SQL Payload corresponding to the business conditions | |||
| BOSS_FILTER | BLOB | BOSS Extraction Payload corresponding to the business conditions | |||
| CATEGORY_CODE | VARCHAR2 | 30 | Indicates logical grouping of related rules. Valid values include Variance, Operational, Reconciliation, and so on. | ||
| TIMESPAN | VARCHAR2 | 4000 | Specifies the time window or schedule duration for rule execution. | ||
| CATALOG_FLAG | VARCHAR2 | 1 | Indicates whether the rule is a reusable catalog template. Valid values are Y or N. | ||
| RULE_ACTION_TYPE_CODE | VARCHAR2 | 30 | Specifies the type of insight generated from rule when it is triggered. | ||
| REFERENCE_RULE_ID | NUMBER | 18 | Identifies the catalog rule from which the active rule was created. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FUN_WF_RULES | fun_wf_participants | PARTICIPANT_ID |
| fun_wf_conditions | fun_wf_rules | RULE_ID |
| fun_wf_actions | fun_wf_rules | RULE_ID |
| fun_wf_patterns | fun_wf_rules | RULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| FUN_WF_RULES_FK1 | Non Unique | Default | PARTICIPANT_ID | |
| FUN_WF_RULES_N1 | Non Unique | Default | SOURCE_CODE | |
| FUN_WF_RULES_N2 | Non Unique | Default | SOURCE_ID, RULE_NAME, ORA_SEED_SET1 | |
| FUN_WF_RULES_N21 | Non Unique | Default | SOURCE_ID, RULE_NAME, ORA_SEED_SET2 | |
| FUN_WF_RULES_PK | Unique | Default | RULE_ID | Obsolete |
| FUN_WF_RULES_U1 | Unique | Default | RULE_ID, ORA_SEED_SET1 | |
| FUN_WF_RULES_U11 | Unique | Default | RULE_ID, ORA_SEED_SET2 |