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: HR.HR_HRHD_RIR_EVENT_DATA

Object Details

Object Name:	HR_HRHD_RIR_EVENT_DATA
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

Table to hold Event Data for future dated transactions to be sent to PSFT system during RIR. Since USER_DATA column in wf_deferred table has a limitation of 2000 chrs, we will place the event data xml in this table and provided a unique transaction_id as poitner to wf_defereed table so that the actual event data will be retrieved from this table at the time of dequequeing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000873671C00002$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER	(15)	Yes	Unique number for each future data transaction to PSFT
EVENT_DATA	CLOB	(4000)		Event Data
STATUS	VARCHAR2	(30)		Status of Transaction

Query Text

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


SELECT TRANSACTION_ID
,      EVENT_DATA
,      STATUS
FROM HR.HR_HRHD_RIR_EVENT_DATA;

Dependencies

[top of page]

HR.HR_HRHD_RIR_EVENT_DATA does not reference any database object

HR.HR_HRHD_RIR_EVENT_DATA is referenced by following:

HR: HR_HRHD_RIR_EVENT_DATA#