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_US_TAX_BALANCES

Object Details

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

PAY_US_TAX_BALANCES holds a list of all tax balances for US Payroll
Tax Balance reports.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_US_TAX_BALANCES_PK	NORMAL	UNIQUE	APPS_TS_SEED	TAX_BALANCE_ID ZD_EDITION_NAME
PAY_US_TAX_BALANCES_UK2	NORMAL	UNIQUE	APPS_TS_SEED	BALANCE_CATEGORY_CODE EE_OR_ER_CODE TAX_TYPE_ID ZD_EDITION_NAME
PAY_US_TAX_BALANCES_FK1	NORMAL	NONUNIQUE	APPS_TS_SEED	TAX_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_BALANCE_ID	NUMBER	(9)	Yes	System-generated primary key column.
TAX_TYPE_ID	NUMBER	(9)	Yes	Foreign key to PAY_US_TAX_TYPES.
BALANCE_CATEGORY_CODE	VARCHAR2	(30)	Yes	Code indicating the balance category.
EE_OR_ER_CODE	VARCHAR2	(30)	Yes	Indicates whether the tax is Employee or Employer tax.
USER_REPORTING_NAME	VARCHAR2	(50)	Yes	Name for the tax balance displayed in reports.
BALANCE_TYPE_ID	NUMBER			Indicates the balance id
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT TAX_BALANCE_ID
,      TAX_TYPE_ID
,      BALANCE_CATEGORY_CODE
,      EE_OR_ER_CODE
,      USER_REPORTING_NAME
,      BALANCE_TYPE_ID
,      ZD_EDITION_NAME
FROM HR.PAY_US_TAX_BALANCES;

Dependencies

[top of page]

HR.PAY_US_TAX_BALANCES does not reference any database object

HR.PAY_US_TAX_BALANCES is referenced by following:

HR: PAY_US_TAX_BALANCES#