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

AWDNTFDTL_RLVW

(SQL View)

Award Notif Dtl Role View

This view lists rolenames which correspond to oprids that are authorized to use the award notification detail 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 = 'USE' AND C.BARITEMNAME = 'AWARD_NOTIF_DETAIL' AND D.PNLGRPNAME = 'AWARD_NOTIF_DETAIL' 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