AWDNTFINQ_RLVW (SQL View)	Index Back
Award Notif Inq Role View This view lists rolenames which correspond to oprids that are authorized to use the award notification inquiry page.

AWDNTFINQ_RLVW

(SQL View)

Award Notif Inq Role View

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

SELECT DISTINCT A.ROLEUSER FROM PSROLEUSER A , PSROLECLASS B , PSAUTHITEM C , PSPNLGROUP D WHERE B.ROLENAME = A.ROLENAME AND C.CLASSID = B.CLASSID AND C.MENUNAME = 'PACKAGE_AID' AND C.BARNAME = 'INQUIRE1' AND C.BARITEMNAME = 'AWARD_NOTIF_INQ' AND D.PNLGRPNAME = 'AWARD_NOTIF_INQ' AND D.PNLNAME = 'AWARD_NOTIF_DETAIL' AND D.HIDDEN = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User