RC_DLG_ID_VW (SQL View)	Index Back
Case Survey Dialog ID View Retrieves valid Dialog IDs by Business Unit. Used with Case Survey design time configuration page.

RC_DLG_ID_VW

(SQL View)

Case Survey Dialog ID View

Retrieves valid Dialog IDs by Business Unit. Used with Case Survey design time configuration page.

SELECT BUSINESS_UNIT , DIALOG_ID , RY_DIALOG_NAME FROM PS_RY_DIALOG WHERE RY_DIALOG_STATUS IN ('A','S')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: RC_SRVY_CFG_WRK.BUSINESS_UNIT

2 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

3 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
Default Value: RC_DLG_ID_VW.RY_DIALOG_NAME

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: RC_SRVY_CFG_WRK.BUSINESS_UNIT
2	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
3	RY_DIALOG_NAME	Character(254)	VARCHAR2(254) NOT NULL	Field is used to capture a Dialog Name. Default Value: RC_DLG_ID_VW.RY_DIALOG_NAME