# DW_GOAL_PERFORMANCE_A

Performance Goals Aggregate Fact

## Details

Module: Goal Management

## Key Columns

GOAL_PLAN_ID, REVIEW_PERIOD_ID, ASSIGNMENT_ID, GOAL_PLAN_SET_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Assignment Identifier of worker. |  |
GOAL_PLAN_ID | NUMBER | 38 | 0 | True | Goal Plan Identifier | DW_GOAL_PLAN_D | GOAL_PLAN_ID
GOAL_PLAN_SET_ID | NUMBER | 38 | 0 | True | Goal Plan Set Identifier | DW_GOAL_PLAN_SET_D | GOAL_PLAN_SET_ID
REVIEW_PERIOD_ID | NUMBER | 38 | 0 | True | Review Period Identifier of the goal plan | DW_REVIEW_PERIOD_D | REVIEW_PERIOD_ID
ANCHOR_DATE | DATE |  |  |  | Anchor Date to get assignmnet related information |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Id of the person to whom the goal is assigned to. | DW_PERSON_D | PERSON_ID
DEPARTMENT_ID | NUMBER | 38 | 0 |  | Department Identifier#1 | DW_DEPARTMENT_D | DEPARTMENT_ID
REPORTING_ESTABLISHMENT_ID | NUMBER | 38 | 0 |  | Reporting Establishment Identifier#2 | DW_REPORTING_EST_D | REPORTING_EST_ID
JOB_ID | NUMBER | 38 | 0 |  | Job Identifier #3 | DW_JOB_D | JOB_ID
LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID
POSITION_ID | NUMBER | 38 | 0 |  | Position Identifier#4 | DW_POSITION_D | POSITION_ID
GRADE_ID | NUMBER | 38 | 0 |  | Grade Identifier#5 | DW_PAY_GRADE_D | GRADE_ID
LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 |  | Legal Employer#6 | DW_LEGAL_EMPLOYER_D | LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Identifier#7 | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 |  | Period of Service Identifier | DW_SERVICE_PERIOD_D | PERIOD_OF_SERVICE_ID
PERSON_TYPE_ID | NUMBER | 38 | 0 |  | Person Type | DW_PERSON_TYPE_D_TL | PERSON_TYPE_ID
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 38 | 0 |  | Assignment Status Type Identifier | DW_ASSIGNMENT_STATUS_D_TL | ASSIGNMENT_STATUS_TYPE_ID
MANAGER_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Manager Assignment Identifier | DW_PERSON_D | PERSON_ID
MANAGER_ID | NUMBER | 38 | 0 |  | Manager Person Identifier | DW_PERSON_D | PERSON_ID
SYSTEM_PERSON_TYPE | VARCHAR2 | 32 |  |  | Person Type in System |  |
PRIMARY_FLAG | VARCHAR2 | 32 |  |  | Represents overall Primary assignment |  |
PRIMARY_ASSIGNMENT_FLAG | VARCHAR2 | 32 |  |  | Primary assignment Flag |  |
ASSIGNMENT_NUMBER | VARCHAR2 | 32 |  |  | Assignment Number |  |
ASSIGNMENT_NAME | VARCHAR2 | 128 |  |  | Assignment Name |  |
WORKER_TYPE | VARCHAR2 | 32 |  |  | Identifies the type of record: either assignment (employee, CWK, applicant, non-workers) or a set of Terms | DW_WORKER_TYPE_D_TL | WORKER_TYPE
WORKER_CATEGORY | VARCHAR2 | 32 |  |  | Employee category example: Blue collar, Civil Servant, etc | DW_WORKER_CATEGORY_D_TL | WORKER_CATEGORY
ASSIGNMENT_CATEGORY | VARCHAR2 | 32 |  |  | User defined category. For example Full-Time Permanent or Part-Time Permanent | DW_ASSIGNMENT_CATEGORY_D_TL | ASSIGNMENT_CATEGORY
LEGISLATION_CODE | VARCHAR2 | 256 |  |  | Legislation of Assignment | DW_LEGISLATION_D_TL | LEGISLATION_CODE
ETHNICITY | VARCHAR2 | 32 |  |  | Person Ethnicity |  |
SEX | VARCHAR2 | 32 |  |  | Person Sex |  |
PAY_SYSTEM_STATUS | VARCHAR2 | 32 |  |  | Payroll status indicating whether the assignment is processed in payroll runs. |  |
PER_SYSTEM_STATUS | VARCHAR2 | 32 |  |  | HR status used to determine how the assignment is processed |  |
FULL_PART_TIME_FLAG | VARCHAR2 | 32 |  |  | Full Part Time Flag |  |
PERMANENT_TEMPORARY_FLAG | VARCHAR2 | 32 |  |  | Permanent Temporary Flag |  |
AGE_IN_YEARS | NUMBER | 38 | 0 |  | Person Age as of Event Date in Years |  |
AGE_IN_MONTHS | NUMBER | 38 | 0 |  | Person Age as of Event Date in months |  |
TENURE_IN_YEARS | NUMBER | 38 | 0 |  | Person Tenure as of Event Date in years |  |
TENURE_IN_MONTHS | NUMBER | 38 | 0 |  | Person Tenure as of Event Date in Months |  |
HEADCOUNT | NUMBER |  |  |  | Headcount Value |  |
FTE | NUMBER |  |  |  | FTE Value |  |
TOTAL_GOALS | NUMBER | 38 | 0 |  | count of goals |  |
COMPLETED_GOALS | NUMBER | 38 | 0 |  | count of goals completed |  |
INCOMPLETE_GOALS | NUMBER | 38 | 0 |  | count of goals not completed |  |
TOTAL_GOALS_COMPLETE_IND | NUMBER | 38 | 0 |  | Indicator field if all goals are complted |  |
ALIGNED_GOALS | NUMBER | 38 | 0 |  | count of goals that are aligned |  |

## Notes

#1 For getting Organization hierarchy, DEPARTMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#2 For getting Organization hierarchy, REPORTING_ESTABLISHMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#3 DW_JOB_D may contain multiple records for a job. Join should also consider fact calendar date to get the dimension values.

#4 DW_POSITION_D may contain multiple records for a position. Join should also consider fact calendar date to get the dimension values.

#5 DW_PAY_GRADE_D may contain multiple records for a grade. Join should also consider fact calendar date to get the dimension values.

#6 For getting Organization hierarchy, LEGAL_EMPLOYER_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#7 For getting Organization hierarchy, BUSINESS_UNIT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

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