RY_EMAIL_HIS_VW

(SQL View)
Index Back

Dialog outbund email view

Dialog outbund email view, which is combine the Single and bulk email transaction into one view.

SELECT A.RY_RECORD_ID , 'B' ,INTERACTION_ID ,RY_IND_ID , C.DIALOG_ID , D.RY_DOC_ID ,RY_LIST_ID , CONTACTED_DTTM ,RY_EMAIL_TO_ADDR FROM PS_RY_BMAIL_HIS A , PS_RY_BMAIL_LOG B , PS_RY_ACT_TASK C ,PS_RY_DOC_NAME_VW D WHERE A.RY_RECORD_ID=B.RY_RECORD_ID AND B.RY_ACTION_ID=C.RY_ACTION_ID AND C.RY_MD_ID=D.RY_MD_ID UNION SELECT A.RY_RECORD_ID , 'S' , INTERACTION_ID ,RY_IND_ID , C.DIALOG_ID , D.RY_DOC_ID ,RY_LIST_ID , CONTACTED_DTTM ,RY_EMAIL_TO_ADDR FROM PS_RY_SMAIL_HIS A , PS_RY_SMAIL_LOG B , PS_RY_ACT_TASK C ,PS_RY_DOC_NAME_VW D WHERE A.RY_RECORD_ID=B.RY_RECORD_ID AND B.RY_ACTION_ID=C.RY_ACTION_ID AND C.RY_MD_ID=D.RY_MD_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_RECORD_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
2 RY_MAILER_TYPE Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing. Only include the Signle and Bulk emailer
B=Broadcast
S=Single
3 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id
4 RY_IND_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
5 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
6 RY_DOC_ID Number(18,0) DECIMAL(18) NOT NULL Document ID - Dialog Document Main Sys ID
7 RY_LIST_ID Number(18,0) DECIMAL(18) NOT NULL Audience ID for Dialogs, used in the dialog designer.
8 CONTACTED_DTTM DateTime(26) TIMESTAMP Contacted On
9 RY_EMAIL_TO_ADDR Character(254) VARCHAR2(254) NOT NULL Email To Address field to use email history