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: TablePAY.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: TablespaceAPPS_TS_SEED
PCT Free: 20
PCT Used:
Primary Key: PAY_US_TAX_BALANCES_PK
  1. ColumnTAX_BALANCE_ID
Unique Key: PAY_US_TAX_BALANCES_UK2
  1. ColumnBALANCE_CATEGORY_CODE
  2. ColumnEE_OR_ER_CODE
  3. ColumnTAX_TYPE_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_US_TAX_BALANCES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTAX_BALANCE_ID
PAY_US_TAX_BALANCES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnBALANCE_CATEGORY_CODE
ColumnEE_OR_ER_CODE
ColumnTAX_TYPE_ID
PAY_US_TAX_BALANCES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnTAX_TYPE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_US_TAX_BALANCES PAY_US_TAX_BALANCES_FK1 TablePAY_US_TAX_TYPES PAY_US_TAX_BALANCES TAX_TYPE_ID
TablePAY_US_TAX_REPORT_BALANCES PAY_US_TAX_REPORT_BALANCES_FK1 PAY_US_TAX_BALANCES PAY_US_TAX_REPORT_BALANCES TAX_BALANCE_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
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
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:

SchemaAPPS
SynonymPAY_US_TAX_BALANCES
SchemaPUBLIC
SynonymPAY_US_TAX_BALANCES