Service Model Foundation data model

  • Release version: Australia
  • Updated March 12, 2026
  • 3 minutes to read
  • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Service Model Foundation Data Model

    The Service Model Foundation data model outlines the structure for maintaining data consistency and relationships across its components. It organizes entities such as services, locations, and accounts, and provides a unified view that ensures scalability and integrity within the framework.

    Show full answer Show less

    Key Features

    • Entity-Relationship Diagram (ERD): Illustrates the connections between service organizations, business locations, and staff, showing how these entities interact within the Service Model Foundation.
    • Service Organizations: Consists of Internal Business Locations (IBL), External Business Locations (EBL), and Outsourced Service Providers (OSP), which may also represent logical rather than physical entities.
    • Reference Architecture: Displays the technical framework and data flow, illustrating how system components interact and manage service operations, ensuring a clear understanding of information processing.
    • Entities Included: Various entities such as service organizations, internal and external business locations, customers, employees, roles, and relationships are defined to facilitate service delivery.

    Key Outcomes

    By utilizing the Service Model Foundation data model, customers can expect enhanced data visibility, control, and consistency across their service operations. This structure supports the creation of tailored data models that reflect their business needs, improves service delivery efficiency, and fosters better customer relationships through defined roles and responsibilities.

    The Service Model Foundation data model defines the underlying structure that supports data consistency and relationships across Service Model Foundation. The data model explains its purpose, including how entities such as services, locations, and accounts are organized and connected through the entity-relationship Diagram (ERD) and reference architecture. It provides a unified view of data design, confirming scalability, integrity, and seamless integration across Service Model Foundation components.

    Service Model Foundation provides a framework that your customers can use to create structured yet flexible data models that represent their business structure. Central support represents the supporting entity within the main organization. Service organizations represent additional entities providing customer support.

    There are three types of service organizations:
    • Internal Business Locations (IBL)
    • External Business Locations (EBL)
    • Outsourced Service Providers (OSP)
    Note: These business locations can also be logical entities and not necessarily physical locations.

    Entity relationship model

    The following entity-relationship diagram (ERD) shows the tables and their relationships that comprise the Service Model Foundation data model.
    Figure 1. Service Model Foundation entity-relationship diagram (ERD)
    Entity relationship diagram showing how service organizations connect to internal and external business locations and outsourced service providers, each linked to employees or staff.

    This ERD illustrates the structural relationships among service organizations, business locations, and staff or employees within the Service Model Foundation. A service organization manages multiple internal (IBL), external (EBL), and outsourced (OSP) locations, each associated with its own workforce, that is employees or external staff, who perform service activities.

    The model differentiates internal versus external service delivery contexts while maintaining a unified link through the sys_user and service organization staff tables. It provides the foundation for access control, visibility, and data consistency across all Service Model Foundation entities.

    Reference architecture and data flow model

    The following reference architecture diagram illustrates the technical framework and data flow within the Service Model Foundation (SMF) system.

    Figure 2. Service Model Foundation reference architecture
    Reference diagram highlighting how various system components, tables, and services interact to deliver and manage service operations.

    This reference architecture highlights how various system components, tables, and services interact to deliver and manage service operations. It shows the flow of data between primary data tables, transaction tables, and custom tables, emphasizing the integration points between internal and external business locations, service offerings, and case management processes.

    The reference architecture ensures a clear understanding of how information is processed, routed, and stored across the Service Model Foundation system.

    Entities included with Service Model Foundation

    The Service Model Foundation feature includes the following entities.
    Table 1. Service Model Foundation entities
    Entity Definition Examples
    Service organizations

    The internal and external entities that are involved in providing a service to customers.

    A service organization provides the base framework that supports the customer service value chain. This framework includes internal and external service organizations.

    You can extend the service organization to create entities as needed.

    • Financial service organizations with multiple branches
    • Automobile manufacturers with multiple dealerships
    • Government agencies with multiple office locations
    Internal business locations The internal entities that belong to a service organization and are involved in providing goods and services.
    • Stores
    • Branches
    • Centers
    External business locations The external entities that belong to a service organization and are involved in providing goods and services.
    • Franchises
    • Dealerships
    Customers (B2B) The external customers in the business-to-business model who use goods and services.
    • Accounts
    • Contacts
    Configuring households The external customers in the business-to-consumer model who use goods and services.
    • Consumers
    • Households
    Employees and staff members The people who work at internal and external service organizations and assist customers.
    • Internal employees
    • External agents
    • External staff
    Roles Job functions that are performed by various users in the service organization.
    • Location managers
    • Location agents
    • Location consumer agents
    • Location relationship managers
    • Location manager contributors
    Responsibility definitions Definitions of the responsibilities that an agent can perform for a customer or that a consumer can perform for another consumer. Use these responsibilities to create relationships between agents and customers or between consumers.
    • Location agents
    • Location consumer agents
    • Location contributors
    • Location manager contributors
    • Location manager fulfiller
    • Location relationship manager
    Relationships Relationships that are created between agents and customers or between two consumers, are based on specific responsibilities. Use these relationships to provide additional access to data.
    • Relationships between an employee or staff member and a customer
    • Relationships between two consumers