DBA Data[Home] [Help] [Dependency Information]

TABLE: AMS.AMS_DM_LIFT

Object Details
Object Name: AMS_DM_LIFT
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_DM_LIFT
Subobject Name:
Status: VALID


AMS_DM_LIFT stores lift data from model building results. The lift data is used for generation of lift charts.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_DM_LIFT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIFT_ID
AMS_DM_LIFT_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMODEL_ID
ColumnQUANTILE
Columns
Name Datatype Length Mandatory Comments
LIFT_ID NUMBER
Yes Unique key identifier.
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
MODEL_ID NUMBER
Yes Foreign key to AMS_DM_MODELS_ALL_B.
QUANTILE NUMBER (15) Yes Identifies the equally sized segment of the trained data.
LIFT NUMBER
Yes The increase in positive target behavior using the model compared to that of random targeting.
TARGETS NUMBER (15)
The number of positive scores in the segment.
NON_TARGETS NUMBER (15)
The number of non-positive scores in the segment.
TARGETS_CUMM NUMBER (15)
The cumulative number of positive scores in the subsequent segment.
TARGET_DENSITY_CUMM NUMBER (15)
Not used.
TARGET_DENSITY NUMBER (15)
Not used.
MARGIN NUMBER

Not used.
ROI NUMBER

Not used.
TARGET_CONFIDENCE NUMBER

Not used.
NON_TARGET_CONFIDENCE NUMBER

Not used.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LIFT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      MODEL_ID
,      QUANTILE
,      LIFT
,      TARGETS
,      NON_TARGETS
,      TARGETS_CUMM
,      TARGET_DENSITY_CUMM
,      TARGET_DENSITY
,      MARGIN
,      ROI
,      TARGET_CONFIDENCE
,      NON_TARGET_CONFIDENCE
FROM AMS.AMS_DM_LIFT;

Dependencies

[top of page]

AMS.AMS_DM_LIFT does not reference any database object

AMS.AMS_DM_LIFT is referenced by following:

SchemaAPPS
SynonymAMS_DM_LIFT