PTSF_QRYDTTM_VW

 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 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