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_RESIDENT_STATE_TAX_V

Object Details

Object Name:	HR_ADP_RESIDENT_STATE_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_ADP_RESIDENT_STATE_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 state and city tax information for employee resident addresses. It is intended for use with the ADP PCPW interface.
The Enterprise payroll interface extracts employee tax information from the HR_ADP_FED_TAX_V, HR_ADP_STATE_TAX_V and HR_ADP_CITY_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 for 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.
FIT_EFFECTIVE_START_DATE	DATE		Yes	Effective start date for FIT record
FIT_EFFECTIVE_END_DATE	DATE		Yes	Effective end date for FIT record
FIT_FILING_STATUS	VARCHAR2	(30)	Yes	FIT filing status
FIT_FILING_STATUS_CODE	VARCHAR2	(30)		FIT filing status code
FIT_EXEMPTIONS	NUMBER			Number of federal tax allowances
FIT_OVERRIDE_AMOUNT	NUMBER			Federal income tax override amount
FIT_OVERRIDE_RATE	NUMBER			Federal income tax 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
FIT_ADDITIONAL_TAX	NUMBER			Amount of additional tax
EIC_FILING_STATUS	VARCHAR2	(30)		EIC filing status
FIT_EXEMPT_FLAG	VARCHAR2	(30)		Indicates if employee is exempt from FIT
FIT_SUPP_OVERRIDE_RATE	NUMBER			FIT supplemental override rate
MEDICARE_EXEMPT_FLAG	VARCHAR2	(1)		Indicates if employee is exempt from Medicare
FUTA_EXEMPT_FLAG	VARCHAR2	(1)		Indicates if employee is exempt from FUTA
SS_EXEMPT_FLAG	VARCHAR2	(1)		Indicates if employee is exempt from SS
CUMULATIVE_TAXATION_FLAG	VARCHAR2	(1)		Set to Y if the employee qualifies for cumulative withholding, and requests its application to his or her regular earnings and commissions
RESIDENT_STATE_CODE	VARCHAR2	(150)		State abbreviation for employee's resident state for tax purposes
RESIDENT_STATE_NAME	VARCHAR2	(150)		State abbreviation for employee's resident state for tax purposes
LOCAL_TAX_CODE	VARCHAR2	(11)	Yes	Vertex jurisdiction code
LOCAL_JURISDICTION	VARCHAR2	(30)	Yes	Name of local tax jurisdiction
COUNTY_NAME	VARCHAR2	(150)		County name
SIT_EFFECTIVE_START_DATE	DATE		Yes	Effective start date of state tax data row in Oracle HR
SIT_EFFECTIVE_END_DATE	DATE		Yes	Effective end date of state tax data row in Oracle HR
SIT_EXEMPT_FLAG	VARCHAR2	(30)		Indicates if employee is exempt from SIT
SIT_EXEMPTIONS	NUMBER			Number of state tax allowances
SIT_OVERRIDE_AMOUNT	NUMBER			State income tax override amount
SIT_OVERRIDE_RATE	NUMBER			State income tax override rate(%)
SIT_FILING_STATUS	VARCHAR2	(80)	Yes	State filing status
SIT_FILING_STATUS_CODE	VARCHAR2	(30)	Yes	State filing status code
SIT_ADDITIONAL_TAX	NUMBER	(11)	Yes	Amount of additional tax
SIT_EXEMPTION_AMOUNT	NUMBER	(11)	Yes	State tax exemption amount
SIT_OPTIONAL_CALC	VARCHAR2	(30)		Indicates if there is an optional SIT calculation
SIT_SECONDARY_ALLOWANCES	NUMBER	(2)	Yes	Number of secondary allowances
SUI_WAGE_BASE_OVERRIDE_AMOUNT	NUMBER	(11)		SUI wage base override amount
LIT_FILING_STATUS	VARCHAR2	(80)	Yes	LIT filing status
LIT_FILING_STATUS_CODE	VARCHAR2	(30)	Yes	LIT filing status code
LIT_EFFECTIVE_START_DATE	DATE		Yes	Effective start date of city tax data row in Oracle HR
LIT_EFFECTIVE_END_DATE	DATE		Yes	Effective end date of city tax data row in Oracle HR
LIT_OVERRIDE_AMOUNT	NUMBER	(11)	Yes	LIT override amount
LIT_EXEMPTIONS	NUMBER			Number of local tax allowances
SCHOOL_DISTRICT_CODE	VARCHAR2	(5)		School district code
LIT_EXEMPT_FLAG	VARCHAR2	(30)		Indicates if employee is exempt from LIT
LIT_ADDITIONAL_TAX	NUMBER			Additional tax
LIT_OVERRIDE_RATE	NUMBER			Override rate
SCHOOL_DISTRICT_TAX_FLAG	VARCHAR2	(30)		Indicates if employee has to pay school district tax
SUI_STATE_NAME	VARCHAR2	(2)	Yes	SUI state abbreviation
SUI_STATE_CODE	VARCHAR2	(2)	Yes	SUI state abbreviation
WORK_AT_HOME_FLAG	VARCHAR2	(30)		Indicates if employee is working at home
SUI_EXEMPT_FLAG	VARCHAR2	(1)		Indicates if employee is exempt from SUI
SDI_EXEMPT_FLAG	VARCHAR2	(1)		Indicates if employee is exempt from SDI
WC_EXEMPT_FLAG	VARCHAR2	(1)		Indicates if employee is exempt from WC
STATE_NON_RESIDENT_CERT	VARCHAR2	(1)		Indicates if employee is certified non-resident in the state
OCC_PRIV_TAX_EXEMPT	VARCHAR2	(1)		Indicates if employee has to pay occupational privilege tax
SIT_SUPP_OVERRIDE_RATE	NUMBER	(6)		Supplemental override rate
LIT_ADDITIONAL_ALLOWANCE_RATE	NUMBER	(6)	Yes	LIT additional allowance rate
SIT_EXISTS	VARCHAR2	(1)		SIT Exists Flag
LIT_EXISTS	VARCHAR2	(1)		LIT Exists Flag
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
,      FIT_EFFECTIVE_START_DATE
,      FIT_EFFECTIVE_END_DATE
,      FIT_FILING_STATUS
,      FIT_FILING_STATUS_CODE
,      FIT_EXEMPTIONS
,      FIT_OVERRIDE_AMOUNT
,      FIT_OVERRIDE_RATE
,      STATUTORY_EMPLOYEE_FLAG
,      FIT_ADDITIONAL_TAX
,      EIC_FILING_STATUS
,      FIT_EXEMPT_FLAG
,      FIT_SUPP_OVERRIDE_RATE
,      MEDICARE_EXEMPT_FLAG
,      FUTA_EXEMPT_FLAG
,      SS_EXEMPT_FLAG
,      CUMULATIVE_TAXATION_FLAG
,      RESIDENT_STATE_CODE
,      RESIDENT_STATE_NAME
,      LOCAL_TAX_CODE
,      LOCAL_JURISDICTION
,      COUNTY_NAME
,      SIT_EFFECTIVE_START_DATE
,      SIT_EFFECTIVE_END_DATE
,      SIT_EXEMPT_FLAG
,      SIT_EXEMPTIONS
,      SIT_OVERRIDE_AMOUNT
,      SIT_OVERRIDE_RATE
,      SIT_FILING_STATUS
,      SIT_FILING_STATUS_CODE
,      SIT_ADDITIONAL_TAX
,      SIT_EXEMPTION_AMOUNT
,      SIT_OPTIONAL_CALC
,      SIT_SECONDARY_ALLOWANCES
,      SUI_WAGE_BASE_OVERRIDE_AMOUNT
,      LIT_FILING_STATUS
,      LIT_FILING_STATUS_CODE
,      LIT_EFFECTIVE_START_DATE
,      LIT_EFFECTIVE_END_DATE
,      LIT_OVERRIDE_AMOUNT
,      LIT_EXEMPTIONS
,      SCHOOL_DISTRICT_CODE
,      LIT_EXEMPT_FLAG
,      LIT_ADDITIONAL_TAX
,      LIT_OVERRIDE_RATE
,      SCHOOL_DISTRICT_TAX_FLAG
,      SUI_STATE_NAME
,      SUI_STATE_CODE
,      WORK_AT_HOME_FLAG
,      SUI_EXEMPT_FLAG
,      SDI_EXEMPT_FLAG
,      WC_EXEMPT_FLAG
,      STATE_NON_RESIDENT_CERT
,      OCC_PRIV_TAX_EXEMPT
,      SIT_SUPP_OVERRIDE_RATE
,      LIT_ADDITIONAL_ALLOWANCE_RATE
,      SIT_EXISTS
,      LIT_EXISTS
,      GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_RESIDENT_STATE_TAX_V;

Dependencies

[top of page]

APPS.HR_ADP_RESIDENT_STATE_TAX_V references the following:

APPS: 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_STATE_RULES; PAY_US_CITY_NAMES; PAY_US_CITY_TAX_INFO_F; PAY_US_COUNTIES; PAY_US_EMP_CITY_TAX_RULES_F; PAY_US_EMP_FED_TAX_RULES_F; PAY_US_EMP_STATE_TAX_RULES_F; PAY_US_STATES; PAY_US_STATE_TAX_INFO_F; PER_ADDRESSES; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_PERIODS_OF_SERVICE; PER_TIME_PERIOD_TYPES

APPS.HR_ADP_RESIDENT_STATE_TAX_V is not referenced by any database object