RY_SVY_DLGS_LVW

(SQL View)
 Index Back

Dialogs with Surveys

language View of Dialogs with Documents that are surveys - used by Score Bracket to add new Bracket(s)

SELECT DISTINCT d.dialog_id ,d.language_cd ,d.ry_dialog_name , d.DESCR254 FROM PS_RYEDIALOG b , PS_RYEDOC a ,PS_RYEDIALOG_LNG d WHERE a.DIALOG_ID = b.DIALOG_ID AND a.DIALOG_ID = d.DIALOG_ID AND a.RY_IS_SURVEY_DOC = 'Y' AND NOT EXISTS( SELECT 'X' FROM PS_RY_SVY_SURVEY c WHERE c.DIALOG_ID = a.DIALOG_ID)

  • Related Language Record for RY_SVY_DLGSY_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
    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.
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254