DW_PERF_TASK_ROLE_D

This dimension Stores the task roles involved in the process flow definition

Details

Module: Performance Management

Key Columns

BUSINESS_GROUP_ID, PROCESS_TASK_ROLE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROCESS_TASK_ROLE_ID NUMBER 38 0 True Unique process flow task role Id. Refer to "DW_PERF_TASK_ROLES_D_TL" for task name    
BUSINESS_GROUP_ID NUMBER 38 0 True Stores the business group id    
SOURCE_RECORD_ID VARCHAR2 256     unique key    
PROCESS_FLOW_ID NUMBER 38 0   Indicates the Process Flow definition that is used in this template definition    
STEP_CODE VARCHAR2 32     Task Code this is a lookup value for all the task that can be performed DW_PROCESS_TASK_CODE_D_TL STEP_CODE
SEQUENCE_NUMBER NUMBER 38 0   Sequence number for the task for this process flow