Field Lists and Changelogs

Please note that the following lists are still ‘work in progress’ and therefore changes will occur irregularly. For Beta versions there is also no version management in place. Therefore, openfunds recommends to use the latest version number (1.10.xx) or to check the print date at the lower left corner of the lists.

openfunds fields 1.1 (stream I): MiFID II fields / Excel [BETA]
openfunds fields 1.1 (stream III): PRIIPs fields / Excel [BETA]

openfunds fields v1.00 / Changelog / Excel [FINAL]

openfunds fields v1.00 / Changelog / Excel [DRAFT]
openfunds fields v0.94 / Changelog / Excel
openfunds fields v0.93 / Changelog / Excel
openfunds fields v0.92 / Changelog / Excel
openfunds fields v0.91 / Changelog / Excel
openfunds fields v0.90 / Changelog / Excel
openfunds fields v0.89 / Changelog
openfunds fields v0.88 / Changelog
openfunds fields v0.87 / Changelog
openfunds fields v0.86 / Changelog
openfunds fields v0.85

Version 1.1 (beta)

Beta Warning

The purpose of this section to give you an idea about the topics openfunds is currently working on. Wherever possible, openfunds also publishes first drafts of proposed new fields. When doing so, openfunds firmly advises to use these new fields with great care as they might change. Also, openfunds does not guarantee backwards compatibility for fields with ‘beta’ status as described in the white paper version management.

The following field lists are not final. They serve as a basis for discussion about new fields or field changes. Some, or even most of them may change in very different ways. We are trying to avoid any changes of the data-IDs although these fields are not finalised. However, as it might be necessary to change some of the below mentioned data-IDs, openfunds strongly recommends to implement these beta data-fields only in very flexible database environments.

Actually openfunds is working on nine streams, seven of them being original, number II and number IV being derivatives of number I and III respectively. The first five streams can be found here, whereas streams no VI to IX are available to active members only.

  1. MiFID II fields
  2. MiFID II target market fields
  3. PRIIPs fields
  4. PRIIPs & MiFID II cost fields
  5. Solvency II fields

The first four streams focus on two major European regulations that will be introduced on the 3rd of January 2018:

  • The MiFID II Directive 2014/65/EU
  • Regulation (EU) No 1286/2014 on key information documents for packaged retail and insurance-based investment products (PRIIPs Regulation)

The following table gives an overview of the main characteristics of the MiFID II and PRIIPs regulation:

Table 1: MiFID II and PRIIPs regulation
Link to regulation The MiFID II Directive 2014/65/EU Regulation (EU) No 1286/2014 on key information documents for PRIIPs
Main purpose of regulation Investor protection Investor information
Adressee Distributors of financial products, e.g. funds Insurance companies
Main topics
  • Target market
  • Cost and charges
  • Risk and performances
  • Cost and charges
European Working Group’s template European MiFID template (EMT) European PRIIPs template (EPT)
Comfort EPT (CEPT)

I. MiFID II fields

The openfunds adaption of MiFID II is based on the work of tisa and the European Working Group’s EMT. As openfunds focuses on funds there are fields within these papers that we could leave out. On the other hand, as MiFID II requires time series for ex-post costs fields, we had to introduce new dynamic openfunds fields. More information can be found in the “IV. PRIIPs & MiFID II cost fields” section. The following files list and describe all MiFID II fields:

MiFID II fieldsMiFID II fields (PDF)
MiFID II Excel listMiFID II Excel list

openfunds adjusted the original EMT file of the European Working Group with two columns at the end indicating the correspondent openfunds data-ID and field names.

European Working Group’s EMT (Excel): EMT 1.1 Version 2017-07-18 (including openfunds)

Please note that this file is currently only available to active members.

II. MiFID II target market fields


A good summary of MiFID’s target market concept can be found on the European Securities and Markets Authority’s (esma) website. The ‘Final Report – Guidelines on MiFID II product governance requirements’ gives good insight into how the target market should be narrowed down from the manufacturer’s perspective (who usually does not know the clients of the distributor, and who should have a strategic view on how to market funds to different types of clients). The following chart displays this concept of ‘Target Market’.

Target market and its context

Besides MiFID II, there are more national regulations that point in a similar direction as they also want to increase investor’s protection. Asset managers are also trying constantly to improve the suitability of their funds by implementing additional features to specific share classes to address specific clients’ needs. National regulations manifest themselves in country legal registrations of share classes, whereas fund houses sometimes modify some of the share classes to the needs of a specific type of clients, e.g. a share class only for pension funds or another one only for discretionary mandates, etc.

The following chart shows the concurrence of ‘target market’, ‘country legal registration’ and ‘share class eligibilty’:

openfunds target market adaption

The following table gives an overview about openfunds’ target market approach. This approach follows quite closely the regulation and hence shows less fields than other adaptions. Despite beginning with the broadest possible solution, openfunds tries to start with a minimum field set as this can be expanded rather easily in the future, whereas eliminating fields creates much more trouble for practical solutions.

