Stores comments for each evaluation and for each overall section
Module: Performance Management
BUSINESS_GROUP_ID, EVAL_SECTION_ID, EVALUATION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
EVALUATION_ID | NUMBER | 38 | 0 | True | Performance Document identifier | DW_PERF_DOC_STATUS_F | EVALUATION_ID |
EVAL_SECTION_ID | NUMBER | 38 | 0 | True | Overall section identifier | DW_PERF_EVAL_SECTION_D | EVAL_SECTION_ID |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | True | Business Group Identifier | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Unique Source Record Identifier with evaluation_id and eval_section_id and business_group_id | ||||
MANAGER_PARTICIPANT_ID | NUMBER | 38 | 0 | Participant ID of the manager in the evaluation | |||
WORKER_PARTICIPANT_ID | NUMBER | 38 | 0 | Participant ID of the worker in the evaluation | |||
MANAGER_OVERALL_COMMENTS | VARCHAR2 | 999 | Manager overall comments | ||||
WORKER_OVERALL_COMMENTS | VARCHAR2 | 999 | Worker overall comments |