RY_SCHEVENT_LNG

(SQL View)
 Index Back

Scheduler Event with Lang Code

Related language table for Dialog name view for Scheduler Event Report

SELECT sch.RY_EVENT_ID ,dlg.LANGUAGE_CD ,dlg.RY_DIALOG_NAME FROM PS_RY_SCH_EVENT sch , PS_RY_PARAM param , PS_RY_ACT_TASK act , PS_RYEDIALOG_LNG dlg WHERE sch.RY_PARAM_LIST_ID=param.RY_PARAM_LIST_ID AND param.RY_ID_1=act.RY_ACTION_ID AND (param.RY_NAME254 = 'milestoneTask' OR param.RY_NAME254 ='task' OR param.RY_NAME254 ='bulkExtensionTask') AND sch.DIALOG_ID=dlg.DIALOG_ID

  • Related Language Record for RY_SCH_EVENT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_EVENT_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.