DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PAY_ACTION_CONTEXTS

Object Details
Object Name: PAY_ACTION_CONTEXTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_ACTION_CONTEXTS
Subobject Name:
Status: VALID


PAY_ACTION_CONTEXTS holds a list of context values processed for a particular Payroll Run assignment action.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_ACTION_CONTEXTS_PK
  1. ColumnASSIGNMENT_ACTION_ID
  2. ColumnASSIGNMENT_ID
  3. ColumnCONTEXT_ID
  4. ColumnCONTEXT_VALUE
Indexes
Index Type Uniqueness Tablespace Column
PAY_ACTION_CONTEXTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ACTION_ID
ColumnASSIGNMENT_ID
ColumnCONTEXT_ID
ColumnCONTEXT_VALUE
PAY_ACTION_CONTEXTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTEXT_VALUE
ColumnCONTEXT_ID
PAY_ACTION_CONTEXTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
ColumnCONTEXT_VALUE
ColumnCONTEXT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_ACTION_CONTEXTS PAY_ACTION_CONTEXTS_FK2 TablePAY_ASSIGNMENT_ACTIONS PAY_ACTION_CONTEXTS ASSIGNMENT_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ACTION_ID NUMBER (15) Yes Foreign Key to PAY_ASSIGNMENT_ACTIONS
ASSIGNMENT_ID NUMBER (10) Yes Foreign key to PER_ASSIGNMENTS_F
CONTEXT_ID NUMBER (9) Yes Foreign key to FF_CONTEXTS
CONTEXT_VALUE VARCHAR2 (60) Yes Value of the context used in the process
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
,      CONTEXT_ID
,      CONTEXT_VALUE
,      INSTANCE_ID
FROM HR.PAY_ACTION_CONTEXTS;

Dependencies

[top of page]

HR.PAY_ACTION_CONTEXTS does not reference any database object

HR.PAY_ACTION_CONTEXTS is referenced by following:

SchemaHR
ViewPAY_ACTION_CONTEXTS#