RY_EMAIL_HIS_VW(SQL View) |
Index Back |
---|---|
Dialog outbund email viewDialog 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 |