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

HRG_GOALS

SharedUsed in 0 subject areas130 reporting columnsBICC incremental-ready

Source object in the Oracle Fusion data model.

Likely primary key: GOAL_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V

Columns

ColumnKeyIn reportsDescription (inferred)
ACCESS_TO_HIERARCHY_FLAG●Indicator (Y/N) for the access to hierarchy.
ACTIVE_FLAG●Indicator (Y/N) for the active.
ACTUAL_COMPLETION_DATE●Actual completion date.
ACTUAL_VALUE●Actual value.
ALLOW_DEL_GOAL_FLAG●Indicator (Y/N) for the allow del goal.
ALLOW_KEY_ATTR_UPDATE_FLAG●Indicator (Y/N) for the allow key attribute update.
APPROVAL_STATUS_CODE●Code identifying the approval status.
APPROVER_RESPONSE_CODE●Code identifying the approver response.
ASSIGNED_BY_PERSON_ID●Identifier for the assigned by person.
ASSIGNMENT_ID●Identifier for the assignment.
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE13●Descriptive flexfield segment.
ATTRIBUTE_DATE14●Descriptive flexfield segment.
ATTRIBUTE_DATE15●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER13●Descriptive flexfield segment.
ATTRIBUTE_NUMBER14●Descriptive flexfield segment.
ATTRIBUTE_NUMBER15●Descriptive flexfield segment.
ATTRIBUTE_NUMBER16●Descriptive flexfield segment.
ATTRIBUTE_NUMBER17●Descriptive flexfield segment.
ATTRIBUTE_NUMBER18●Descriptive flexfield segment.
ATTRIBUTE_NUMBER19●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER20●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
BUSINESS_GROUP_ID●Identifier for the business group.
CATEGORY_CODE●Code identifying the category.
COMMENTS●Comments.
COMMENTS_TEXT●Comments text.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DESCRIPTION●Description.
GOAL_ACCESS_LEVEL_CODE●Code identifying the goal access level.
GOAL_APPROVAL_STATE●Goal approval state.
GOAL_EXT_ID●Identifier for the goal ext.
GOAL_IDPK?●Identifier for the goal.
GOAL_NAME●Name of the goal.
GOAL_SOURCE_CODE●Code identifying the goal source.
GOAL_SUB_TYPE_CODE●Code identifying the goal sub type.
GOAL_TYPE_CODE●Code identifying the goal type.
GOAL_URL●Goal url.
GOAL_VERSION_TYPE_CODE●Code identifying the goal version type.
HRCHY_ACCESS_GRANT_DATE●Hrchy access grant date.
INCLUDE_IN_PERFDOC_FLAG●Indicator (Y/N) for the include in perfdoc.
LAST_MODIFIED_BY●Last modified by.
LAST_MODIFIED_DATE●Last modified date.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●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.
LEVEL_CODE●Code identifying the level.
LEVEL_MEANING●Level meaning.
LONG_DESCRIPTION●Description of the long.
MASS_REQUEST_ID●Identifier for the mass request.
MEASURE_CALC_RULE_CODE●Code identifying the measure calc rule.
MEASURE_COMMENTS●Measure comments.
MEASURE_NAME●Name of the measure.
MEASURE_TYPE_CODE●Code identifying the measure type.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
ORGANIZATION_ID●Identifier for the organization.
PERCENT_COMPLETE_CODE●Code identifying the percent complete.
PERSON_ID●Identifier for the person.
PREVIOUS_STATE_GOAL_ID●Identifier for the previous state goal.
PRIORITY_CODE●Code identifying the priority.
PRIVATE_FLAG●Indicator (Y/N) for the private.
PUBLISHED_FLAG●Indicator (Y/N) for the published.
PUBLISH_DATE●Publish date.
REFERENCE_CONTENT_ITEM_ID●Identifier for the reference content item.
REFERENCE_GOAL_ID●Identifier for the reference goal.
REQUESTER_PERSON_ID●Identifier for the requester person.
REQUEST_CONTEXT●Request context.
START_DATE●Start date.
STATUS_CODE●Code identifying the status.
SUCCESS_CRITERIA●Success criteria.
SUCCESS_CRITERIA_TEXT●Success criteria text.
TARGET_COMPLETION_DATE●Target completion date.
TARGET_TYPE●Type of target.
TARGET_VALUE●Target value.
UOM_CODE●Code identifying the unit of measure.
VERSION_DATE●Version date.

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 HRG_GOALS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern