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: ViewPER.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:

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
ViewPAY_PAYROLLS_X
SynonymPAY_US_EMP_FED_TAX_RULES_F
SynonymPER_ADDRESSES
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE
SynonymPER_TIME_PERIOD_TYPES

APPS.HR_ADP_FED_TAX_V is not referenced by any database object