RD_CR_LIST_VW

(SQL View)
 Index Back

Call Reports List

List of all Call Reports in the system

SELECT A.CALL_REPORT_ID ,A.DESCR30 ,A.CALL_REPORT_DATE ,A.CALLRPT_EVENT_TYPE ,A.CALLRPT_LOCATION ,A.SYNCID ,A.SYNCDTTM ,A.APPLICATION_USAGE FROM PS_RD_CALL_REPORT A

  • Related Language Record: RD_CR_LIST_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CALL_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for Call Reports.

    Default Value: 99999999

    2 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
    3 CALL_REPORT_DATE Date(10) DATE Date
    4 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
    5 CALLRPT_LOCATION Character(30) VARCHAR2(30) NOT NULL Location of the meeting being documented in the Call Report.
    6 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.
    7 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    8 APPLICATION_USAGE Character(4) VARCHAR2(4) NOT NULL Application Usage. Holds the info about the application.
    ALL=All Applications
    CHMG=Change Management
    EVNT=Marketing Events
    FLDS=Field Service
    HIED=Higher Education
    HLPD=HelpDesk
    HRHD=HR Helpdesk
    LEAD=Lead
    OPPY=Opportunity
    PIM=Personal Information Mgmt
    RSP=Strategic Planning
    SALS=Sales
    SUPP=Support