# DW_AC_IEX_STRATEGY_TEMPLATE_GROUPS_D (Preview)

This table requires activation of Advanced Collections functional area. Strategy details grouped within a strategy method

## Details

Module: Advanced Collections

## Key Columns

GROUP_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
GROUP_ID | NUMBER | 38 | 0 | True | Group Id |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
GROUP_NAME | VARCHAR2 | 256 |  |  | Group Name |  |
STRATEGY_TEMP_ID | NUMBER | 38 | 0 |  | Strategy Template Id |  |
STRATEGY_ORDER_ID | NUMBER | 38 | 0 |  | Strategy Order |  |
STRATEGY_RANK | VARCHAR2 | 16 |  |  | Strategy Rank |  |
ENABLED_FLAG | VARCHAR2 | 16 |  |  | Strategy enabled yn | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
CATEGORY_TYPE | VARCHAR2 | 64 |  |  | Category Type | DW_AC_IEX_DELINQUENCY_STATUS_TL | IEX_DELINQUENCY_STATUS_CODE
CHANGE_STRATEGY_YN | VARCHAR2 | 16 |  |  | Change Strategy YN | 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
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
OBJECT_FILTER_ID | NUMBER | 38 | 0 |  | Object Filter Id |  |
SCORE_TOLERANCE | NUMBER |  |  |  | Score Tolerance |  |
SCORING_ENGINE_ID | NUMBER | 38 | 0 |  | Score Engine Id |  |
STRATEGY_LEVEL | NUMBER |  |  |  | Strategy Level |  |
TRANSACTION_SEGMENT_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the strategy group has segments defined at the transaction level. Possible values are Y, N, and blank. N or blank indicates that the strategy does not have the transaction segments. | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
TRX_LEVEL_FLAG | VARCHAR2 | 16 |  |  | Indicates the strategy group contains transaction level tasks only. | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
VALID_FROM_DT | DATE |  |  |  | Valid From Date | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
VALID_TO_DT | DATE |  |  |  | Valid To Date | DW_FISCAL_DAY_D | FISCAL_DAY_DATE

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