DW_PERF_EVAL_OS_COMMENTS_D

Stores comments for each evaluation and for each overall section

Details

Module: Performance Management

Key Columns

EVAL_SECTION_ID, EVALUATION_ID, BUSINESS_GROUP_ID

Columns

Columns
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 This column is for Oracle Internal use only. 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