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_FSTG

Object Details

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

This is the interface table for the Custom Measure fact. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	5
PCT Used:

Columns

Name	Datatype	Length	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)
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
SUPPLIER_SITE_FK_KEY	NUMBER		System generated foreign key to the Trading Partner dimension (Supplier or Supplier Site)
SCORE	NUMBER		Score entered for the criteria
REQUEST_ID	NUMBER		Identifier used by collection program
OPERATING_UNIT_FK_KEY	NUMBER		System generated foreign key to the Internal Organization dimension (Operating Unit)
MIN_SCORE	NUMBER		Lowest possible score for the criteria
MAX_SCORE	NUMBER		Highest possible score for the 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)
EVAL_DATE_FK_KEY	NUMBER		System generated foreign key to the Time dimension (Evaluation Date)
EVALUATION_ID	NUMBER		Identifier assigned to evaluation
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)
DUNS_FK	VARCHAR2	(80)	Foreign key to the DUNS dimension (D&B DUNS Code)
SIC_CODE_FK	VARCHAR2	(80)	Foreign key to the SIC Code dimension (Standard Industry Commodity Code)
UNSPSC_FK	VARCHAR2	(80)	Foreign key to the UNSPSC dimension (UNSPSC Code)
USER_NAME	VARCHAR2	(100)	Name of person completing the survey
USER_FK5	VARCHAR2	(2000)	User defined foreign key
USER_FK4	VARCHAR2	(2000)	User defined foreign key
USER_FK3	VARCHAR2	(2000)	User defined foreign key
USER_FK2	VARCHAR2	(2000)	User defined foreign key
USER_FK1	VARCHAR2	(2000)	User defined foreign key
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
SUPPLIER_SITE_FK	VARCHAR2	(320)	Foreign key to the Trading Partner dimension (Supplier or Supplier Site)
SCORE_COMMENTS	VARCHAR2	(240)	Comments for clarification or justification of assigned scores
ROW_ID	ROWID	(10)	Row Identifier
OPERATION_CODE	VARCHAR2	(30)	Code used by the loader program to determine whether to insert/update/delete this record
OPERATING_UNIT_FK	VARCHAR2	(320)	Foreign key to the Internal Organization dimension (Operating Unit)
ITEM_FK	VARCHAR2	(320)	Foreign key to the Item dimension (Item or Item Category)
INSTANCE_FK	VARCHAR2	(320)	Foreign key to the Instance dimension (Instance)
EVAL_DATE_FK	VARCHAR2	(320)	Foreign key to the Time dimension (Evaluation Date)
EVAL_COMMENTS	VARCHAR2	(240)	General evaluation comments
ERROR_CODE	VARCHAR2	(2000)	Code used to store error messages
CUSTOM_MEASURE_FK	VARCHAR2	(320)	Foreign key to the Lookup dimension (Custom Measure Type)
CSTM_MSR_PK	VARCHAR2	(320)	Unique identifier
CRITERIA_CODE_FK	VARCHAR2	(320)	Foreign key to the Lookup dimension (Criteria)
COLLECTION_STATUS	VARCHAR2	(30)	Loading status code for the record (It refers to the status after the Load Engine attempts to move the record from the staging table to the fact table. It does not refer to the movement of the data from the source to the staging table)

Query Text

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


SELECT SIC_CODE_FK_KEY
,      UNSPSC_FK_KEY
,      DUNS_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
,      SUPPLIER_SITE_FK_KEY
,      SCORE
,      REQUEST_ID
,      OPERATING_UNIT_FK_KEY
,      MIN_SCORE
,      MAX_SCORE
,      ITEM_FK_KEY
,      INSTANCE_FK_KEY
,      EVAL_DATE_FK_KEY
,      EVALUATION_ID
,      CUSTOM_MEASURE_FK_KEY
,      CRITERIA_CODE_FK_KEY
,      DUNS_FK
,      SIC_CODE_FK
,      UNSPSC_FK
,      USER_NAME
,      USER_FK5
,      USER_FK4
,      USER_FK3
,      USER_FK2
,      USER_FK1
,      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
,      SUPPLIER_SITE_FK
,      SCORE_COMMENTS
,      ROW_ID
,      OPERATION_CODE
,      OPERATING_UNIT_FK
,      ITEM_FK
,      INSTANCE_FK
,      EVAL_DATE_FK
,      EVAL_COMMENTS
,      ERROR_CODE
,      CUSTOM_MEASURE_FK
,      CSTM_MSR_PK
,      CRITERIA_CODE_FK
,      COLLECTION_STATUS
FROM POA.POA_EDW_CSTM_MSR_FSTG;

Dependencies

[top of page]

POA.POA_EDW_CSTM_MSR_FSTG does not reference any database object

POA.POA_EDW_CSTM_MSR_FSTG is referenced by following:

APPS: POA_EDW_CSTM_MSR_FSTG