Siebel Life Sciences Guide > Setting Up Siebel Pharma > Using Assignment Manager in Siebel Pharma >

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
  • The Direct field in the Accounts, Contact Affiliations view

    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 activate 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, because 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".