RY_RPT_SRVY_VW

(SQL View)
 Index Back

Document Report

Where clause: A.BUSINESS_UNIT='xxx' AND A.RY_DIALOG_NAME='xxx' AND B.ROW_ADDED_DTTM>='xxx' AND B.ROW_ADDED_DTTM<'xx'

SELECT A.DIALOG_ID ,A.RY_DIALOG_NAME ,A.BUSINESS_UNIT ,B.RY_IND_ID ,B.RY_FLOW_INS_ID ,B.RY_STATUS_SRVY ,B.RY_SRVY_SCORE ,B.RY_ORA_EXT_ID ,B.RY_ORA_EXT_TYPE ,B.RY_ORA_EXT_BU ,B.RY_ORA_EXT_INS_ID ,B.ROW_ADDED_DTTM ,B.ROW_LASTMANT_DTTM ,CASE WHEN C.RY_RECORD_ID>0 AND RY_ORA_EXT_ID>0 THEN 'Y' ELSE 'N' END FROM PS_RY_DIALOG A ,PS_RY_FLOW_INST B LEFT JOIN PS_RY_SMAIL_LOG C ON B.RY_FLOW_INS_ID=C.RY_FLOW_INS_ID WHERE A.DIALOG_ID=B.DIALOG_ID AND RY_ORA_EXT_TYPE='case' AND B.RY_STATUS_SRVY='I'

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 RY_IND_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
5 RY_FLOW_INS_ID Number(18,0) DECIMAL(18) NOT NULL Dialog Flow Instance ID
6 RY_STATUS_SRVY Character(1) VARCHAR2(1) NOT NULL Survey Status - 'Open' or 'Complete'
C=Complete
I=Initial
O=Open
7 RY_SRVY_SCORE Signed Number(19,0) DECIMAL(18) NOT NULL Survey Overall score -- overall running score for a survey instance.
8 RY_ORA_EXT_ID Number(18,0) DECIMAL(18) NOT NULL Survey External Id - external system id for integration
9 RY_ORA_EXT_TYPE Character(8) VARCHAR2(8) NOT NULL Survey External Type -- external system type for integration
10 RY_ORA_EXT_BU Character(5) VARCHAR2(5) NOT NULL Survey External Business Unit for integration
11 RY_ORA_EXT_INS_ID Number(18,0) DECIMAL(18) NOT NULL Survey External Instance Id -- survey instance id from external system for integration
12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
14 RY_SURVEY_SENT Character(1) VARCHAR2(1) NOT NULL Indecate if the e-mail has been sent.