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.

[Home] [Help]

Table: PAY_DEFINED_BALANCES

Product:	PAY - Payroll
Description:	Intersection between PAY_BALANCE_TYPES and PAY_BALANCE_DIMENSIONS.
Implementation/DBA Data:	HR.PAY_DEFINED_BALANCES

Primary Key: PAY_DEFINED_BALANCES_PK

DEFINED_BALANCE_ID

Primary Key: PAY_DEFINED_BALANCES_UK2

BALANCE_TYPE_ID
BALANCE_DIMENSION_ID
BUSINESS_GROUP_ID
LEGISLATION_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_DEFINED_BALANCES	PAY_BALANCE_TYPES	PAY_DEFINED_BALANCES.BALANCE_TYPE_ID
PAY_DEFINED_BALANCES	PAY_BALANCE_DIMENSIONS	PAY_DEFINED_BALANCES.BALANCE_DIMENSION_ID
PAY_ASSIGNMENT_LATEST_BALANCES	PAY_DEFINED_BALANCES	PAY_ASSIGNMENT_LATEST_BALANCES.DEFINED_BALANCE_ID
PAY_BACKPAY_RULES	PAY_DEFINED_BALANCES	PAY_BACKPAY_RULES.DEFINED_BALANCE_ID
PAY_BALANCE_ATTRIBUTES	PAY_DEFINED_BALANCES	PAY_BALANCE_ATTRIBUTES.DEFINED_BALANCE_ID
PAY_LATEST_BALANCES	PAY_DEFINED_BALANCES	PAY_LATEST_BALANCES.DEFINED_BALANCE_ID
PAY_MONITOR_BALANCE_RETRIEVALS	PAY_DEFINED_BALANCES	PAY_MONITOR_BALANCE_RETRIEVALS.DEFINED_BALANCE_ID
PAY_MONITOR_BALANCE_RETRIEVALS	PAY_DEFINED_BALANCES	PAY_MONITOR_BALANCE_RETRIEVALS.DEFINED_BALANCE_ID
PAY_ORG_PAYMENT_METHODS_F	PAY_DEFINED_BALANCES	PAY_ORG_PAYMENT_METHODS_F.DEFINED_BALANCE_ID
PAY_PERSON_LATEST_BALANCES	PAY_DEFINED_BALANCES	PAY_PERSON_LATEST_BALANCES.DEFINED_BALANCE_ID
PAY_RUN_BALANCES	PAY_DEFINED_BALANCES	PAY_RUN_BALANCES.DEFINED_BALANCE_ID