# DW_AC_IEX_STRY_TEMP_WORK_ITEMS_D (Preview)

This table requires activation of Advanced Collections functional area. This table stores strategy task work items

## Details

Module: Advanced Collections

## Key Columns

WORK_ITEM_TEMP_ID

## Columns

Columns
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.