RA_PUPD_AUDP_VW (SQL View)	Index Back
Audience Prompt View This view returns audiences that the user is authorized to view. Only approved or committed audiences are returned.

RA_PUPD_AUDP_VW

(SQL View)

Audience Prompt View

This view returns audiences that the user is authorized to view. Only approved or committed audiences are returned.

SELECT B.OPRID , A.SETID , A.RA_LIST_ID , A.RA_LIST_NAME , A.DESCR254 , A.RA_STAT_DYN_IND FROM PS_RA_LIST A , PS_RA_LST_SCRTY_VW B WHERE A.SETID=B.SETID AND A.RA_LIST_ID=B.RA_LIST_ID AND A.RA_LIST_STATUS IN ('060', '070')

# 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

4 RA_LIST_NAME Character(30) VARCHAR2(30) NOT NULL Audience / List Name

5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

6 RA_STAT_DYN_IND Character(1) VARCHAR2(1) NOT NULL Fixed/Dynamic Audience indicator
D=Dynamic Audience
S=Fixed Audience

#	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
4	RA_LIST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Audience / List Name
5	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
6	RA_STAT_DYN_IND	Character(1)	VARCHAR2(1) NOT NULL	Fixed/Dynamic Audience indicator D=Dynamic Audience S=Fixed Audience