This table requires activation of Advanced Collections functional area. Strategy methods detailed information
Module: Advanced Collections
STRATEGY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| STRATEGY_ID | NUMBER | 38 | 0 | True | Primary Key for strategies table | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| STRATEGY_ASSIGNMENT_MATRIX_ID | NUMBER | 38 | 0 | Identifier of a strategy assignment matrix. | DW_AC_IEX_STRATEGY_ASSIGNMENT_MATRIX_D | STRATEGY_ASSIGNMENT_MATRIX_ID | |
| STATUS_CODE | VARCHAR2 | 32 | Status of the strategy | DW_AC_IEX_STRATEGY_STATUS_TL | IEX_STRATEGY_STATUS_CODE | ||
| STRATEGY_ACTIVE_FLAG | VARCHAR2 | 16 | Is Active Strategy | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| STRATEGY_TEMPLATE_ID | NUMBER | 38 | 0 | Template Id of the strategy used | DW_AC_IEX_STRATEGY_TEMPLATES_D | STRATEGY_TEMP_ID | |
| DELINQUENCY_ID | NUMBER | 38 | 0 | Delinquency_id from iex_delinquencies_all table is stored in this column | |||
| OBJECT_TYPE | VARCHAR2 | 32 | Object Type of the strategy | ||||
| OBJECT_ID | NUMBER | 38 | 0 | Object Id of the strategy | |||
| ORG_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| LEDGER_ID | NUMBER | 38 | 0 | Ledger Id of the strategy | DW_LEDGER_D | LEDGER_ID | |
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal Entity Id of the strategy | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| PARTY_ID | NUMBER | 38 | 0 | Party id of the strategy | DW_PARTY_D | PARTY_ID | |
| CUST_ACCOUNT_ID | NUMBER | 38 | 0 | Cust Account Id of the strategy | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID | |
| CUST_ACCOUNT_PROFILE_ID | NUMBER | 38 | 0 | Customer account profile identifier. | DW_AC_HZ_CUSTOMER_PROFILES_F_D | CUST_ACCOUNT_PROFILE_ID | |
| CUSTOMER_SITE_USE_ID | NUMBER | 38 | 0 | Site use Id | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID | |
| CUSTOMER_LOCATION_ID | NUMBER | 38 | 0 | Customer location identifier. | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID | |
| STRATEGY_COLLECTOR_ID | NUMBER | 38 | 0 | Collector ID | DW_AC_AR_COLLECTORS_D | COLLECTOR_ID | |
| CREATION_FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | ||||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name. | ||||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | ||||
| 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 | |||
| CREATION_DATE_1 | DATE | Who column: indicates the date and time of the creation of the row. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| UPDATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | ||||
| 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 | |||
| LAST_UPDATE_DATE_1 | DATE | Who column: indicates the date and time of the last update of the row. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| SCORE_VALUE | NUMBER | Score value of the strategy | |||||
| 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. | |||
| STRATEGY_LEVEL | NUMBER | 38 | 0 | Level of the strategy | |||
| STRATEGY_LEVEL_CODE | VARCHAR2 | 128 | Level code of the strategy | DW_AC_IEX_STRATEGY_LEVEL_TL | STRATEGY_LEVEL_CODE | ||
| EFFECTIVE_START_DATE | TIMESTAMP | Effective start date of the strategy Template/method | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| EFFECTIVE_END_DATE | TIMESTAMP | Effective end date of the strategy Template/method | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| EFFECTIVE_START_DATE_1 | DATE | Effective start date of the strategy Template/method | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| EFFECTIVE_END_DATE_1 | DATE | Effective end date of the strategy Template/method | DW_FISCAL_DAY_D | FISCAL_DAY_DATE |
Copyright © 2019, 2026, Oracle and/or its affiliates.