Home Articles Downloads Forum Products Services Seminar Contact
Previous Thread
Next Thread
Print Thread
Rate Thread
Categories list
#72894 01/03/18 6:15 PM
Joined: Mar 2014
Posts: 6
Newbie
OP Offline
Newbie
Joined: Mar 2014
Posts: 6
Hi

I am trying to tidy up our categories list in our Medical equipment database as over the years it has grown rather massive.

Is there a nice list of categories that is relatively small that covers most medical devices that you can recommend?

Re: Categories list
SidneyAW #72895 01/03/18 7:17 PM
Joined: Feb 2004
Posts: 14,165
Likes: 13
Super Hero
Offline
Super Hero
Joined: Feb 2004
Posts: 14,165
Likes: 13

You need to give us a few more clues there, Andy. There can be as few or as many as you need, depending upon what you (and-or your database system) require.

For instance the GN7 document ("Guidance Note 7: Special Locations" published by the Institution of Engineering and Technology (IET)) that has been mentioned in other threads on here recently mentions only three:-

1) Life support

- infusion pumps, ventilators, anaesthetic equipment and monitors etc.

2) Diagnostic

- X-ray machines, CT scanners, magnetic resonance imagers, blood pressure monitors, ECG equipment etc.

3) Treatment

- electrosurgical units, defibrillators, haemodialysis units and radiotherapy equipment etc.


On the other hand, some approaches list hundreds of equipment types.

So, what database system are you using? What are its requirements and constraints (field lengths, and what have you)? Are you looking for generic equipment types, or manufacturer-model combinations?

How many "categories" do you have at the moment? Can you give us a few examples?

Are you thinking about a hierarchical structure, or just a simple linear approach?

Sometimes it's best to sit down with pencil and paper (plus a cup of tea, of course), and spend a bit of time planning what you want to achieve, before (and rather than simply) diving in.

In short - more information required! smile

This sort of thing has been discussed on here a fair amount over the years; for instance, take a look at this old thread.


If you don't inspect ... don't expect.
Re: Categories list
SidneyAW #72900 02/03/18 12:10 PM
Joined: Feb 2004
Posts: 14,165
Likes: 13
Super Hero
Offline
Super Hero
Joined: Feb 2004
Posts: 14,165
Likes: 13

Another way of simply categorising the equipment within your domain (and one that offers only three choices) is by *Risk:-

Low
Medium
High


* Perceived Risk to Patient if the equipment fails.


If you don't inspect ... don't expect.

Moderated by  DaveC in Oz, RoJo 

Link Copied to Clipboard
Who's Online Now
1 members (DaveC in Oz), 513 guests, and 32 robots.
Key: Admin, Global Mod, Mod
Newest Members
John75, HuyNguyen, Sahibnoor, Stuart Eccles, Garry1647
9722 Registered Users
Forum Statistics
Forums25
Topics10,616
Posts71,815
Members9,722
Most Online5,980
Jan 29th, 2020
Powered by UBB.threads™ PHP Forum Software 7.7.4