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