Siebel Life Sciences Guide > Configuring Data for Oracle Pharma Sales Analytics >

Entering Call Activity Data


Oracle Pharma Sales Analytics allows users to analyze the Account Calls, Contact Calls, and Attendee Calls data entered in the Siebel Pharma application. The Oracle Pharma Sales Analytics ETL requires a number of key call activity fields to be populated and the data to be entered correctly so that the Oracle Business Analytics Warehouse is loaded.

Table 100 outlines which fields must be populated for Oracle Pharma Sales Analytics.

Table 100. Fields that must be Populated for Oracle Pharma Sales Analytics
Records
Fields That Must Be Populated

Account Call - Header Records

  • Status (set to Submitted)
  • Account
  • Address
  • Start Date

Contact Call - Header Records

  • Status (set to Submitted)
  • Last Name, First Name
  • Address
  • Start Date

Attendee Call - Header Records

  • Status (set to Submitted)
  • Last Name, First Name
  • Address
  • Start Date

Call Products Detailed - Child Records

  • Product
  • Priority
  • Indication

Samples Dropped - Child Records

  • Name
  • Quantity

Promotional Items Dropped - Child Records (Contact calls)

  • Name
  • Quantity
Siebel Life Sciences Guide Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices.