# DW_AC_IEX_SCORES_D (Preview)

This table requires activation of Advanced Collections functional area. Stores all the score definitions for Advanced Collections.

## Details

Module: Advanced Collections

## Key Columns

SCORE_ID

## Columns

Columns
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.