# DW_AC_IEX_STRATEGY_TEMPLATES_D (Preview)

This table requires activation of Advanced Collections functional area. Template details for a strategy

## Details

Module: Advanced Collections

## Key Columns

STRATEGY_TEMP_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
STRATEGY_TEMP_ID | NUMBER | 38 | 0 | True | Primary Key | DW_AC_IEX_STRATEGY_TEMPLATES_TL | STRATEGY_TEMP_ID
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
CATEGORY_TYPE | VARCHAR2 | 64 |  |  | Template category | DW_AC_IEX_DELINQUENCY_STATUS_TL | IEX_DELINQUENCY_STATUS_CODE
CHANGE_STRATEGY_YN | VARCHAR2 | 16 |  |  | Allow to change strategy | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_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. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
ENABLED_FLAG | VARCHAR2 | 16 |  |  | Determines whether a template is enabled or disabled | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
GROUP_SUBNAME | VARCHAR2 | 64 |  |  | Group subname |  |
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. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
SCORE_TOLERANCE | NUMBER |  |  |  | Score tolerance |  |
STRATEGY_LEVEL | NUMBER |  |  |  | Stragey level |  |
STRATEGY_ORDER_ID | NUMBER | 38 | 0 |  | Strategy Order Id |  |
STRATEGY_RANK | VARCHAR2 | 16 |  |  | Rank of strategy work item |  |
START_SCORE | NUMBER | 38 | 0 |  | Start score derived from strategy rank |  |
HIGH_SCORE | NUMBER | 38 | 0 |  | High score derived from next strategy rank |  |
STRATEGY_TEMP_GROUP_ID | NUMBER | 38 | 0 |  | Template group id | DW_AC_IEX_STRATEGY_TEMPLATE_GROUPS_D | GROUP_ID
VALID_FROM_DT | DATE |  |  |  | Template valid from date | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
VALID_TO_DT | DATE |  |  |  | Template valid to date | DW_FISCAL_DAY_D | FISCAL_DAY_DATE

Copyright Â© 2019, 2026, Oracle and/or its affiliates.