Step 1:

There are five steps required to create an event table in the Siebel Sales Enterprise application. The first step involves setting up columns in the event table.

Before you begin

Why and when to perform this task

To create an event table and object in the Siebel application, perform the following procedure by using the Siebel tools:

Steps for this task

  1. Create IBM project and lock your project. Except for event triggers, you must complete all Siebel customizations under the new project.
  2. If you are installing multiple connectors, create multiple tables with different names.
  3. Using New Object Wizard, create a stand-alone table CX_IBM_Events.
  4. Create the following columns in your new table:
    • Column Name/User Name
    • Type
    • Length
    • Physical type
    • Required
    • Nullable
    • Status
Column Name/ User Name Type Length Physical Type Required Nullable Status
DESCRIPTION Data (public) 255 Varchar   Yes Active
EVENT_ID Data (public) 30 Varchar Yes   Active
EVENT_TIMESTAMP Data (public) 7 Date Time Yes   Active
EVENT_TYPE Data (public) 20 Varchar Yes   Active
OBJECT_KEY Data (public) 255 Varchar Yes   Active
OBJECT_NAME Data (public) 255 Varchar Yes   Active
PRIORITY Data (public) 10 Number   Yes Active
STATUS Data (public) 20 Number Yes   Active

Parent topic: Creating an event table in Siebel


Copyright IBM Corp. 2003, 2005