S_PARTY model is the major change seen in Siebel 7.X and later version. The S_PARTY table is the base table for all the party related entities: Person (Contact), User, Employee, Partner User, Account, Division, Organization, Partner Organization, Household, Access Group and User list.
Party components have M: M relationships among them. 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.
PARTY DATA MODEL:
PARTY TYPE AND PARTIES:
1) PARTY => PERSON (CONTACT) PARTY TYPE => PERSON
- An employee at the customer company.
- An employee at the competitor’s company
- A Person is an individual who is represented by a Person record in the database
- Without additional attributes, a Person has no access to your database
The base table (S_PARTY) and extension table (S_CONTACT) that define a contact or person. A person is the simplest representation of an individual in the database
2) PARTY => USER PARTY TYPE => PERSON
- A registered customer on (your) Web site
- A self-registered partner user, that is, one who has no position.
- A User is a Person who can log into your database and has a responsibility that defines what application views are accessible.
- A self-registered partner on a Siebel partner application has a responsibility, but does not have a position like a full Partner User has.
The base table (S_PARTY) and extension tables that define a user (S_CONTACT and S_USER) form User Data Model. A User is a person with following added qualities
1) The S_USER table contains a login for this user
2) The S_PER_RESP intersection table specifies the responsibility for this user
3) It is possible to promote a contact to a user. For example, adding a User ID value for a person in the All Persons view in the Administration – User screen causes the person to appear as a user in the Users view.
3) PARTY => EMPLOYEE PARTY TYPE => PERSON
- An Employee at your company – An Employee is a User who is associated with a position in a division within your company
Base table (S_PARTY) and the extension tables (S_CONTACT, S_USER, and S_EMP_PER) define employee. This includes internal employees and Partner users. An Employee is a User with the following added qualities:
- S_EMP_PER provides employee data for this user.
- A position defined using the S_POSTN table is typically (but not necessarily) associated with an employee.
- If the organization to which the position belongs is not a partner organization, then the employee is an internal employee.
- If the organization is a partner organization, then the employee is a partner user.
4) PARTY => POSITION PARTY TYPE => POSITION E.G:
- A job title within (your) company
- A job title within the partner company
Base table (S_PARTY) and extension table (S_POSTN) Features:
- Position exist for the purpose of representing reporting relationships
- A position within your company is associated with a division and is associated with the organization to which that division belongs.
- A position can be associated with one division only.
- A position may have a parent position. It may also have child positions
- One or more employees can be associated with an internal position, and one or more partner users can be associated with an external position.
- An employee or partner user can be associated with more than one position, but only one position is active at any time.
5) PARTY => ACCOUNT PARTY TYPE => ORGANIZATION Account is a company or group of individuals with whom you do business. An account is typically made up of contacts It can have parent and child accounts. An account can be promoted to partner organization, but it is not a division, an internal or external organization. Base Table (S_PARTY) and extension table (S_ORG_EXT) defines Account data Model.