Service Model Foundation tables and plugins
Tables that are included with or modified by the plugins that enable the Service Model Foundation feature.
The Service Model Foundation feature adds new tables or modifies existing tables when you activate the following plugins:
- Business Location (com.snc.business_location)
- Customer Household Data Model (com.snc.household)
- Service Organization (com.snc.service_organization)
- Customer Service Base Extension Entities (com.snc.cs_base_extension)
- Customer Service Install Base Management (com.snc.install_base)
Business Location plugin
The Business Location plugin adds the following tables.
| Table | Description |
|---|---|
| Business Organization \[sn\_csm\_business\_location\] | Extends the Organization Core \[sn\_customer\_service\_organization\] table. A business location is one type of service organization. This table stores business location records. |
| Internal Organization \[sn\_csm\_business\_location\_internal\] | Extends the Business Organization [sn_csm_business_location] table. This table stores internal business location records. Note: An internal business location is a business location with the Internal field set to true. |
| External Organization \[sn\_csm\_business\_location\_external\] | Extends the Business Organization [sn_csm_business_location] table. This table stores external business location records. Note: An external business location is a business location with the Internal field set to false. |
Customer Household Data Model plugin
The Customer Household Data Model plugin adds or modifies the following tables.
| Table | Description |
|---|---|
| Household\[csm\_household\] | Stores consumer household records. For the Service Model Foundation feature, this table is updated to support the head of household. |
| Household Member\[csm\_household\_member\] | Stores records of the consumers who have been added to households. |
| Household Team Member\[sn\_customer\_rel\_household\_to\_user\] | Stores records for each of the household team member relationships that have been created between an internal user and a household. |
| Household Member Relationship\[sn\_customer\_rel\_household\_member\_relationship\] | Extends the Consumer to Consumer Relationship \[sn\_customer\_rel\_consumer\_to\_consumer\] table. This table stores records for each of the relationships that have been created between two consumers who belong to the same household. |
Service Organization plugin
The Service Organization plugin adds the following tables.
| Table | Description |
|---|---|
| Service Organization\[sn\_customer\_service\_organization\] | A unidirectional relationship between a company and a service organization, with a reference to the company record added from the service organization. Stores records for service organizations, including business locations and internal business locations. Note: The following new columns are replicated from the company [core_company] table to the service organization [sn_customer_service_organization] table:
|
| Service Organization Member\[sn\_csm\_service\_organization\_member\] | Stores records for the users who belong to internal service organizations. |
| External Organization Staff \[sn\_csm\_service\_organization\_external\_staff\] | Extends the User [sys_user] table. Stores records for the users who belong to external service organizations. Note: If the Company field is populated, the Service Organization field displays only those service organizations that are associated with the company record. Similarly, if the Service Organization field is populated, the Company field displays only those companies that are associated with the service organization. |
| Organization Member Responsibility \[sn\_csm\_svc\_org\_member\_responsibility\] | Configure the responsibilities of the staff working at service organizations or its extended entities. |
Customer Service Base Extension Entities plugin
The Customer Service Base Extension Entities plugin adds the following tables.
| Table | Description |
|---|---|
| Consumer to Consumer Relationship\[sn\_customer\_rel\_consumer\_to\_consumer\] | Stores records for each of the relationships that have been created between two consumers, regardless of household. |
| Consumer Team Member\[sn\_customer\_rel\_consumer\_to\_user\] | Stores records for each of the consumer team member relationships that have been created between an internal user and a consumer. |
Customer Service Install Base Management plugin
The Customer Service Install Base Management plugin adds the Consumer Sold Product [sn_install_base_m2m_consumer_sold_product] table. This table stores records for each sold product (products and components) that have been sold to a consumer.
Tables used by Service Model Foundation
Tables from existing plugins that are used by the Service Model Foundation feature to support customers.
| Plugin | Table | New columns |
|---|---|---|
| Customer Service \(com.sn\_customerservice\) | Responsibility Definition\[sn\_customerservice\_responsibility\] | |
| Account Team Member\[sn\_customerservice\_team\_member\] | ||
| Related Party Configuration\[sn\_customerservice\_related\_party\_configuration\] | ||
| Case\[sn\_customersrevice\_case\] | Household Service Organization Consumer Profile | |
| Customer Service Install Base Management \(com.snc.install\_base\) | Sold Product\[sn\_install\_base\_sold\_product\] | Household Consumer Profile |
| Install Base Item\[sn\_install\_base\_item\] | Consumer Profile | |
| Customer Service Management for Orders \(com.snc.csm.order\) | Order\[csm\_order\] | Household Service Organization |