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_STATE_TAX_V

Object Details

Object Name:	HR_ADP_STATE_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_ADP_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 employee state 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	Comments
COMPANY_CODE_EQUIVALENT	VARCHAR2	(60)	ADP company code
GRE_NAME	VARCHAR2	(240)	GRE name
GRE_ID	VARCHAR2	(60)	GRE ID
ORGANIZATION_ID	NUMBER	(15)	Organization ID of employee's HR organization
EMPLOYEE_NUMBER	VARCHAR2	(30)	Employee number
BUSINESS_GROUP_ID	NUMBER	(15)	Business group ID
PERSON_ID	NUMBER	(10)	Person ID
PAY_FREQUENCY	VARCHAR2	(40)	Payroll frequency
ASSIGNMENT_ID	NUMBER	(10)	Assignment ID
ASSIGNMENT_NUMBER	VARCHAR2	(30)	Assignment number
ASSIGNMENT_SEQUENCE	NUMBER		Assignment sequence
PRIMARY_FLAG	VARCHAR2	(30)	Indicates primary employee assignment. Y/N.
EFFECTIVE_START_DATE	DATE		Effective start date of state tax row in Oracle HR
EFFECTIVE_END_DATE	DATE		Effective end date of state tax row in Oracle HR
RESIDENT_FLAG	CHAR	(1)	Indicates if the employee is resident in this state for tax purposes
WORK_FLAG	CHAR	(1)	Indicates if this employee works in this state for tax purposes
STATE_ABBREV	VARCHAR2	(2)	Abbreviation for state. eg. CA.
FILING_STATUS	VARCHAR2	(80)	State filing status
FILING_STATUS_CODE	VARCHAR2	(30)	State filing status code
ALLOWANCES	NUMBER	(3)	Number of allowances
SECONDARY_ALLOWANCES	NUMBER	(2)	Secondary allowances
ADDITIONAL_TAX	NUMBER		Additional tax
SIT_EXEMPT_FLAG	VARCHAR2	(30)	State income tax exempt flag - Y if exempt, N if not.
SUI_EXEMPT_FLAG	VARCHAR2	(30)	SUI exempt flag - Y if exempt, N if not.
SDI_EXEMPT_FLAG	VARCHAR2	(30)	SDI exempt flag - Y if exempt, N if not.
WC_EXEMPT_FLAG	VARCHAR2	(1)	WC exempt flag - Y if exempt, N if not
STATE_NON_RESIDENT_CERT	VARCHAR2	(30)	Indicates if employee is certified non-resident in the state
SUI_WAGE_BASE_OVERRIDE_AMOUNT	NUMBER	(11)	SUI wage base override amount
OVERRIDE_RATE	NUMBER		State income tax override rate(%).
OVERRIDE_AMOUNT	NUMBER		State income tax override amount.
SUPP_OVERRIDE_RATE	NUMBER		Supplemental override rate.
EXEMPTION_AMOUNT	NUMBER	(11)	Exemption amount
OPTIONAL_CALCULATION	VARCHAR2	(30)	State tax optional calculation code
SIT_EXISTS	VARCHAR2	(1)	SIT 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
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RESIDENT_FLAG
,      WORK_FLAG
,      STATE_ABBREV
,      FILING_STATUS
,      FILING_STATUS_CODE
,      ALLOWANCES
,      SECONDARY_ALLOWANCES
,      ADDITIONAL_TAX
,      SIT_EXEMPT_FLAG
,      SUI_EXEMPT_FLAG
,      SDI_EXEMPT_FLAG
,      WC_EXEMPT_FLAG
,      STATE_NON_RESIDENT_CERT
,      SUI_WAGE_BASE_OVERRIDE_AMOUNT
,      OVERRIDE_RATE
,      OVERRIDE_AMOUNT
,      SUPP_OVERRIDE_RATE
,      EXEMPTION_AMOUNT
,      OPTIONAL_CALCULATION
,      SIT_EXISTS
,      GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_STATE_TAX_V;

Dependencies

[top of page]

APPS.HR_ADP_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_PAYROLLS_X; PAY_STATE_RULES; 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_STATE_TAX_V is not referenced by any database object