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.