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

VIEW: APPS.PAY_US_PSD_ACTION_INFO_V

Object Details
Object Name: PAY_US_PSD_ACTION_INFO_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


PAY_US_PSD_ACTION_INFO_V view retrieves PSD tax information from the archiver.


[View Source]

Columns
Name Datatype Length Mandatory Comments
EFFECTIVE_DATE DATE

Effective date of the record
JURISDICTION_CODE VARCHAR2 (30)
Jurisdiction Code
ACTION_NUMBER NUMBER (15) Yes Foreign key to PAY_ACTION_CONTEXTS
ASSIGNMENT_ID NUMBER (10)
Assignment Id
PSD_WITHHELD NUMBER

PSD tax withheld
PSD_SUBJ_WHABLE NUMBER

PSD Subject to withholdable
CITY_PSD_WITHHELD NUMBER

City Component of the PSD tax withheld
CITY_PSD_SUBJ_WHABLE NUMBER

City Component of the Subject to withholdable
SCHOOL_PSD_WITHHELD NUMBER

School Disctrict Component of PSD tax withheld
NON_RESIDENT_FLAG VARCHAR2 (240)
Resident or Non Resident Flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EFFECTIVE_DATE
,      JURISDICTION_CODE
,      ACTION_NUMBER
,      ASSIGNMENT_ID
,      PSD_WITHHELD
,      PSD_SUBJ_WHABLE
,      CITY_PSD_WITHHELD
,      CITY_PSD_SUBJ_WHABLE
,      SCHOOL_PSD_WITHHELD
,      NON_RESIDENT_FLAG
FROM APPS.PAY_US_PSD_ACTION_INFO_V;

Dependencies

[top of page]

APPS.PAY_US_PSD_ACTION_INFO_V references the following:

SchemaAPPS
SynonymPAY_ACTION_INFORMATION
APPS.PAY_US_PSD_ACTION_INFO_V is referenced by following:

SchemaAPPS
Package BodyPAY_ARCHIVER_REPORT_PKG - show dependent code