This table requires activation of Advanced Collections functional area. Stores all the score definitions for Advanced Collections.
Module: Advanced Collections
SCORE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SCORE_ID | NUMBER | 38 | 0 | True | Primary key. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| SCORE_NAME | VARCHAR2 | 512 | Name of the scoring engine. | ||||
| SCORE_DESCRIPTION | VARCHAR2 | 256 | Long description of the score. | ||||
| ENABLED_FLAG | VARCHAR2 | 16 | Indicates if the scoring method is enabled for use. | ||||
| VALID_FROM_DT | DATE | Low end of valid scoring period. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| VALID_TO_DT | DATE | High end of valid scoring period. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| JTF_OBJECT_CODE | VARCHAR2 | 32 | Code of the object scored on JTF_OBJECTS table. | ||||
| SCORE_RANGE_LOW | VARCHAR2 | 999 | Minimum value generated by this scoring engine. | ||||
| SCORE_RANGE_HIGH | VARCHAR2 | 999 | Maximum value generated by this scoring engine. | ||||
| WEIGHT_REQUIRED | VARCHAR2 | 16 | Indicate if weights are required in the scoring engine. | ||||
| CONCURRENT_PROG_NAME | VARCHAR2 | 32 | Concurrent program name that generated the score. | ||||
| OUT_OF_RANGE_RULE | VARCHAR2 | 32 | Rule that indicates what we should do if the value returned by the engine is outside the valid range. We can replace the value with the first value in the range or with the last value in the range. | DW_AC_IEX_SCR_OUT_OF_RANGE_RULE_TL | OUT_OF_RANGE_RULE_CODE | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. |
Copyright © 2019, 2026, Oracle and/or its affiliates.