DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_ADP_WORK_STATE_TAX_V

Object Details
Object Name: HR_ADP_WORK_STATE_TAX_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_ADP_WORK_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 federal, state and city tax information for employee work 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
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
SUI_STATE_NAME VARCHAR2 (2) Yes SUI state abbreviation
SUI_STATE_CODE VARCHAR2 (2) Yes SUI state abbreviation
SIT_EFFECTIVE_START_DATE DATE
Yes Effective start date for SIT record
SIT_EFFECTIVE_END_DATE DATE
Yes Effective end date for SIT record
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 SIT filing status
SIT_FILING_STATUS_CODE VARCHAR2 (30) Yes SIT filing status code
SIT_ADDITIONAL_TAX NUMBER (11) Yes SIT additional tax
SIT_EXEMPT_FLAG VARCHAR2 (30)
Indicates if employee is exempt from SIT
SIT_EXEMPTION_AMOUNT NUMBER (11) Yes State tax exemption amount
SIT_OPTIONAL_CALC VARCHAR2 (30)
SIT optional calculation code
SIT_SECONDARY_ALLOWANCES NUMBER (2) Yes Number of[ secondary allowances
SUI_WAGE_BASE_OVERRIDE_AMOUNT NUMBER (11)
SUI wage base override amount
FIT_SUPP_OVERRIDE_RATE NUMBER

FIT supplemental override rate
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 for LIT record
LIT_EFFECTIVE_END_DATE DATE
Yes Effective end date for LIT record
LIT_OVERRIDE_AMOUNT NUMBER (11) Yes LIT override amount
SCHOOL_DISTRICT_CODE VARCHAR2 (5)
School district code
WORK_STATE_CODE VARCHAR2 (150)
Work state abbreviation
WORK_STATE_NAME VARCHAR2 (150)
Work state abbreviation
WORK_AT_HOME_FLAG VARCHAR2 (30)
Indicates if employee is working at home
LIT_ADDITIONAL_TAX NUMBER

Additional LIT
LIT_OVERRIDE_RATE NUMBER

LIT override rate
LIT_EXEMPTIONS NUMBER

Number of local tax allowances
SCHOOL_DISTRICT_TAX_FLAG VARCHAR2 (30)
Indicates if employee has to pay school district tax
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
LIT_EXEMPT_FLAG VARCHAR2 (30)
Indicates if employee is exempt from LIT
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 tax override rate.
LIT_ADDITIONAL_ALLOWANCE_RATE NUMBER (6) Yes Additional LIT 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
,      MEDICARE_EXEMPT_FLAG
,      FUTA_EXEMPT_FLAG
,      SS_EXEMPT_FLAG
,      CUMULATIVE_TAXATION_FLAG
,      SUI_STATE_NAME
,      SUI_STATE_CODE
,      SIT_EFFECTIVE_START_DATE
,      SIT_EFFECTIVE_END_DATE
,      SIT_EXEMPTIONS
,      SIT_OVERRIDE_AMOUNT
,      SIT_OVERRIDE_RATE
,      SIT_FILING_STATUS
,      SIT_FILING_STATUS_CODE
,      SIT_ADDITIONAL_TAX
,      SIT_EXEMPT_FLAG
,      SIT_EXEMPTION_AMOUNT
,      SIT_OPTIONAL_CALC
,      SIT_SECONDARY_ALLOWANCES
,      SUI_WAGE_BASE_OVERRIDE_AMOUNT
,      FIT_SUPP_OVERRIDE_RATE
,      LIT_FILING_STATUS
,      LIT_FILING_STATUS_CODE
,      LIT_EFFECTIVE_START_DATE
,      LIT_EFFECTIVE_END_DATE
,      LIT_OVERRIDE_AMOUNT
,      SCHOOL_DISTRICT_CODE
,      WORK_STATE_CODE
,      WORK_STATE_NAME
,      WORK_AT_HOME_FLAG
,      LIT_ADDITIONAL_TAX
,      LIT_OVERRIDE_RATE
,      LIT_EXEMPTIONS
,      SCHOOL_DISTRICT_TAX_FLAG
,      LOCAL_TAX_CODE
,      LOCAL_JURISDICTION
,      COUNTY_NAME
,      LIT_EXEMPT_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_WORK_STATE_TAX_V;

Dependencies

[top of page]

APPS.HR_ADP_WORK_STATE_TAX_V references the following:

SchemaAPPS
PL/SQL PackageHR_ADP - show dependent code
ViewHR_ADP_EMP_REF_V
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
ViewHR_LOOKUPS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
SynonymPAY_STATE_RULES
SynonymPAY_US_CITY_NAMES
SynonymPAY_US_CITY_TAX_INFO_F
SynonymPAY_US_COUNTIES
SynonymPAY_US_EMP_CITY_TAX_RULES_F
SynonymPAY_US_EMP_FED_TAX_RULES_F
SynonymPAY_US_EMP_STATE_TAX_RULES_F
SynonymPAY_US_STATES
SynonymPAY_US_STATE_TAX_INFO_F
SynonymPER_ADDRESSES
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE
SynonymPER_TIME_PERIOD_TYPES
SchemaPUBLIC
SynonymDUAL

APPS.HR_ADP_WORK_STATE_TAX_V is not referenced by any database object