RA_ACAD_PGM_MC (SQL Table)	Index Back
Academic Program MC Marketing Centers that are assigned to an academic program

RA_ACAD_PGM_MC

(SQL Table)

Academic Program MC

Marketing Centers that are assigned to an academic program

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic career field coming from campus solution system.
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine

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

5 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code
Prompt Table: RA_MC_OPRACT_VW

6 RA_ACAD_MCSOURCE Character(3) VARCHAR2(3) NOT NULL Source field is used to store information on how the marketing center was added to the prospect.
A=Auto Assigned
C=Campus Solutions
I=Import
M=Manually Added

7 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

8 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

9 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

10 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

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

12 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system.
3	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic career field coming from campus solution system. BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine
4	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic program field coming from campus solution system.
5	RA_MKT_CENTER	Character(10)	VARCHAR2(10) NOT NULL	Marketing Center code Prompt Table: RA_MC_OPRACT_VW
6	RA_ACAD_MCSOURCE	Character(3)	VARCHAR2(3) NOT NULL	Source field is used to store information on how the marketing center was added to the prospect. A=Auto Assigned C=Campus Solutions I=Import M=Manually Added
7	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
8	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
9	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
10	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
11	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.
12	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time