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

Object Details

Object Name:	PAY_PROCESS_EVENTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_PROCESS_EVENTS
Subobject Name:
Status:	VALID

PAY_PROCESS_EVENTS holds currently pending, or previously processed
events for the event driven processes within HRMS e.g. Continuous calculation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_PROCESS_EVENTS_PK

PROCESS_EVENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_PROCESS_EVENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROCESS_EVENT_ID
PAY_PROCESS_EVENTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_PROCESS_EVENT_GROUP_ID
PAY_PROCESS_EVENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_TYPE STATUS
PAY_PROCESS_EVENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID CHANGE_TYPE STATUS
PAY_PROCESS_EVENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID CREATION_DATE
PAY_PROCESS_EVENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_UPDATE_ID CREATION_DATE
PAY_PROCESS_EVENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID EFFECTIVE_DATE
PAY_PROCESS_EVENTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_PROCESS_EVENTS	PAY_EVENT_UPDATES	PAY_PROCESS_EVENTS EVENT_UPDATE_ID
PAY_PROCESS_EVENTS	PAY_PROCESS_EVENTS	PAY_PROCESS_EVENTS ORG_PROCESS_EVENT_GROUP_ID
PAY_PROCESS_EVENTS	PAY_PROCESS_EVENTS	PAY_PROCESS_EVENTS ORG_PROCESS_EVENT_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_EVENT_ID	NUMBER	(9)	Yes	System-generated primary key column.
ASSIGNMENT_ID	NUMBER	(10)		Assignment for which the event was detected.
EFFECTIVE_DATE	DATE		Yes	Effective date of event.
CHANGE_TYPE	VARCHAR2	(30)	Yes	Type of change detected.
STATUS	VARCHAR2	(30)	Yes	Has this record been subsequently processed
DESCRIPTION	VARCHAR2	(240)		Brief description of the event change
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
EVENT_UPDATE_ID	NUMBER	(15)		Foreign key to PAY_EVENT_UPDATES
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group triggering the event
ORG_PROCESS_EVENT_GROUP_ID	NUMBER	(15)		Not currently used.
SURROGATE_KEY	VARCHAR2	(60)		Column that triggered to event monitor
CALCULATION_DATE	DATE			Date event was processed
RETROACTIVE_STATUS	VARCHAR2	(30)		Has the event been processed in RetroNotification
NOTED_VALUE	VARCHAR2	(30)		A value from the originated row that is needed in the case of a delete.

Query Text

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


SELECT PROCESS_EVENT_ID
,      ASSIGNMENT_ID
,      EFFECTIVE_DATE
,      CHANGE_TYPE
,      STATUS
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      EVENT_UPDATE_ID
,      BUSINESS_GROUP_ID
,      ORG_PROCESS_EVENT_GROUP_ID
,      SURROGATE_KEY
,      CALCULATION_DATE
,      RETROACTIVE_STATUS
,      NOTED_VALUE
FROM HR.PAY_PROCESS_EVENTS;

Dependencies

[top of page]

HR.PAY_PROCESS_EVENTS does not reference any database object

HR.PAY_PROCESS_EVENTS is referenced by following:

APPS: PAY_PROCESS_EVENTS; PAY_PROCESS_EVENTS_WHO
PUBLIC: PAY_PROCESS_EVENTS