AWDNTFINQ_OPVW (SQL View)	Index Back
Award Notif Inq Operator View This view lists oprids that are authorized to use the award notification inquiry page.

AWDNTFINQ_OPVW

(SQL View)

Award Notif Inq Operator View

This view lists oprids that are authorized to use the award notification inquiry page.

SELECT DISTINCT A.OPRID FROM PSOPRDEFN A , PSAUTHITEM B , PSPNLGROUP C WHERE B.CLASSID = A.OPRCLASS AND B.MENUNAME = 'PACKAGE_AID' AND B.BARNAME = 'INQUIRE1' AND B.BARITEMNAME = 'AWARD_NOTIF_INQ' AND C.PNLGRPNAME = 'AWARD_NOTIF_INQ' AND C.PNLNAME = 'AWARD_NOTIF_DETAIL' AND C.HIDDEN = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).