SAD_CRM_RTRM_VW

(SQL View)
Index Back

Requirement Term View

SA/CRM Integration View created to load requirment terms into the CRM database as attribute choices on the marketing profiles.

SELECT DISTINCT 'CS_REQ_TERM' , STRM , STRM %Concat ' - ' %Concat DESCR FROM PS_TERM_VAL_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