Home | Articles | Products | Services | Jobs | Forum | Downloads | Press | Contact Us

Page 1 of 3 1 2 3 >
Topic Options
Rate This Topic
#56663 - 06/06/11 10:31 AM Medical Device Type Spreadsheet
Sean Fearon Offline
Mentor

Registered: 10/02/03
Posts: 176
Loc: CMFT Manchester
Hello All

Has anyone a list of standardised medical device types in excel format that they are willing to share with me? Ideally, along recognised international lines.
It's the old problem of free form fields. Every Biomed can describe the same device differently! (Going through an exercise with a Community inventory, and it would be nice to impose some order).
Probably about 900 or so, generic device types?
I am sure there must be something similar to the ECRI format freely available in the public domain.

Regards
Sean

Top
#56664 - 06/06/11 11:21 AM Re: Medical Device Type Spreadsheet [Re: Sean Fearon]
Geoff Hannis Online   content
Super Hero

Registered: 12/02/04
Posts: 10300
Loc: the path less trodden

All I have (and all I have ever needed myself) is what we might call the "TaskMaster format" ... which is freely downloadable from this website. For example:-

Code:
BOU-   Boiling-Out Unit
BPM-   Blood Pressure Monitor
BPP-   BiPAP Unit
BPU-   Battery Pack Unit
BPW-   Bedpan Washer
BRF-   Blood Refrigerator
BRM-   Bilirubinometer

It also includes typical Risk Levels, suggested PM intervals (which all ties in to various PM regimes), and electrical safety class ... etc.

I can export to .xls if you want, but why not take a look at TM first and see if it's what you're after. Following a successful download, call the appropriate browser with keys Alt+W E C (that is, Browses -> Equipment -> Classes). Issue Ctrl+N to add your own codes.

Once you have set the Export Format to "XLS" you can export directly from the browser using (for example) Ctrl+X if you wish. smile

Top
#56665 - 06/06/11 11:41 AM Re: Medical Device Type Spreadsheet [Re: Sean Fearon]
DaveC in Oz Online   crying
Philosopher

Registered: 26/06/09
Posts: 595
Loc: Brisbane, Australia
Sean, PM me your work email, I may be able to assist.

Top
#56666 - 06/06/11 11:41 AM Re: Medical Device Type Spreadsheet [Re: Sean Fearon]
Neil Porter Offline
Hero

Registered: 23/02/09
Posts: 1499
Loc: Jeddah, Saudi Arabia
Sean check your email
_________________________
Stress is for other people

Top
#56669 - 06/06/11 12:12 PM Re: Medical Device Type Spreadsheet [Re: Sean Fearon]
biomedbill Offline
Sage

Registered: 22/07/05
Posts: 469
Loc: south yorkshire
Good luck with that. I was tasked with rationalising the equipment types on our database. After many weeks I managed to reduce the number of different types from over 3000 to approx 1200. Unfortunately I can't produce a list from our system. One of my colleagues is still working on sorting out the models, a nightmare-ish task. Deciding if a 8V13000 is the same as a BVI3000 crazy

Top
#56670 - 06/06/11 12:15 PM Re: Medical Device Type Spreadsheet [Re: biomedbill]
DaveC in Oz Online   crying
Philosopher

Registered: 26/06/09
Posts: 595
Loc: Brisbane, Australia
Which is exactly why you need to have a standardised naming system (drives me BLOODY NUTS mad )

Top
#56672 - 06/06/11 12:20 PM Re: Medical Device Type Spreadsheet [Re: DaveC in Oz]
Geoff Hannis Online   content
Super Hero

Registered: 12/02/04
Posts: 10300
Loc: the path less trodden

No need to go nuts ... twenty years ago (whilst working with techs for whom English wasn't their first language - if you see what I'm saying) I decided that sensible codes are the only answer.

As long as the correct code is allocated (and can be changed later if found to be wrong), then the other fields can be in Arabic (or, if you prefer, Swahili) and it shouldn't make a whole lot of difference!

Needless to say, it's a similar story with the naming of parts, maintenance tasks, and all the rest.

Been there, done that. smile

Those were smaller hospitals than Bill's, no doubt. But I used to visit the sites, crank up the database, and wade through the mess until I was rewarded with something I just love:- a clean set of data. Sometimes I had to get off my butt and actually visit the kit, just to be sure, but it usually took me a matter of hours (or at worst, days). But weeks? What's the matter with you guys?

Top
#56673 - 06/06/11 12:27 PM Re: Medical Device Type Spreadsheet [Re: Sean Fearon]
Sean Fearon Offline
Mentor

Registered: 10/02/03
Posts: 176
Loc: CMFT Manchester
Thanks Guys
Some Good stuff so far! When we can populate the device types meaningfully, the next stage will be models and manufacturer data. Whoa! Maybe risk scores / factors?

But, I intend not to jump the gun (too soon), Keep it coming

By the way, Geoff that’s a good system there mate!

Regards
Sean

Top
#56674 - 06/06/11 12:29 PM Re: Medical Device Type Spreadsheet [Re: Sean Fearon]
Geoff Hannis Online   content
Super Hero

Registered: 12/02/04
Posts: 10300
Loc: the path less trodden

Did you spot the bug (corrected now, of course)?

Once again, for the life of me, I can't see why the National Health Service doesn't have its own standard nomenclature! think

Top
#56675 - 06/06/11 12:34 PM Re: Medical Device Type Spreadsheet [Re: Sean Fearon]
Neil Porter Offline
Hero

Registered: 23/02/09
Posts: 1499
Loc: Jeddah, Saudi Arabia
The only problem with having a standardized list is the end-user.
Radiographic/Fluoroscopic Systems, General-Purpose, Remote-Controlled, ECRI name; x-ray machine, end-user name. Ultrasound machines will never be called Scanning Systems, Ultrasonic, General-Purpose; Having a standard list is fine for the inventory, but for everyday use, I don't think so.

_________________________
Stress is for other people

Top
Page 1 of 3 1 2 3 >



Moderator:  DaveC in Oz, KM, RoJo 
Sponsors
Press Releases
Who's Online
15 registered (Huw, Paul Owens, Lee S, Paul Robbins, Gordovan, DinhVu, Geoff Hannis, RoJo, KM, hieu, Laiq, lm1253, Jameson, DaveC in Oz, GeorgeK), 332 Guests and 8 Spiders online.
Key: Admin, Global Mod, Mod
May
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31
Events