WTHD_BUFLD_VW1 (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_BUFLD_VW1

(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 B.FIELDNAME FROM PSRECFIELD A , PSRECFIELD B WHERE A.RECNAME = 'BU_WTHD_FLD_SBR' AND B.RECNAME = A.FIELDNAME AND A.SUBRECORD = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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