PTSF_DQRYFLD_VW

index back

Query Field View


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 Field Type Column Type Description
PTSF_PSQUERY_DLT Character(30) VARCHAR2(30) NOT NULL Query Name

Prompt Table: PTSF_DELQRYS_VW

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