This table requires activation of Advanced Collections functional area. Stores data point results of scoring formula components for Advanced Collections.
Module: Advanced Collections
SCORE_DATA_POINT_HISTORY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SCORE_DATA_POINT_HISTORY_ID | NUMBER | 38 | 0 | True | Primary key. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| SCORE_HISTORY_ID | NUMBER | 38 | 0 | Identifier of historical score data. | |||
| SCORE_COMPONENT_ID | NUMBER | 38 | 0 | Identifier of a scoring formula component. | DW_AC_IEX_SCORE_COMPONENTS_D | SCORE_COMPONENT_ID | |
| SCORE_COMP_DET_ID | NUMBER | 38 | 0 | Identifier of range and value details of a scoring formula component. | DW_AC_IEX_SCORE_COMP_DET_D | SCORE_COMP_DET_ID | |
| DATA_POINT_VALUE | NUMBER | Data point result of a scoring formula component. | |||||
| WEIGHTED_SCORE | NUMBER | Weighted score of a scoring formula component. | |||||
| 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. | DW_FISCAL_DAY_D | FISCAL_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. |
Copyright © 2019, 2026, Oracle and/or its affiliates.