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: BIV.BIV_DBI_ESCALATIONS_STG

Object Details

Object Name:	BIV_DBI_ESCALATIONS_STG
Object Type:	TABLE
Owner:	BIV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIV_DBI_ESCALATIONS_STG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCIDENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INCIDENT_ID	NUMBER		Yes	Incident_id of the Service Request
ESCALATED_DATE_FROM	DATE			Incident escalated from date
ESCALATED_DATE_TO	DATE			Incident escalated to date
ESCALATED_DATE	DATE			Incident escalation date with time stamp
DE_ESCALATED_SAME_DAY	VARCHAR2	(1)		Flag indicating escalation and de-escalations on the same day.

Query Text

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


SELECT INCIDENT_ID
,      ESCALATED_DATE_FROM
,      ESCALATED_DATE_TO
,      ESCALATED_DATE
,      DE_ESCALATED_SAME_DAY
FROM BIV.BIV_DBI_ESCALATIONS_STG;

Dependencies

[top of page]

BIV.BIV_DBI_ESCALATIONS_STG does not reference any database object

BIV.BIV_DBI_ESCALATIONS_STG is referenced by following:

APPS: BIV_DBI_ESCALATIONS_STG