RY_DEDUP_LNG

(SQL View)
 Index Back

Language SQL view

Language SQL view for Dialog e-mail dedup page

SELECT jobnum.RY_RECORD_ID ,dlg.LANGUAGE_CD , dlg.RY_DIALOG_NAME FROM PS_RY_BULK_DED_CNT jobnum , PS_RY_AUDIENCE aud , PS_RY_BULK_JOB bjob , PS_RY_ACT_TASK act , PS_RYEDIALOG_LNG dlg , PS_RY_ACT_TASK ms WHERE jobnum.RY_BULK_JOB_ID=bjob.RY_BULK_JOB_ID AND jobnum.RY_LIST_ID=aud.RY_LIST_ID AND bjob.RY_ACTION_ID=act.RY_ACTION_ID AND act.DIALOG_ID=dlg.DIALOG_ID AND ms.RY_ACTION_ID=act.RY_MILESTN_ID

  • Related Language Record for RY_DEDUP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_RECORD_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.