DOO_TASK_INSTANCES
This table holds Task Instances.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
DOO_TASK_INSTANCES_PK |
TASK_INSTANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TASK_INSTANCE_ID | NUMBER | 18 | Yes | Unique identifier for the orchestration process task instance. | |
| OPERATION_CODE | VARCHAR2 | 50 | Indicates the task level operation | ||
| COMPENSATION_PATTERN | VARCHAR2 | 200 | indicate interaction with external systems | ||
| ACK_CORRELATION_ID | VARCHAR2 | 50 | Contains the correlation ID that the task layer request interface composite is using to listen for an abort signal. This should usually be the same as the taskInstanceId except when aggregator is being used. With aggregator, this will be the taskInstanceId of the primary requester. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| DOO_PROCESS_INSTANCE_ID | NUMBER | 18 | Yes | Reference to the unique identifier of an orchestration process instance | |
| TASK_ID | NUMBER | 18 | Reference to the unique identifier of the task | ||
| STEP_ACTIVE | VARCHAR2 | 30 | Indicates whether step is active or not | ||
| PLANNED_START_DATE | DATE | The date a task is intended to begin. | |||
| PLANNED_COMPLETION_DATE | DATE | Planned Completion date of the task. | |||
| SCHEDULED_START_DATE | DATE | The date when a task is scheduled to begin. | |||
| SCHEDULED_COMPLETION_DATE | DATE | The scheduled date of completion of a task. | |||
| ACTUAL_START_DATE | DATE | The date that work commenced on a task. | |||
| ACTUAL_COMPLETION_DATE | DATE | The date when task is completed. | |||
| REQUIRED_START_DATE | DATE | The date when a task is required to begin. | |||
| REQUIRED_COMPLETION_DATE | DATE | Date when a task is required to be completed by, in order to meet the promised date of the order. | |||
| STATUS_CODE | VARCHAR2 | 30 | State or condition of a task. | ||
| JEOPARDY_SCORE | NUMBER | The number that specifies the severity of the delayed task. | |||
| JEOPARDY_REASON | VARCHAR2 | 128 | Reason entered by user to explain why the jeopardy score is set. | ||
| ROOT_PARENT_GROUP_ID | NUMBER | 18 | Reference to the unique identifier of the root node of a group hierarchy. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ORIGINAL_TASK_INSTANCE_ID | NUMBER | 18 | Internal column used to store the original task instance in case of changes to the process | ||
| REFERENCE_TASK_INSTANCE_ID | NUMBER | 18 | Internal column used to store the reference task instance in case of changes to the process | ||
| ORCHESTRATION_APP_ATTRIBUTE1 | NUMBER | 18 | This is the Custom columns to store product specific information. | ||
| ORCHESTRATION_APP_ATTRIBUTE2 | NUMBER | 18 | This is the Custom columns to store product specific information. | ||
| ORCHESTRATION_APP_ATTRIBUTE3 | VARCHAR2 | 256 | This is the Custom columns to store product specific information. | ||
| ORCHESTRATION_APP_ATTRIBUTE4 | VARCHAR2 | 256 | This is the Custom columns to store product specific information. | ||
| ORCHESTRATION_APP_ATTRIBUTE5 | VARCHAR2 | 256 | This is the Custom columns to store product specific information. | ||
| ORCHESTRATION_APP_ATTRIBUTE6 | VARCHAR2 | 256 | This is the Custom columns to store product specific information. | ||
| ORCHESTRATION_APP_ATTRIBUTE7 | VARCHAR2 | 256 | This is the Custom columns to store product specific information. | ||
| ORCHESTRATION_APP_ATTRIBUTE8 | DATE | This is the Custom columns to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE9 | DATE | This is the Custom columns to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE10 | DATE | This is the Custom columns to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE11 | DATE | This is the Custom columns to store product specific information. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| DOO_TASK_INSTANCES | doo_process_instances | DOO_PROCESS_INSTANCE_ID |
| doo_activities | doo_task_instances | TASK_INSTANCE_ID |
| doo_process_step_instances | doo_task_instances | TASK_INSTANCE_ID |
| doo_aggregation_task_instances | doo_task_instances | TASK_INSTANCE_ID |
| doo_jeopardy_score_history | doo_task_instances | TASK_INSTANCE_ID |
| doo_error_recovery_instances | doo_task_instances | TASK_INSTANCE_ID |
| doo_gantt_split_units | doo_task_instances | TASK_INSTANCE_ID |
| doo_task_status_history | doo_task_instances | TASK_INSTANCE_ID |
| doo_hold_task_instances | doo_task_instances | TASK_INSTANCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_TASK_INSTANCES_FK1 | Non Unique | Default | DOO_PROCESS_INSTANCE_ID |
| DOO_TASK_INSTANCES_N1 | Non Unique | Default | ORIGINAL_TASK_INSTANCE_ID |
| DOO_TASK_INSTANCES_N2 | Non Unique | Default | ACK_CORRELATION_ID |
| DOO_TASK_INSTANCES_N3 | Non Unique | Default | REFERENCE_TASK_INSTANCE_ID |
| DOO_TASK_INSTANCES_PK | Unique | Default | TASK_INSTANCE_ID |