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_EVENT_UPDATES

Object Details

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

PAY_EVENT_UPDATES holds the object information (table, column)
and associated change type affected by a continuous calc. process event update.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_EVENT_UPDATES_PK

EVENT_UPDATE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_EVENT_UPDATES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_UPDATE_ID
PAY_EVENT_UPDATES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATED_TABLE_ID
PAY_EVENT_UPDATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_EVENT_UPDATES		PAY_DATED_TABLES	PAY_EVENT_UPDATES DATED_TABLE_ID
PAY_PROCESS_EVENTS		PAY_EVENT_UPDATES	PAY_PROCESS_EVENTS EVENT_UPDATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_UPDATE_ID	NUMBER	(9)	Yes	System-generated primary key column.
TABLE_NAME	VARCHAR2	(30)		Name of table to monitor
COLUMN_NAME	VARCHAR2	(30)		Name of column to monitor
BUSINESS_GROUP_ID	NUMBER	(15)		Business group. Populated for customer created data.
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code. Populated for seeded data.
CHANGE_TYPE	VARCHAR2	(30)	Yes	Events detected should be marked as this type of 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.
DATED_TABLE_ID	NUMBER	(15)	Yes	Foreign key to PAY_DATED_TABLES.
EVENT_TYPE	VARCHAR2	(30)		Event to monitor e.g. Insert, Update, Delete

Query Text

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


SELECT EVENT_UPDATE_ID
,      TABLE_NAME
,      COLUMN_NAME
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      CHANGE_TYPE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      DATED_TABLE_ID
,      EVENT_TYPE
FROM HR.PAY_EVENT_UPDATES;

Dependencies

[top of page]

HR.PAY_EVENT_UPDATES does not reference any database object

HR.PAY_EVENT_UPDATES is referenced by following:

APPS: PAY_EVENT_UPDATES; PAY_EVENT_UPDATES_WHO
PUBLIC: PAY_EVENT_UPDATES