Siebel Server Sync Guide > Customizing Siebel Server Sync for Microsoft Exchange Server >

About SSSE User Filtering


SSSE runs a user filtering algorithm periodically to determine which users have Siebel database records that have been changed and that require synchronization with Microsoft Exchange. For an implementation of SSSE that is not customized, the default user filtering configuration monitors changes in every table that is referenced by the domains and fields that are synchronized by default.

The default user filtering configuration involves 15 Siebel business components. Table 33 lists these business components and the fields and Objects associated with them. Each business component has a set of fields that record the true database update time of each row in a table or joined table. In addition, each business component has a User Id field that specifies the owner of each record in the business component. For information on changing user filtering configurations, see Changing User Filtering Configurations.

Table 33. Default SSSE User Filtering Configuration
Business Object
Business Component
Fields Mapped to Database Last Update Time

PIMSI Sync Info

PIMSI Sync Info

DB_LAST_UPDATE

PIMSI User Filter Action

PIMSI User Filter Action

Activity Last Upd, Act Employee Last Upd

PIMSI User Filter Action

PIMSI User Filter Action Account

Account Last Upd

PIMSI User Filter Action

PIMSI User Filter Action Contact

Action Contact Last Upd

PIMSI User Filter Action

PIMSI User Filter Action Contact 2

Contact Last Upd

PIMSI User Filter Action

PIMSI User Filter Action Contact 3

Contact Last Upd

PIMSI User Filter Action

PIMSI User Filter Action Oppty

Oppty Last Upd

PIMSI User Filter Action

PIMSI User Filter Action Project

Project Last Upd

PIMSI User Filter Action

PIMSI User Filter Action SR

SR Last Upd

PIMSI User Filter Contact

PIMSI User Filter Contact

Contact Info Last Upd, Contact Last Upd, Party Last Upd

PIMSI User Filter Contact

PIMSI User Filter Contact Account

Account Last Upd

PIMSI User Filter Contact

PIMSI User Filter Contact Business Address

Address Last Upd

PIMSI User Filter Contact

PIMSI User Filter Contact Oppty

Oppty Last Upd

PIMSI User Filter Contact

PIMSI User Filter Contact Personal Address

Address Last Upd

PIMSI User Filter Contact

PIMSI User Filter Contact Position

Contact Position Last Upd

Each time the user filtering algorithm runs, a set of queries is issued to identify the users whose records have changed since the last filtering. For example, for particular values of last_filtering_time and business_component_name, the query finds information that can be described as follows:

All User Ids in business_component_name where DB_LAST_UPDATE >= last_filtering_time

Some business components have more than one database update time field. Separate queries are issued for each of these fields, sequentially. As a result, 18 queries are issued each time the user filtering algorithm runs. The union of query results is the set of users who have records that require synchronization with the Exchange Server.

Siebel Server Sync Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.