[Home] [Help] [Dependency Information]
Object Name: | IEX_SCORES |
---|---|
Object Type: | TABLE |
Owner: | IEX |
Subobject Name: | |
Status: | VALID |
Stores all the score definitions.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEX_SCORES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | SCORE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCORE_ID | NUMBER | Yes | Primary key | |
SCORE_NAME | VARCHAR2 | (256) | Name of the score engine | |
SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use | ||
SCORE_DESCRIPTION | VARCHAR2 | (150) | Long description | |
ENABLED_FLAG | VARCHAR2 | (1) | Can we use it? | |
VALID_FROM_DT | DATE | Low end of valid period | ||
VALID_TO_DT | DATE | High end of valid period | ||
CAMPAIGN_SCHED_ID | NUMBER | What marketing campaign should this be used with | ||
JTF_OBJECT_CODE | VARCHAR2 | (25) | Code of the object scored on JTF_OBJECTS table. | |
CONCURRENT_PROG_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
CONCURRENT_PROG_NAME | VARCHAR2 | (30) | Concurrent program name that generated the score. | |
STATUS_DETERMINATION | VARCHAR2 | (1) | This indicates if the scoring engine is to be used for status determination only. Used by Oracle Loans. | |
WEIGHT_REQUIRED | VARCHAR2 | (3) | Indicate if weights are required in the scoring engine. | |
SCORE_RANGE_LOW | VARCHAR2 | (1000) | Minimum value generated by this scoring engine. | |
SCORE_RANGE_HIGH | VARCHAR2 | (1000) | Maximum value generated by this scoring engine. | |
OUT_OF_RANGE_RULE | VARCHAR2 | (20) | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT SCORE_ID
, SCORE_NAME
, SECURITY_GROUP_ID
, SCORE_DESCRIPTION
, ENABLED_FLAG
, VALID_FROM_DT
, VALID_TO_DT
, CAMPAIGN_SCHED_ID
, JTF_OBJECT_CODE
, CONCURRENT_PROG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CONCURRENT_PROG_NAME
, STATUS_DETERMINATION
, WEIGHT_REQUIRED
, SCORE_RANGE_LOW
, SCORE_RANGE_HIGH
, OUT_OF_RANGE_RULE
FROM IEX.IEX_SCORES;
IEX.IEX_SCORES does not reference any database object
IEX.IEX_SCORES is referenced by following:
|
|
|