RY_SVY_DLGSY_VW (SQL View)	Index Back
Dialogs with Surveys View of Dialogs with Documents that are surveys - used by Score Bracket to add new Bracket(s)

RY_SVY_DLGSY_VW

(SQL View)

Dialogs with Surveys

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

SELECT DISTINCT a.dialog_id , b.ry_dialog_name , b.DESCR254 , b.ry_dialog_status FROM PS_RYEDIALOG b , PS_RYEDOC a WHERE a.DIALOG_ID = b.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: RY_SVY_DLGS_LVW

# 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 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.

3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

4 RY_DIALOG_STATUS Character(1) VARCHAR2(1) NOT NULL Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.

#	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	RY_DIALOG_NAME	Character(254)	VARCHAR2(254) NOT NULL	Field is used to capture a Dialog Name.
3	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
4	RY_DIALOG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.