Understanding FSO Core relationships
This section describes the key tables in FSO Core and their relationships. Understanding these relationships helps you manage data effectively and enhances system functionality.
The Financial Services Operations Core application is automatically installed with any of the Financial Services Operations applications but can also be installed independently for a basic configuration using only its data model.
The following table lists this application's dependencies:
| Name | Value |
|---|---|
| Customer Service Management (CSM) | com.sn_customerservice |
| Expanded Model and Asset Classes | com.sn_ent |
| Install Base | com.snc.install_base |
Important: Starting with the Vancouver release, the Financial Services Operations Core model tables will use child tables of Expanded Model and Asset's base Service model [cmdb_service_product_model] to classify different service models within the Configuration Management Database (CMDB). For more information, see Expanded Model and Asset Classes
Financial Services Operations Core data model diagram
The following diagram shows the tables and their relationships that build the Financial Services Operations Core data model.
Diagram illustrating the FSO Core data model.
Using ServiceNow AI Platform, Customer Service Management (CSM) tables
The Financial Services Operations data model uses the following tables included within the ServiceNow AI Platform, Customer Service Management (CSM), and Configuration Management Database (CMDB) applications to store data.
| Table | Description | Application |
|---|---|---|
| Business location \[sn\_csm\_business\_location\] | Provides the business location records. | CSM |
| Case \[sn\_customerservice\_case\] | Provides the cases for patients associated with customer contact records. | CSM |
| Characteristic \[sn\_prd\_pm\_characteristic\] | Provides the attributes available for a product. | CSM |
| Characteristic Option \[sn\_prd\_pm\_characteristic\_option\] | Provides the options for attributes available for a product. | CSM |
| Consumer \[csm\_consumer\] | Provides patient records associated with consumer records. | CSM |
| Consumer profile \[sn\_csm\_consumer\_profile\] | Provides multiple consumer profiles. | CSM |
| Household Member \[csm\_household\_member\] | Provides records of the patient members who have been added to a household. | CSM |
| Location \[cmn\_location\] | Provides addresses associated with a patient. | ServiceNow AI Platform |
| Product Specification \[sn\_prd\_pm\_specification\] | Defines, at a functional level, a product a service provider sells to the customer. | CSM |
| Sold product \[sn\_install\_base\_sold\_product\] | Provides the product purchased by a patient as a customer and references the Product Model \[cmdb\_model\] table or Service Model \[cmdb\_service\_product\_model\] table for a customer \(customer account or consumer\). | ServiceNow AI Platform |
| Specification \[sn\_prd\_pm\_specification\] | Provides the base table for specifications included in the industry vertical applications. | CSM |
| Specification Characteristic \[sn\_prd\_pm\_specification\_characteristic\] | Provides the characteristics for product, service, and resource specifications. | CSM |
| Task \[task\] | Provides a series of standard fields used on each of the tables that extend it. | ServiceNow AI Platform |
Parent Topic:Financial Services Operations Core