Changes

MDS Database (view source)

Revision as of 17:22, 4 May 2022

1,219 bytes removed , 17:22, 4 May 2022

Line 34: Line 34:

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.

−

~~=== DEVICE ===~~

−

The device ID is the basic unit for a medical device, and is used to connect to other tables. Relating an application to devices, for example, makes use of the DEVICE_ID, and this is the table that defines characteristics that are 1-to-1 with the device in this sense. These include the trade name of the device, the risk class under the [https://laws-lois.justice.gc.ca/eng/regulations/sor-98-282/ Medical Devices Regulations], and terms used to group devices together (PNC, GMDN code, and usage code as examples).

−

~~==== DEVICE_AUDIT ====~~

−

The DEVICE_AUDIT table captures the history of changes made to device tables such as adding or removing companies, addition of new device identifiers, etc. As it is an audit table, it has many more rows than the base tables do, and is not efficient to use in most queries of the system.

−

~~==== 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 ====~~

== Establishments ==

Richard.mcateer

28

edits