Oracle Fusion · Data dictionary
HWM_GRP_CRITERIA
SharedUsed in 0 subject areas34 reporting columnsBICC incremental-ready
Source object in the Oracle Fusion data model.
Likely primary key: GRP_CRITERIA_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDL_ATTR_CATEGORY | ● | Addl attribute category. | |
| ADDL_ATTR_CHAR1 | ● | Addl attribute char1. | |
| ADDL_ATTR_CHAR2 | ● | Addl attribute char2. | |
| ADDL_ATTR_CHAR3 | ● | Addl attribute char3. | |
| ADDL_ATTR_CHAR4 | ● | Addl attribute char4. | |
| ADDL_ATTR_CHAR5 | ● | Addl attribute char5. | |
| ADDL_ATTR_NUMBER1 | ● | Addl attribute number1. | |
| ADDL_ATTR_NUMBER2 | ● | Addl attribute number2. | |
| ADDL_ATTR_NUMBER3 | ● | Addl attribute number3. | |
| ADDL_ATTR_NUMBER4 | ● | Addl attribute number4. | |
| ADDL_ATTR_NUMBER5 | ● | Addl attribute number5. | |
| BOOL_OPER_CD | ● | Bool oper code. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CRITERIA_DISPLAY_NAME | ● | Name of the criteria display. | |
| CRITERIA_ID | ● | Identifier for the criteria. | |
| CRITERIA_NAME | ● | Name of the criteria. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| GRP_CRITERIA_ID | PK? | ● | Identifier for the grp criteria. |
| GRP_ID | ● | Identifier for the grp. | |
| 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. | |
| LEFT_PARAM_NUM | ● | Left param number. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| OPERATOR_ID | ● | Identifier for the operator. | |
| OPERATOR_NAME | ● | Name of the operator. | |
| ORDR_NUM | ● | Ordr number. | |
| RIGHT_PARAM_NUM | ● | Right param number. | |
| SEED_DATA_SOURCE | ● | Seed data source. | |
| VALUE_CHAR | ● | Value char. | |
| VALUE_DATE | ● | Value date. | |
| VALUE_NUMBER | ● | Value number. | |
| VALUE_TS | ● | Value ts. |
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_GRP_CRITERIA?
We ship parameterized SQL, BICC config, and dbt models you own.