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: EAM.EAM_SAFETY_HISTORY

Object Details

Object Name:	EAM_SAFETY_HISTORY
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_SAFETY_HISTORY
Subobject Name:
Status:	VALID

Table for storing safety history

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER		Yes	Refers to ISOLATION_ID/WORK_CLEARANCE_ID/ PERMIT_ID
OBJECT_NAME	VARCHAR2	(240)	Yes	Object Name
OBJECT_TYPE	NUMBER		Yes	This stores the safety object type(1-Isolation,2-WorkClearance,3-WorkPermit)
EVENT	VARCHAR2	(240)	Yes	Event Name
STATUS	VARCHAR2	(240)	Yes	Object Status
DETAILS	VARCHAR2	(240)	Yes	Event Details
USER_ID	NUMBER		Yes	User Id

Query Text

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


SELECT OBJECT_ID
,      OBJECT_NAME
,      OBJECT_TYPE
,      EVENT
,      STATUS
,      DETAILS
,      USER_ID
FROM EAM.EAM_SAFETY_HISTORY;

Dependencies

[top of page]

EAM.EAM_SAFETY_HISTORY does not reference any database object

EAM.EAM_SAFETY_HISTORY is referenced by following:

EAM: EAM_SAFETY_HISTORY#