Siebel Developer's Reference > Business Component User Properties > Doing Other Work >

Specifying Joins to the S_PARTY Table

The Inner Join Extension Table n user property specifies a table. The value for this user property must contain the name of a table, not enclosed in quotes. This table must be an extension table of the S_PARTY table. Siebel CRM uses an inner-join to join this table to the S_PARTY table. Some business components use the Siebel Party Model to control access and visibility. For example, organization, account, and position. These business components use one or more inner joins to the base S_PARTY table.

If you create a new business component that references the Siebel Party Model, then you must use the Inner Join Extension Table n user property to define one or more tables that Siebel CRM implicitly joins to the S_PARTY base table. For example, to configure visibility for a group that does not fit any of the predefined Siebel Party Model business components, you might need to create a new business component.

You must not deactivate this user property or modify the value. You can create a new instance of this user property, if necessary. You can specify this user property with or without the numeric suffix. For more information, see Numbering Instances of a User Property.

CAUTION:  You must be careful if you use the S_PARTY table in a custom configuration. For more information, see Configuring Siebel Business Applications.

Numbering Instances of the Inner Join Extension Table User Property

If you add multiple Inner Join Extension Table n user properties to a business component, then you can append a value to this user property. The lowest value indicates the primary extension table. For example, the predefined Employee business component includes the following user properties:

• Inner Join Extension Table 1 includes a value of S_CONTACT.
• Inner Join Extension Table 2 includes a value of S_USER.
• Inner Join Extension Table 3 includes a value of S_EMP_PER.

In this example, S_CONTACT is the primary extension table. For more information, see Numbering Instances of a User Property.