Contact Denormalization Mode in Siebel Life Sciences

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

• This mode 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 Account Affiliations view of the Contacts screen.

  • The Direct field in the Contact Affiliations view of the Accounts screen.

  For more information, see Siebel Life Sciences Guide.

• This mode does not denormalize positions from the opportunity team table to the contact team table.

• You must run this mode after separately running batch mode jobs for contacts and accounts. Run the batch mode jobs in the following order:

  1. Contacts

  2. Accounts

  3. 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 following parameters:

  Object Name=Contact Denormalization

  Assignment Mode=Denorm

• Contact Denormalization mode does not evaluate rules. Therefore, you do not have to create a rule-based object for Contact Denormalization 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 to which the contacts are directly affiliated. 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 the Contact Denormalization process assigns to team members are not visible to managers on their local databases. However, if you want managers to see all contacts that are assigned to their team members, regardless of the assignment method, then set ASGN_DNRM_ "Y".