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 This column is for Oracle Internal use only. 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
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.