MDR EUDAMED, how to prepare your spreadsheet templates.
The European Commission (EC) delayed the release of MDR EUDAMED until May 26th 2022, MDR now applies and IVDR will apply from May 26th 2023. This means that you now have to collate, maintain and keep up to date all of your UDI Device data. You have to find some way of collating your UDI data in preparation for EUDAMED and the XML data required for UDI data uploads.
The most common question we get asked at our EUDAMED training courses is how do we prepare a spreadsheet to collate the EUDAMED required data? Do you have any examples? Can you help us?
It is possible for your in-house team to put together a correctly formatted spreadsheet. This will keep your data in-house where you retain control of your data.
There is some complexity involved with the proposed spreadsheet. First, there are a lot of fields within MDR Eudamed, a lot of mandatory fields, and some fields that can accept multiple entries, particularly language specific fields. If you do not wish to invest a lot of time in preparing the spreadsheets with the correct EUDAMED fields then you can purchase ours, they are split into two packages, MDR and IVDR.
Tips for spreadsheet preparation
- Avoid duplication of data.
- Some elements allow you to add multiple entries e.g. Critical warnings, storage and handling etc. And place where multiple entries are possible, create a specific tab for this data.
- Any element that allows for multiple languages is data that should be in its own tab.
- For example, if you have one UDI DI on a single row, and needed to enter an ‘additional description’ in 10 languages, then you would need to duplicate the UDI DI row 10 times, thus making the overall management and maintainability virtually impossible.
- The main reason for separating the data elements into tabs is that it won’t be necessary to repeat all the UDI DI data for each multi-language entry.
- Use drop-down lists in your spreadsheet for each enum or value list to reduce errors during data entry.
- Enum examples include issuing entities, storage and handling, critical warnings, languages, countries and many more.
- Highlight the mandatory fields to make data entry easier for the end-user.
- Where to find the information? Locating the information will require research the following are the three main sources of information for you:
- Firstly, the data dictionary V8 was recently published (October 2021) and has an abundance of information, from occurrences (multiple entries) and data types to what enumerations are used.
- To find the enumerations is a bit of work because the EC have yet to publish the full lists. For now, you need the XSD’s. Inside the XSD’s the enumerations are detailed. Locate the required entity name in the data dictionary and use this to search the XSD which will bring you to the enum or value list. These are the options you must include in your XML when you upload to EUDAMED.
- The UML diagrams are a great source of information including mandatory and multiple entry fields.
The preparation of the spreadsheet takes a lot of time. For the Eudamed.com available spreadsheets, we estimated that we spent well in excess of 175+ hours creating ours, and that is before we started on the business rules.
To save you a lot of time and research, our spreadsheets are available for you to purchase. They are split into two packages, MDR and IVDR. Each spreadsheet has some legislation specific MDR EUDAMED rules built-in. The inclusion of the business rules is to help with the overall MDR EUDAMED data preparation and the long-term maintainability of the data.
Regardless of creating your own or purchasing our spreadsheets, you must start keeping collated device records, which will greatly reduce the level of work needed when MDR Eudamed goes live. If you need further assistance, training, or would like to purchase our spreadsheet templates please go to our website for further information, https://eudamed.com