# DW_AC_IEX_STRATEGY_WORK_ITEMS_CF (Preview)

This table requires activation of Advanced Collections functional area. Actionable work generated by a web-service when a strategy task is created

## Details

Module: Advanced Collections

## Key Columns

WORK_ITEM_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
WORK_ITEM_ID | NUMBER | 38 | 0 | True | Work Item Id |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
STRATEGY_ID | NUMBER | 38 | 0 |  | Strategy Id |  |
S_STRATEGY_ASSIGNMENT_MATRIX_ID | NUMBER | 38 | 0 |  | Identifier of a strategy assignment matrix. | DW_AC_IEX_STRATEGY_ASSIGNMENT_MATRIX_D | STRATEGY_ASSIGNMENT_MATRIX_ID
S_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the strategy | DW_AC_IEX_STRATEGY_STATUS_TL | CODE
S_STRATEGY_ACTIVE_FLAG | VARCHAR2 | 16 |  |  | Is Active Strategy | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
S_STRATEGY_TEMPLATE_ID | NUMBER | 38 | 0 |  | Template Id of the strategy used | DW_AC_IEX_STRATEGY_TEMPLATES_D | STRATEGY_TEMP_ID
S_DELINQUENCY_ID | NUMBER | 38 | 0 |  | Delinquency_id from iex_delinquencies_all table is stored in this column |  |
S_OBJECT_TYPE | VARCHAR2 | 32 |  |  | Object Type of the strategy |  |
S_OBJECT_ID | NUMBER | 38 | 0 |  | Object Id of the strategy |  |
S_ORG_ID | NUMBER | 38 | 0 |  | Indicates the identifier of the business unit associated to the row. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
S_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger Id of the strategy | DW_LEDGER_D | LEDGER_ID
S_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal Entity Id of the strategy | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
S_PARTY_ID | NUMBER | 38 | 0 |  | Party id of the strategy | DW_PARTY_D | PARTY_ID
S_CUST_ACCOUNT_ID | NUMBER | 38 | 0 |  | Cust Account Id of the strategy | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
S_CUST_ACCOUNT_PROFILE_ID | NUMBER | 38 | 0 |  | Customer account profile identifier. | DW_AC_HZ_CUSTOMER_PROFILES_F_D | CUST_ACCOUNT_PROFILE_ID
S_CUSTOMER_SITE_USE_ID | NUMBER | 38 | 0 |  | Site use Id | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID
S_CUSTOMER_LOCATION_ID | NUMBER | 38 | 0 |  | Customer location identifier. | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
S_STRATEGY_COLLECTOR_ID | NUMBER | 38 | 0 |  | Collector ID | DW_AC_AR_COLLECTORS_D | COLLECTOR_ID
S_CREATION_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name. |  |
S_FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name. |  |
S_FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. |  |
S_CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
S_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
S_CREATION_DATE_1 | DATE |  |  |  | Who column: indicates the date and time of the creation of the row. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
S_UPDATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name. |  |
S_LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who last updated the row. |  |
S_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
S_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
S_SCORE_VALUE | NUMBER |  |  |  | Score value of the strategy |  |
S_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. |  |
S_STRATEGY_LEVEL | NUMBER | 38 | 0 |  | Level of the strategy |  |
S_STRATEGY_LEVEL_CODE | VARCHAR2 | 128 |  |  | Level code of the strategy | DW_AC_IEX_STRATEGY_LEVEL_TL | STRATEGY_LEVEL_CODE
S_EFFECTIVE_START_DATE | TIMESTAMP |  |  |  | Effective start date of the strategy Template/method | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
S_EFFECTIVE_END_DATE | TIMESTAMP |  |  |  | Effective end date of the strategy Template/method | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
S_EFFECTIVE_START_DATE_1 | DATE |  |  |  | Effective start date of the strategy Template/method | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
S_EFFECTIVE_END_DATE_1 | DATE |  |  |  | Effective end date of the strategy Template/method | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
WORK_ITEM_TEMPLATE_ID | NUMBER | 38 | 0 |  | Work Item Template Id | DW_AC_IEX_STRY_TEMP_WORK_ITEMS_D | WORK_ITEM_TEMP_ID
RESOURCE_ID | NUMBER | 38 | 0 |  | Resource Id | DW_AC_AR_COLLECTORS_D | EMPLOYEE_ID
STATUS_CODE | VARCHAR2 | 32 |  |  | Status Code | DW_AC_IEX_STRATEGY_WORK_STATUS_TL | IEX_STRATEGY_WORK_STATUS_CODE
EXECUTE_START | DATE |  |  |  | Execution Start | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
EXECUTE_END | DATE |  |  |  | Execution End | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
SCHEDULE_START | DATE |  |  |  | Schedule Start | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
SCHEDULE_END | DATE |  |  |  | Schedule End | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
SCH_START_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name for schedule start. |  |
WORK_ITEM_ORDER | NUMBER | 38 | 0 |  | Work Item Order |  |
COMMENTS | VARCHAR2 | 999 |  |  | Comments on the Collections strategy task. |  |
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
ESCALATED_YN | VARCHAR2 | 16 |  |  | Escalate YN | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
ESCALATE_YN | VARCHAR2 | 16 |  |  | Escalate YN | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
NOTIFY_YN | VARCHAR2 | 16 |  |  | Notify YN | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
OPTIONAL_YN | VARCHAR2 | 16 |  |  | Optional YN | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
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. |  |
OUTCOME_TYPE_CODE | VARCHAR2 | 32 |  |  | The outcome type code for the Collections strategy task. Valid values are included in the lookup type ORA_IEX_STRA_TASK_OUTCOME_TYPE, such as GENERAL. | DW_AC_IEX_STRA_TASK_OUTCOME_TYPE_TL | OUTCOME_TYPE_CODE
PAYMENT_SCHEDULE_ID | NUMBER |  |  |  | Specifies the payment schedule that the strategy task assignment is associated with. |  |

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