[Home] [Help] [Dependency Information]
Object Name: | PAY_US_PSD_ACTION_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|