
Standard data models play a crucial role in the financial sector by providing a consistent framework for organizing and analyzing data. These models define standardized structures and relationships for financial data elements, such as customers, accounts, transactions, and financial instruments. By adopting standard data models, financial institutions can enhance data interoperability and integration across various systems, enabling seamless data exchange between internal departments, business partners, and regulatory authorities. Standard data models facilitate accurate and efficient data processing, reporting, and analysis, improving risk management, compliance, and decision-making processes. They also enable comparability and benchmarking, allowing institutions to assess their performance against industry standards and best practices. Ultimately, standard data models foster transparency, data quality, and operational efficiency in the financial sector, supporting robust and informed business operations.
Financial Information Exchange
Acronym: FIX
Organisation responsible: FIX Trading Community
Official web page: https://www.fixtrading.org/
Description: FIX is a messaging protocol used for real-time electronic communication of trade-related information in the financial industry.
Current Version: 1.1
Schema location: https://www.fixtrading.org/standards/fixml-online/
Standard: Not applicable
Type of data: XML
Primary purpose : Structured data transfer
API available: Not available
License details: Open standard
Data model (Power BI): Available on request
ISO 20022
Acronym: ISO 20022
Organisation responsible: ISO
Official web page: https://www.iso20022.org/
Description: ISO 20022 is a global standard for financial messaging that provides a common framework for the development of messages for various financial business domains, including payments, securities, trade finance, and more.
Current Version: Not applicable
Schema location: https://www.iso.org/standard/84857.html
Standard: Not applicable
Type of data: XML / UML
Primary purpose : Structured metadata exchange / Structured metadata storage
API available: Not applicable
License details: Open standard
Data model (Power BI): Available on request
eXtensible Business Reporting Language
Acronym: xBRL
Organisation responsible: xBRL International
Official web page: https://www.xbrl.org/
Description: IXBRL (eXtensible Business Reporting Language) is a freely available and global framework for exchanging business information
Current Version: 2.1 (February 20, 2013)
Schema location: https://www.xbrl.org/the-standard/
Standard: Extended from XML
Type of data: XML
Primary purpose : Structured metadata exchange
API available: Available here
License details: Open standard
Data model (Power BI): Available on request
Financial Products Markup Language
Acronym: FpML
Organisation responsible: International Swaps and Derivatives Association
Official web page: https://www.isda.org/
Description: FpML is an XML-based standard for representing and exchanging financial derivatives and structured products. It defines schemas for various financial instruments, including interest rate swaps, credit derivatives, and equities.
Current Version: 5.12 (December 2021)
Schema location: https://www.fpml.org/reference-data/
Standard: Not applicable
Type of data: Reference data / Data dictionary / XML
Primary purpose : Structured data storage / Structured data exchange
API available: Validator API here
License details: Open standard with details here
Data model (Power BI): Available on request
Financial Data Exchange
Acronym: FDX
Organisation responsible: Financial Data Exchange
Official web page: https://financialdataexchange.org/
Description: FDX is an industry standard for financial data sharing, primarily focused on consumer and small business financial data. It provides a standardized schema for the secure exchange of financial information, such as transaction data, account details, and balances.
Current Version: API 5.3
Schema location: https://www.financialdataexchange.org/FDX/FDX/News/Press-Releases/Financial_Data_Exchange_Releases_FDX_API_5.0.aspx
Standard: Not applicable
Type of data: API
Primary purpose : Structured data exchange
API available: Validator API here
License details: Details of license required are here
Data model (Power BI): Not available
Financial Industry Business Ontology
Acronym: FIBO
Organisation responsible: FIBO
Official web page: https://spec.edmcouncil.org/fibo/
Description: FIBO is a semantic model and ontology for representing financial industry concepts and relationships. It aims to standardize the meanings and definitions of financial terms, enabling better interoperability and understanding of financial data.
Current Version: API 5.3
Schema location: https://github.com/edmcouncil/fibo/blob/master/README.md
Standard: Not applicable
Type of data: Ontology (OWL) / Hierarchical data classification
Primary purpose : Structured data storage
API available: Not applicable
License details: Open standard with details here
Data model (Power BI): Not available
Financial Instruments Reference Database System
Acronym: FIBO
Organisation responsible: FIRDS
Official web page: European Securities and Markets Authority (ESMA)
Description: FIRDS is a database that provides reference data for financial instruments traded on European Union markets. It includes information on instrument classification, identifiers, and attributes, facilitating regulatory reporting and market surveillance.
Current Version: 1.2.1
Schema location: https://www.esma.europa.eu/document/firds-reference-data-xml-schema-v121
Standard: Directive 2014/65/EU
Type of data: XML / Reference data
Primary purpose : Structured data storage
API available: Not applicable
License details: Open standard
Data model (Power BI): Not available
The Global Industry Classification Standard
Acronym: GICS
Organisation responsible: Developed in 1999 by MSCI and S&P Dow Jones Indices
Official web page: European Securities and Markets Authority (ESMA)
Description: GICS is a classification system used to categorize companies into industry groups, sectors, and subsectors. It helps in analyzing and comparing companies within the financial markets.
Current Version: 2023 (Since March 17th 2023)
Schema location: https://www.msci.com/our-solutions/indexes/gics
Standard: Directive 2014/65/EU
Type of data: Excel / Reference data
Primary purpose : Structured data storage
API available: Not applicable
License details: Open standard
Data model (Power BI): Not available