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.PER_BEN_IDENTIFIED_EVENTS

Object Details

Object Name:	PER_BEN_IDENTIFIED_EVENTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_BEN_IDENTIFIED_EVENTS
Subobject Name:
Status:	VALID

When a Checklist Life Event is triggered, a record is inserted into this table with status as 'PENDING'. After allocating the tasks, the record is updated with status as 'PROCESSED'.
Based on the user choice given during submission of 'Allocate checklists and tasks process' request, the 'PROCESSED' records are deleted.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
BEN_IDENTIFIED_EVENT_ID	NUMBER	(15)	Yes	System-generated Primary Key Column.
EVENT_REASON_ID	NUMBER	(15)	Yes	Foreign key to BEN_LER_F.
PERSON_ID	NUMBER	(15)	Yes	Checklist Task Identifier Primary Key
ASSIGNMENT_ID	NUMBER	(15)		Foreign key to PER_ALL_ASSIGNMENTS_F.
STATUS	VARCHAR2	(240)		Status of the event ( Pending or Processed).
EFFECTIVE_DATE	DATE		Yes	Effective date on which the event is created.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.

Query Text

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


SELECT BEN_IDENTIFIED_EVENT_ID
,      EVENT_REASON_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      STATUS
,      EFFECTIVE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_BEN_IDENTIFIED_EVENTS;

Dependencies

[top of page]

HR.PER_BEN_IDENTIFIED_EVENTS does not reference any database object

HR.PER_BEN_IDENTIFIED_EVENTS is referenced by following:

APPS: PER_BEN_IDENTIFIED_EVENTS; PER_BEN_IDENTIFIED_EVENTS_WHO
PUBLIC: PER_BEN_IDENTIFIED_EVENTS