# DW_AC_IEX_SCORE_HISTORIES_CF (Preview)

This table requires activation of Advanced Collections functional area. Stores historical data about collection scores for Advanced Collections.

## Details

Module: Advanced Collections

## Key Columns

SCORE_HISTORY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SCORE_HISTORY_ID | NUMBER | 38 | 0 | True | Primary key. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
CREATION_DATE_1 | DATE |  |  |  | Creation date in DATE format. |  |
FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name. |  |
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier. | DW_LEDGER_D | LEDGER_ID
ORG_ID | NUMBER | 38 | 0 |  | Identifier of the business unit associated to the row. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PARTY_ID | NUMBER | 38 | 0 |  | Foreign key to the party. | DW_PARTY_D | PARTY_ID
CUST_ACCOUNT_ID | NUMBER | 38 | 0 |  | Customer account identifier. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
SITE_USE_ID | NUMBER | 38 | 0 |  | Customer site usage identifier. | 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
COLLECTOR_ID | NUMBER | 38 | 0 |  | Collector identifier. | DW_AC_AR_COLLECTORS_D | COLLECTOR_ID
SCORE_ID | NUMBER | 38 | 0 |  | Foreign key to the score definition. | DW_AC_IEX_SCORES_D | SCORE_ID
SCORE_OBJECT_CODE | VARCHAR2 | 32 |  |  | The object code that describes the SCORE_OBJECT_ID column. |  |
SCORE_OBJECT_ID | NUMBER | 38 | 0 |  | Identifier of the object to which the score applies. |  |
STRATEGY_ASSIGNMENT_MATRIX_ID | NUMBER | 38 | 0 |  | Identifier of a strategy assignment matrix. |  |
REQUEST_ID | NUMBER | 38 | 0 |  | Enterprise Service Scheduler request identifier of the job that created or last updated the row. |  |
SCORE_VALUE | NUMBER |  |  |  | Score value for this history entry. |  |

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