MDS Database

This will be a page about the database side of the MDS system - about documenting the fields, decodes, and how the system is used. For information about the user interface and the history of the system, see Medical Device System.

The whole of the MDS system is vast and complex, and covers multiple areas from the applications for device licences, the tracking of establishments, companies and contact lists, finance, lists of physicians for Special Access Program, Incidents, and so on. It would be inefficient to try to cover all these various uses in a single go, so instead these will be broken out by the overall sections of the database.

Applications

Describe Applications here

Certificates

Describe certificates here

Companies

Describe Company table relationships here

Devices

The tables relating specifically to devices

The “Device” tables consist mostly of those tables starting with the term “DEVICE” as well as a few tables that are used to decode these; a few “Dev” tables are actually paired instead with the APPLICATION tables. There will be some overlap as a decode table may be used by more than one set of tables. The following are the tables that are described in this section.

• DEVICE
  • DEVICE_AUDIT
  • DEVICE_IDENTIFIER
  • DEVICE_SUPERSEDE
  • DEVICE_RELATION
  • DEVICE_MATERIALS
    • DEVICE_SPECIES
    • DEVICE_TISSUES
    • DEVICE_DERIVATIVES
  • DEVICE_SAP
  • DEVICE_DRUGS
    • DRUG_TAB
  • USAGE_CODE_TAB
  • PREF_NAME_MAST
    • PREF_NAME_AUDIT
  • PREF_DESC_DTL

Device tables are those for which the DEVICE_ID is the basis for lookup, and that describe the characteristic of devices. Information related to the licence is not directly related to the device, and is captured elsewhere.

Establishments

Establishments go here

Incidents

Incidents go here