# DW_PERF_DOC_STATUS_F

Performance Document Status Fact

## Details

Module: Performance Management

## Key Columns

EVALUATION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
EVALUATION_ID | NUMBER | 38 | 0 | True | Business key of the performance document. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Key - EVALUATION_ID |  |
EVALUATION_DATE | DATE |  |  |  | The date on which the evaluation takes place |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Worker/person identifier | DW_PERSON_D | PERSON_ID
MANAGER_ID | NUMBER | 38 | 0 |  | Evaluation document manager identifier | DW_PERSON_D | PERSON_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment identifier on which the evaluation is performed |  |
TEMPLATE_DEFINITION_ID | NUMBER | 38 | 0 |  | Template Definitions identifier | DW_PERF_TEMPLATE_DEF_D | TEMPLATE_DEFINITION_ID
TEMPLATE_PERIOD_ID | NUMBER | 38 | 0 |  | Template Period identifier | DW_PERF_TEMPLATE_PERIOD_D | TEMPLATE_PERIOD_ID
STATUS_CODE | VARCHAR2 | 32 |  |  | The status code of the performance document |  |
PREV_STATUS_CODE | VARCHAR2 | 32 |  |  | The previous status code of the performance document |  |
START_DATE | DATE |  |  |  | Start Date of performance document |  |
END_DATE | DATE |  |  |  | End Date of performance document |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |

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