RY_EE_TL_RSP_VW (SQL View)	Index Back
EE Total Response View to get total response for a dialog

RY_EE_TL_RSP_VW

(SQL View)

EE Total Response

View to get total response for a dialog

SELECT K.PROBINST , A.DIALOG_ID , COUNT(*) FROM PS_RY_EE_FACT A , PS_RY_EE_PARM_RJC K WHERE A.DIALOG_ID = K.DIALOG_ID GROUP BY K.PROBINST, A.DIALOG_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

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

3 RY_RESPONDENTS Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
3	RY_RESPONDENTS	Number(10,0)	DECIMAL(10) NOT NULL	Field used by Online Marketing.