RA_PRF_OPRM_VW (SQL View)	Index Back
Profile Security View This view shows all the roles as users that are authorized to view the dialogs. Dialog must be secure and authorization to view dialog must be on

RA_PRF_OPRM_VW

(SQL View)

Profile Security View

This view shows all the roles as users that are authorized to view the dialogs. Dialog must be secure and authorization to view dialog must be on

SELECT DISTINCT A.RA_PROFILE_ID ,B.OPRID FROM PS_RA_MKTCTR_PRF A , PS_RA_MC_OPRANC_VW B , PS_RA_PROFILE C WHERE A.RA_MKT_CENTER= B.RA_MKT_CENTER AND A.RA_PROFILE_ID = C.RA_PROFILE_ID AND C.RA_SECURE_PRF = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RA_PROFILE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Profile - profile ID
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).