RC_OM_2PRADR_VW(SQL View) |
Index Back |
---|---|
Telemarketing viewTelemarketing view used for recording selected Prospect. For Preview Dialing status selected has been expanded from just N to N and C |
SELECT DISTINCT A.BUSINESS_UNIT_RA , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.BO_ID_CUST , A.BO_ID_CONTACT , G.BO_NAME_DISPLAY , H.BO_NAME_DISPLAY , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.NAME , D.RA_CMPGN_NAME , E.RA_WAVE_NAME , C.ADDRESS1 , C.CITY , C.STATE , C.POSTAL , A.LEAD_ID , K.RC_CALLBACK_DATE , K.RC_CALLBACK_TIME FROM PS_RSF_LEAD A , PS_RB_PRSN_P_NM_VW B , PS_RT_OM_1PRADR_VW C , PS_RA_CAMPAIGN D , PS_RA_CMPGN_WAVE E , PS_RSF_LE_CONTACTS F , PS_BO_NAME G , PS_BO_NAME H , PS_RC_CALLRSLT_MAX K WHERE A.LEAD_ID = F.LEAD_ID AND F.SEQNUM = 1 AND B.BO_ID = F.BO_ID_CONTACT AND A.BUSINESS_UNIT_RA = D.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = D.RA_CAMPAIGN_ID AND A.BUSINESS_UNIT_RA = E.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = E.RA_CAMPAIGN_ID AND A.RA_CMPGN_WAVE_ID = E.RA_CMPGN_WAVE_ID AND A.RC_PROSPECT_SW = 'Y' AND A.RC_PROSPECT_STAT IN ('N', 'C') AND G.BO_ID = F.BO_ID_CONTACT AND G.PRIMARY_IND = 'Y' AND H.BO_ID = A.BO_ID_CUST AND (E.END_DATE > %CurrentDateIn OR (E.END_DATE = %CurrentDateIn AND E.END_TIME >= %CurrentTimeIn)) AND H.PRIMARY_IND = 'Y' AND A.BO_ID_CUST = C.BO_ID (+) AND A.ROLE_TYPE_ID_CUST = C.ROLE_TYPE_ID (+) AND A.LEAD_ID = K.LEAD_ID (+) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RA_NONVW |
|
2 | Character(15) | VARCHAR2(15) NOT NULL |
Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
Prompt Table: RA_CMPGN_ID_VW |
|
3 | Character(15) | VARCHAR2(15) NOT NULL |
Used to uniquely identify a Marketing - Campaign Activity (wave) ID
Prompt Table: RA_WAVE_ID_VW |
|
4 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
5 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
6 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
7 | BO_NAME_DISPLAY_1 | Character(80) | VARCHAR2(80) NOT NULL | This field represents the Display Name for a business object |
8 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
9 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
10 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
11 | RA_CMPGN_NAME | Character(50) | VARCHAR2(50) NOT NULL | Campaign Name - field containing the name of the campaign. |
12 | 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. |
13 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
14 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
15 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
16 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
17 | LEAD_ID | Character(15) | VARCHAR2(15) NOT NULL | Used by Sales Force Automation, this field uniquely identifies a Sales Lead. |
18 | RC_CALLBACK_DATE | Date(10) | DATE | Outbound Marketing |
19 | RC_CALLBACK_TIME | Time(15) | TIMESTAMP | Outbound Marketing field holding the time for a Prospect to be called back. |