Party Data Model

The S_PARTY table is the base table for all of the parties listed in Access Control for Parties: Person (or Contact), User, Employee, Position, Partner User, Account, Division, Organization, Partner Organization, Household, User List, and Access Group.

For each party record stored in the S_PARTY table, the value of the PARTY_TYPE_CD column denotes the party type. Along with the party type, extension tables provide the primary differentiation between the different parties.

For information about how joins are used to draw data from multiple tables into a single business component, such as is done for Employee, Account, and other business components for party-type data, see Configuring Siebel Business Applications.

In the following image, the base table (S_PARTY) and extension tables that make up the party data model are shown within the Party boundary box (all of the shaded area). The three tables shown outside of the Party boundary box (Party Relationship, Party Reporting Relationship Denormalized, and Party Member) are used to define relationships among parties.

The following subtopics illustrate how the party data model applies to various particular parties:

• How Parties Relate to Each Other

• Person (Contact) Data Model

• User Data Model

• Employee Data Model

• Position Data Model

• Account Data Model

• Division Data Model

• Organization Data Model

• Partner Organization Data Model

• Household Data Model

• User List Data Model

• Access Group Data Model