RY_DLG_REACH_VW

(SQL View)
 Index Back

Dialog Performance Rpt - Reach

Dialog Performance Reach View for ACE Reports

SELECT D.PROBINST , %Substring(A.LABEL_TEXT ,1 ,30) , A.RA_LIST_NAME , A.RY_OFFERS , A.RY_BOUNCES , A.RY_PER_BOUNCED , A.RY_DELIVERED , A.RY_RESPONDENTS , A.RY_PER_RESPONSE , A.RY_CLICKTHROUGH , %Substring(B.RY_DIALOG_NAME ,1 ,30) , A.RY_HARD_BOUNCES , A.RY_SOFT_BOUNCES , A.RY_QUEUED , A.RY_EXPIRED , A.RY_OPENED , A.RY_REOPENED FROM PS_RY_DLG_REACH A , PS_RY_DIALOG B , PS_RY_DIALOG_IR C , PS_RY_DLG_IR_INST D WHERE B.DIALOG_ID = A.DIALOG_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.DIALOG_ID = C.DIALOG_ID AND A.RUN_CNTL_ID = C.RUN_CNTL_ID AND A.OPRID = C.OPRID AND A.PROCESS_INSTANCE = D.PROCESS_INSTANCE AND C.OPRID = D.OPRID AND C.RUN_CNTL_ID = D.RUN_CNTL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 LABEL_TEXT Character(254) VARCHAR2(254) NOT NULL Activity Name
3 RA_LIST_NAME Character(30) VARCHAR2(30) NOT NULL Audience / List Name
4 RY_OFFERS Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
5 RY_BOUNCES Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
6 RY_PER_BOUNCED Number(6,2) DECIMAL(5,2) NOT NULL Field used by Online Marketing.
7 RY_DELIVERED Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
8 RY_RESPONDENTS Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
9 RY_PER_RESPONSE Number(6,2) DECIMAL(5,2) NOT NULL Field used by Online Marketing.
10 RY_CLICKTHROUGH Number(10,0) DECIMAL(10) NOT NULL Used by Online Marketing Dialog Search record.
11 DIALOG_NAME Character(80) VARCHAR2(80) NOT NULL Online Dialog Name
12 RY_HARD_BOUNCES Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
13 RY_SOFT_BOUNCES Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
14 RY_QUEUED Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
15 RY_EXPIRED Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
16 RY_OPENED Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.
17 RY_REOPENED Number(10,0) DECIMAL(10) NOT NULL Field used by Online Marketing.