RY_AGG_OPR_VW (SQL View)	Index Back
Dialog Security View This view shows all the users authorized to view the dialogs based upon team member and dialog secure and aggregate report security authorized

RY_AGG_OPR_VW

(SQL View)

Dialog Security View

This view shows all the users authorized to view the dialogs based upon team member and dialog secure and aggregate report security authorized

SELECT C.OPRID , A.DIALOG_ID FROM PS_RY_DLG_TEAM_ALL A , PS_RD_PERSON B , PSOPRALIAS C , PS_RYEDIALOG D WHERE A.BO_ID_PERSON = B.BO_ID AND B.PERSON_ID = C.PERSON_ID AND a.ry_authorized_arpt ='Y' AND A.DIALOG_ID = D.DIALOG_ID AND D.RY_SECURE_DIALOG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.