PTSF_QRY_FLD_VW

 index back

PTSF Query Field View

This view returns the all fields from the query
SELECT DISTINCT PSQRYFIELD.QRYNAME , PSQRYFIELD.QRYFLDNAME ,PSQRYFIELD.FIELDNAME FROM PSQRYFIELD WHERE PSQRYFIELD.QRYFLDNAME <> ' '

PeopleSoft Field Name Field Type Column Type Description
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20