This table requires activation of Advanced Collections functional area. IEX_STRATEGY_ASSIGNMENT_MATRIX contains setup information about segments of Oracle Collections
Module: Advanced Collections
STRATEGY_ASSIGNMENT_MATRIX_ID
| 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.