QRY_FLD_HDNG_VW

(SQL View)
Index Back

Query Field Heading


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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
2 QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
3 HEADING Character(30) VARCHAR2(30) NOT NULL Field Heading