| Bookshelf Home | Contents | Index | Search | PDF | |
Security Guide for Siebel eBusiness Applications > Access Control > Access Control Overview >
Party Data Model
The S_PARTY table is the base table for all of the parties listed in Table 19: Person (Contact), User, Employee, Partner User, Position, 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, refer to Siebel Tools Reference.
In Figure 16, the base table and extension tables that make up the party data model are shown within the Party boundary (the dark box). The tables shown outside of the Party boundary are used to define relationships among parties.
Person (Contact) Data Model
In Figure 17, the base table and extension table (S_CONTACT) that define a Person, or Contact, are shaded in the figure. A Person is the simplest representation of an individual in the database.
User Data Model
In Figure 18, the base table and extension tables (S_CONTACT and S_USER) that define a User are shaded in the figure. A User is a Person with the following added qualities:
- S_USER contains a login for this user.
- The S_PER_RESP intersection table (not shown) specifies a responsibility for this user.
- 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 User Administration screen causes the person to appear as a user in the All Users view.
Employee Data Model
In Figure 19, the base table and extension tables (S_CONTACT, S_USER, and S_EMP_PER) that define an Employee are shaded in the figure. Internal Employees and Partner Users are each represented as Employee records.
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.
Position Data Model
In Figure 20, the base table and extension table (S_POSTN) that define a Position are shaded in the figure.
Account Data Model
In Figure 21, the base table and extension table (S_ORG_EXT) that define an Account are shaded in the figure.
(Accounts, Divisions, Organizations, and Partner Organizations share many of the same data model elements.)
Division Data Model
In Figure 22, the base table and extension table (S_ORG_EXT) that define a Division are shaded in the figure.
In S_ORG_EXT, the flag INT_ORG_FLG = Y specifies that a division is an internal organization. (For an account, this flag is set to N.)
(Accounts, Divisions, Organizations, and Partner Organizations share many of the same data model elements.)
Organization Data Model
In Figure 23, the base table and extension tables (S_ORG_EXT and S_BU) that define an Organization are shaded in the figure.
An Organization, sometimes known as a business unit, is also a Division, but has a record in the S_BU table.
(Accounts, Divisions, Organizations, and Partner Organizations share many of the same data model elements.)
Partner Organization Data Model
In Figure 24, the base table and extension tables (S_ORG_EXT, S_BU, and S_ORG_PRTNR) that define a Partner Organization are shaded in the figure.
A Partner Organization is the same as an Organization but the flag PRTNR_FLG in S_ORG_EXT qualifies it as a Partner Organization.
(Accounts, Divisions, Organizations, and Partner Organizations share many of the same data model elements.)
Household Data Model
In Figure 25, the base table and extension table (S_ORG_GROUP) that define a Household are shaded in the figure.
User List Data Model
In Figure 25, the base table and extension table (S_USERLIST) that define a User List are shaded in the figure.
Access Group Data Model
In Figure 25, the base table and extension table (S_PARTY_GROUP) that define an Access Group are shaded in the figure.
| Bookshelf Home | Contents | Index | Search | PDF | |
Security Guide for Siebel eBusiness Applications Published: 23 June 2003 |
