CSO_TASK_WORK_UNITS
This table contains a general list of task work units that are currently being processed, will be processed, or were already processed. A task work unit can be a single piece of data or a group of data that need to be processed together. Each task work unit is picked up by an internal process to be processed in parallel with other task work units.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_TASK_WORK_UNITS_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| DATE_ADDED | TIMESTAMP | This is the datetime that the record was added. | ||
| DATE_MODIFIED | TIMESTAMP | This is the datetime that the record was modified - updated every time user stops/starts GFR job. | ||
| SCHEDULED_TIME | TIMESTAMP | This is the datetime that the task work unit will be picked up to be processed. | ||
| TYPE | VARCHAR2 | 30 | This value is used to describe the type of work that this task will be performing. | |
| TASK_DATA | CLOB | This contains any information to be used during the processing of this task work unit. | ||
| STATUS | VARCHAR2 | 50 | This value is used to describe the current processing state of this task work unit. | |
| STATUS_DATA | CLOB | This contains any information that would describe what happened during the processing of this task work unit. | ||
| CLUSTER_NAME | VARCHAR2 | 255 | This value is used to describe the current cluster that this is being processed in. | |
| POD_NAME | VARCHAR2 | 255 | This value is used to describe the current pod that this is being processed in. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cso_bulk_update_doc_detail | cso_task_work_units | WORK_UNIT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_TASK_WORK_UNITS_U1 | Unique | Default | RECORD_ID |