HWM_RULE_TMPLTS

SharedUsed in 0 subject areas30 reporting columnsBICC incremental-ready

Source object in the Oracle Fusion data model.

Likely primary key: RULE_TMPLTS_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

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.
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_NAME		●	Name of the process.
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_SUB_TYPE		●	Type of rule sub.
RULE_TMPLTS_ID	PK?	●	Identifier for the rule tmplts.
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.
SEEDED_FLAG		●	Indicator (Y/N) for the seeded.
SEED_DATA_SOURCE		●	Seed data source.
SUPPRESS_DUP_MSGS		●	Suppress dup msgs.
TEMPLATE_NAME		●	Name of the template.
TEMPLATE_TYPE		●	Type of template.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Need the extract + dbt staging for HWM_RULE_TMPLTS?

We ship parameterized SQL, BICC config, and dbt models you own.