Used as a prompt view for getting Document types of 'DisbursementRoster' and 'Response'

SFA_CRC_RPT_VW1

(SQL View)
 Index Back

SELECT XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME='SFA_CR_DOC_TYPE_T'AND FIELDVALUE IN ('DR','RESP','CR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name