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_SHADOW

Object Details

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

Table used for archiving data being purged by the 'Purge Process for Pay Events Table' process. Structure is same as PAY_PROCESS_EVENTS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_PROCESS_EVENTS_SHADOW_PK

PROCESS_EVENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_PROCESS_EVENTS_SHADOW_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROCESS_EVENT_ID
PAY_PROCESS_EVENTS_SHADOW_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_PROCESS_EVENT_GROUP_ID
PAY_PROCESS_EVENTS_SHADOW_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_TYPE STATUS
PAY_PROCESS_EVENTS_SHADOW_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID CHANGE_TYPE STATUS
PAY_PROCESS_EVENTS_SHADOW_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID CREATION_DATE
PAY_PROCESS_EVENTS_SHADOW_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_UPDATE_ID CREATION_DATE
PAY_PROCESS_EVENTS_SHADOW_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID EFFECTIVE_DATE
PAY_PROCESS_EVENTS_SHADOW_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_PROCESS_EVENTS_SHADOW		PAY_PROCESS_EVENTS_SHADOW	PAY_PROCESS_EVENTS_SHADOW ORG_PROCESS_EVENT_GROUP_ID
PAY_PROCESS_EVENTS_SHADOW		PAY_PROCESS_EVENTS_SHADOW	PAY_PROCESS_EVENTS_SHADOW 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 event change
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
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System genrated 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 coulmn - user who created this row (foreign key to FND_USER.USER_ID)
CREATION_DATE	DATE			standard who column - date when this row was created
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
,      EVENT_UPDATE_ID
,      BUSINESS_GROUP_ID
,      ORG_PROCESS_EVENT_GROUP_ID
,      SURROGATE_KEY
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      CALCULATION_DATE
,      RETROACTIVE_STATUS
,      NOTED_VALUE
FROM HR.PAY_PROCESS_EVENTS_SHADOW;

Dependencies

[top of page]

HR.PAY_PROCESS_EVENTS_SHADOW does not reference any database object

HR.PAY_PROCESS_EVENTS_SHADOW is referenced by following:

HR: PAY_PROCESS_EVENTS_SHADOW#