PTSF_QRY_URL_VW

(SQL View)
 Index Back

PTSF Query URL Field View

This view returns the Drill URL fields from the query

SELECT DISTINCT PSQRYFIELD.QRYNAME , PSQRYFIELD.QRYFLDNAME , PSQRYFIELD.FIELDNAME FROM PSQRYFIELD , PSQRYEXPR WHERE PSQRYFIELD.QRYNAME = PSQRYEXPR.QRYNAME AND PSQRYFIELD.FLDEXPNUM = PSQRYEXPR.EXPNUM AND PSQRYEXPR.FIELDTYPE=11 AND PSQRYFIELD.QRYFLDNAME <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
2 QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).