Configuring Siebel eBusiness Applications > Configuring EIM Interfaces > About EIM Object Types >

User Key Attribute Join Object Type

Each User Key Attribute object definition has one or more User Key Attribute Join child object definitions. The user key attribute join specifies a join operation that can be used to convert a user key attribute that is itself a foreign key to another table into attribute column values in that table. For example, the S_PROD_INT (products) table has a user key consisting of three attributes: PROD_NAME, PROD_VENDOR, and PROD_VEN_LOC. The PROD_NAME (product name) attribute column is directly obtained from the S_PROD_INT table, so no join is required. However, the PROD_VENDOR and PROD_VEN_LOC columns occur in the S_ORG_EXT (accounts) table, and must be obtained using a join on VENDR_OU_ID, a foreign key from S_PROD_INT to S_ORG_EXT.