SECURITY_DIM_VW

(SQL View)
 Index Back

SELECT DISTINCT A.QRYNAME, A.DESCR FROM PSQRYDEFN A, PSQRYFIELD B, PSQRYSELECT C WHERE A.OPRID = B.OPRID AND A.QRYNAME = B.QRYNAME AND B.OPRID = C.OPRID AND B.QRYNAME = C.QRYNAME AND B.SELNUM = C.SELNUM AND B.COLUMNNUM > 0 AND ( B.FIELDNAME = 'OPRID' OR B.FIELDNAME = 'OPRCLASS')

# 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