Siebel PARTY DATA MODEL - Continued

Siebel Party Data Model – Continued

19 September 2011 2,266 views No Comment

We have discover the secret about Party Data Model of Siebel application. in previous article.

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.

Please read last 5 points in previous article. PARTY DATA MODEL

6) PARTY => DIVISION PARTY TYPE => ORGANIZATION Division is an organizational unit within a company such as Manufacturing or Corporate unit. It can also refer to a group of people operating within a particular company. Features: A division exists for the purposes of mapping a company's physical structure into the Siebel Database and for providing a container for position hierarchies. A division may have a parent division. It may also have child divisions. Data cannot be associated directly with a division. (Divisions that are not designated as organizations do not drive visibility.) Base table (S_PARTY) and extension table (S_ORG_EXT) define division data model along with INT_ORG_FLG=Y (in S_ORG_EXT) table This flag specifies that division is an internal organization. NOTE: For Account this flag is set to N

7) PARTY => ORGANISATION PARTY TYPE => ORGANISATION E.G: An Organizational unit within the company such as Asian organization and A partner company Features: An organization is a division that is designated as an organization. An organization exists for the purpose of providing a container in which positions can be associated with data. An organization can be internal or it can be a partner organization. A division can be associated with only one organization: itself or an ancestor division that is also an organization. Base Table (S_PARTY) and extension tables (S_ORG_EXT and S_BU) define Organizational data model. An Organization, sometimes known as a business unit, is also a Division, but has a record in the S_BU table. Partner Organization Data Model: The base table and extension tables (S_ORG_EXT, S_BU, and S_ORG_PRTNR) define a Partner Organization. A Partner Organization is the same as an Organization but the flag PRTNR_FLG in S_ORG_EXT qualifies it as a Partner Organization

8 ) PARTY => HOUSEHOLD PARTY TYPE => HOUSEHOLD Base table (S_PARTY) and household (S_ORG_GROUP) defines Household. A group of people, typically a family, who reside at the same residence forms Household A group of purchasers who live in different residences are also included. Typically, a household is a group of individual consumers who are economically affiliated and share a common purchasing or service interest. A household may have any combination of contacts, users, employees, and partner users as members. An individual can belong to more than one household.

9) PARTY => USER LIST PARTY TYPE => USER LIST Base table (S_PARTY) and extension table (S_USERLIST) defines User list. E.G: A support team made up of some internal employees and some partner users. Features: A user list is an ad hoc group of people. It may have any combination of contacts, users, employees, and partner users as members A user list cannot have a parent or children.

10) PARTY => ACCESS GROUP PARTY TYPE => ACCESS GROUP Base table (S_PARTY) and extension table (S_PARTY_GROUP) defines access group E.G: Partner IT service providers and business-to-business customer companies that buy networking equipment. An access group is a group of any combination of parties of type Position, Organization, and User List. That is, it is a group of groups An access group may have a parent access group. It may also have child access groups.

<<<< Previous Article Next Article >>>>