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