Siebel Tools Reference > Data Objects Layer >

User Keys

A user key specifies columns that must contain unique sets of values. It is used to determine the uniqueness of records during data import operations, such as in EIM and remote synchronization. The purpose of user keys is to prevent users from entering duplicate records.

A user key is designated by the name of its parent table with an _Un suffix, such as S_PROD_INT_U1. Each user key has User Key Column child objects that specify the table columns that must have unique values, for example BU_ID, NAME, and VENDR_OU_ID in the S_PROD_INT_U1 user key.

A predefined index exists for each Siebel-defined user key. This index also takes the form S_TABLE_NAME_Un.

NOTE:  Modifying user keys in standard Siebel tables or EIM base tables is a restricted activity and should not be attempted. Siebel Expert Services can assist customers in evaluating strategies to remap data in their implementations to make use of the current user key structure within their specific business requirements.

For more information, see EIM Interface Tables.


 Siebel Tools Reference, Version 7.5, Rev. A 
 Published: 18 April 2003