RDM_CR_LEAD_LVW

(SQL View)
Index Back

Lead Call Report View RL

Related Language view. Call Report directly linked to Lead. Used in mobile.

SELECT C.LEAD_ID , T.CALL_REPORT_ID , T.LANGUAGE_CD , T.DESCR30 FROM PS_RD_CALL_REPORTL T , PS_RDM_CR_LEAD_VW C WHERE T.CALL_REPORT_ID = C.CALL_REPORT_ID

  • Related Language Record for RDM_CR_LEAD_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR30 Character(30) VARCHAR2(30) NOT NULL Subject