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: POA.POA_EDW_CSTM_MSR_F

Object Details

Object Name:	POA_EDW_CSTM_MSR_F
Object Type:	TABLE
Owner:	POA
FND Design Data:	POA.POA_EDW_CSTM_MSR_F
Subobject Name:
Status:	VALID

The Custom Measure fact contains custom survey data relating to a supplier's performance. For Oracle Applications users, this data is entered through a Self Service Applications form. The Enterprise Data Warehouse customer defines the questions/criteria for the survey.
The tables storing the survey data are part of the Oracle Purchasing tables. The data in this fact table is stored at the most granular time level, which is the calendar day level. The data in this fact table is used to analyze the performance of suppliers based on subjective criteria defined by the Enterprise Data Warehouse customer.
The measures available in this fact table include the following: Score, Weight, Weighted Score, Maximum Score, and Minimum Score. Some attributes that are available are: Score Comments and Evaluation Comments.
The data in this fact table can be aggregated by the following dimensions: Time, Trading Partner, Item, Internal Organization, Custom Measure, Criteria, and Instance.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POA_EDW_CSTM_MSR_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	CSTM_MSR_PK
POA_EDW_CSTM_MSR_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
POA_EDW_CSTM_MSR_F_N10	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SIC_CODE_FK_KEY
POA_EDW_CSTM_MSR_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ITEM_FK_KEY
POA_EDW_CSTM_MSR_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CRITERIA_CODE_FK_KEY
POA_EDW_CSTM_MSR_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CUSTOM_MEASURE_FK_KEY
POA_EDW_CSTM_MSR_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_FK_KEY
POA_EDW_CSTM_MSR_F_N6	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	EVAL_DATE_FK_KEY
POA_EDW_CSTM_MSR_F_N7	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SUPPLIER_SITE_FK_KEY
POA_EDW_CSTM_MSR_F_N8	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	DUNS_FK_KEY
POA_EDW_CSTM_MSR_F_N9	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	UNSPSC_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
SIC_CODE_FK_KEY	NUMBER			System generated foreign key to the SIC Code dimension (Standard Industry Commodity Code)
UNSPSC_FK_KEY	NUMBER			System generated foreign key to the UNSPSC dimension (UNSPSC Code)
DUNS_FK_KEY	NUMBER			System generated foreign key to the DUNS dimension (D&B DUNS Code)
SUPPLIER_SITE_FK_KEY	NUMBER			System generated foreign key to the Trading Partner dimension (Supplier or Supplier Site)
EVAL_DATE_FK_KEY	NUMBER			System generated foreign key to the Time dimension (Evaluation Date)
OPERATING_UNIT_FK_KEY	NUMBER			System generated foreign key to the Internal Organization dimension (Operating Unit)
CUSTOM_MEASURE_FK_KEY	NUMBER			System generated foreign key to the Lookup dimension (Custom Measure Type)
CRITERIA_CODE_FK_KEY	NUMBER			System generated foreign key to the Lookup dimension (Criteria)
ITEM_FK_KEY	NUMBER			System generated foreign key to the Item dimension (Item or Item Category)
INSTANCE_FK_KEY	NUMBER			System generated foreign key to the Instance dimension (Instance)
WEIGHTED_SCORE	NUMBER			Score for a survey criteria multiplied by a weighting factor
WEIGHT	NUMBER			Weighting factor used to give greater importance to specific criteria in a supplier survey
USER_MEASURE5	NUMBER			User defined measure
USER_MEASURE4	NUMBER			User defined measure
USER_MEASURE3	NUMBER			User defined measure
USER_MEASURE2	NUMBER			User defined measure
USER_MEASURE1	NUMBER			User defined measure
USER_FK5_KEY	NUMBER			System generated user defined foreign key
USER_FK4_KEY	NUMBER			System generated user defined foreign key
USER_FK3_KEY	NUMBER			System generated user defined foreign key
USER_FK2_KEY	NUMBER			System generated user defined foreign key
USER_FK1_KEY	NUMBER			System generated user defined foreign key
SCORE	NUMBER			Score entered for the criteria
MIN_SCORE	NUMBER			Lowest possible score for the criteria
MAX_SCORE	NUMBER			Highest possible score for the criteria
EVALUATION_ID	NUMBER			Identifier assigned to evaluation
CSTM_MSR_PK_KEY	NUMBER			Unique identifier
USER_NAME	VARCHAR2	(100)		Name of person completing the survey
USER_ATTRIBUTE9	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE8	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE7	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE6	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE5	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE4	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE3	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE2	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE15	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE14	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE13	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE12	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE11	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE10	VARCHAR2	(240)		User defined attribute
USER_ATTRIBUTE1	VARCHAR2	(240)		User defined attribute
SCORE_COMMENTS	VARCHAR2	(240)		Comments for clarification or justification of assigned scores
EVAL_COMMENTS	VARCHAR2	(240)		General evaluation comments
CSTM_MSR_PK	VARCHAR2	(320)		Unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column

Query Text

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


SELECT SIC_CODE_FK_KEY
,      UNSPSC_FK_KEY
,      DUNS_FK_KEY
,      SUPPLIER_SITE_FK_KEY
,      EVAL_DATE_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      CUSTOM_MEASURE_FK_KEY
,      CRITERIA_CODE_FK_KEY
,      ITEM_FK_KEY
,      INSTANCE_FK_KEY
,      WEIGHTED_SCORE
,      WEIGHT
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      SCORE
,      MIN_SCORE
,      MAX_SCORE
,      EVALUATION_ID
,      CSTM_MSR_PK_KEY
,      USER_NAME
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE1
,      SCORE_COMMENTS
,      EVAL_COMMENTS
,      CSTM_MSR_PK
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM POA.POA_EDW_CSTM_MSR_F;

Dependencies

[top of page]

POA.POA_EDW_CSTM_MSR_F does not reference any database object

POA.POA_EDW_CSTM_MSR_F is referenced by following:

APPS: POA_EDW_CSTM_MSR_F