eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AMS.AMS_DM_SOURCE

Object Details

Object Name:	AMS_DM_SOURCE
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_DM_SOURCE
Subobject Name:
Status:	VALID

AMS_DM_SOURCE is a table which captures the party_id of all the parties which are used for model building or scoring. In addition, the table also contains fields which are used by the data mining engine to determine a target value, in the case of model building, and the scoring result field, in the case of model scoring.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DM_SOURCE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_ID
AMS_DM_SOURCE_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ARC_USED_FOR_OBJECT USED_FOR_OBJECT_ID PARTY_ID
AMS_DM_SOURCE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_ID	NUMBER		Yes	Unique 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_TYPE	VARCHAR2	(30)		De-normalized type of a the model used in the scoring.
ARC_USED_FOR_OBJECT	VARCHAR2	(30)	Yes	Identifies the type of object which the source is used for.
USED_FOR_OBJECT_ID	NUMBER		Yes	Foreign key reference to the object which the source is used for.
PARTY_ID	NUMBER		Yes	Reference identifier for the unique identifier of the data source used by the model or scoring run.
TARGET_VALUE	VARCHAR2	(30)		The target value used by the data mining engine for building models.
SCORE_RESULT	VARCHAR2	(30)		The result returned by the data mining engine for the specific record when scoring.
CONFIDENCE	NUMBER			The confidence of the scoring result in percentage.
CONTINUOUS_SCORE	NUMBER			The probability that the scoring results is positive in percentage.
DECILE	NUMBER			Binned summary for the probability of a positive score.
TRAINING_DATA_FLAG	VARCHAR2	(1)		Used in model building to determine if the dataset is used for training, otherwise, the data is used to sample the trained model.
PERCENTILE	NUMBER			The percentile for the probability of a positive score.

Query Text

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


SELECT SOURCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      MODEL_TYPE
,      ARC_USED_FOR_OBJECT
,      USED_FOR_OBJECT_ID
,      PARTY_ID
,      TARGET_VALUE
,      SCORE_RESULT
,      CONFIDENCE
,      CONTINUOUS_SCORE
,      DECILE
,      TRAINING_DATA_FLAG
,      PERCENTILE
FROM AMS.AMS_DM_SOURCE;

Dependencies

[top of page]

AMS.AMS_DM_SOURCE does not reference any database object

AMS.AMS_DM_SOURCE is referenced by following:

APPS: AMS_DM_SOURCE