DW_PERF_TASK_STATUS_F

This table stores Evaluation Tasks per Evaluation per Role.

Details

Module: Performance Management

Key Columns

EVAL_STEP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EVAL_STEP_ID NUMBER 38 0 True Primary key of Steps    
SOURCE_RECORD_ID VARCHAR2 64     Unique Source Record Identifier consisting of eval_step_id    
BUSINESS_GROUP_ID NUMBER 38 0   Business Group identifier    
EVALUATION_ID NUMBER 38 0   Evaluation identifier DW_PERF_DOC_STATUS_F EVALUATION_ID
PARENT_STEP_ID NUMBER 38 0   Parent step identifier to the current step    
EVAL_PARTICIPANT_ID NUMBER 38 0   Participant identifier in a particular evaluation DW_PERF_PARTICIPANT_D EVAL_PARTICIPANT_ID
STEP_CODE VARCHAR2 32     Indicates the step code for the evaluation    
STEP_STATUS VARCHAR2 32     Indicates the step status of the evaluation    
DUE_DATE DATE       This is the due date of the step code    
STEP_COMPLETION_DATE DATE       Indicatest the date on which this step is completed    
SEQUENCE_NUMBER NUMBER 38 0   Indicates the processing sequence for the step    

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