RA_LST_OPROL_VW (SQL View)	Index Back
Audeince Security View This view shows all the roles as users that are authorized to view the audience. Audeince must be secured and rolese exist to view audience

RA_LST_OPROL_VW

(SQL View)

Audeince Security View

This view shows all the roles as users that are authorized to view the audience. Audeince must be secured and rolese exist to view audience

SELECT B.ROLEUSER , A.SETID , A.RA_LIST_ID FROM PS_RPM_RA_TEAM_ALL A , PSROLEUSER B , PS_RA_LIST D WHERE A.ROLENAME = B.ROLENAME AND A.SETID = D.SETID AND A.RA_LIST_ID = D.RA_LIST_ID AND D.RA_LIST_SECURE_FLG = '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 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

3 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	RA_LIST_ID	Character(15)	VARCHAR2(15) NOT NULL	Audience ID