SAD_CRM_SPLN_VW (SQL View)	Index Back
Acad Sub-Plan View SA/CRM Integration View created to load academic sub-plans into the CRM database as attribute choices on the marketing profiles.

SAD_CRM_SPLN_VW

(SQL View)

Acad Sub-Plan View

SA/CRM Integration View created to load academic sub-plans into the CRM database as attribute choices on the marketing profiles.

SELECT DISTINCT 'CS_ACAD_SUB_PLAN' , ACAD_SUB_PLAN , ACAD_SUB_PLAN %Concat ' - ' %Concat DESCR FROM PS_ACAD_SUBPLN_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

2 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	FIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Field Value
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50