PROBINSTRY_DLG_RSPND_VW(SQL View) |
Index Back |
|---|---|
Dialog Performance Rpt - RespDialog Performance Respond ACE Report View |
| SELECT E.PROBINST , %Substring(C.LABEL_TEXT ,1 ,30) , C.RA_LIST_NAME , C.RY_OFFERS , C.RY_DELIVERED , C.RY_VISITORS , C.RY_PER_RESPONSE , C.RY_SUBMITS , C.RY_HITS , C.RY_PER_SUBMIT , C.RY_PER_COMPLETE , %Substring(B.RY_DIALOG_NAME ,1 ,30) FROM PS_RY_DIALOG B , PS_RY_DLG_RESPONSE C , PS_RY_DIALOG_IR D , PS_RY_DLG_IR_INST E WHERE B.DIALOG_ID = C.DIALOG_ID AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.DIALOG_ID = D.DIALOG_ID AND C.RUN_CNTL_ID = D.RUN_CNTL_ID AND C.OPRID = D.OPRID AND C.PROCESS_INSTANCE = E.PROCESS_INSTANCE AND D.OPRID = E.OPRID AND D.RUN_CNTL_ID = E.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_DELIVERED | Number(10,0) | DECIMAL(10) NOT NULL | Field used by Online Marketing. |
| 6 | RY_VISITORS | Number(10,0) | DECIMAL(10) NOT NULL | Field used by Online Marketing. |
| 7 | RY_PER_RESPONSE | Number(6,2) | DECIMAL(5,2) NOT NULL | Field used by Online Marketing. |
| 8 | RY_SUBMITS | Number(10,0) | DECIMAL(10) NOT NULL | Field used by Online Marketing. |
| 9 | RY_HITS | Number(10,0) | DECIMAL(10) NOT NULL | Field used by Online Marketing. |
| 10 | RY_PER_SUBMIT | Number(6,2) | DECIMAL(5,2) NOT NULL | Field used by Online Marketing. |
| 11 | RY_PER_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | Field used by Online Marketing. |
| 12 | RY_DIALOG_NAME | Character(254) | VARCHAR2(254) NOT NULL | Field is used to capture a Dialog Name. |