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: OPI.OPI_EDW_RES_UTIL_FSTG

Object Details

Object Name:	OPI_EDW_RES_UTIL_FSTG
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_EDW_RES_UTIL_FSTG
Subobject Name:
Status:	VALID

This is the interface table for Resource Utilization Fact. Data from multiple transactional systems is staged here for verification and cleansing before being loaded into the fact table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ACT_RES_USAGE	NUMBER		Daily actual resource charged to job/schedules for a department
AVAIL_RES	NUMBER		Daily resource capacity available for a department. Resource availability = capacity units * shift hours per day Or Capacity units * 24 hours (if resource is available 24 hours)
COLLECTION_STATUS	VARCHAR2	(30)	Collection status code for the record
CREATION_DATE	DATE		Standard who column
DEPARTMENT	VARCHAR2	(240)	Department owning the resource
EDW_COLLECTION_DATE	DATE		Collection Date
ERROR_CODE	VARCHAR2	(2000)	Error Code
INSTANCE_FK	VARCHAR2	(240)	Foreign key to Instance Dimension
INSTANCE_FK_KEY	NUMBER		System generated foreign key to Instance Dimension
LAST_UPDATE_DATE	DATE		Standard who column
LOCATOR_FK	VARCHAR2	(240)	Foreign key to new Inventory Locaiton Dimension at Inventory Org Group level for OPM and at inventory Org level for OPI.Organization where resource is charged.
LOCATOR_FK_KEY	NUMBER		System generated foreign key to new Inventory Locaiton Dimension
OPERATION_CODE	VARCHAR2	(30)	Operation code
REQUEST_ID	NUMBER		Concurrent request id
RES_FK	VARCHAR2	(240)	Foreign key to Resource dimension, resource level
RES_FK_KEY	NUMBER		System generated foreign key to Resource dimension, resource level
RES_UTIL_PK	VARCHAR2	(240)	User-defined primary key, having the following structure:(PRODTAG = OPI or OPM)
RES_UTIL_PK_KEY	NUMBER		Surrogate key determined by the Collection Engine
ROW_ID	VARCHAR2	(20)	rowid
TRX_DATE	DATE		Transaction date when resource is charged to jobs/schedules
TRX_DATE_FK	VARCHAR2	(240)	Foreign key to Time Dimension at Calendar Day level
TRX_DATE_FK_KEY	NUMBER		System generated foreign key to Time Dimension at Calendar Day level
UOM_FK	VARCHAR2	(240)	Foreign key to UOM dimension
UOM_FK_KEY	NUMBER		System generated foreign key to UOM dimension
USER_ATTRIBUTE1	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE10	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE11	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE12	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE13	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE14	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE15	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE2	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE3	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE4	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE5	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE6	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE7	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE8	VARCHAR2	(240)	User-defined attribute
USER_ATTRIBUTE9	VARCHAR2	(240)	User-defined attribute
USER_FK1	VARCHAR2	(240)	User-defined dimension foreign key
USER_FK1_KEY	NUMBER		User-defined dimension foreign key
USER_FK2	VARCHAR2	(240)	User-defined dimension foreign key
USER_FK2_KEY	NUMBER		User-defined dimension foreign key
USER_FK3	VARCHAR2	(240)	User-defined dimension foreign key
USER_FK3_KEY	NUMBER		User-defined dimension foreign key
USER_FK4	VARCHAR2	(240)	User-defined dimension foreign key
USER_FK4_KEY	NUMBER		User-defined dimension foreign key
USER_FK5	VARCHAR2	(240)	User-defined dimension foreign key
USER_FK5_KEY	NUMBER		User-defined dimension foreign key
USER_MEASURE1	NUMBER		User-defined measure
USER_MEASURE2	NUMBER		User-defined measure
USER_MEASURE3	NUMBER		User-defined measure
USER_MEASURE4	NUMBER		User-defined measure
USER_MEASURE5	NUMBER		User-defined measure

Query Text

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


SELECT ACT_RES_USAGE
,      AVAIL_RES
,      COLLECTION_STATUS
,      CREATION_DATE
,      DEPARTMENT
,      EDW_COLLECTION_DATE
,      ERROR_CODE
,      INSTANCE_FK
,      INSTANCE_FK_KEY
,      LAST_UPDATE_DATE
,      LOCATOR_FK
,      LOCATOR_FK_KEY
,      OPERATION_CODE
,      REQUEST_ID
,      RES_FK
,      RES_FK_KEY
,      RES_UTIL_PK
,      RES_UTIL_PK_KEY
,      ROW_ID
,      TRX_DATE
,      TRX_DATE_FK
,      TRX_DATE_FK_KEY
,      UOM_FK
,      UOM_FK_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_FK1
,      USER_FK1_KEY
,      USER_FK2
,      USER_FK2_KEY
,      USER_FK3
,      USER_FK3_KEY
,      USER_FK4
,      USER_FK4_KEY
,      USER_FK5
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
FROM OPI.OPI_EDW_RES_UTIL_FSTG;

Dependencies

[top of page]

OPI.OPI_EDW_RES_UTIL_FSTG does not reference any database object

OPI.OPI_EDW_RES_UTIL_FSTG is referenced by following:

APPS: OPI_EDW_RES_UTIL_FSTG