RY_SVY_ADCNT_VW (SQL View)	Index Back
Dialog Survey Audience Count View that shows the audience count associated to a dialog.

RY_SVY_ADCNT_VW

(SQL View)

Dialog Survey Audience Count

View that shows the audience count associated to a dialog.

SELECT A.DIALOG_ID , SUM(B.LIST_CURR_COUNT) AS RY_SENT_COUNT FROM PS_RYEAUD_LIST A , PS_RY_AUD_SEL_VW B WHERE A.RY_LIST_ID = B.RY_LIST_ID GROUP BY A.DIALOG_ID

# 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_SVY_SENT_COUNT Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.

#	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_SVY_SENT_COUNT	Number(18,0)	DECIMAL(18) NOT NULL	Field used by Online Marketing.