1. Life Sciences Guide
  2. Entering Call Activity Data

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.

The following table outlines which fields must be populated for Oracle Pharma Sales Analytics.

Records Fields That Must Be Populated

Account Call - Header Records

  • Status (set to Submitted)

  • Account

  • Address

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