Step 1: Setting up columns

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 an object in the Siebel application, perform the following procedure using the Siebel tools:

Steps for this task

  1. Create an IBM® project and lock your project. Except for event triggers, you must complete all Siebel customization 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 named CX_IBM_Events.
  4. Create the following columns in your new table:
    • Column Name/User Name
    • Type
    • Length
    • Physical type
    • Required
    • Nullable
    • Status

Column example

Column Name/ User Name Type Length Physical Type Required Nullable Status

DESCRIP
TION

Data (public) 255 Varchar   Yes Active
EVENT_ID Data (public) 30 Varchar Yes   Active

EVENT_
TIME
STAMP

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

Terms of use |

Last updated: Sun Mar 12 11:38:29 2006

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)