RA_UD_MCINUS_VW (SQL View)	Index Back
user security marketing center user security by MARKETING CENTER AND institution. Shows a view of all marketing centers assigned to a user.

RA_UD_MCINUS_VW

(SQL View)

user security marketing center

user security by MARKETING CENTER AND institution. Shows a view of all marketing centers assigned to a user.

SELECT OPRID , RA_MKT_CENTER FROM PS_RA_UD_MC_OPR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN

2 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN
2	RA_MKT_CENTER	Character(10)	VARCHAR2(10) NOT NULL	Marketing Center code