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

TABLE: HR.PAY_RUN_RESULTS

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


PAY_RUN_RESULTS holds the run results from processing each element
entry. There is always a single run result for each entry. The run
result may have one or more run result values, for example, the run
result values from processing an element entry are usually the pay
value and input values. Different categories of run result are
defined as subtypes: P - processed, PA - adjusted, O - overwritten,
U- unprocessed.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_RUN_RESULTS_PK
  1. ColumnRUN_RESULT_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_RUN_RESULTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUN_RESULT_ID
PAY_RUN_RESULTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELEMENT_TYPE_ID
PAY_RUN_RESULTS_N50 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ACTION_ID
ColumnELEMENT_TYPE_ID
ColumnSOURCE_TYPE
PAY_RUN_RESULTS_N51 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_ID
ColumnSOURCE_TYPE
ColumnASSIGNMENT_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
RUN_RESULT_ID NUMBER (15) Yes Primary key.
ELEMENT_TYPE_ID NUMBER (9) Yes Foreign key to PAY_ELEMENT_TYPES.
ASSIGNMENT_ACTION_ID NUMBER (15)
Foreign key to PAY_ASSIGNMENT_ACTIONS.
ENTRY_TYPE VARCHAR2 (1) Yes Denormalised from element entry.
SOURCE_ID NUMBER (15) Yes Source element entry.
SOURCE_TYPE VARCHAR2 (1) Yes For example, E-normal entry, I-indirect result.
STATUS VARCHAR2 (2) Yes Processing status of the result.
JURISDICTION_CODE VARCHAR2 (30)
US - Jurisdiction applying to the result.
START_DATE DATE

Start date of the prorated result
END_DATE DATE

End date of the Prorated result
ELEMENT_ENTRY_ID NUMBER (15)
Foreign key to PAY_ELEMENT_ENTRIES_F.
ENTRY_PROCESS_PATH VARCHAR2 (1000)
Entry Process Path
TIME_DEFINITION_ID NUMBER (9)
Foreign key to PAY_TIME_DEFINITIONS.
LOCAL_UNIT_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS.
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 RUN_RESULT_ID
,      ELEMENT_TYPE_ID
,      ASSIGNMENT_ACTION_ID
,      ENTRY_TYPE
,      SOURCE_ID
,      SOURCE_TYPE
,      STATUS
,      JURISDICTION_CODE
,      START_DATE
,      END_DATE
,      ELEMENT_ENTRY_ID
,      ENTRY_PROCESS_PATH
,      TIME_DEFINITION_ID
,      LOCAL_UNIT_ID
,      INSTANCE_ID
FROM HR.PAY_RUN_RESULTS;

Dependencies

[top of page]

HR.PAY_RUN_RESULTS does not reference any database object

HR.PAY_RUN_RESULTS is referenced by following:

SchemaHR
ViewPAY_RUN_RESULTS#