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 This column is for Oracle Internal use only. 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
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.

Notes

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