Analytics Catalog/Data dictionary/HRM_PLAN_OWNERS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

HRM_PLAN_OWNERS

SharedUsed in 0 subject areas13 reporting columnsBICC incremental-ready

Source object in the Oracle Fusion data model.

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

Columns

ColumnKeyIn reportsDescription (inferred)
CREATED_BYUser who created the row.
CREATION_DATEDate and time the row was created.
DATE_FROMDate from.
ENTERPRISE_IDIdentifier for the enterprise.
LAST_UPDATED_BYUser who last updated the row.
LAST_UPDATE_DATEINCRDate and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGINSession login of the user who last updated the row.
LATEST_RECORD_FLAGIndicator (Y/N) for the latest record.
OBJECT_VERSION_NUMBEROptimistic-locking version number, incremented on each update.
OWNER_TYPE_CODECode identifying the owner type.
PERSON_IDIdentifier for the person.
PLAN_IDIdentifier for the plan.
PLAN_OWNER_IDPK?Identifier for the plan owner.

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 HRM_PLAN_OWNERS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us