You are a Data Architect or Modeler who downloaded the Financial Industry Business Data Model, or your organization has licensed FIB-DM, and you want to understand the design and contents.
This education module is a hands-on exercise. You can follow the steps in PowerDesigner or your modeling tool.
- Example: FDIC Bank Call Report reference data
- We use five of the FIB Fundamental Supertypes to create a concept map.
- Transpose the concept map to a Data Model subject area
- Review the conceptual data model and compare it to the ontology graph
You can download a PDF of the presentation.
Text of the presentation
Education module – Scoping our first data model from FIB-DM
Financial Industry Business Data Model (FIB-DM)
Education Module
Scoping our first data model from FIB-DM
The Bank Call Report example, using Concept Maps.
An introduction course into the ontology-derived Enterprise Data Model. Jurgen Ziemer, Ontologist & Data Architect at Jayzed Data Models Inc.
Audience and content
a) You are a Data Architect or Modeler who downloaded the Financial Industry Business Data Model
b) Your organization has licensed FIB-DM, and you want to understand the design and contents.
This education module is a hands-on exercise. You can follow the steps in PowerDesigner or your modeling tool.
Data Architect
Example: FDIC Bank Call Report reference data
We use eight of the FIB Fundamental Supertypes to create a concept map. Transpose the concept map to a Data Model subject area.
Review the conceptual data model and compare it to the ontology graph.
US Bank Call Report
The Federal Deposit Insurance Corporation is a regulator of U.S. banks.
One of the key reports required for filing is the quarterly Consolidated Report of Condition and Income, commonly referred to as the call report or RC report.
The Federal Financial Institutions Examination Council (FFIEC) publishes the XBRL taxonomy and bank filings. You can view and download Call Report submissions on the FFIEC website: https://cdr.ffiec.gov/public/
Call Report Schedule ENT – reference data
The Entity Schedule (ENT) contains reference data for the reporting Bank. For this exercise, our data requirements are the Entity schedule data items, plus additional reference data about the FDIC, already in the FIBO.
The example shows JPMorgan Chase Bank, NA submission with call date, ID, data item, value, definition, call schedule, and line number.
A simple diagram of our sample data
FDIC Certificate 628 identifies JPM Chase as a registered bank. The Certificate is registered in the FDIC Institution Directory.
The FDIC registers the Certificate. JPMC has the legal identity of JPMC NA. Note the distinction of what JPMC is – a legal entity, and what JPM Chase Bank does – taking deposits.
The Legal Entity has a registered address in the US.
JPMC NA has a Legal Entity Identifier (LEI). The corporation has $176 billion in issued capital.
15 Fundamental Business Concepts
In our second step, we conceptualize our sample data items. That means to assign fundamental business concepts and their specializations.
The fifteen concepts are extensive ultimate supertypes in the Financial Industry Business Data Model. In other words, they have the most subtypes and the most relationships.
In the FIBO ontology, the 15 fundamental concepts are direct subclasses of Thing.
We use abbreviations and icons as mnemonics to teach modeling and business-user concepts.
Identifying Entities and Concepts
We can use the modelling tool or MS Excel to research Concept Entities.
In this example, we look for supertypes of the FDIC Certificate and their Associations
Creating the concept map diagram
FIB-DM has a Legal Entity Identifier, an exact match for the LEI in the sample. Reference(REF) is the ultimate supertypeof Legal Entity Identifier.
Likewise, we have an Entity named Country in FIB-DM. The country is a specialization of the fundamental concept of Region/Location(LOC).
The FDIC Certificate Number is another direct match.
The FDIC Institution Directory is a Registry. The entity Registry belongs to the Collection concept.
The LEI identifies a Legal Person. In our example, JPMC NA, a Stock Corporation, is an entity in the FIB-DM. The stock corporation is a subtype of the Agent (A). The concept comprisesPerson, Legal Person, Automated System, and Organization.
The FDIC insures and regulates financial institutions that take deposits. Depository Institution is an entity in the data model, rolling up to the fundamental concept of the Role (R).
The FDIC is the Registration Authority that issues the certificate number. The FDIC also has an identity as an Autonomous Agent, but we don’t need that detail for our scope.
JPMC’s capital is a Balance, a subtype of Monetarey Amout. The entity holds the number and more descriptive properties, such as the currency and date. Following the supertype hierarchy we see that Monetary Amount is a Scalar Quantity Value.
The address fields in our schedule are a RegisteredAddress, another subtype of Reference. The Reference functions like an associative entity with a role, linking Country to the Autonomous Agent.
Our sample data as a concept map
A concept map, or conceptual diagram, depicts suggested relationships among concepts.
We replace the circles in our sample data diagram with shapes of the Fundamental Business Concepts.
Standardize concept map relations
Similarly, we standardize relationships in our concept map. The data modeler suggests FIB-DM association names that match the related concepts and requirements.
Finally, we replace the sample values with identified FIB-DM entities. Here is our Fundamental Business Concept map for the Call Report Entity Schedule.
The FIB-DM Concept map
Easy to understand for non-technical business users.
The methodology keeps the concept-mapping within the vocabulary and structure of the underlying model.
We can see how the diagram expands. The Monetary Amount has more defining concepts.
JPMC is a Thing in many more Roles, so is the FDIC. We can add other Regulators to the picture, and so on.
From Concept Map to Data Model
Populate a new diagram with the
identified entities
Add supertypes all the way up to
The Fundamental Concept
Add Associative
entities
Generate an LDM or export our FIB-
DM subject area model
Create a new diagram of the nine entities
Open FIB-DM in your data modeling tool. The screenshots, Legal Entity Identifier, Monetary Amount, Country(cmns), and diagrams in this education module are PowerDesigner.
Populate your diagram with the nine entities of the concept map. These are existing FIB-DM entities derived from FIBO classes.
In practice, you may draw the concept map and CDM in parallel. However, you want to use the concept map to validate the design with the business.
Stock Corporation
DepositoryInstitution
Conventional Street Address
Registration Authority(cmns)
FDIC Certificate Number
Registry(cmns)
2.1 Adding Depository Institution supertypes to the diagram
Let’s start with the Depository Institution. We use the data modeling tool to navigate to the Inheritance (a.k.a. subtype symbol) and the supertype.
In PowerDesigner, this is a bit cumbersome: we open the entity properties dependencies tab, select the parents to find the Financial Institution subtypes, open the inheritance properties, find the inheritance in the browser, and copy the inheritance as a link into the diagram.
Role
Role subtype
Agent Role
Agent Role subtype
Service Provider (cmns)
Service Provider (cmns) subtype
Financial Service Provider
FinancialService Provider subtype
We repeat the process until we arrive at the ultimate supertype, our Fundamental Concept, the Role.
The Depository Institution is a Financial Institution, which is a Financial Service Provider, with is a Service Provider, a direct subtype of the Thing.
Financial Institution
Financial Institutionsubtype
DepositoryInstitution
2.2 Adding the Registration Authority supertype
Role
Role subtype
The Registration Authority, our entity for the FDIC and other registrars, is also a Service Provider, a subtype of Agent Role, a subtype of the Fundamental Concept of Role (R).
Agent Role
Agent Role subtype
Service Provider (cmns)
Service Provider (cmns) subtype
Financial Service Provider
Financial Service Provider subtype
Financial Institution
Financial Institution subtype
DepositoryInstitution Registration Authority(cmns)
2.3 Stock Corporation rolls up to the Agent
Agent
Agent subtype
Party
Partysubtype
The Stock Corporation is a Legal Entity, ultimately a subtype of the Agent (A).
Legal Person(cmns)
Legal Person(cmns) subtype
Legal Entity(cmns)
Legal Entity(cmns) subtype
Corporation
Corporationsubtype
Stock Corporation
2.4 Country and Registry Region Regionsubtype
Geographic Region(cmns)
Geographic Region(cmns) subtype
The country is a Geopolitical Entity, a subtype of Geographic Region, and ultimately the Fundamental Concept of Region.
Geopolitical Entity(cmns)
Geopolitical Entity(cmns) subtype
Country(cmns)
2.5 Balance
Scalar Quantity Value
Scalar QuantityValue subtype
The Issued Capital is on the Balance sheet, and hence a Balance, which is a Monetary Amount subtype of the Scalar Quantity.
MonetaryAmount
MonetaryAmount subtype
Balance
2.6 Registry
Collection (cmns)
Collection(cmns) subtype
The Registry is a Structured Collection, a subtype of the OMG Commons concept of Collection.
Structured Collection
Structured Collectionsubtype
Registry(cmns)
2.7 Reference
Reference
Reference subtype
The [Conventional] Street Address is a Physical Address.
Addresses are a type of Index under the fundamental concept of Reference.
Identifiers are under the fundamental concept of Designation.
Index
Indexsubtype
Address
Address subtype
Physical Address
Physical Address subtype
Conventional Street Address
2.8 Designation Designation
Designation subtype
The LEI and FDIC Certificate Number are Registered Identifiers, a subtype of Contextual Identifier.
Identifiers are under the fundamental concept of Designation.
Identifier (cmns)
Identifier (cmns) subtype
Contextual Identifier
Contextual Identifier subtype
Registered Identifier
Registered Identifier subtype
Legal EntityIdentifier FDIC Certificate Number
2.9 Our Entities and their Fundamental Concepts.
Role
Role subtype
Agent
Agent subtype
Agent Role
Agent Role subtype
Party
Partysubtype
Reference
Reference subtype
Designation
Designation subtype
Service Provider (cmns)
Service Provider (cmns) subtype
Legal Person (cmns)
Legal Person (cmns) subtype
Region
Region subtype
Index
Indexsubtype
Identifier (cmns)
Identifier (cmns) subtype
Financial Service Provider Legal Entity(cmns) Geographic Region (cmns) Collection (cmns) Scalar Quantity Value Address Contextual Identifier
Financial Service Provider subtype Legal Entity(cmns) subtype Geographic Region (cmns) subtype Collection(cmns) subtype Scalar QuantityValue subtype Address subtype Contextual Identifier subtype
Financial Institution
Financial Institution subtype
Corporation
Corporation subtype
Geopolitical Entity(cmns)
Geopolitical Entity(cmns) subtype
Structured Collection
Structured Collection subtype
MonetaryAmount
MonetaryAmount subtype
Physical Address
Physical Address subtype
Registered Identifier
Registered Identifier subtype
Depository Institution Registration Authority(cmns) Stock Corporation Country(cmns) Registry(cmns) Balance Conventional Street Address Legal EntityIdentifier FDIC Certificate Number
Adding Associations and Associative Entities.
The next step is to connect the entities by adding the appropriate Association or Associative entity for the business context.
Finding a matching Association is a challenge, even for experienced FIBO experts.
How does Issued Capital relate to the Stock Corporation?
We can research the entity’s relationships in the data modelling tool.
3.1 Stock Corporation – Balance
The preferred association connects our scoped concept hierarchies at the leaf level. In other words the green entities of the concept map. Often, however, supertypes connect the Base Entities.
We use the modeling tool or the Relationships spreadsheet to investigate relationships of the Stock Corporation and find has Issued Capital.
Stock Corporation
(D) <>
Stock Corporation- has Issued Capital
<>
has Issued Capital
<>
has Issued Capital -MonetaryAmount
MonetaryAmount
MonetaryAmount subtype
A perfect match, the Associative entity “has Issued Capital” directly
relates to the Monetary Amount, a supertype of Balance. Balance
3.2 Associating the FDIC Certificate Number
Another easy match, the associative entity “registers” has relationships to the FDIC Certificate Number and the Registration Authority.
RegistrationAuthority(cmns)
<> RegistrationAuthority(cmns) – registers (cmns)
<>
registers (cmns)
<>
registers (cmns) -FDIC Certificate Number
FDIC Certificate Number
<>
The Association “is Registered in” FDIC Certificate Number – is Registered In(cmns)
directly connects the FDIC Certificate Number to the Registry.
<>
is Registered In(cmns)
<>
is Registered In(cmns) -Registry(cmns)
Registry(cmns)
3.3 Stock Corporation – Address
The Stock Corporation has no direct Associative Entity relating to an Address.
Legal Entity(cmns)
<>
Legal Entity(cmns) – has Legal Address
<>
has Legal Address
<>
has Legal Address -Conventional Street Address Conventional Street Address
Legal Entity(cmns) subtype
Corporation
Corporation subtype
However, its supertype, Legal Entity “has Legal Address” connects to the Conventional Street Address.
Stock Corporation
3.4 Address – Country
The Conventional Street Address does not have an Association relating to the Country.
Physical Address
(D) <>
Physical Address – has Country(cmns)
<>
has Country(cmns)
<>
has Country(cmns) -Country(cmns)
Country(cmns)
Physical Address subtype
Conventional Street Address We investigate its supertype, the Physical Address, and find “has Country”.
3.5 The identifies association completes the model
- The Financial Service Provider Identifier, the supertype of the FDIC Certificate Number, identifies the Financial Service Provider, the supertype of the Depository Institution.
- The Legal Entity Identifier identifies the Legal Person, a supertype of Legal Entity.
<>
Financial Service Provider Identifier (DFinancial Service Provider Identifier – identifies (cmns)
)
<>
identifies (cmns) -Legal Person(cmns)
Legal Person(cmns)
Financial Service Provider Identifier subtype Legal Person(cmns) subtype
<> identifies (cmns)
FDIC Certificate Number Legal Entity(cmns)
Legal EntityIdentifier (D)
<>
Legal EntityIdentifier – identifies (cmns)
<>
identifies (cmns) -Financial Service Provider
Financial Service Provider
Data Architect Ontologist 28
Conceptual Data Model Model: Financial Industry Business Data Model (FIB-DM) Package:Call Report
Diagram: Call Report scope
Author:JurgenZiemer, © Jayzed Data Models Inc. Date: 2025-11-14 Version: October, 2025 (FIBO 2025/Q3) https://fib-dm.com
<> identifies (cmns)
Role
Role subtype
<>
Legal EntityIdentifier – identifies (cmns)
<>
Financial Service Provider Identifier – identifies (cmns)
Designation
Designationsubtype
identifies (cmns) -Legal Person(cmns) complete CDM scope
The
<>
Agent Role
<>
identifies (cmns) -Financial Service Provider
Agent Role subtype
<>
identifies (cmns) -Financial Institution
Service Provider (cmns)
Service Provider (cmns) subtype
Party Role Identifier
PartyRole Identifier subtype
Identifier (cmns)
Identifier (cmns) subtype
Contextual Identifier
Financial Service Provider Registration Authority(cmns)
(D) Contextual Identifier subtype
Registration Authos>) – registers (cmns) Financial Service Provider Identifier
Financial Service Provider subtype <> registers (cmns)
<>
registers (cmns) -Registered Identifier
Registered Identifier
Registered Identifier subtype
Collection (cmns)
Collection (cmns) subtype
Agent
Agent subtype
Reference
Reference subtype
Financial Institution
Financial Institution subtype
<>
Financial Institution- manages (cmns)
<>
registers (cmns) -Legal Entity Identifier
<> RegistrationAuthority(cmns) – manages (cmns)
(D)
Legal Entity Identifier
<> Structured Collection Registered Identifier – is Registered In(cmns)
Structured Collectionsubtype
Party
Partysubtype
Index
Indexsubtype
<>
Depository Institution registers (cmns) -FDIC Certificate Number
FDIC Certificate Number
<>
FDIC Certificate Number – is Registered In(cmns)
<>
is Registered In(cmns)
<> Legal Person(cmns)
is Registered In (cmns) -Registry(cmns)
Address
Address subtype
<> manages (cmns)
<>
manages (cmns) -Legal Entity (cmns)
<>
manages (cmns) -Registry (cmns)
Legal Person(cmns) subtype Registry (cmns)
Legal Entity (cmns) <>
Legal Entity (cmns) – has Legal Address
Legal Entity (cmns) subtype
Physical Address (D) <>
Physical Address – has Country(cmns) Region
<> Physical Address subtype
has Legal Address
<>
has Country (cmns) Regionsubtype
Corporation
has Legal Address -t>ional Street Address Conventional Street Address
Corporation subtype Scalar Quantity Value
Scalar Quantity Value subtype
Geographic Region(cmns)
Geographic Region (cmns) subtype
Stock Corporation
(D) <>
Stock Corporation- has Issued Capital
<> has Issued Capital
<>
has Issued Capital -Monetary Amount
Monetary Amount Geopolitical Entity (cmns)
MonetaryAmount subtype Geopolitical Entity (cmns) subtype <>
has Country (cmns) -Country (cmns)
Data Architect Balance Country(cmns) 29
Discussion – Do I really need all these entities?
The short answer is no. For a project model, it is perfectly fine to scope only the directly required green entities.
In practice, the following Logical Modeling phase attributes the model. The Logical Data Modeler looks at the full set of required data items and places them as attributes of the entities.
A simple rule:
You can remove any entity in the subtype hierarchy that does not have attributes or relationships.
The FIB-DM is a reference data model. For the data modeler, the Financial Industry Business Data Model provides a rich library of building blocks to accelerate the design process.
Financial Institution
is Subject To Reserve Requirements Date & Time
Financial Institution subtype
<>
Financial Institution – manages (cmns)
Legal Entity (cmns)
Sample
Textual Name (cmns) Variable characters (255) For_Textual Name (cmns) Variable characters (255) Entity ExpirationDate Date & Time
<> Legal Entity(cmns) subtype
manages (cmns) -Legal Entity(cmns)
<>
Legal Entity (cmns) – has Legal Address
project LDM
RegistrationAuthority(cmns) <> <> Registration Authority (cmns) – manages (cmns) manages (cmns)
<>
Registration Authority (cmns) – registers (cmns)
Depository Institution
is Subject To Reserve Requirements Date & Time
<>
<>
registers (cmns)
registers (cmns) -Registered Identifier
Registered Identifier
Text Value Variable characters (255) Ide_Text Value Variable characters (255) RegistrationDate (cmns) Date & Time
Registered Identifier subtype
<> <>
registers (cmns) -Legal EntityIdentifier Registered Identifier – is Registered In (cmns)
Legal EntityIdentifier
Text Value Variable characters (255) <>
Reg_Text Value Variable characters (255) manages (cmns) -Registry (cmns) Reg_Ide_Text Value Variable characters (255)
Registration Date (cmns) Date & Time
Corporation
Entity Expiration Date Date & Time
Textual Name (cmns) Variable characters (255) For_Textual Name (cmns) Variable characters (255)
Legal Name Variable characters (255)
Corporationsubtype
Stock Corporation
Entity Expiration Date Date & Time
Textual Name (cmns) Variable characters (255) For_Textual Name (cmns) Variable characters (255)
Legal Name Variable characters (255)
(D)
<>
has Legal Address
<>
Stock Corporation- has Issued Capital
Physical Address
Attention Line Variable characters (255) City Name (cmns) Variable characters (255)
<> Address Line3 Variable characters (255)
has Issued Capital Postal Code Variable characters (255) Mail Routing Variable characters (255)
Address Line1 Variable characters (255) Address Line2 Variable characters (255)
Physical Address subtype
<>
has Issued Capital -Monetary Amount
<>
has Legal Address -Conventional Street Address
Monetary Amount Conventional Street Address
(D) <>
Physical Address – has Country (cmns)
The diagram shows out-of-the-box attributes derived from FIBO object properties. The data modeler adds more attributes from source systems and data requirements.
<>
registers (cmns) -FDIC Certificate Number
FDIC Certificate Number
Text Value Variable characters (255) Ide_Text Value Variable characters (255) RegistrationDate (cmns) Date & Time Fin_Text Value Variable characters (255)
<>
<>
FDIC Certificate Number – is Registered In(cmns)
is Registered In (cmns)
<>
is Registered In (cmns) -Registry (cmns)
Numeric Value Decimal Amount Decimal
Monetary Amount subtype
Balance
Amount Decimal Numeric Value Decimal
AttentionLine Variable characters (255) CityName (cmns) Variable characters (255) Phy_Address Line3 Variable characters (255) Postal Code Variable characters (255) Mail Routing Variable characters (255) Phy_Address Line1 Variable characters (255) Phy_Address Line2 Variable characters (255) Address Line2 Variable characters (255) Address Line1 Variable characters (255) Address Line3 Variable characters (255)
<>
has Country (cmns)
Registry (cmns)
Selection Criteria Variable characters (255) Registry Name Variable characters (255)
<>
has Country(cmns) -Country (cmns)
Country (cmns)
Geo_is Independent (cmns) Date & Time
Textual Name (cmns) Variable characters (255)
is Independent (cmns) Date & Time
Data Architect 31
LDM denomalization and simplifications
Next steps:
The modeler will review the associative entities and those that are not many-to-many with direct relationships. For example, if the Physical Address has only one country; we can replace the associative entity with a direct relationship.
Supertype/subtype relations, such as Physical/Conventional Address, can be configured to roll up or down during Physical Model generation.
It is a Logical/Physical Model decision whether certain Scalar Quantities and Dates should be transformed into plain attributes/columns.
Data Architect 32
Excursus: Scoping an operational ontology
The 15 Fundamental Business Concepts apply to both the Financial Industry Business Ontology and Data Model. We use the same methodology to create the concept map. With the concept map we can easily scope a subset of the FIBO to hold the regulatory reference data. The Call Report presentation and the Semantic Compliance article on the Bank Ontology website show the instance graph below.
We recognize the very same design pattern as in the sample data concept map and data model.
Data Architect Ontologist 33
Core in
(and other data modeling tools) https://fib-dm.com/