# DW_GOAL_F

Goals Fact stores all worker goals

## Details

Module: Goal Management

## Key Columns

GOAL_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
GOAL_ID | NUMBER | 38 | 0 | True | Goals identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Functional key of records. Goal Id |  |
REFERENCE_GOAL_ID | NUMBER | 38 | 0 |  | Reference Goal Identifier |  |
ORGANIZATION_ID | NUMBER | 38 | 0 |  | Reference to the organization to which goal is being created. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier holds assignment of worker. |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Id of the person to whom the goal is assigned to. | DW_PERSON_D | PERSON_ID
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business group Identifier |  |
PRIVATE_FLAG | VARCHAR2 | 32 |  |  | Flag to indicate whether this goal is accessible to others or not |  |
ACTIVE_FLAG | VARCHAR2 | 32 |  |  | Active flag of goals |  |
PUBLISHED_FLAG | VARCHAR2 | 32 |  |  | Flag to indicate if Organization goal is published |  |
PUBLISH_DATE | TIMESTAMP |  |  |  | Publish date |  |
START_DATE | DATE |  |  |  | Start date of goal. |  |
TARGET_COMPLETION_DATE | DATE |  |  |  | Target completion date of gaol. |  |
ACTUAL_COMPLETION_DATE | DATE |  |  |  | Actual completion date of goal. |  |
GOAL_VERSION_TYPE_CODE | VARCHAR2 | 32 |  |  | Contains codes to indentify worker goals |  |
GOAL_TYPE_CODE | VARCHAR2 | 32 |  |  | Type of goal |  |
GOAL_SUB_TYPE_CODE | VARCHAR2 | 256 |  |  | Goal Sub Type Code |  |
GOAL_CATEGORY_CODE | VARCHAR2 | 32 |  |  | Contains category for a goal. |  |
GOAL_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of goal |  |
GOAL_SOURCE_CODE | VARCHAR2 | 32 |  |  | Source of assignment goals. |  |
PRIORITY_CODE | VARCHAR2 | 32 |  |  | Priority of goal. Possible values are High, Medium and Low. |  |
PERCENT_COMPLETE_CODE | VARCHAR2 | 32 |  |  | Goal completion percentage code. |  |
GOAL_NAME | VARCHAR2 | 512 |  |  | Name of goal. |  |
DW_INITIAL_RECORD_IND | NUMBER | 38 | 0 |  | This indicates whether the goal is created after the Initial Extract Date |  |
CREATION_DATE | TIMESTAMP |  |  |  | creation date |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.