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     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