Difference between revisions of "Medical Device System"

From wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
== Medical Device System (MDS) ==
 
== Medical Device System (MDS) ==
  
The Medical Device System (often abbreviated to MDS) is the data base (see MDS Database for information specific to the database tables) and graphical user interface used to house medical device program related data such as companies, company contacts, applications for authorization, lists of devices, and more. It is also the source of the data for the Medical Devices Active Licence Listing (MDALL), the outwardly visible database of licensed devices.   
+
The Medical Device System (often abbreviated to MDS) is the data base (see [[MDS Database]] for information specific to the database tables) and graphical user interface used to house medical device program related data such as companies, company contacts, applications for authorization, lists of devices, and more. It is also the source of the data for the [[Medical Devices Active Licence Listing]] (MDALL), the outwardly visible database of licensed devices.   
  
The MDS is divided up into sections; this related mostly to the function, but there is substantial communication between the sections (e.g., while the Company section maintains information about companies, other sections like Applications or Incidents will refer to the company entries.)
+
The MDS is divided up into sections; this related mostly to function, but there is substantial communication between the sections (e.g., while the Company section maintains information about companies, other sections like Applications or Incidents will refer to the company entries).
  
 
==History==
 
==History==
Prior to April 2018, the MDS was run on HP PowerHouse, and this interface and system was rather dated and due to the departure of staff knowledgeable about the language, impossible to update and maintain. The system had been labeled a legacy system that required replacement. In April 2018, the new interface was launched, an HTML5 web-based interface that was more modern and allowed continued development.  
+
Prior to April 2018, the MDS was run on HP PowerHouse, and this interface and system was rather dated and due to the departure of staff knowledgeable about the language, impossible to update and maintain. The system had been labeled a legacy system that required replacement. In April 2018, the new interface was launched, an HTML5 web-based interface that was more modern and allowed continued development. Querying of the system was performed with Cognos Impromptu, and as there was no ability to edit the framework that supported these searches it was difficult to develop new reports. With the upgrade to the system it became possible to add new functionality; some of the new improvements include the addition of a pdf and XML reader for industry problem reports, the addition of a post-market tracking module, and rapid changes to add new COVID-19 interim order authorizations. 
The system runs on a Oracle database - it was on version 11g for many years and was updated in 2021 to Oracle 19c.  
+
 
 +
The MDS runs on a Oracle database - it was on version 11g for many years<ref>citation needed</ref> and was updated in 2021 to Oracle 19c.  
 
[[File:MDS POWERHOUSE.png|thumb|Image from the Incident section of the old MDS PowerHouse interface]]
 
[[File:MDS POWERHOUSE.png|thumb|Image from the Incident section of the old MDS PowerHouse interface]]
 
In the old PowerHouse system, each section of the user interface was accessed by numbers, and some fields still have these references in the HTML version or in documentation (e.g., the numbers before the sub-sections on the device screens refer to the field numbers in the old MDS system).   
 
In the old PowerHouse system, each section of the user interface was accessed by numbers, and some fields still have these references in the HTML version or in documentation (e.g., the numbers before the sub-sections on the device screens refer to the field numbers in the old MDS system).   
Line 50: Line 51:
  
 
==== Special Access Summary ====
 
==== Special Access Summary ====
The Special Access Summary lists the special access requests made for the device, along with the request dtae and action date, and whether the request was approved or not.  
+
The Special Access Summary lists the special access requests made for the device, along with the request date and action date, and whether the request was approved or not.  
  
 
==== Special Access Info ====
 
==== Special Access Info ====
Line 59: Line 60:
  
 
===Company Section===
 
===Company Section===
 +
