RDM_CR_LEAD_VW

(SQL View)
 Index Back

Lead Call Report View

Call Report view for Lead Component. Used by Mobile.

SELECT LD.LEAD_ID , TX.CALL_REPORT_ID , T.DESCR30 , T.CALL_REPORT_DATE , T.CALLRPT_EVENT_TYPE , T.CALLRPT_LOCATION , TX.TXN_MARKET , TX.SYNCID , TX.SYNCDTTM FROM PS_RD_CALL_REPORT T , PS_RD_CALLRPT_TXN TX , PS_RSF_LEAD LD WHERE TX.REL_TXN_SYNCID = LD.SYNCID AND TX.RB_TRANSACTION_ID = 'LEAD' AND T.CALL_REPORT_ID = TX.CALL_REPORT_ID

  • Related Language Record: RDM_CR_LEAD_LVW

    • # 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 CALL_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for Call Reports.

    Default Value: 99999999

    3 DESCR30 Character(30) VARCHAR2(30) NOT NULL Subject
    4 CALL_REPORT_DATE Date(10) DATE Date

    Default Value: %date

    5 CALLRPT_EVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Call Report Event Type. Translate values: Meeting, Phone or Other.
    MTG=Face to Face Meeting
    OTHE=Other
    PHON=Telephone

    Default Value: MTG

    6 CALLRPT_LOCATION Character(30) VARCHAR2(30) NOT NULL Location of the meeting being documented in the Call Report.
    7 TXN_MARKET Character(3) VARCHAR2(3) NOT NULL Transaction Market. Used by Task Management.
    8 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.
    9 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time