TL_QRYEXCL_VW

(SQL View)
 Index Back

Psquery name prompt view


SELECT DISTINCT A.QRYNAME ,A.DESCR FROM PSQRYDEFN A WHERE EXISTS ( SELECT 'X' FROM PSQRYFIELD B , PSQRYFIELD C WHERE B.QRYNAME = C.QRYNAME AND B.QRYNAME = A.QRYNAME AND B.FIELDNAME = 'EMPLID' AND C.FIELDNAME = 'EMPL_RCD') AND A.OPRID =' ' AND A.QRYTYPE =5

# 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