The company section is used to maintain company records (and with the implementation of Vanessa's Law and mandatory reporting by hospitals, the list of hospital reporters) for multiple purposes - reporting of incidents, tracking of applications, and so on.
 +
 +
Like the device section, there is a set of tombstone information (drawn from the COMPANY table), as well as several sub-sections.
 +
 +
* Contacts
 +
* History
 +
* Incident
 +
* Finance
 +
 +
==== Contacts ====
 +
The Contacts tab of the MDS company section tracks the company contacts related to a company ID; these are drawn from the COMPANY_CONTACTS table, and include fields like Name, Title, Contact type, Phone number, Email address, and status (active or inactive).
 +
 +
==== History ====
 +
The History tab of the MDS company section tracks the history of the name, address, and other fundamental/tombstone data about the company.
 +
 +
==== Incident ====
 +
The Incident tab on the company section tracks the incidents related to the company; this counts the rows of the INCIDENT_COMPANY table that list the company in any role.
 +
 +
==== Finance ====
 +
The Finance tab on the company section lists finance specific elements from the company table such as the bill to ID, tax numbers, and so on.
 +
 +
=== Meeting ===
 +
 +
=== Application ===
 +
 +
=== Special Access ===
 +
- for maintaining information relevant to Special Access Program requests for medical devices
 +
 +
=== Correspondence ===
 +
- for maintaining correspondence records
 +
 +
=== Quality System ===
 +
 +
=== Batch ===
 +
- used to launch batch processes for administrative closure of incidents
 +
 +
=== Incident ===
 +
- for tracking complaints, recalls, and reported medical device problems (Some of these were migrated to the Canada Vigilance ArisG system in February 2020)
 +
 +
=== Establishment ===
 +
- for establishment information
 +
 +
=== Maintenance ===
 +
 +
=== Logout ===
 +
- log out of the system

Latest revision as of 14:38, 4 May 2022

En français

Medical Device System (MDS)

The Medical Device System (often abbreviated to MDS) is the data base (see MDS Database for information specific to the database tables) and graphical user interface used to house medical device program related data such as companies, company contacts, applications for authorization, lists of devices, and more. It is also the source of the data for the Medical Devices Active Licence Listing (MDALL), the outwardly visible database of licensed devices.

The MDS is divided up into sections; this related mostly to function, but there is substantial communication between the sections (e.g., while the Company section maintains information about companies, other sections like Applications or Incidents will refer to the company entries).

History

Prior to April 2018, the MDS was run on HP PowerHouse, and this interface and system was rather dated and due to the departure of staff knowledgeable about the language, impossible to update and maintain. The system had been labeled a legacy system that required replacement. In April 2018, the new interface was launched, an HTML5 web-based interface that was more modern and allowed continued development. Querying of the system was performed with Cognos Impromptu, and as there was no ability to edit the framework that supported these searches it was difficult to develop new reports. With the upgrade to the system it became possible to add new functionality; some of the new improvements include the addition of a pdf and XML reader for industry problem reports, the addition of a post-market tracking module, and rapid changes to add new COVID-19 interim order authorizations.

The MDS runs on a Oracle database - it was on version 11g for many years[1] and was updated in 2021 to Oracle 19c.

Image from the Incident section of the old MDS PowerHouse interface

In the old PowerHouse system, each section of the user interface was accessed by numbers, and some fields still have these references in the HTML version or in documentation (e.g., the numbers before the sub-sections on the device screens refer to the field numbers in the old MDS system).

Interface sections

  • Device - for maintaining device information
  • Company - for maintaining company information
  • Meeting
  • Application - for maintaining application information
  • Special Access - for maintaining information relevant to Special Access Program requests for medical devices
  • Correspondence - for maintaining correspondence records
  • Quality System
  • Batch - used to launch batch processes for administrative closure of incidents
  • Incident - for tracking complaints, recalls, and reported medical device problems (Some of these were migrated to the Canada Vigilance ArisG system in February 2020)
  • Establishment - for establishment information
  • Maintenance
  • Logout - log out of the system

Device Section

An image from the web GUI for the new MDS system, showing the Device section

The Device screen is used to maintain device records, and has the following sections - a tombstone section, with general characteristics about the device, accompanied by 6 sub sections:

  • Drug/NPN Assignment
  • Defined Material
  • Pre-market/licensing summary
  • Special Access Summary
  • Special Access Info
  • Incident Summary

Drug/NPN Assignment

This section is used to capture information about drugs that are part of the device; this could include eluted drugs (e.g., paclitaxel eluting stents) as well as drugs applied with the device (disinfecting wipes).

Defined Material

Defined materials are biologically sourced; this section captures information about the source of biological components, including the species (e.g., bovine), tissue (e.g., ligament), and if it is a derivative (e.g., collagen), as well as the country from which it is sourced and can have multiple records for different time periods.

Pre-market/licensing summary

The pre-market and licensing summary details the licence history of a device as well as the history of applications that include the device.

Special Access Summary

The Special Access Summary lists the special access requests made for the device, along with the request date and action date, and whether the request was approved or not.

Special Access Info

The Special Access Info tab lists some characteristics about the indication of the device, future considerations, and the status (active or inactive). I also captures licence alternatives.

Incident Summary

This section summarizes the incidents recorded for the device; the word incident in this setting relates to anything that would be recorded in the incident section, which includes recalls, complaints, as well as mandatory medical device problem reports. On deployment of the medical device sections of the ArisG system on February 3, 2020, most of the incident data was migrated to this new system, leaving only the recall incidents to continue to be recorded. Due to a variety of challenges with the new system as well as the costs of licensing, the Regulatory Operations and Enforcement Branch (ROEB) is planning to migrate their records and work back to the MDS system sometime in 2022. This will result in a system in which the data for mandatory problems is entered and stored in a different system than voluntary reports, trade complaints, and recalls.

Company Section

The company section is used to maintain company records (and with the implementation of Vanessa's Law and mandatory reporting by hospitals, the list of hospital reporters) for multiple purposes - reporting of incidents, tracking of applications, and so on.

Like the device section, there is a set of tombstone information (drawn from the COMPANY table), as well as several sub-sections.

  • Contacts
  • History
  • Incident
  • Finance

Contacts

The Contacts tab of the MDS company section tracks the company contacts related to a company ID; these are drawn from the COMPANY_CONTACTS table, and include fields like Name, Title, Contact type, Phone number, Email address, and status (active or inactive).

History

The History tab of the MDS company section tracks the history of the name, address, and other fundamental/tombstone data about the company.

Incident

The Incident tab on the company section tracks the incidents related to the company; this counts the rows of the INCIDENT_COMPANY table that list the company in any role.

Finance

The Finance tab on the company section lists finance specific elements from the company table such as the bill to ID, tax numbers, and so on.

Meeting

Application

Special Access

- for maintaining information relevant to Special Access Program requests for medical devices

Correspondence

- for maintaining correspondence records

Quality System

Batch

- used to launch batch processes for administrative closure of incidents

Incident

- for tracking complaints, recalls, and reported medical device problems (Some of these were migrated to the Canada Vigilance ArisG system in February 2020)

Establishment

- for establishment information

Maintenance

Logout

- log out of the system

  1. citation needed