Siebel Field Service Integration to Oracle Real-Time Scheduler Implementation Guide > Extending the Connector > Process of Extending the Connector >

Creating Siebel CRM Objects

This task is a step in Process of Extending the Connector.

In this topic, you create Siebel CRM objects.

To create Siebel CRM objects

1. Open Siebel Tools.
2. Display the object types you must modify:
   1. Click the View menu, and then the Options menu item.
   2. In the Development Tools Options dialog box, click the Object Explorer tab.
   3. In the Object Explorer Hierarchy window, make sure the Integration Object tree contains a check mark, and then click OK.
3. Create new table columns:
   1. In the Object Explorer, click Table.
   2. In the Tables list, query the Name property for S_EVT_ACT.
   3. Right-click the S_EVT_ACT table, and then choose Lock Object.
   4. In the Object Explorer, expand the Table tree, and then click Column.
   5. In the Columns list, add three new columns using values from the following table.

      Name	Physical Type	Length	Type
      X_MAX_OFFSET	Varchar	30	Extension
      X_MIN_OFFSET	Varchar	30	Extension
      X_PRIMARY_ACT_ID	Varchar	30	Extension

   6. In the Tables list, click Apply/DDL.
4. Create new business component fields:
   1. In the Object Explorer, click Business Component.
   2. In the Business Components list, query the Name property for Action.
   3. In the Object Explorer, expand the Business Component tree and then click Field.
   4. In the Fields list, add three new fields using values from the following table.

      Name	Column	Default Value
      Max Offset	X_MAX_OFFSET	00:40:00
      Min Offset	X_MIN_OFFSET	00:10:00
      Primary Activity Id	X_PRIMARY_ACT_ID	Field: "Id"

      This configuration uses default values. Siebel CRM includes these values in the fields of each new activity record.

5. Create new integration component fields:
   1. In the Object Explorer, click Integration Object.
   2. In the Integration Object list, query the Name property for Abssiebel.

      The Abssiebel integration object is predefined with this integration.

   3. In the Object Explorer, expand the Integration Object tree, and then click Integration Component.
   4. In the Integration Component list, query the Name property for Action.
   5. In the Object Explorer, expand the Integration Component tree, and then click Integration Component Field.
   6. In the Integration Component Fields list, add a new field using values from the following table.

      Property	Value
      Name	Max Offset
      Data Type	DTYPE_TEXT
      External Name	Max Offset
      External Data Type	DTYPE_TEXT
      External Sequence	656
      XML Tag	MaxOffset

   7. In the Integration Component Fields list, add a new field using values from the following table.

      Property	Value
      Name	Min Offset
      Data Type	DTYPE_TEXT
      External Name	Min Offset
      External Data Type	DTYPE_TEXT
      External Sequence	655
      XML Tag	MinOffset

   8. In the Integration Component Fields list, add a new field using values from the following table.

      Property	Value
      Name	Primary Activity Id
      Data Type	DTYPE_TEXT
      External Name	Primary Activity Id
      External Data Type	DTYPE_TEXT
      External Sequence	654
      XML Tag	PrimaryActivityId

6. Compile the following projects:
   • Activity
   • AdvScheduler

     The AdvScheduler project is predefined with this integration.