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_CITY_TAX_V

Object Details

Object Name:	HR_ADP_CITY_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_ADP_CITY_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 city 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 for 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 city tax data row in Oracle HR
EFFECTIVE_END_DATE	DATE		Effective end date of city tax data row in Oracle HR
RESIDENT_FLAG	CHAR	(1)	Indicates if the employee is resident in this city for tax purposes
WORK_FLAG	CHAR	(1)	Indicates if the employee works in this city for tax purposes
STATE_ABBREV	VARCHAR2	(2)	Abbreviation for state, eg. CA.
COUNTY_NAME	VARCHAR2	(30)	County name
CITY_NAME	VARCHAR2	(30)	City name
JURISDICTION_CODE	VARCHAR2	(11)	Vertex tax jurisdiction code
FILING_STATUS	VARCHAR2	(80)	Local tax filing status
FILING_STATUS_CODE	VARCHAR2	(30)	Local tax filing status code
ALLOWANCES	NUMBER		Number of allowances
ADDITIONAL_TAX	NUMBER		Additional tax
ADDITIONAL_ALLOWANCE_RATE	NUMBER		Additional allowance rate
LIT_EXEMPT_FLAG	VARCHAR2	(30)	Indicates if employee is exempt from LIT
SD_EXEMPT_FLAG	VARCHAR2	(1)	Indicates if employee is exempt from paying school district tax
OCC_PRIV_TAX_EXEMPT	VARCHAR2	(1)	Indicates if employee is exempt from occupational privilege tax
OVERRIDE_RATE	NUMBER		Override rate
OVERRIDE_AMOUNT	NUMBER		Override amount
SCHOOL_DISTRICT_CODE	VARCHAR2	(5)	School district code
SCHOOL_DISTRICT_NAME	VARCHAR2	(15)	School district name
LIT_EXISTS	VARCHAR2	(1)	LIT Exists Flag
GREATEST_LAST_UPDATE_DATE	DATE		Date on which anything significant that is returned by this view was last 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
,      COUNTY_NAME
,      CITY_NAME
,      JURISDICTION_CODE
,      FILING_STATUS
,      FILING_STATUS_CODE
,      ALLOWANCES
,      ADDITIONAL_TAX
,      ADDITIONAL_ALLOWANCE_RATE
,      LIT_EXEMPT_FLAG
,      SD_EXEMPT_FLAG
,      OCC_PRIV_TAX_EXEMPT
,      OVERRIDE_RATE
,      OVERRIDE_AMOUNT
,      SCHOOL_DISTRICT_CODE
,      SCHOOL_DISTRICT_NAME
,      LIT_EXISTS
,      GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_CITY_TAX_V;

Dependencies

[top of page]

APPS.HR_ADP_CITY_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_US_CITY_NAMES; PAY_US_CITY_SCHOOL_DSTS; PAY_US_CITY_TAX_INFO_F; PAY_US_COUNTIES; PAY_US_EMP_CITY_TAX_RULES_F; PAY_US_STATES; PER_ADDRESSES; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_PERIODS_OF_SERVICE; PER_TIME_PERIOD_TYPES

APPS.HR_ADP_CITY_TAX_V is not referenced by any database object