RA_ACADPMC_VW (SQL View)	Index Back
Career Program MC View Career program view is used in profile record definition. This contains the marketing center and its syncid for marketing center security purposes

RA_ACADPMC_VW

(SQL View)

Career Program MC View

Career program view is used in profile record definition. This contains the marketing center and its syncid for marketing center security purposes

SELECT A.INSTITUTION , A.ACAD_PROG , B.RA_MKT_CENTER , A.EFFDT , C.SYNCID FROM PS_ACAD_PROG_TBL A LEFT OUTER JOIN PS_RA_ACAD_PGM_MC B ON A.INSTITUTION = B.INSTITUTION AND A.ACAD_PROG = B.ACAD_PROG , PS_RA_UD_MKTCENTER C WHERE A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_ACAD_PROG_TBL AA WHERE A.INSTITUTION = AA.INSTITUTION AND A.ACAD_PROG=AA.ACAD_PROG AND AA.EFFDT <= %CurrentDateIn) AND B.RA_MKT_CENTER= C.RA_MKT_CENTER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic program field coming from campus solution system.

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

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system.
2	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic program field coming from campus solution system.
3	RA_MKT_CENTER	Character(10)	VARCHAR2(10) NOT NULL	Marketing Center code
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	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.