RC_EMAILLVW1

(SQL View)
 Index Back

BO email address

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

SELECT B.BO_ID , B.PROFILE_CM_SEQ , D.LANGUAGE_CD , D.DESCR , D.DESCR FROM PS_BO_CM B , PS_CM_PURP_TYP_LNG D WHERE B.CM_TYPE_ID = 4 AND B.CM_PURPOSE_TYPE_ID = D.CM_PURPOSE_TYPE_ID AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn

  • Related Language Record for RC_EMAIL_VW1

    • # 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 PROFILE_CM_SEQ_EML Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for a email address.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RC_PURP_TYPE_DSC30 Character(30) VARCHAR2(30) NOT NULL Purpose Type
    5 RC_PURP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Short Description