This dimension Stores the task roles involved in the process flow definition
Module: Performance Management
PROCESS_TASK_ROLE_ID, BUSINESS_GROUP_ID
| 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, 2024, Oracle and/or its affiliates.