PSARCHQRY

(SQL View)
Index Back

Archive Queries


SELECT QRYNAME , DESCR FROM PSQRYDEFN WHERE OPRID = ' ' AND QRYTYPE = 7

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description