Oracle Fusion · Data dictionary
HWM_RULES
SharedUsed in 0 subject areas29 reporting columnsBICC incremental-ready
Source object in the Oracle Fusion data model.
Likely primary key: RULE_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): RULE_TMPLTS_ID → HWM_RULE_TMPLTS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CLASSIFICATION | ● | Classification. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DESCRIPTION | ● | Description. | |
| DFLT_ALLOCATION_ID | ● | Identifier for the dflt allocation. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| FAST_FORMULA_EXEC_TYPE | ● | Type of fast formula exec. | |
| INCLUDE_EMPTY_TC | ● | Include empty tc. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| MODULE_ID | ● | Identifier for the module. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PROCESS_TYPE | ● | Type of process. | |
| PRS_FORMULA_ID | ● | Identifier for the prs formula. | |
| PRS_SCRIPT_ID | ● | Identifier for the prs script. | |
| RULE_EXEC_TYPE | ● | Type of rule exec. | |
| RULE_ID | PK? | ● | Identifier for the rule. |
| RULE_NAME | ● | Name of the rule. | |
| RULE_SUB_TYPE | ● | Type of rule sub. | |
| RULE_TMPLTS_ID | ● | Identifier for the rule tmplts. | |
| RULE_TYPE | ● | Type of rule. | |
| RUN_EVENT_DELETE | ● | Run event delete. | |
| RUN_EVENT_RESUB | ● | Run event resub. | |
| RUN_EVENT_SAVE | ● | Run event save. | |
| RUN_EVENT_SUB | ● | Run event sub. | |
| RUN_SUMMATION_LEVEL | ● | Run summation level. | |
| RUN_TBB_LEVEL | ● | Run tbb level. | |
| SUPPRESS_DUP_MSGS | ● | Suppress dup msgs. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for HWM_RULES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table