[Home] [Help] [Dependency Information]
Object Name: | PAY_TAXABILITY_RULES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_TAXABILITY_RULES |
Subobject Name: | |
Status: | VALID |
PAY_TAXABILITY_RULES holds information on the taxability rules for
categories of supplemental earnings, imputed earnings, and pre-tax
deductions at the federal and state levels for US and at the federal
and province level for Canada.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_TAXABILITY_RULES_UK | NORMAL | UNIQUE | APPS_TS_SEED |
JURISDICTION_CODE
TAX_TYPE CLASSIFICATION_ID TAX_CATEGORY TAXABILITY_RULES_DATE_ID SECONDARY_CLASSIFICATION_ID |
PAY_TAXABILITY_RULES_FK1 | NORMAL | NONUNIQUE | APPS_TS_SEED | CLASSIFICATION_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_TAXABILITY_RULES | PAY_ELEMENT_CLASSIFICATIONS | PAY_TAXABILITY_RULES SECONDARY_CLASSIFICATION_ID | PAY_TAXABILITY_RULES | PAY_ELEMENT_CLASSIFICATIONS | PAY_TAXABILITY_RULES CLASSIFICATION_ID | PAY_TAXABILITY_RULES | PAY_TAXABILITY_RULES_DATES | PAY_TAXABILITY_RULES TAXABILITY_RULES_DATE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JURISDICTION_CODE | VARCHAR2 | (11) | Yes | Geocode of the jurisdiction: Federal or State. |
TAX_TYPE | VARCHAR2 | (30) | Type of tax the earnings or pre-tax deduction is subject to. | |
TAX_CATEGORY | VARCHAR2 | (30) | Category of the earnings or pre-tax deduction, for example, Bonuses, Commissions. | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CLASSIFICATION_ID | NUMBER | (9) | Foreign key to PAY_ELEMENT_CLASSIFICATIONS. | |
TAXABILITY_RULES_DATE_ID | NUMBER | (15) | Yes | Foreign key to PAY_TAXABILITY_RULES_DATES. Used to determine the length of time for which the taxability rules are valid. Allows for date-effective maintainence of rules. |
LEGISLATION_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_TERRITORIES. |
STATUS | VARCHAR2 | (30) | Determines whether the category is subject to tax. If set to 'D' then is not subject to tax. | |
SECONDARY_CLASSIFICATION_ID | NUMBER | (9) | Foreign key to PAY_ELEMENT_CLASSIFICATIONS. |
Cut, paste (and edit) the following text to query this object:
SELECT JURISDICTION_CODE
, TAX_TYPE
, TAX_CATEGORY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, CLASSIFICATION_ID
, TAXABILITY_RULES_DATE_ID
, LEGISLATION_CODE
, STATUS
, SECONDARY_CLASSIFICATION_ID
FROM HR.PAY_TAXABILITY_RULES;
HR.PAY_TAXABILITY_RULES does not reference any database object
HR.PAY_TAXABILITY_RULES is referenced by following:
|
|
|