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_F

Object Details

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

This is resource utilization fact table.
Resource utilization is a measure indicating how much your resources are used in production.
It is a comparison of the resource time used and the total resource available.
The Resource Utilization fact will store each resources availability and actual usage for every workday.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_EDW_RES_UTIL_F_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	RES_UTIL_PK RES_UTIL_PK_KEY
OPI_EDW_RES_UTIL_F_UKEY	NORMAL	UNIQUE	APPS_TS_SUMMARY	RES_UTIL_PK_KEY
OPI_EDW_RES_UTIL_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	UOM_FK_KEY
OPI_EDW_RES_UTIL_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
OPI_EDW_RES_UTIL_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	LOCATOR_FK_KEY
OPI_EDW_RES_UTIL_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	RES_FK_KEY
OPI_EDW_RES_UTIL_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TRX_DATE_FK_KEY

Columns

Name	Datatype	Length	Mandatory	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)
CREATION_DATE	DATE			Standard who column
DEPARTMENT	VARCHAR2	(240)		Department owning the resource
INSTANCE_FK_KEY	NUMBER			Foreign key to Instance Dimension
LAST_UPDATE_DATE	DATE			Standard who column
LOCATOR_FK_KEY	NUMBER			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.
RES_FK_KEY	NUMBER			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		Yes	Surrogate key determined by the Collection Engine
TRX_DATE	DATE			Transaction date when resource is charged to jobs/schedules
TRX_DATE_FK_KEY	NUMBER			Foreign key to Time Dimension at Calendar Day level
UOM_FK_KEY	NUMBER			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_KEY	NUMBER			User-defined dimension foreign key
USER_FK2_KEY	NUMBER			User-defined dimension foreign key
USER_FK3_KEY	NUMBER			User-defined dimension foreign key
USER_FK4_KEY	NUMBER			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
,      CREATION_DATE
,      DEPARTMENT
,      INSTANCE_FK_KEY
,      LAST_UPDATE_DATE
,      LOCATOR_FK_KEY
,      RES_FK_KEY
,      RES_UTIL_PK
,      RES_UTIL_PK_KEY
,      TRX_DATE
,      TRX_DATE_FK_KEY
,      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_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
FROM OPI.OPI_EDW_RES_UTIL_F;

Dependencies

[top of page]

OPI.OPI_EDW_RES_UTIL_F does not reference any database object

OPI.OPI_EDW_RES_UTIL_F is referenced by following:

APPS: OPI_EDW_RES_UTIL_F