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 NameField TypeColumn TypeDescription
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
QRYFLDNAMECharacter(30)VARCHAR2(30) NOT NULLSource Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19