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_RUN_BALANCES

Object Details

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

PAY_RUN_BALANCES holds run balance values calculated during the Payroll Run. It is intended to enhance balance reporting performance. It will hold values only for those defined balances that have been identified as required for balance reporting.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_RUN_BALANCES_PK

RUN_BALANCE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_RUN_BALANCES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RUN_BALANCE_ID
PAY_RUN_BALANCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID DEFINED_BALANCE_ID EFFECTIVE_DATE
PAY_RUN_BALANCES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ACTION_ID DEFINED_BALANCE_ID
PAY_RUN_BALANCES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEFINED_BALANCE_ID TAX_UNIT_ID EFFECTIVE_DATE
PAY_RUN_BALANCES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RUN_BALANCE_ID	NUMBER	(15)	Yes	System generated primary key
DEFINED_BALANCE_ID	NUMBER	(9)	Yes	Foreign key to pay_defined_balances.
EFFECTIVE_DATE	DATE		Yes	Effective date of the associated payroll action.
BALANCE_VALUE	NUMBER	(38)	Yes	The balance value.
ASSIGNMENT_ACTION_ID	NUMBER	(15)		Foreign key to pay_assignment_actions.
ASSIGNMENT_ID	NUMBER	(10)		Associated assignment id.
ACTION_SEQUENCE	NUMBER	(15)		The action sequence for the assignment action id.
PAYROLL_ACTION_ID	NUMBER	(9)		Associated payroll action id.
TAX_UNIT_ID	NUMBER	(15)		Government Reporting Entity, or Legal Entity context value for the balance.
JURISDICTION_CODE	VARCHAR2	(30)		Jurisdiction context value for the balance.
JURISDICTION_COMP1	VARCHAR2	(30)		Jurisdiction context value for the balance split into component parts.
JURISDICTION_COMP2	VARCHAR2	(30)		Jurisdiction context value for the balance split into component parts.
JURISDICTION_COMP3	VARCHAR2	(30)		Jurisdiction context value for the balance split into component parts.
SOURCE_ID	NUMBER	(15)		Source id context value for the balance.
SOURCE_TEXT	VARCHAR2	(60)		Source text context value for the balance.
TAX_GROUP	VARCHAR2	(60)		Tax group context value for the balance.
SOURCE_NUMBER	NUMBER			Source Number context value for the balance.
SOURCE_TEXT2	VARCHAR2	(60)		Source text2 context value for the balance.
SOURCE_NUMBER2	NUMBER			Source Number2 context value for the balance.
TIME_DEFINITION_ID	NUMBER	(9)		Foreign Key to PAY_TIME_DEFINITIONS.
BALANCE_DATE	DATE			Value of the Balance Date Context
LOCAL_UNIT_ID	NUMBER	(15)		Local Unit context value for the balance
ORGANIZATION_ID	NUMBER	(15)		Third Party Payee Organization context value for the balance
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_BALANCE_ID
,      DEFINED_BALANCE_ID
,      EFFECTIVE_DATE
,      BALANCE_VALUE
,      ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ID
,      ACTION_SEQUENCE
,      PAYROLL_ACTION_ID
,      TAX_UNIT_ID
,      JURISDICTION_CODE
,      JURISDICTION_COMP1
,      JURISDICTION_COMP2
,      JURISDICTION_COMP3
,      SOURCE_ID
,      SOURCE_TEXT
,      TAX_GROUP
,      SOURCE_NUMBER
,      SOURCE_TEXT2
,      SOURCE_NUMBER2
,      TIME_DEFINITION_ID
,      BALANCE_DATE
,      LOCAL_UNIT_ID
,      ORGANIZATION_ID
,      INSTANCE_ID
FROM HR.PAY_RUN_BALANCES;

Dependencies

[top of page]

HR.PAY_RUN_BALANCES does not reference any database object

HR.PAY_RUN_BALANCES is referenced by following:

HR: PAY_RUN_BALANCES#