PTSF_QRY_URL_VW

index back

PTSF Query URL Field View

This view returns the Drill URL fields from the query
SELECT DISTINCT PSQRYFIELD.QRYNAME , PSQRYFIELD.QRYFLDNAME FROM PSQRYFIELD , PSQRYEXPR WHERE PSQRYFIELD.QRYNAME = PSQRYEXPR.QRYNAME AND PSQRYFIELD.FLDEXPNUM = PSQRYEXPR.EXPNUM AND PSQRYEXPR.FIELDTYPE=11 AND 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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19