This table requires activation of Advanced Collections functional area. This table stores strategy task work items
Module: Advanced Collections
WORK_ITEM_TEMP_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| WORK_ITEM_TEMP_ID | NUMBER | 38 | 0 | True | Work Item Template Id | DW_AC_IEX_STRY_TEMP_WORK_ITEMS_TL | WORK_ITEM_TEMP_ID |
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| CATEGORY_TYPE | VARCHAR2 | 32 | Category Type | DW_AC_IEX_STRATEGY_WORK_CATEGORY_TL | IEX_STRATEGY_WORK_CATEGORY_CODE | ||
| CLOSURE_TIME_LIMIT | NUMBER | Closure time limit | |||||
| CLOSURE_TIME_UOM | VARCHAR2 | 64 | Closure time limit UOM | DW_AC_IEX_STRATEGY_TIME_UOM_TL | IEX_STRATEGY_TIME_UOM_CODE | ||
| CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| ENABLED_FLAG | VARCHAR2 | 16 | Enabled flag | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| ESCALATE_YN | VARCHAR2 | 16 | Escalate YN | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| EXECUTION_TIME_UOM | VARCHAR2 | 64 | Execution Time UOM | DW_AC_IEX_STRATEGY_TIME_UOM_TL | IEX_STRATEGY_TIME_UOM_CODE | ||
| NOTIFY_YN | VARCHAR2 | 16 | Notify YN | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| OPTIONAL_YN | VARCHAR2 | 16 | Optional YN | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| OPTION_WAIT_TIME | NUMBER | Optional Wait Time | |||||
| OPTION_WAIT_TIME_UOM | VARCHAR2 | 64 | Optional Wait Time UOM | DW_AC_IEX_STRATEGY_TIME_UOM_TL | IEX_STRATEGY_TIME_UOM_CODE | ||
| POST_EXECUTION_WAIT | NUMBER | 38 | 0 | Post Execution Wait | |||
| PRE_EXECUTION_WAIT | NUMBER | 38 | 0 | Pre Execution Wait | |||
| PRIORITY_TYPE | VARCHAR2 | 32 | Priority Type | DW_AC_IEX_STRATEGY_WORK_PRIORITY_TL | IEX_STRATEGY_WORK_PRIORITY_CODE | ||
| SAME_RESOURCE_YN | VARCHAR2 | 16 | Same resource YN | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| SCHEDULE_UOM | VARCHAR2 | 64 | Schedule UOM | DW_AC_IEX_STRATEGY_TIME_UOM_TL | IEX_STRATEGY_TIME_UOM_CODE | ||
| SCHEDULE_WAIT | NUMBER | Schedule wait | |||||
| TRX_LEVEL_FLAG | VARCHAR2 | 16 | Indicates the strategy task is transaction level. | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| WORK_TYPE | VARCHAR2 | 32 | Work Item | DW_AC_IEX_STRATEGY_WORK_TYPE_TL | IEX_STRATEGY_WORK_TYPE_CODE |
Copyright © 2019, 2026, Oracle and/or its affiliates.