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]

VIEW: APPS.HR_ADP_FED_TAX_V

Object Details

Object Name:	HR_ADP_FED_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_ADP_FED_TAX_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view returns employee federal tax information.
It is intended for use with the ADP Enterprise Payroll interface. The PCPW interface extracts employee tax information from the HR_ADP_RESIDENT_STATE_TAX_V and HR_ADP_WORK_STATE_TAX_V views.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPANY_CODE_EQUIVALENT	VARCHAR2	(60)		ADP company code
GRE_NAME	VARCHAR2	(240)	Yes	GRE name
GRE_ID	VARCHAR2	(60)		GRE ID
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization ID of employee's HR organization
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee number
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Business group ID
PERSON_ID	NUMBER	(10)	Yes	Person ID
PAY_FREQUENCY	VARCHAR2	(40)		Payroll frequency
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment ID
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Assignment number
ASSIGNMENT_SEQUENCE	NUMBER			Assignment sequence
PRIMARY_FLAG	VARCHAR2	(30)	Yes	Indicates primary employee assignment. Y/N.
EFFECTIVE_START_DATE	DATE		Yes	Effective start date of federal tax data row in Oracle HR.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date of federal tax data row in Oracle HR.
FILING_STATUS	VARCHAR2	(80)	Yes	Federal filing status
FILING_STATUS_CODE	VARCHAR2	(30)	Yes	Federal filing status code
ALLOWANCES	NUMBER			Number of allowances
ADDITIONAL_TAX	NUMBER			Additional tax
EIC_FILING_STATUS	VARCHAR2	(80)	Yes	EIC filing status
FIT_EXEMPT_FLAG	VARCHAR2	(30)		Federal income tax exemption flag - Y if exempt, N if not.
MEDICARE_EXEMPT_FLAG	VARCHAR2	(30)		MEDICARE exemption flag - Y if exempt, N if not.
FUTA_EXEMPT_FLAG	VARCHAR2	(30)		FUTA exemption flag - Y if exempt, N if not.
SS_EXEMPT_FLAG	VARCHAR2	(30)		SS exemption flag - Y if exempt, N if not.
OVERRIDE_RATE	NUMBER			Federal income tax override rate (%).
OVERRIDE_AMOUNT	NUMBER			Federal income tax override amount.
SUPP_OVERRIDE_RATE	NUMBER			Supplemental override rate.
STATUTORY_EMPLOYEE_FLAG	VARCHAR2	(30)		Set to Y if the employee governs his or her own conditions of work, and is not considered an employee under common law rules
CUMULATIVE_TAXATION_FLAG	VARCHAR2	(30)		Set to Y if the employee qualifies for cumulative withholding, and requests its application to his or her regular earnings and commissions
GREATEST_LAST_UPDATE_DATE	DATE			Date on which anything significant that is returned by this view was changed for this employee

Query Text

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


SELECT COMPANY_CODE_EQUIVALENT
,      GRE_NAME
,      GRE_ID
,      ORGANIZATION_ID
,      EMPLOYEE_NUMBER
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      PAY_FREQUENCY
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_SEQUENCE
,      PRIMARY_FLAG
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      FILING_STATUS
,      FILING_STATUS_CODE
,      ALLOWANCES
,      ADDITIONAL_TAX
,      EIC_FILING_STATUS
,      FIT_EXEMPT_FLAG
,      MEDICARE_EXEMPT_FLAG
,      FUTA_EXEMPT_FLAG
,      SS_EXEMPT_FLAG
,      OVERRIDE_RATE
,      OVERRIDE_AMOUNT
,      SUPP_OVERRIDE_RATE
,      STATUTORY_EMPLOYEE_FLAG
,      CUMULATIVE_TAXATION_FLAG
,      GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_FED_TAX_V;

Dependencies

[top of page]

APPS.HR_ADP_FED_TAX_V references the following:

APPS: FND_GLOBAL - show dependent code; HR_ADP - show dependent code; HR_ADP_EMP_REF_V; HR_ALL_ORGANIZATION_UNITS; HR_API - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_LOOKUPS; HR_SECURITY - show dependent code; HR_SOFT_CODING_KEYFLEX; PAY_PAYROLLS_X; PAY_US_EMP_FED_TAX_RULES_F; PER_ADDRESSES; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_PERIODS_OF_SERVICE; PER_TIME_PERIOD_TYPES

APPS.HR_ADP_FED_TAX_V is referenced by following:

PUBLIC: HR_ADP_FED_TAX_V