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 Scoping our first Data Model (PDF)
Text of the presentation
Financial Industry Business Data Model (FIB-DM)
Scoping our first data model from FIB-DM
The Bank Call Report example, using Concept Maps.
Solution Architecture is middle-out
Focus on FIB-DM packages (FIBO modules) for the project – not the whole model.
Implementation is iterative, not a waterfall.
F Finance key point 2
Departments and projects leverage and derive
We adhere to the industry-standard
Normative
FIBO Production
scope
Enterprise Data Model
Informative
FIBO Customization
Inhouse models
Other Standards
Vendor models
We consult other models
Our goal is leverage
derive
Implementation Department
Project Application
Our method is to derive
Data Architect 3
To derive a project model means scoping
FIB-DM has more than 3,000 entities.
We don’t need a giant model for our project or even department.
We certainly won’t create 3,000 tables (most of them empty) on our RDBMS.
So, we “cut,” we extract a subset model from FIB-DM that comprises only the required entities.
In PowerDesigner, we create a new Package for our project, and add required (=scoped) entities to it and its diagram.
In ERWin, we create a new Subject Area.
In both cases, we generate a new Project Logical Data Model (LDM) from our scope. Subsequent iterations scope additional content and merge into the Project LDM.
Data Architect 4
FIB-DM training
Scoping is an advanced class for Data Architects.
Semantics for Project Architects sets the stage.
The previous deep-dive classes are prerequisites for understanding this lecture:
Semantics for Finance Users explains FIB Concept Maps.
Semantics for Data Architects teaches the structure of the FIBO Data Models.
The FIB-DM concepts article is a reference.
F Finance key point 5
Audience and content
Project Data Architect/Modeler experienced in Enterprise Reference models. You may have used FIBO design patterns and definitions.
Finance users and subject matter experts define the scope. Project Managers want to understand the process.
Ontologists follow the same approach when scoping an operational ontology from the FIBO. Ontology and data model are in sync – the project scope is the same.
This class 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
6
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/
Data Architect 7
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.
Data Architect 8
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.
Data Architect 9
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 fundamental fifteen concepts are direct subclasses of the Thing.
We use abbreviations and icons as mnemonics to teach the concepts to modelers and business users.
Data Architect 10
Identifying Entities and Concepts
We can use the modeling tool or MS Excel to research Concept Entities.
In this example, we look for supertypes of the FDIC Certificate and their Associations
Data Architect 11
Creating the concept map diagram
FIB-DM has a Legal Entity Identifier, an exact match for the LEI in the sample. Designation (D) is the ultimate supertype of 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 comprises Person, Legal Person, Automated System, and Organization.
The FDIC insures and regulates financial institutions that take deposits. A Depository Institution is an entity in the data model that rolls 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 Agent, but we don’t need that detail for our scope.
JPMC’s capital is a Balance, a subtype of Monetary Amount. 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 Registered Address, a subtype of Reference. The Reference functions like an associative entity with a role, linking Country to Agent.
Data Architect 12
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.
LEI: 7H6GLXDRUGQFU57RNE97
identifies
JPMorgan Chase National Association
Plays Role
has Issued Capital
has Legal Address
$176,083,000,000
Physical Address
has Country
registers
USA
Federal Deposit Insurance Corporation
identifies Is registered In
JPM Chase Bank
FDIC Cert: 628
FDIC Registry Entry
Data Architect 13
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.
Legal Entity
Identifier
Monetary has Issued Capital Amount
Country
Finally, we replace the sample values with identified FIB-DM entities. Here is our Fundamental Business Concept map for the Call Report Entity Schedule.
Stock Corporation
Depository Institution
Physical Address
FDIC Certificate Number
Is registered In
Registration Authority
Registy
Data Architect 14
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.
Monetary Amount
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.
Data Architect 15
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
Data Architect 16
1. Create a new diagram of the nine entities
Open FIB-DM in your data modeling tool. The screenshots and diagrams in this education module are PowerDesigner.
LegalEntityIdentifier MonetaryAmount Country(cmns)
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
ConventionalStreetAddress
RegistrationAuthority(cmns)
Registry(cmns)
Data Architect 17
2. Adding Supertypes
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
Financial Service 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
Data Architect 18
2.2 Adding the Registration Authority supertype
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).
FinancialService Provider
FinancialService Provider subtype
FinancialInstitution
FinancialInstitutionsubtype
DepositoryInstitution RegistrationAuthority(cmns)
Data Architect 19
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
Data Architect 20
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.
GeopoliticalEntity(cmns)
GeopoliticalEntity(cmns) subtype
Country(cmns)
Data Architect 21
2.5 Balance
Scalar Quantity Value
Scalar Quantity Value subtype
The Issued Capital is on the Balance sheet, and hence a Balance, which is a Monetary Amount subtype of the Scalar Quantity.
MonetaryAmount
MonetaryAmountsubtype
Balance
Data Architect 22
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 Collection subtype
Data Architect 23
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
PhysicalAddress
PhysicalAddress subtype
Data Architect 24
2.8 Designation Designation
Designationsubtype
The LEI and FDIC Certificate Number are Registered Identifiers, a subtype of Contextual Identifier.
Identifier (cmns)
Identifier (cmns) subtype
ContextualIdentifier
ContextualIdentifier subtype
Registered Identifier
Registered Identifier subtype
LegalEntityIdentifier FDIC Certificate Number
Data Architect 25
2.9 Our Entities and their Fundamental Concepts.
Agent
Designation
Region
Regionsubtype
Geopolitical Entity(cmns)
Geopolitical Entity(cmns) subtype
Collection (cmns)
Structured Collection
Scalar Quantity Value
MonetaryAmount subtype
Physical Address subtype
Contextual Identifier
Contextual Identifier subtype
DepositoryInstitution RegistrationAuthority(cmns) Stock Corporation Country(cmns) Registry(cmns) Balance Conventional Street Address Legal EntityIdentifier FDIC Certificate Number
Data Architect 26
3 Adding 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.
Data Architect 27
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.
(D) <>
Stock Corporation- has Issued Capital
<>
<>
has Issued Capital-MonetaryAmount
A perfect match, the Associative entity “has Issued Capital” directly
relates to the Monetary Amount, a supertype of Balance. Balance
Data Architect 28
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) – registers (cmns)
registers (cmns)
registers (cmns) -FDIC Certificate Number
The Association “is Registered in” directly connects the FDIC Certificate Number to the Registry.
<>
FDIC Certificate Number – is Registered In(cmns)
<> <>
is Registered In(cmns) is Registered In(cmns) -Registry(cmns)
29
Preview: The Navigator finds Associations
From the Stock Corporation to its Capital Balance
Stock Corporation has Issued Capital a Balance [amount] associated via its supertype, the Monetary Amount
From the Registration Authority to the FDIC Certificate Number to the Registry
Registration Authority registers FDIC Certificate Number is Registered in a Registry
Data Architect 30
3.3 Stock Corporation – Address
The Stock Corporation has no direct Associative Entity relating to an Address.
LegalEntity(cmns)
<> LegalEntity(cmns) – has LegalAddress
has LegalAddress
has LegalAddress -ConventionalStreetAddress ConventionalStreetAddress
LegalEntity(cmns) subtype
However, its supertype, Legal Entity “has Legal Address” connects to the Conventional Street Address.
Data Architect 31
3.4 Address – Country
The Conventional Street Address does not have an Association relating to the Country. .
(D) <> PhysicalAddress – has Country(cmns)
has Country(cmns)
has Country(cmns) -Country(cmns)
ConventionalStreetAddress We investigate its supertype, the Physical Address, and find “has Country”.
Data Architect Ontologist 32
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, supertype of the Depository Institution.
- The Legal Entity Identifier identifies the Legal Person, a supertype of Legal Entity.
FinancialService Provider Identifier (DFinancialService Provider Identifier – identifies (cmns)
identifies (cmns) -LegalPerson(cmns)
LegalPerson(cmns)
FinancialService Provider Identifier subtype LegalPerson(cmns) subtype
<> identifies (cmns)
FDIC Certificate Number LegalEntity(cmns)
LegalEntityIdentifier (D)
<> LegalEntityIdentifier – identifies (cmns)
identifies (cmns) -Financial Service Provider
Data Architect Ontologist 33
The complete CDM scope
Conceptual Data Model Model: Financial IndustryBusiness Data Model (FIB-DM)
Package: Call Report Diagram: Call Report scope
Author: JurgenZiemer, © Jayzed Data Models Inc. Version: October, 2025 (FIBO 2025/Q3)
Date: 2025-11-14
Legal EntityIdentifier – identifies (cmns)
Financial Service Provider Identifier – identifies (cmns)
Designation
The
identifies (cmns) -Legal Person(cmns)
complete CDM scope
identifies (cmns) -Financial Service Provider
identifies (cmns) -Financial Institution
PartyRole Identifier
PartyRole Identifier subtype
Designationsubtype
(D) Contextual Identifier subtype
Financial Service Provider RegistrationAuthority(cmns)
<> RegistrationAuthority(cmns) – registers (cmns)
Financial Service Provider Identifier
Financial Service Provider subtype <>
registers (cmns) -Registered Identifier
Financial Institution- manages (cmns)
registers (cmns) -Legal EntityIdentifier
(D)
Legal EntityIdentifier
<> Structured Collection Party Index Registered Identifier – is Registered In(cmns)
<> RegistrationAuthority(cmns) – manages (cmns)
<> DepositoryInstitution registers (cmns) -FDIC Certificate Number
Structured Collectionsubtype Partysubtype
<> manages (cmns)
manages (cmns) -Legal Entity(cmns)
manages (cmns) -Registry(cmns)
<>
is Registered In(cmns)
<> Legal Person(cmns)
is Registered In(cmns) -Registry(cmns)
Legal Person(cmns) subtype Registry(cmns)
Legal Entity(cmns) <>
Legal Entity(cmns) – has Legal Address
Physical Address – has Country(cmns) Region
<> Physical Address subtype
has Country(cmns) Regionsubtype
has Legal Address -t>ional Street Address Conventional Street Address
Corporationsubtype Scalar Quantity Value Geographic Region(cmns)
<> has Issued Capital
has Issued Capital -MonetaryAmount
Scalar QuantityValue subtype
Geographic Region(cmns) subtype
MonetaryAmount subtype Geopolitical Entity(cmns) subtype <>
Balance Country(cmns)
Data Architect 34
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 examines the full set of required data items and maps them to the entities’ attributes.
A simple rule:
You can remove any entity from the subtype hierarchy that has no 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.
Data Architect 35
Sample project LDM
is SubjectTo Reserve Requirements Date & Time
<> FinancialInstitution- manages (cmns)
Sample
TextualName (cmns) Variable characters (255) For_TextualName (cmns) Variable characters (255) EntityExpirationDate Date & Time
<> LegalEntity(cmns) subtype
manages (cmns) -LegalEntity(cmns)
project LDM
RegistrationAuthority(cmns) <> <> RegistrationAuthority(cmns) – manages (cmns) manages (cmns)
<>
registers (cmns) registers (cmns) -Registered Identifier
TextValue Variable characters (255) Ide_TextValue Variable characters (255) RegistrationDate (cmns) Date & Time
<> <>
registers (cmns) -LegalEntityIdentifier Registered Identifier – is Registered In(cmns)
LegalEntityIdentifier
TextValue Variable characters (255) <> Reg_TextValue Variable characters (255) manages (cmns) -Registry(cmns) Reg_Ide_TextValue Variable characters (255)
RegistrationDate (cmns) Date & Time
TextValue Variable characters (255) <> Ide_TextValue Variable characters (255)
registers (cmns) -FDIC Certificate Number RegistrationDate (cmns) Date & Time Fin_TextValue Variable characters (255)
FDIC Certificate Number – is Registered In(cmns) <>
Corporation
EntityExpirationDate Date & Time TextualName (cmns) Variable characters (255) For_TextualName (cmns) Variable characters (255)
LegalName Variable characters (255)
AttentionLine Variable characters (255) CityName (cmns) Variable characters (255)
<> Address Line3 Variable characters (255)
has Issued Capital PostalCode Variable characters (255)
MailRouting Variable characters (255) Address Line1 Variable characters (255) Address Line2 Variable characters (255)
has LegalAddress -ConventionalStreetAddress
MonetaryAmount ConventionalStreetAddress
Numeric Value Decimal AttentionLine Variable characters (255) Amount Decimal CityName (cmns) Variable characters (255) Phy_Address Line3 Variable characters (255)
PostalCode Variable characters (255)
MonetaryAmountsubtype MailRouting 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)
Amount Decimal Numeric Value Decimal
(D) <> PhysicalAddress – has Country(cmns)
The diagram shows out-of-the-box attributes derived from FIBO Data Properties.
The data modeler adds more attributes from source systems and data requirements.
SelectionCriteria Variable characters (255) RegistryName Variable characters (255)
Geo_is Independent(cmns) Date & Time TextualName (cmns) Variable characters (255)
is Independent(cmns) Date & Time
Data Architect 36
LDM denormalization 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 37
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 38
Resources for further study
Find selected diagrams on the FIB-DM website or your Full Model delivery zip folder.
Open-source users can review the PowerPoint in MS Office Online and download a PDF.
Full Model licensees find the PPTX file in their delivery folder.
https://fib-dm.com/diagrams/ https://fib-dm.com/education-module-scoping-our-first-data-model/
Study the article for a deeper understanding of the FIBO/FIB-DM Fundamental Concepts.
https://fib-dm.com/house-of-finance-15-business-concepts/
Avoid islands and watch the Navigator lesson on the YouTube Course.
https://www.youtube.com/@FIBDM/courses
Data Architect 39