DW_PERF_EVAL_RATING_F

Stores information of evaluation ratings for item/section for an assignment rated by different roles for different evaluations

Details

Module: Performance Management

Key Columns

EVAL_RATING_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EVAL_RATING_ID NUMBER 38 0 True Primary key of the Performance Rating    
SOURCE_RECORD_ID VARCHAR2 64     Unique Source Record Identifier with eval_rating_id.    
EVALUATION_ID NUMBER 38 0   Performance Document Key refers to base Evaluation fact. DW_PERF_DOC_STATUS_F EVALUATION_ID
BUSINESS_GROUP_ID NUMBER 38 0   Business Group    
REFERENCE_TYPE VARCHAR2 256     Evaluation Type.It can be Item or Section    
REFERENCE_ID NUMBER 38 0   If Reference type is Item will point to Item. if Section type then points to Section.#1 DW_PERF_EVAL_ITEM_D EVAL_ITEM_ID
PERFORMANCE_RATING_ID NUMBER 38 0   Indicates the rating level for the performance. Uses performance rating model DW_RATING_LEVEL_D RATING_LEVEL_ID
PROFICIENCY_RATING_ID NUMBER 38 0   Indicates the rating level for the proficiency. Uses proficiency rating model DW_RATING_LEVEL_D RATING_LEVEL_ID
EVAL_PARTICIPANT_ID NUMBER 38 0   Any person other than the employee/worker or manager who participates in the performance evaluation business process. DW_PERF_PARTICIPANT_D EVAL_PARTICIPANT_ID
ROLE_TYPE_CODE VARCHAR2 256     Indicates which role type has given the rating. This code refers to common look up.    
CALCULATED_RATING NUMBER       Indicates the value of the rating calculated from fast formulas    

Notes

#1 If it is section type then it will refer to dimension DW_PERF_EVAL_SECTION_DEF_D to column EVAL_SECTION_ID

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