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 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 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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19