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.HR_H2PI_FEDERAL_TAX_RULES

Object Details

Object Name:	HR_H2PI_FEDERAL_TAX_RULES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_H2PI_FEDERAL_TAX_RULES
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(10)	Yes	Person ID
EMP_FED_TAX_RULE_ID	NUMBER	(9)	Yes	System generated primary key column
EFFECTIVE_START_DATE	DATE		Yes	Effective start date
EFFECTIVE_END_DATE	DATE		Yes	Effective end date
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment ID
SUI_STATE_CODE	VARCHAR2	(2)	Yes	SUI state code
SUI_JURISDICTION_CODE	VARCHAR2	(11)	Yes	SUI jurisdiction code in format XX-YYY-ZZZZ, XX state, YYY county, ZZZZ-city
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group ID
CLIENT_ID	NUMBER	(15)	Yes	Client id
ADDITIONAL_WA_AMOUNT	NUMBER	(11)	Yes	The extra W4 withholding amount
FILING_STATUS_CODE	VARCHAR2	(30)	Yes	The W4 filing status code
FIT_OVERRIDE_AMOUNT	NUMBER	(11)	Yes	Federal income tax override amount
FIT_OVERRIDE_RATE	NUMBER	(6)	Yes	Federal income tax override rate (%)
WITHHOLDING_ALLOWANCES	NUMBER	(3)	Yes	W4 withholding allowance
CUMULATIVE_TAXATION	VARCHAR2	(30)		Cumulative taxation flag Y or N
EIC_FILING_STATUS_CODE	VARCHAR2	(30)		EIC filing status code
FIT_ADDITIONAL_TAX	NUMBER	(11)	Yes	Federal income tax additional tax
FIT_EXEMPT	VARCHAR2	(30)		Federal income tax exempt
FUTA_TAX_EXEMPT	VARCHAR2	(30)		FUTA tax exemption flag
MEDICARE_TAX_EXEMPT	VARCHAR2	(30)		Medicare tax exemption flag
SS_TAX_EXEMPT	VARCHAR2	(30)		Social security tax exempt flag
STATUTORY_EMPLOYEE	VARCHAR2	(30)		Statutory employee flag
W2_FILED_YEAR	NUMBER	(4)		The year W2 was filed
SUPP_TAX_OVERRIDE_RATE	NUMBER	(6)		Supplimental override rate
EXCESSIVE_WA_REJECT_DATE	DATE			The allowance rejet date
LAST_UPD_DATE	DATE			Last update date
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
STATUS	VARCHAR2	(1)		Status of record for upload

Query Text

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


SELECT PERSON_ID
,      EMP_FED_TAX_RULE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_ID
,      SUI_STATE_CODE
,      SUI_JURISDICTION_CODE
,      BUSINESS_GROUP_ID
,      CLIENT_ID
,      ADDITIONAL_WA_AMOUNT
,      FILING_STATUS_CODE
,      FIT_OVERRIDE_AMOUNT
,      FIT_OVERRIDE_RATE
,      WITHHOLDING_ALLOWANCES
,      CUMULATIVE_TAXATION
,      EIC_FILING_STATUS_CODE
,      FIT_ADDITIONAL_TAX
,      FIT_EXEMPT
,      FUTA_TAX_EXEMPT
,      MEDICARE_TAX_EXEMPT
,      SS_TAX_EXEMPT
,      STATUTORY_EMPLOYEE
,      W2_FILED_YEAR
,      SUPP_TAX_OVERRIDE_RATE
,      EXCESSIVE_WA_REJECT_DATE
,      LAST_UPD_DATE
,      OBJECT_VERSION_NUMBER
,      STATUS
FROM HR.HR_H2PI_FEDERAL_TAX_RULES;

Dependencies

[top of page]

HR.HR_H2PI_FEDERAL_TAX_RULES does not reference any database object

HR.HR_H2PI_FEDERAL_TAX_RULES is referenced by following:

APPS: HR_H2PI_FEDERAL_TAX_RULES
PUBLIC: HR_H2PI_FEDERAL_TAX_RULES