Bookshelf Home | Contents | Index | Search | PDF

Siebel Life Sciences Guide > Getting Started > Using Assignment Manager in Siebel Life Sciences >

Contact Denormalization Mode in Siebel Life Sciences

---

Contact Denormalization mode in Siebel Life Sciences differs from the description in Siebel Assignment Manager Administration Guide in the following ways:

It denormalizes positions from the account team table to the contact team table for all contacts directly affiliated with an account. Users can specify a direct affiliation between a contact and an account by selecting:
The Direct field in the Contacts, Account Affiliations view tab
The Direct field in the Accounts, Contact Affiliations view tab

For more information, see Indicating an Affiliation Between an Account and a Contact.

It does not denormalize positions from the opportunity team table to the contact team table.
It must be run after running batch mode jobs for contacts and accounts separately. Run three separate batch mode jobs in this order:
Contacts
Accounts
Contact Denormalization

Contact Denormalization in Siebel Life Sciences has the following additional important rules, requirements, and exceptions:

Running Contact Denormalization mode in Dynamic mode. To enable the Contact Denormalization Policy, set the expiration date to a future date or leave it blank. Then generate the database triggers by running Generate Triggers.
Running Contact Denormalization mode in Batch mode. Remember to specify the parameters:

Object Name = Contact Denormalization
Assignment Mode = Denorm

Contact Denormalization mode does not evaluate rules. Therefore, it is not necessary to create a Contact Denormalization rule-based object to run Assignment Manager in this mode. Also, since it does not evaluate rules, Contact Denormalization mode does not set the primary team position.
Contact Denormalization assigns contacts to employees who are on the Account Team for which the contacts are directly affiliated. In order to reduce the number of contact-to-position relationship (S_POSTN_CON) rows routed to the manager's local database, the value of the ASGN_DNRM_FLG field is set to "N". With this default setting, the contacts that team members have been assigned by the Contact Denormalization process will not be visible to managers on their local databases. However, if the desired behavior is for managers to see all contacts that are assigned to their team members, regardless the assignment method, set the ASGN_DNRM_ "Y".

For more information, see Charting Denormalized Syndicated Data.

Bookshelf Home | Contents | Index | Search | PDF