# DW_AC_IEX_STRATEGY_ASSIGNMENT_MATRIX_D (Preview)

This table requires activation of Advanced Collections functional area. IEX_STRATEGY_ASSIGNMENT_MATRIX contains setup information about segments of Oracle Collections

## Details

Module: Advanced Collections

## Key Columns

STRATEGY_ASSIGNMENT_MATRIX_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
STRATEGY_ASSIGNMENT_MATRIX_ID | NUMBER | 38 | 0 | True | Unique identifier of a scoring and strategy assignment by segment. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
STRATEGY_ASSIGN_MATRIX_NAME | VARCHAR2 | 512 |  |  | Name of the scoring and strategy assignment by segment. |  |
STRATEGY_GROUP_ID | NUMBER | 38 | 0 |  | The identifier of the delinquent strategy group for the scoring and strategy assignment. | DW_AC_IEX_STRATEGY_TEMPLATE_GROUPS_D | STRATEGY_GROUP_ID
BUSINESS_LEVEL_CODE | VARCHAR2 | 32 |  |  | Collections business level at which the scoring and strategy assignment is defined. Valid values are Customer, Account, and Site. | DW_AC_IEX_OBJECT_CODES_TL | IEX_OBJECT_CODES_CODE
BU_ID | NUMBER | 38 | 0 |  | The identifier of the business unit at which the scoring and strategy assignment is defined. | DW_INTERNAL_ORG_D | ORG_ID
ENABLED_FLAG | VARCHAR2 | 16 |  |  | Indicates if the scoring and strategy assignment is enabled. | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
START_DATE | DATE |  |  |  | Start date of the scoring and strategy assignment. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
END_DATE | DATE |  |  |  | End date of the scoring and strategy assignment. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
HIGH_SEGMENT_AMOUNT | NUMBER |  |  |  | The amount overdue upper threshold. The upper threshold for the customer's amount overdue above which the above threshold strategy group is used. |  |
HIGH_SEGMENT_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency code of the amount overdue upper threshold. |  |
HIGH_STRATEGY_GROUP_ID | NUMBER |  |  |  | The above threshold strategy group. The identifier of the strategy group assignment when the customer's amount overdue is more than the amount overdue upper threshold. | DW_AC_IEX_STRATEGY_TEMPLATE_GROUPS_D | STRATEGY_GROUP_ID
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
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
LOW_SEGMENT_AMOUNT | NUMBER |  |  |  | The amount overdue lower threshold. The lower threshold for the customer's amount overdue below which the below threshold strategy group is used. |  |
LOW_SEGMENT_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency code of the amount overdue lower threshold. |  |
LOW_STRATEGY_GROUP_ID | NUMBER | 38 | 0 |  | The below threshold strategy group. The identifer of the strategy group assignment when the customer's amount overdue is less than the amount overdue lower threshold. | DW_AC_IEX_STRATEGY_TEMPLATE_GROUPS_D | STRATEGY_GROUP_ID
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 |  | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |  |
PREDELINQ_AMOUNT | NUMBER |  |  |  | Predelinquent amount threshold. A transaction is predelinquent if its amount due remaining is more than the amount threshold and it becomes past due in the number of days specified by the day threshold. |  |
PREDELINQ_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency code of the predelinquent amount threshold. |  |
PREDELINQ_STRATEGY_GROUP_ID | NUMBER | 38 | 0 |  | The identifier of the predelinquent strategy group for the scoring and strategy assignment. | DW_AC_IEX_STRATEGY_TEMPLATE_GROUPS_D | STRATEGY_GROUP_ID
PREDELINQ_DAYS | NUMBER |  |  |  | Predelinquent day threshold. A transaction is predelinquent if its amount due remaining is more than the amount threshold and it becomes past due in the number of days specified by the day threshold. |  |
PREDELINQ_FLAG | VARCHAR2 | 16 |  |  | Indicates if the assignment is a predelinquent strategy assignment. | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
PROFILE_CLASS_ID | NUMBER | 38 | 0 |  | The identifier of the profile class at which the scoring and strategy assignment is defined. | DW_AC_HZ_CUSTOMER_PROFILES_F_D | PROFILE_CLASS_ID

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