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

TABLE: HR.PAY_US_TAX_TYPES

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


PAY_US_TAX_TYPES holds a list of US tax types used by US Payroll Tax
Balance reporting.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 20
PCT Used:
Primary Key: PAY_US_TAX_TYPES_PK
  1. ColumnTAX_TYPE_ID
Unique Key: PAY_US_TAX_TYPES_UK2
  1. ColumnTAX_TYPE_CODE
Indexes
Index Type Uniqueness Tablespace Column
PAY_US_TAX_TYPES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTAX_TYPE_ID
PAY_US_TAX_TYPES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTAX_TYPE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePAY_US_TAX_BALANCES PAY_US_TAX_BALANCES_FK1 PAY_US_TAX_TYPES PAY_US_TAX_BALANCES TAX_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
TAX_TYPE_ID NUMBER (9) Yes System-generated primary key column.
EE_ER_CODE VARCHAR2 (30) Yes Code indicating whether the tax type is an Employee and/or Employer tax.
LIMIT_TAX_FLAG VARCHAR2 (30) Yes Indicates whether the tax type is a limit tax.
TAX_DOMAIN_CODE VARCHAR2 (30) Yes Indicates whether the tax type is a federal, state or local tax.
TAX_TYPE_CODE VARCHAR2 (30) Yes Tax type code.
Query Text

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


SELECT TAX_TYPE_ID
,      EE_ER_CODE
,      LIMIT_TAX_FLAG
,      TAX_DOMAIN_CODE
,      TAX_TYPE_CODE
FROM HR.PAY_US_TAX_TYPES;

Dependencies

[top of page]

HR.PAY_US_TAX_TYPES does not reference any database object

HR.PAY_US_TAX_TYPES is referenced by following:

SchemaAPPS
SynonymPAY_US_TAX_TYPES
SchemaPUBLIC
SynonymPAY_US_TAX_TYPES