RA_MC_SRCHTM_VW (SQL View)	Index Back
Marketing Center Search of Marketing Centers by BO_ID

RA_MC_SRCHTM_VW

(SQL View)

Marketing Center

Search of Marketing Centers by BO_ID

SELECT A.SYNCID , C.NAME , A.RA_MKT_CENTER , A.DESCR50 , C.BO_ID FROM PS_RA_MC_SEARCH_VW A , PS_RA_UD_MC_OPR B , PS_RD_PRSN_OPR_VW C WHERE A.RA_MKT_CENTER=B.RA_MKT_CENTER AND B.OPRID = C.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

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

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

5 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	RA_MKT_CENTER	Character(10)	VARCHAR2(10) NOT NULL	Marketing Center code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID