RT_CMPG_DTL_VW(SQL View) |
Index Back |
|---|---|
Campaign Detail ViewOutbound Marketing Campaign Detail View |
| SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , B.RA_CMPGN_NAME , A.RA_WAVE_NAME , A.RA_PRIORITY , A.START_DATE , A.END_DATE , A.START_TIME , A.END_TIME , A.RA_OFFER_ID , A.RA_SCRIPT_ID_OTBN , F.RC_LIST_COUNT , F.RC_COMPLETED_CALL , F.RC_CALLS_LEFT , A.RA_PROMOTION_CODE , A.RA_OBJECTIVE_CD , A.RA_CMPGN_STATUS_CD , A.RA_INTEGRATE_MTHD FROM PS_RA_CMPGN_WAVE A , PS_RA_CAMPAIGN B , PS_RC_CALL_SUMMRY F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND F.BUSINESS_UNIT = A.BUSINESS_UNIT AND F.RA_CAMPAIGN_ID = A.RA_CAMPAIGN_ID AND F.RA_CMPGN_WAVE_ID = A.RA_CMPGN_WAVE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RA_NONVW |
| 2 | RA_CAMPAIGN_ID |
Character(15) | VARCHAR2(15) NOT NULL | Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. |
| 3 | RA_CMPGN_WAVE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used to uniquely identify a Marketing - Campaign Activity (wave) ID |
| 4 | RA_CMPGN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Campaign Name - field containing the name of the campaign. |
| 5 | RA_WAVE_NAME | Character(50) | VARCHAR2(50) NOT NULL | Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry. |
| 6 | RA_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Marketing - campaign wave content task priority
1=High Priority 2=Medium Priority 3=Low Priority |
| 7 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 8 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 9 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 10 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 11 | RA_OFFER_ID | Character(15) | VARCHAR2(15) NOT NULL | Marketing Offer ID |
| 12 | RA_SCRIPT_ID_OTBN | Number(12,0) | DECIMAL(12) NOT NULL | Outbound Script ID - Numeric |
| 13 | RC_LIST_COUNT | Number(8,0) | INTEGER NOT NULL | Outbound Marketing |
| 14 | RC_COMPLETED_CALL | Number(8,0) | INTEGER NOT NULL | Outbound Marketing |
| 15 | RC_CALLS_LEFT | Number(8,0) | INTEGER NOT NULL | Calls Remaining |
| 16 | RA_PROMOTION_CODE | Character(35) | VARCHAR2(35) NOT NULL | Marketing - campaign wave promotion code |
| 17 | RA_OBJECTIVE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Objective code of the campaign
Prompt Table: RA_UD_CMPGN_OBJ |
| 18 | RA_CMPGN_STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Valid Campaign and Wave Status Codes
APPR=Approved ARCH=Archived CMPL=Completed DCLN=Declined EXEC=Executing IREV=In Review NEW=New STOP=Stop TRIG=Trigger Approved |
| 19 | RA_INTEGRATE_MTHD | Character(4) | VARCHAR2(4) NOT NULL |
Telemarketing Integration method, will be used in Telemarketing application to integrate with another PeopleSoft application to generate Leads or Orders
NA=Not Applicable OCD=Order Capture Direct OCI=Order Capture Indirect SALE=Sales Leads |