RC_EMAILLVW2

(SQL View)
 Index Back

Email Address Language View

This is a Call Center Related Language View used for Email Address.

SELECT DISTINCT C.EMAIL_ADDR , D.LANGUAGE_CD , D.DESCR FROM PS_BO_SRCH_EML C , PS_CM_PURP_TYP_LNG D WHERE C.ROLE_TYPE_ID = 4 AND C.BO_CM_USE_TYPE = 'R' AND C.CM_PURPOSE_TYPE_ID = D.CM_PURPOSE_TYPE_ID

  • Related Language Record for RC_EMAIL_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMAIL_ADDR_CUST Character(70) VARCHAR2(70) NOT NULL email address for the customer - used in case
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RC_PURP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Short Description