RA_LST_OPRM_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_OPRM_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 DISTINCT A.SETID , A.RA_LIST_ID , B.OPRID FROM PS_RA_MKTCTR_AUD A , ps_ra_mc_opranc_vw B , PS_RA_LIST C WHERE a.ra_mkt_center= b.ra_mkt_center AND A.SETID = C.SETID AND A.RA_LIST_ID = C.RA_LIST_ID AND C.RA_LIST_SECURE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	RA_LIST_ID	Character(15)	VARCHAR2(15) NOT NULL	Audience ID
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).