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

VIEW: APPS.HR_CERIDIAN_500_RESIDENT_TAX_V

Object Details
Object Name: HR_CERIDIAN_500_RESIDENT_TAX_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_CERIDIAN_500_RESIDENT_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 resident addresses.
Ceridian's SourceLink interface module has not yet been configured to extract information from this view.


[View Source]

Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number
EFFECTIVE_START_DATE DATE

Effective start date of employee tax data
EFFECTIVE_END_DATE DATE

Effective end date of employee tax data
ASSIGNMENT_NUMBER VARCHAR2 (30)
Employee assignment number.
PRIMARY_FLAG VARCHAR2 (30) Yes Indicates primary employee assignment. Y/N.
SOCIAL_SECURITY_NUMBER VARCHAR2 (30)
Social security number
COMPANY VARCHAR2 (240) Yes GRE name
TAX_STATUS VARCHAR2 (30)
FIT filing status
FICA_FUTA_EXEMPT VARCHAR2 (4000)
Ceridian specific code showing FICA/FUTA exemption status
FEDERAL_TAX_EXEMPT VARCHAR2 (30)
Indicates if employee is exempt from FIT
FIT_EXEMPTIONS NUMBER (3) Yes Number of federal tax allowances
FEDERAL_TAX_ADJ VARCHAR2 (122)
Federal tax adjustment (override amount, override rate or additional amount)
STATE_TAX_EXEMPT VARCHAR2 (30)
Indicates if employee is exempt from SIT
SIT_EXEMPTIONS NUMBER (3) Yes Number of state tax allowances
STATE_TAX_ADJ VARCHAR2 (122)
State tax adjustment (override amount, override rate or additional amount)
LOCAL_TAX_EXEMPT VARCHAR2 (30)
Indicates if employee is exempt from LIT
LOCAL_ADJUSTMENT_AMOUNT VARCHAR2 (122)
Local tax adjustment (override amount, override rate or additional amount)
PRIMARY_STATE VARCHAR2 (150)
Resident state
PRIMARY_LOCAL VARCHAR2 (11) Yes Vertex jurisdiction code
PRIMARY_JURISDICTION VARCHAR2 (30) Yes Name of local tax jurisdiction
CITY VARCHAR2 (30) Yes Resident city
ASSIGNMENT_ID NUMBER (10) Yes Assignment ID
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group ID.
PAYROLL_ID NUMBER (9)
Business Group ID
PERSON_ID NUMBER (10) Yes Person ID.
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 EMPLOYEE_NUMBER
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_NUMBER
,      PRIMARY_FLAG
,      SOCIAL_SECURITY_NUMBER
,      COMPANY
,      TAX_STATUS
,      FICA_FUTA_EXEMPT
,      FEDERAL_TAX_EXEMPT
,      FIT_EXEMPTIONS
,      FEDERAL_TAX_ADJ
,      STATE_TAX_EXEMPT
,      SIT_EXEMPTIONS
,      STATE_TAX_ADJ
,      LOCAL_TAX_EXEMPT
,      LOCAL_ADJUSTMENT_AMOUNT
,      PRIMARY_STATE
,      PRIMARY_LOCAL
,      PRIMARY_JURISDICTION
,      CITY
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      PAYROLL_ID
,      PERSON_ID
,      LAST_UPDATE_DATE
FROM APPS.HR_CERIDIAN_500_RESIDENT_TAX_V;

Dependencies

[top of page]

APPS.HR_CERIDIAN_500_RESIDENT_TAX_V references the following:

SchemaAPPS
PL/SQL PackageHR_CERIDIAN - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
SynonymPAY_US_CITY_NAMES
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
SynonymPER_ADDRESSES
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE

APPS.HR_CERIDIAN_500_RESIDENT_TAX_V is not referenced by any database object