PTSF_PAR_FLD_VW

index back

PTSF Query URL Field View

This view returns the Drill URL fields from the query
SELECT QRYNAME , QRYFLDNAME , FIELDNAME FROM PSQRYFIELD WHERE SELNUM = 1

PeopleSoft Field Name Field Type Column Type Description
QRYNAMEPARENT Character(30) VARCHAR2(30) NOT NULL Connected Queries Parent Query Name
QRYFLDNAMEPAR Character(30) VARCHAR2(30) NOT NULL Select a Parent Query 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