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: IEO.IEO_LNA_RECORDS

Object Details

Object Name:	IEO_LNA_RECORDS
Object Type:	TABLE
Owner:	IEO
Subobject Name:
Status:	VALID

Records can represent logs or alerts, and represent the base unit of information needed for a log or alert. Optionally, logs and alerts can have descriptions, and parameters associated with them, but only if that association makes sense for that log. Timestamp is captured with mill-second granularity. Severity ranges from CRITICAL to INFORMATIONAL.
The data captured here is optimized to be a trade-off between speed of a master-detail viewer application, and speed of producers emitting data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEO_LNA_RECORDS_N1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTION_ID ALERT_KEY RECORD_ID SEVERITY_ID SOURCE_ID TIMESTAMP TIMESTAMP_MILLI

Columns

Name	Datatype	Length	Mandatory	Comments
RECORD_ID	NUMBER	(30)	Yes	Uniquely identifies an LNA record.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.
SOURCE_ID	NUMBER	(10)	Yes	Source that emitted this record.
TIMESTAMP	DATE		Yes	Timestamp, to DATE granularity.
TIMESTAMP_MILLI	NUMBER	(3)	Yes	Millisecond portion of timestamp.
ACTION_ID	NUMBER	(10)	Yes	Action performed (log, alert-set, alert-clear, etc).
SEVERITY_ID	NUMBER		Yes	Severity of log or alert (critical, major, minor, info, etc).
TITLE_MSG_NAME	VARCHAR2	(30)	Yes	MSG_ID code used to translate title of the record.
TITLE_RESOURCE_GUID	VARCHAR2	(32)		Resource in which the TITLE_MSG_ID translation can be found.
ALERT_KEY	VARCHAR2	(256)		Key that can distinguish alert further (emitter sets).
XML_DATA	VARCHAR2	(4000)		XML data attached by emitter can represent anything.
RESERVED	VARCHAR2	(2000)		Reserved for on-site customization, etc.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER			Standard column used by HTML utilities.
USER_FILTER	VARCHAR2	(128)		User filter

Query Text

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


SELECT RECORD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SOURCE_ID
,      TIMESTAMP
,      TIMESTAMP_MILLI
,      ACTION_ID
,      SEVERITY_ID
,      TITLE_MSG_NAME
,      TITLE_RESOURCE_GUID
,      ALERT_KEY
,      XML_DATA
,      RESERVED
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      USER_FILTER
FROM IEO.IEO_LNA_RECORDS;

Dependencies

[top of page]

IEO.IEO_LNA_RECORDS does not reference any database object

IEO.IEO_LNA_RECORDS is referenced by following:

APPS: IEO_LNA_RECORDS