Please be aware of the fact that the new EMT V1.0 from July 20th 2017 may have certain changes regarding the “Distribution strategy” fields. We will keep you informed once those changes are finalized.

target market adaptiontarget market adaption

III. PRIIPs fields

This section provides an overview of all openfunds fields that might be introduced because of the European PRIIPs Regulation. As it seems that the industry will agree on the European PRIIPs template as it was established by the European Working Group, openfunds has adapted the EPT and CEPT quite closely and has created new openfunds fields when there didn’t exist already an appropriate field.

The following PDF and Excel files describe all the potential openfunds PRIIP fields that are necessary to assure that all relevant EPT and CEPT fields can be imported into an openfunds compatible fund database. The Excel file is the above mentioned EPT enhanced with two columns that point to the relevant field within openfunds.

PRIIPs PDF filePRIIP fields (PDF)
PRIIPs Excel ListePRIIP fields – EPT (Excel)

The Insurance Europe Executive Committee and the EFAMA members have validated the EPT 1.0 Version 2017-06-21.

Please note that this file has been established by the European Working Group (EWG). For further information about the file kindly contact Ghislain Perisse (Manager of the EWG):

To approach the openfunds PRIIPs adaption to the EPT, we adjusted the European PRIIPs Template (EPT) with two columns at the end indicating the correspondent openfunds data-ID and field names.

EPT file including openfunds fields:
EPT 1.0 Version 2017-06-21 (including openfunds) v01
EPT 1.0 Version 2017-06-21 (including openfunds) v02 – This version includes openfunds fields for all mandatory EPT fields.

IV. PRIIPs & MiFID II cost fields

Even before the EU PRIIPs and MiFID regulation forced the industry to publish some cost information about their funds, openfunds had included some cost fields as management fees, ongoing charges or total expense ratio.

The new thing about costs being introduced with the PRIIPs and MiFID regulation is the attempt by the regulator to specify the calculation methods for the different cost figures. Additionally the regulator distinguishes for the first time between ex-ante and ex-post cost figures. This has lead to some conceptual questions about data handling within openfunds as for ex-post cost figures there is a need of storing and transmitting time series. This is one reason why openfunds distinguishes between static fields, their data-IDs all starting with ‘OFSTxxxxxx’ and dynamic fields (starting with ‘OFDYyyyyyy’). More information on dynamic fields will be released soon.

The following graph shows an overview of the relevant cost and charges categories as mentioned in either the European PRIIPs Template (EPT) or the European MiFIID Template (EMT). Additionally to this openfunds has included a reduced set of cost and charges fields compared to the EMT and EPT as we think that that all cost information requirements can be fulfilled even with this reduced set of fields:

MiFID PRIIPs cost matrix - draft

As you can see, there is a distinction between ex-ante and ex-post fields. Therefore openfunds introduced additional fields like period start and period end dates in order to allow the handling of time series as needed for the MiFID II ex-post cost fields.

V. Solvency II fields

The following list contains an extract of the Solvency II fields as defined in the Tripartite Template version 3 (TPT). It focuses on aggregate figures that can be used by insurance companies to define their capital requirements when investing in specific share classes.

More information can be found in the whitepaper ‘Solvency II Fields’.

openfunds says ‘thank you’ to SolvencyAnalytics, Zürich, who provided all solvency field descriptions and the whitepaper.

Data Identifier (data-ID)

Data identifiers (data-ID) constitute the core of openfunds, that is expanded by additional concepts to simplify the exchange of data and to make it more secure as well. The data-ID consists of a 10-character alphanumeric code, to which spaces may be added to improve readability, making it longer. The field names are in English, and the individual words all begin with a capital letter.

data-IDs have the following format: OFGGnnnnnn(lang)[rrrr].

OF stands for openfunds.
GG denotes a group of data fields (ST=static; AS=assets; DY=dynamic).
nnnnnn stands for an unique number identifying the data field.

(lang) indicates an optional language tag. Please refer to white paper Language Tags.

[rrrr] indicates an optional recipient code. This allows values intended for a single recipient to be shown exclusively to that recipient.

The identifiers are arranged into groups. In order to group related fields as closely as possible together, these are sorted by data-ID. The groups can be divided as follows:

openfunds Field Range narrow

Each field has a data-ID. Similar fields have the same field range assignment, i.e. the fields “Fund Group Name” (OFST001000) and “Fund Promotor Name” (OFST001100), that both belong to the Field Range “Key Facts – Company” (OFST001000 – OFST004999).  In addition, there are fields that have more properties or tag assignments (tags). All the tags without a corresponding field range at the bottom of the list can be assigned supplementary to a field. An example for a field assigned to more than one tag is ISIN (OFST020000). It is assigned to “Key Fact: Share Class” as well as to “Code”.

An actual list that contains all fields is available at the top of this page by chosing the right sided menu item “Field Lists and Changelogs”.

Field Requests

The openfunds committee welcomes input from specialists.
If you would like to propose new fields that should be included in the standard, or you notice any errors, please inform us by downloading the corresponding form and returning it completed to

New Field Request

Field Change Request