This table requires activation of Advanced Collections functional area. Stores historical data about collection scores for Advanced Collections.
Module: Advanced Collections
SCORE_HISTORY_ID
| 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.