28
edits
Changes
→Devices
This will be a page about the database side of the MDS system - about documenting the fields, decodes, and how the system is used
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 ==
[[File:Device tables relationship.png|thumb|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.
* [[MDS DEVICE table|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