DW_PERF_EVAL_OS_COMMENTS_D

Stores comments for each evaluation and for each overall section

Details

Module: Performance Management

Key Columns

BUSINESS_GROUP_ID, EVALUATION_ID, EVAL_SECTION_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     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    

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