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

TABLE: HR.PAY_RUN_RESULT_VALUES

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


PAY_RUN_RESULT_VALUES holds the values that result from processing a
single element entry. Each input or pay value for the element entry
will have an associated run result value.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_RUN_RESULT_VALUES_PK
  1. ColumnINPUT_VALUE_ID
  2. ColumnRUN_RESULT_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_RUN_RESULT_VALUES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINPUT_VALUE_ID
ColumnRUN_RESULT_ID
PAY_RUN_RESULT_VALUES_N50 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUN_RESULT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePAY_COSTS PAY_COSTS_FK2 PAY_RUN_RESULT_VALUES PAY_COSTS INPUT_VALUE_ID
PAY_COSTS RUN_RESULT_ID
Columns
Name Datatype Length Mandatory Comments
INPUT_VALUE_ID NUMBER (9) Yes Foreign key to PAY_INPUT_VALUES.
RUN_RESULT_ID NUMBER (15) Yes Foreign key to PAY_RUN_RESULTS.
RESULT_VALUE VARCHAR2 (60)
The value of the result.
FORMULA_RESULT_FLAG VARCHAR2 (1)
Indicates if the RESULT_VALUE was produced as a result of a Fast Formula calculation
Query Text

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


SELECT INPUT_VALUE_ID
,      RUN_RESULT_ID
,      RESULT_VALUE
,      FORMULA_RESULT_FLAG
FROM HR.PAY_RUN_RESULT_VALUES;

Dependencies

[top of page]

HR.PAY_RUN_RESULT_VALUES does not reference any database object

HR.PAY_RUN_RESULT_VALUES is referenced by following:

SchemaAPPS
SynonymPAY_RUN_RESULT_VALUES
SchemaPUBLIC
SynonymPAY_RUN_RESULT_VALUES