RSFM_LECAMP_VW

(SQL View)
 Index Back

Mobile Lead Campaign View.

This is used as a work record to create a level one collection to have a Qualify tab on mobile sales.

SELECT LEAD_ID , BUSINESS_UNIT_RA , RA_CAMPAIGN_ID , RA_CMPGN_WAVE_ID , LEAD_TYPE , LEAD_SOURCE_ID , ACCEPTED_DT , REFERRED_DT , SYNCID , SYNCDTTM FROM PS_RSF_LEAD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
2 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit
3 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.
4 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
5 LEAD_TYPE Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to indicate what type of Lead,
IN=Inquiry
LE=Lead
QU=Qualified Lead
TQ=Turnback Qualified Lead
TU=Turnback Lead
6 LEAD_SOURCE_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation to identify the source of a Sales Lead.
7 ACCEPTED_DT Date(10) DATE Accepted Date
8 REFERRED_DT Date(10) DATE Referred Date
9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time