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: OZF.OZF_DASHB_DAILY_KPI

Object Details

Object Name:	OZF_DASHB_DAILY_KPI
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_DASHB_DAILY_KPI
Subobject Name:
Status:	VALID

This table is populated with the KPI infomation to be displayed on the Account Manager Dashboard.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_DASHB_DAILY_KPI_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DASHB_DAILY_KPI_ID
OZF_DASHB_DAILY_KPI_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_DATE RESOURCE_ID
OZF_DASHB_DAILY_KPI_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DASHB_DAILY_KPI_ID	NUMBER		Yes	Unique Identifier
REPORT_DATE	DATE			Date on which the table got populated
RESOURCE_ID	NUMBER			Resource identifier
PERIOD_TYPE_ID	NUMBER			Period Type identifier
TIME_ID	NUMBER			Unique identifier of the period type
SEQUENCE_NUMBER	NUMBER			Sequence Number indication the position of the KPI
KPI_NAME	VARCHAR2	(240)		KPI Name
KPI_VALUE	NUMBER			KPI Value
ALERT_TYPE	VARCHAR2	(30)		Type Of Alert to be displayed

Query Text

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


SELECT DASHB_DAILY_KPI_ID
,      REPORT_DATE
,      RESOURCE_ID
,      PERIOD_TYPE_ID
,      TIME_ID
,      SEQUENCE_NUMBER
,      KPI_NAME
,      KPI_VALUE
,      ALERT_TYPE
FROM OZF.OZF_DASHB_DAILY_KPI;

Dependencies

[top of page]

OZF.OZF_DASHB_DAILY_KPI does not reference any database object

OZF.OZF_DASHB_DAILY_KPI is referenced by following:

OZF: OZF_DASHB_DAILY_KPI#