RA_MC_OPRACT_VW (SQL View)	Index Back
Operator Active Marketing Marketing Center Operator Ancestry / Hierarchy By ACTIVE marketing centers, with type of Recruit - show all oprid of all parents

RA_MC_OPRACT_VW

(SQL View)

Operator Active Marketing

Marketing Center Operator Ancestry / Hierarchy By ACTIVE marketing centers, with type of Recruit - show all oprid of all parents

SELECT a.oprid , b.cs_institution , a.ra_mkt_center , b.ra_mc_level_num , b.descr50 FROM ps_ra_mc_opranc_vw a , PS_RA_UD_MKTCENTER b WHERE a.ra_mkt_center = b.ra_mkt_center AND b.status = 'A' AND b.ra_he_center_type <> 'A'

# 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

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

4 RA_MC_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Marketing Center - Level Number

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

#	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	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system.
3	RA_MKT_CENTER	Character(10)	VARCHAR2(10) NOT NULL	Marketing Center code
4	RA_MC_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Marketing Center - Level Number
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50