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