WTHD_FIELDS_VW (SQL View)	Index Back
Withholding Fields View returns all of the fields used in record WTHD_FIELDS_SBR. This is used to populate the withholding entity fields record.

WTHD_FIELDS_VW

(SQL View)

Withholding Fields

View returns all of the fields used in record WTHD_FIELDS_SBR. This is used to populate the withholding entity fields record.

SELECT DISTINCT FIELDNAME FROM PSRECFIELD WHERE (RECNAME = 'WTHD_FIELDS_SBR' AND SUBRECORD = 'N') OR (FIELDNAME = 'CUSIP_NBR' OR FIELDNAME = 'STATE_INCOME' OR FIELDNAME = 'AP_TIN_STATUS_CD')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).