RD_CALL_REPORT

(SQL Table)
 Index Back

Call Report

General information for Call Report

  • Related Language Record: RD_CALL_REPORTL

  • Parent Record Of RD_CALLRPT_CONT RD_CALLRPT_NOTE RD_CALLRPT_TXN RD_CALLR_CNT_VW

    • # 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

    Default Value: %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

    Default Value: MTG

    5 CALLRPT_LOCATION Character(30) VARCHAR2(30) NOT NULL Location of the meeting being documented in the Call Report.
    6 RELATED_TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskID field. Key for RB_TSK record. Used by Task Management.
    7 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

    Default Value: ALL

    8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    10 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    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