1. Configuring Siebel Business Applications
  2. How Siebel CRM Uses Denormalized Columns

How Siebel CRM Uses Denormalized Columns

Siebel CRM comes predefined with denormalized columns that reside in intersection tables that affect visibility. The user can use a shuttle applet to create an association in a view that affects this visibility. For example, the user can navigate to the Accounts screen, and then use the Account Team view in the Accounts List to add a record in the Account Sales Team View. In this example, Siebel CRM creates an intersection record in the S_ACCNT_POSTN intersection table, and then populates the denormalized columns. It uses the Account/Position many-to-may link to create a many-to-may relationship between the parent Account business component and the child Position business component. The Account/Position link uses the S_ACCNT_POSTN table as the intersection table. The following table describes the properties of the ACCNT_NAME column that Siebel CRM uses in the S_ACCNT_POSTN table.

Property Value

Name

ACCNT_NAME

Type

Denormalized

Denormalization Path

[OU_EXT_ID].[NAME]

Assume you use the Account business component as the parent, you add a custom child Account Position business component that references the S_ACCNT_POSTN intersection table, and you use a a one-to-many link. If you do this, then Siebel CRM does not populate the denormalized columns. It populates them only if it also automatically creates the intersection record for the many-to-many relationship. If the user manually creates a one-to-many relationship, then Siebel CRM does not populate the denormalized columns. Instead, you must add a field that references a denormalized column in the intersection business component and use a predefault value for this field.

Adding Fields That Reference Denormalized Columns

The example in this topic describes how to add the Account Name field so that it references the ACCNT_NAME denormalized column.

To add fields that reference denormalized columns

  1. In Siebel Tools, click Business Component in the Object Explorer.

  2. In the Business Components list, locate the intersection business component that you must modify.

  3. In the Object Explorer, expand the Business Component tree, and then click Field.

  4. In the Fields list, create a new record using values from the following table.

    Property Description

    Name

    Account Name

    Column

    ACCNT_NAME

    Predefault Value

    Parent: 'Account.Name'