RDM_CR_CONT_VW

(SQL View)
 Index Back

Contact Call Reports (mobile)

List of Call Reports for a given Contact. This view is made for mobile use.

SELECT B.PERSON_ID , A.CALL_REPORT_ID ,A.DESCR30 ,A.CALL_REPORT_DATE ,A.CALLRPT_EVENT_TYPE ,A.CALLRPT_LOCATION ,B.BO_ID_CONTACT ,B.ROLE_TYPE_ID_CNTCT ,B.BO_ID_CUST ,B.ROLE_TYPE_ID_CUST ,B.PRIMARY_IND ,B.SYNCID ,B.SYNCDTTM FROM PS_RD_CALL_REPORT A , PS_RD_CALLRPT_CONT B WHERE A.CALL_REPORT_ID = B.CALL_REPORT_ID

  • Related Language Record: RDM_CR_CONT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    2 CALL_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for Call Reports.
    3 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
    4 CALL_REPORT_DATE Date(10) DATE 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
    6 CALLRPT_LOCATION Character(30) VARCHAR2(30) NOT NULL Location of the meeting being documented in the Call Report.
    7 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    8 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    9 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    10 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    11 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
    N=No
    Y=Yes

    Y/N Table Edit

    12 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.
    13 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time