RA_UD_MCUPD_VW (SQL View)	Index Back
Marketing Center with userid View of Marketing Centers that have User IDs assigned to them

RA_UD_MCUPD_VW

(SQL View)

Marketing Center with userid

View of Marketing Centers that have User IDs assigned to them

SELECT A.RA_MKT_CENTER , A.DESCR50 FROM PS_RA_UD_MKTCENTER A WHERE EXISTS ( SELECT B.RA_MKT_CENTER FROM PS_RA_UD_MC_OPR B WHERE A.RA_MKT_CENTER =B.RA_MKT_CENTER)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code
Prompt Table: RA_UD_MCADD_VW

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RA_MKT_CENTER	Character(10)	VARCHAR2(10) NOT NULL	Marketing Center code Prompt Table: RA_UD_MCADD_VW
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50