RA_PRF_SRCH_VW

(SQL View)
Index Back

Audience Security View

This view shows all the users authorized to view the Audience

SELECT A.RA_PROFILE_ID , A.RA_PROFILE_NAME , A.RA_PROFILE_TYPE , A.RA_ONE_OR_MANY , A.DESCR254 , A.RA_PROFILE_STATUS , A.RA_PROFILE_GROUP , B.OPRID FROM PS_RA_PROFILE A , PS_RA_PRF_SCRTY_VW B WHERE A.RA_PROFILE_ID=B.RA_PROFILE_ID

# 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 RA_PROFILE_NAME Character(80) VARCHAR2(80) NOT NULL Profile - Name
3 RA_PROFILE_TYPE Character(4) VARCHAR2(4) NOT NULL Profile - Type
SYS=System Global
USER=User
4 RA_ONE_OR_MANY Character(1) VARCHAR2(1) NOT NULL Profile - One or Many
M=Many rows
N=One row
5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
6 RA_PROFILE_STATUS Character(3) VARCHAR2(3) NOT NULL Profile - status
AC1=Activating
ACT=Activated
DES=In Design
INA=Inactivated
REJ=Rejected
REQ=Requested
UPD=Update
7 RA_PROFILE_GROUP Character(3) VARCHAR2(3) NOT NULL Profile - Group
IND=Individuals
ORG=Organizations
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).