Scribd Logo
Upload

Welcome to Scribd!

  • 116 views

    CRM 8.9 Telemarketing

    Uploaded by

    youssef MCH
    This document outlines various tables related to customer relationship management (CRM) and telemarketing processes like lead tracking, call tracking, fulfillment tracking, and user dispositions. The tables contain fields for tracking leads, contacts, call results, fulfillment requests and statuses, user dispositions, and audit information. The CRM database schema outlined here seems to be designed for tracking all aspects of lead generation, contact, fulfillment, and closure in a telemarketing workflow.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    CRM 8.9 Telemarketing

    Uploaded by

    youssef MCH
    116 views1 page
    This document outlines various tables related to customer relationship management (CRM) and telemarketing processes like lead tracking, call tracking, fulfillment tracking, and user dispositions. The tables contain fields for tracking leads, contacts, call results, fulfillment requests and statuses, user dispositions, and audit information. The CRM database schema outlined here seems to be designed for tracking all aspects of lead generation, contact, fulfillment, and closure in a telemarketing workflow.

    Original Description:

    CRM 8.9 Telemarketing

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines various tables related to customer relationship management (CRM) and telemarketing processes like lead tracking, call tracking, fulfillment tracking, and user dispositions. The tables contain fields for tracking leads, contacts, call results, fulfillment requests and statuses, user dispositions, and audit information. The CRM database schema outlined here seems to be designed for tracking all aspects of lead generation, contact, fulfillment, and closure in a telemarketing workflow.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    116 views1 page

    CRM 8.9 Telemarketing

    Uploaded by

    youssef MCH
    This document outlines various tables related to customer relationship management (CRM) and telemarketing processes like lead tracking, call tracking, fulfillment tracking, and user dispositions. The tables contain fields for tracking leads, contacts, call results, fulfillment requests and statuses, user dispositions, and audit information. The CRM database schema outlined here seems to be designed for tracking all aspects of lead generation, contact, fulfillment, and closure in a telemarketing workflow.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    CRM 8.

    9 Telemarketing

    PS_RSF_LEAD PS_RC_AGT_ASGMNT
    LEAD_ID
    PS_RT_RS_TO_LE_RAT SETID
    PS_RSF_LE_CONTACTS DESCR50 RC_RATE_ID PERSON_ID
    BUSINESS_UNIT SEQNUM SEQUENCENO
    LEAD_ID (FK) PERSON_ID
    SEQNUM LEAD_RATE_SETI BUSINESS_UNIT (FK)
    SALES_USER_NAME RA_CAMPAIGN_ID (FK)
    CONTACT_ID LEAD_RATING
    PERSON_ID_PARTNER RA_CMPGN_WAVE_ID (FK)
    BO_ID_CONTACT SETID LEAD_RATE_CATEGORY
    RB_AUDIT_SBR START_DATE
    ROLE_TYPE_ID_CNTCT CUST_ID START_TIME
    FIRST_NAME BO_ID_CUST END_DATE
    LAST_NAME ROLE_TYPE_ID_CUST
    ROLE_CD END_TIME
    BO_ID_SITE RB_AUDIT_SBR
    SUPPORT_ID ROLE_TYPE_ID_SITE
    IMPACT_ID BO_ID_PERSON
    TITLE_ID ROLE_TYPE_ID_USER Marketing
    DEPARTMENT_ID BO_ID_PARTNER
    APPROVED_FLAG ROLE_TYPE_ID_PART
    CONTACT_NAME BO_ID_PART_CONT
    COMM_METHOD ROLE_TYPE_ID_PARTC PS_RA_CMPGN_WAVE PS_RC_CALL_SUMMRY
    PRIMARY_FLAG BO_ID_REFERRED_BY BUSINESS_UNIT BUSINESS_UNIT (FK)
    COUNTRY_CODE ROLE_TYPE_ID_RFRL RA_CAMPAIGN_ID RA_CAMPAIGN_ID (FK)
    WORK_PHONE BO_ID_CONTACT RA_CMPGN_WAVE_ID RA_CMPGN_WAVE_ID (FK)
    EXTENSION NAME1 RC_LIST_COUNT
    HOME_PHONE SITE_NAME RC_COMPLETED_CALL
    CELL_PHONE OPPORTUNITY_ID RC_ATTEMPTED_CALL
    FAX LEAD_RATING RC_POSITIVE_CALL
    EMAILID LEAD_STATUS RC_ORDER_CALL
    PROFILE_CM_SEQ_HM ASSIGN_GROUP RC_DONOT_CALL
    PROFILE_CM_SEQ_CEL TERRITORY_ID RC_CALLS_LEFT
    PROFILE_CM_SEQ_EML TREE_NAME RC_CALLBACK_CALL
    PROFILE_CM_SEQ_FAX REGION_ID RC_NO_CONTACT
    PROFILE_CM_SEQ_WK CUST_SETID RC_OM_CNTCT_METHOD
    CB_CONVERT_CONTACT PROD_SETID PS_RC_OM_CALLBACKS RB_AUDIT_SBR
    DESCR254 PRODUCT_ID BUSINESS_UNIT (FK)
    DESCR100 PRODUCT_GROUP RA_CAMPAIGN_ID (FK)
    CMF_ID PROD_GRP_SETID RA_CMPGN_WAVE_ID (FK)
    RB_AUDIT_SBR FULFILL_SETID
    SURVEY_SETID NUM_OF_DAYS
    LEAD_SOURCE_ID NUM_OF_HRS
    BUSINESS_UNIT_RA (FK) RC_OM_NUM_CB_ALLOW PS_RC_CALL_TEAMSUM
    RA_CAMPAIGN_ID (FK) RB_AUDIT_SBR
    BUSINESS_UNIT (FK)
    RA_CMPGN_WAVE_ID (FK) RA_CAMPAIGN_ID (FK)
    LEAD_TYPE RA_CMPGN_WAVE_ID (FK)
    PS_RSF_LEAD_SURVEY INDUSTRY_ID
    LEAD_ID (FK) PROVIDER_GRP_ID
    EST_REVENUE
    RC_BRSCR_INSTANCE CURRENCY_CD RC_ATTEMPTED_CALL
    SCRIPT_ID CUR_RT_TYPE RC_COMPLETED_CALL
    CONTACT_NAME PS_RT_FULFILLMENT RC_POSITIVE_CALL
    CHNL_PARTNER_ID
    SETID RB_AUDIT_SBR
    CONTACT_ID ALLIANC_PARTNER_ID
    REFERRED_DT FULFILLMENT_ID
    EFFDT
    RC_BRSCR_STATUS ACCEPTED_DT PRODUCT_ID
    DESCR REJECTED_DT STATUS
    NEXT_ACTIVITY_DT DESCR PS_RT_USR_DISPOSTN
    BO_ID_CONTACT
    RB_AUDIT_SBR PROFILE_CM_SEQ DESCR254 SETID
    CM_ID_ADDRESS RB_AUDIT_SBR RC_FINAL_DISPOSTN
    COUNTRY RT_USR_DISPOSTN
    ADDRESS1 DESCR
    ADDRESS2 RB_AUDIT_SBR
    ADDRESS3
    ADDRESS4
    PS_RT_LE_FULFILL CITY
    LEAD_ID (FK) NUM1
    FULFILLMENT_ID NUM2
    REQUEST_DT HOUSE_TYPE
    CONTACT_NAME ADDR_FIELD1
    CONTACT_ID ADDR_FIELD2
    FULFILLMENT_STATUS ADDR_FIELD3
    COUNTY PS_RT_FULFILL_LNG
    QTY_REQUESTED
    STATE SETID (FK)
    QTY_SHIPPED
    POSTAL FULFILLMENT_ID (FK)
    LAST_SHIPMENT_DT LANGUAGE_CD PS_RT_USR_DISP_LNG
    LAST_SHIPPED_VIA GEO_CODE
    IN_CITY_LIMIT SETID (FK)
    BO_ID_CONTACT DESCR
    ADDRESS1_AC RC_FINAL_DISPOSTN (FK)
    RB_AUDIT_SBR DESCR254 RT_USR_DISPOSTN (FK)
    ADDRESS2_AC
    ADDRESS3_AC LANGUAGE_CD
    ADDRESS4_AC DESCR
    CITY_AC
    TIMEZONE
    BILL_TO_FLG
    PS_RC_CALL_RESULT
    LEAD_ID (FK)
    SOLD_TO_FLG Subrecord
    SHIP_TO_FLG
    SEQNO CLONEDFROM_LEAD_ID
    SETID_PROV_GRP CLONEDTO_LEAD_ID RB_AUDIT_SBR RB_SYSD_SBR
    PROVIDER_GRP_ID RC_BUS_UNIT
    ASSIGNED_TO CASE_ID
    AGREEMENT_CODE ROW_ADDED_DTTM RC_MAINT_OWNER
    RC_CALL_STATUS
    AGR_RENEWAL_NUM ROW_ADDED_OPRID SYSD_APPLICATION01
    RC_CALLBACK_DATE SYSD_APPLICATION02
    RC_CALLBACK_TIME RC_PROSPECT_SW ROW_LASTMAINT_DTTM
    RC_PROSPECT_STAT ROW_LASTMAINT_OPRID SYSD_APPLICATION03
    RC_REASON
    RC_FINAL_DISPOSTN FIRST_NAME SYNCID SYSD_APPLICATION04
    SYNCDTTM SYSD_APPLICATION05
    RB_AUDIT_SBR LAST_NAME
    CNSMR_CNTCT_SEQ SYSD_APPLICATION06
    DONE_FLAG
    RC_BS_STATUS CNSMR_CNTCT_FLG SYSD_APPLICATION07
    SYSD_APPLICATION08
    RT_USR_DISPOSTN SALES_PRIORITY
    TEAM_ID SYSD_APPLICATION09
    LEAD_RATING SYSD_APPLICATION10
    LEAD_RATE_CATEGORY CONV_FROM_TLM_DTTM
    CAPTURE_ID OPRID_CONVERTED_BY
    SENT_TO_OCI_AGENT STATUS_CHANGE_DATE
    LEAD_REJECT_CD
    REFERRAL_FLG
    DESCR254
    RB_AUDIT_SBR
    MARKET
    REJECTION_COMMENTS

    You might also like