# DW_PERF_TASK_ROLE_D

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

## Details

Module: Performance Management

## Key Columns

PROCESS_TASK_ROLE_ID, BUSINESS_GROUP_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 |  |  | This column is for Oracle Internal use only. 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 |  |

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