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_ASSIGNMENT_ACTIONS

Object Details

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

PAY_ASSIGNMENT_ACTIONS holds information about the effects of
processing on specific assignments. An assignment action is one
instance of an assignment for a particular process. For example, when
an assignment has been processed by a payroll run a row is created to
identify the action applied to the assignment. Importantly, the
existence of a row in this table indicates that some processing, or at
least inclusion in the payroll run, has taken place. The
ACTION_STATUS indicates whether it processed successfully,
unsuccessfully, or not at all.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_ASSIGNMENT_ACTIONS_PK

ASSIGNMENT_ACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ASSIGNMENT_ACTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ACTION_ID
PAY_ASSIGNMENT_ACTIONS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRE_PAYMENT_ID
PAY_ASSIGNMENT_ACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SERIAL_NUMBER
PAY_ASSIGNMENT_ACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ACTION_ID
PAY_ASSIGNMENT_ACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ACTION_ID ASSIGNMENT_ID ACTION_STATUS
PAY_ASSIGNMENT_ACTIONS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ACTION_ID CHUNK_NUMBER
PAY_ASSIGNMENT_ACTIONS_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID PAYROLL_ACTION_ID
PAY_ASSIGNMENT_ACTIONS_N52	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_ASSIGNMENT_ACTIONS	PAY_PRE_PAYMENTS	PAY_ASSIGNMENT_ACTIONS PRE_PAYMENT_ID
PAY_ACTION_CONTEXTS	PAY_ASSIGNMENT_ACTIONS	PAY_ACTION_CONTEXTS ASSIGNMENT_ACTION_ID
PAY_ACTION_INTERLOCKS	PAY_ASSIGNMENT_ACTIONS	PAY_ACTION_INTERLOCKS LOCKED_ACTION_ID
PAY_ACTION_INTERLOCKS	PAY_ASSIGNMENT_ACTIONS	PAY_ACTION_INTERLOCKS LOCKING_ACTION_ID
PAY_CE_RECONCILED_PAYMENTS	PAY_ASSIGNMENT_ACTIONS	PAY_CE_RECONCILED_PAYMENTS ASSIGNMENT_ACTION_ID
PAY_COSTS	PAY_ASSIGNMENT_ACTIONS	PAY_COSTS ASSIGNMENT_ACTION_ID
PAY_ELEMENT_ENTRIES_F	PAY_ASSIGNMENT_ACTIONS	PAY_ELEMENT_ENTRIES_F UPDATING_ACTION_ID
PAY_MONITOR_BALANCE_RETRIEVALS	PAY_ASSIGNMENT_ACTIONS	PAY_MONITOR_BALANCE_RETRIEVALS ASSIGNMENT_ACTION_ID
PAY_PRE_PAYMENTS	PAY_ASSIGNMENT_ACTIONS	PAY_PRE_PAYMENTS ASSIGNMENT_ACTION_ID
PAY_QUICKPAY_EXCLUSIONS	PAY_ASSIGNMENT_ACTIONS	PAY_QUICKPAY_EXCLUSIONS ASSIGNMENT_ACTION_ID
PAY_QUICKPAY_INCLUSIONS	PAY_ASSIGNMENT_ACTIONS	PAY_QUICKPAY_INCLUSIONS ASSIGNMENT_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes	The system generated primary key.
ASSIGNMENT_ID	NUMBER	(10)		Foreign key to PER_ASSIGNMENTS.
PAYROLL_ACTION_ID	NUMBER	(9)	Yes	Foreign key to PAY_PAYROLL_ACTIONS.
ACTION_STATUS	VARCHAR2	(1)	Yes	Valid statuses for an assignment action.
CHUNK_NUMBER	NUMBER	(15)		Number used to group events into chunks for parallelization.
ACTION_SEQUENCE	NUMBER	(15)		Absolute sequence number to determine physical order of events.
PRE_PAYMENT_ID	NUMBER	(15)		Foreign key to PAY_PRE_PAYMENTS.
SERIAL_NUMBER	VARCHAR2	(30)		Check or Magnetic Tape number.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
TAX_UNIT_ID	NUMBER	(15)		Identifies the Government Reporting Entity, or Legal Entity for the assignment.
SOURCE_ACTION_ID	NUMBER	(15)		Parent assignment action of this action.
RUN_TYPE_ID	NUMBER	(9)		Foreign key to PAY_RUN_TYPES_F. Identifies the type of run processed.
SECONDARY_STATUS	VARCHAR2	(30)		The processing status of Phase 2 of Purge.
START_DATE	DATE			Identifies the start of a date range the action relates to e.g. used for proration
END_DATE	DATE			Identifies the end of a date range the action relates to e.g. used for proration
OBJECT_ID	NUMBER	(15)		Dynamic Foreign Key to a Table identfied by the object type.
OBJECT_TYPE	VARCHAR2	(30)		Indicates the type of object that OBJECT_ID refers to.
PROCESS_PATH	VARCHAR2	(2000)		process path, to be used in retry of reversals
LABEL_IDENTIFIER	VARCHAR2	(30)		Label Identifier
INSTANCE_ID	NUMBER	(9)		For tracking the INSTANCE ID as part of 12.2 RAC Affinity enhancement.

Query Text

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


SELECT ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ID
,      PAYROLL_ACTION_ID
,      ACTION_STATUS
,      CHUNK_NUMBER
,      ACTION_SEQUENCE
,      PRE_PAYMENT_ID
,      SERIAL_NUMBER
,      OBJECT_VERSION_NUMBER
,      TAX_UNIT_ID
,      SOURCE_ACTION_ID
,      RUN_TYPE_ID
,      SECONDARY_STATUS
,      START_DATE
,      END_DATE
,      OBJECT_ID
,      OBJECT_TYPE
,      PROCESS_PATH
,      LABEL_IDENTIFIER
,      INSTANCE_ID
FROM HR.PAY_ASSIGNMENT_ACTIONS;

Dependencies

[top of page]

HR.PAY_ASSIGNMENT_ACTIONS does not reference any database object

HR.PAY_ASSIGNMENT_ACTIONS is referenced by following:

HR: PAY_ASSIGNMENT_ACTIONS#