Siebel Party Model – What is a User?

User is a person/contact with User ID. For example – A registered customer on your Web site browsing/ordering products online.

Parties Person - Venn Diagram

Parties Person – Venn Diagram

User records can be seen in following application view:

  • Administration – User > Users
  • Contacts > All Contacts

Characteristics of a User

  • May have associated responsibility leading to application access.
  • May have any associated positions.
  • Must have a User ID leading to database login.
  • It is possible to promote a contact/person to a user.
    • Adding a User ID value for a person record in Persons view causes it to appear as a user in the Users view.
What is User - Application View

What is User – Application View

Database Tables

Tables representing a User record are highlighted below:

  • Base Table – S_PARTY
  • Extension Tables
    • S_CONTACT – Stores First and Last Name of user.
    • S_USER – Stores User ID.
  • Intersection table – S_PER_RESP (not shown) stores responsibilities for users.
Table Architecture - User

Table Architecture – User

Complete Overview of Party Data Model

To study Siebel’s Party Data Model in detail, please purchase our ebook on this topic:

4 responses to this post.

  1. In Siebel a User must have a responsability but won’t have a position since the user isn’t an employee. This applies for your section: “Characteristics of a User “


    • Dear R

      In my opinion, it would be wrong to say that – “User isn’t an employee.”

      Reason – Please study the Venn Diagram above carefully. You will come to a conclusion that –
      1) All Employees are Users.
      2) Some Users are also Employees.

      Hope this clarifies my point in characteristics section – “Users may have positions.”

      To substantiate, my next point – “Users may (not must) have associated responsibilities.”, Responsibility is not a mandatory attribute at Users view.

      Please revert in case of any additional query.



  2. Suansh, Without a responsibility, being a Siebel user becomes moot. You will get no views. Kind of like being an earthling without air, sure you exist, but what’s the point? Deleting responsibilities was a method used since way back to remove users without deleting them. And to a data table guy, a user IS NOT an employee. Straight up. To be an employee you have to have a record in S_EMP_PER. No record, no employee. Period. As to your point an employee IS a user. Both nomenclatures have a record in S_USER, therefore rendering that part of your logic true. In Siebel CRM, IT truly is all about relationships! Both people and data


    • Dear Stottlemyer,

      Real significance of Siebel user can be understood in terms of eSales and eServices packages.

      For example, if I want to implement Amazon via Siebel eSales and allow my customers to browse available products and place order. I can have my custom website linked with eSales application. Two high level requirements will be:
      1) Allow a customer to browse website as a GUEST or with his/her specific account.
      2) Allow a customer access to products available for sale in his/her country.

      Requirement 1 – It can be achieved by setting up GUEST user or a specific user with login functionality. No responsibilities required.

      Requirement 2 – Customer can be granted access to specific products based on his/her country be setting up Product Catalogs and linking them to Access Groups. And, Access Groups can be linked to User records through User Lists. (More of a person-based and non-person based party concept).

      In essence, the concept of Users makes more sense in B2C model without the need of responsibilities.

      In case of “Party Data Model” ebook, I have tried to capture the minimum requirement to setup a particular party entity.

      Hope this helps you understand my perspective.



Appreciate your feedback

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: