QRY_HDNG_NUM_VW

index back

Query Field Heading


select distinct QRYNAME, COLUMNNUM, QRYFLDNAME, HEADING from PSQRYFIELD where SELNUM=1 and COLUMNNUM > 0

PeopleSoft Field Name Field Type Column Type Description
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence
QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
HEADING Character(30) VARCHAR2(30) NOT NULL Field Heading
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20