DW_PERF_PARTICIPANT_D

This dimension captures the Evaluation Participant details

Details

Module: Performance Management

Key Columns

EVAL_PARTICIPANT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EVAL_PARTICIPANT_ID NUMBER 38 0 True Participant Id    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. unique key    
EVALUATION_ID NUMBER 38 0   Reference to Evaluation. Primary key of Evaluation    
PERSON_ID NUMBER 38 0   The global ID of the person who is nominated as the participant DW_PERSON_D PERSON_ID
ROLE_TYPE_CODE VARCHAR2 32     Indicates the code to identify the type of role (MANAGER, WORKER or PARTICIPANT) DW_ROLE_TYPE_D_TL ROLE_TYPE_CODE
PARTICIPATION_STATUS_CODE VARCHAR2 32     Indicates the status of the participant DW_PARTICIPATION_STATUS_D_TL PARTICIPATION_STATUS_CODE

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