Stores information of evaluation ratings for item/section for an assignment rated by different roles for different evaluations
Module: Performance Management
EVAL_RATING_ID
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 |
#1 If it is section type then it will refer to dimension DW_PERF_EVAL_SECTION_DEF_D to column EVAL_SECTION_ID