Start tracking your progress
Trailhead Home
Trailhead Home

Learn About the Financial Services Cloud Data Model

Learning Objectives

After completing this unit, you’ll be able to:

  • Describe the Financial Services Cloud data model.
  • Define key terms such as database, object, field, and record.

How Is a Data Model like a Supermodel?

A supermodel is a person who is paid to make fashion look gorgeous. A data model’s job is to make the information in the database look gorgeous. Well, maybe not gorgeous exactly, but easy to understand.

A data model shows each object in the database and how the objects are related to each other. Sounds straightforward, right? Let’s define some terms to make sure it stays that way, then view the data model.

What’s a Database?

A database is a series of related tables that contain data. If you’re not familiar with database tables, how about spreadsheets? Good. Let’s compare a database to a spreadsheet table.

We took the client data from the Financial Services Cloud trial org and put it into a spreadsheet.

A spreadsheet table displaying the following columns: Client name, Category, Marketing Segment, Personal interests, Financial Interests, Status. Only one record is displayed: Rachel Adams

The spreadsheet has columns, like Client name and Category, and rows, like Rachel Adams.

Our database uses different terms.
  • Tables are objects, such as the Financial Account object.
  • Columns are fields, such as the Client name field.
  • Rows are records, such as the Rachel Adams record.

More About Objects

Let’s look at a common object: Financial Account. The Financial Account object contains fields, such as Financial Account Name, Status, and Ownership. Our client, Rachel Adams, has several financial accounts, including an investment account. Here’s Rachel’s investment account.

Screenshot of a sample investment account showing status: open, ownership: individual; type: brokerage; primary owner: Rachel Adams.

Financial Services Cloud provides all standard Salesforce objects, plus out-of-the-box financial objects to represent your business data. Specialized objects include Financial Account, Financial Account Role, Financial Holding, Securities, and others. If needed, you can extend the data model to support your business requirements.

Take a Look at the Data Model

We’ve spent enough time talking about the data model. How about we look at a real live data model in the Schema Builder?

The Schema Builder shows the following.
  • Objects, such as Account and Contact.
  • Fields, such as Account Name, Account Number, and Account Owner.
  • Relationships, such as between Account and Contact (hover over the relationship line to see related objects and their relationship type).
First, log in to your Financial Services Cloud trial org and navigate to the home page.
  1. Click Setup and select Setup.
  2. In the Quick Find box, enter Schema Builder.
  3. Click Schema Builder.

Poke around a little. Scroll to see different parts of the data model and how they are connected. Once you have an overview, select objects in the list on the left to display specific objects and their relationships.

Here’s what the Account and Contact objects look like in the Schema Builder.

Schema Builder displaying the Account and Contact Relationships with the Lookup Relationship for Contact to Account highlighted.

Now that you know the basic parts of the data model and have examined it yourself, get ready to dive into the details.

retargeting