PTSF_QRYDTTM_VW

(SQL View)
 Index Back

PTSF Query datetime Field View

This view returns the date time fields from the query

SELECT DISTINCT PSQRYFIELD.QRYNAME , PSQRYFIELD.QRYFLDNAME , PSQRYFIELD.FIELDNAME FROM PSQRYFIELD , PSDBFIELD WHERE (PSQRYFIELD.FIELDNAME = PSDBFIELD.FIELDNAME AND PSDBFIELD.FIELDTYPE=6) AND PSQRYFIELD.COLUMNNUM > 0 AND PSQRYFIELD.SELNUM = 1 AND PSQRYFIELD.QRYFLDNAME <> ' ' UNION SELECT DISTINCT PSQRYFIELD.QRYNAME , PSQRYFIELD.QRYFLDNAME , PSQRYFIELD.FIELDNAME FROM PSQRYFIELD , PSQRYEXPR WHERE (PSQRYFIELD.QRYNAME = PSQRYEXPR.QRYNAME AND PSQRYFIELD.FLDEXPNUM = PSQRYEXPR.EXPNUM AND PSQRYEXPR.FIELDTYPE=6) AND PSQRYFIELD.COLUMNNUM > 0 AND PSQRYFIELD.SELNUM = 1 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).