Robin, It is possible, but as far as I know, the most efficient way is to manipulate the data outside of Meditech and script it back in. If you have someone who understands how databases and joins work, this is possible if you have the FSV source file layouts.
I'm in the process of doing this very thing with the RXM drug dictionary. MediTech has been "working" on a service issue involving missing generic names for over a year now without progress, so I've given up on them. Their best response so far is for me to manually update all the drugs in the file (46,000+!) What I'm doing is joining the source FSV files in combination with Meditech downloads in Access. In the final step, a spreadsheet is generated which can be used to script the appropriate generics back into Meditech. We're a MicroMedex hospital so I can't comment on the process in FDB. I asked MicroMedex for a listing of the file layouts in their files. They were gracious enough to let me have them on the promise that I'd use the information only "inhouse". Several years ago, MediSpan provided the same information when we were one of their clients. I'll bet FDB can help you if you contact them. Alan Miller, RPh Patient Care Information Systems Catawba Valley Medical Center Hickory, NC 28602 >>> "Robin D. Cullen" <[EMAIL PROTECTED]> 11/27/2006 09:50 >>> Hi Everyone, As you may be aware, sites typically set the parameter "overwrite" in the FSV Parameters to "N" so as to prevent their FSV from overwriting all of their blood, sweat, & tears vis a vis the generic name dictionary. After all, it wasn't too long ago that the Drug ID field in the drug dictionary didn't exist. In place, they had to modify the generic name description in order to have labels, mars, reports etc. present drugs in the correct fashion(esp. premixes). Unfortunately, by setting the overwrite to "N" they prevented their FSV from updating their generic names. This meant that, for example, the drug Voriconazole, which was put on the market a few years ago, was inappropriately classed as 99:00 - Appendix because more than likely FDB simply hadn't updated their shipping files with the appropriate class of 08: 14.08 - Azoles. So, we find ourselves as many facilities do with generic names that are incorrectly classed with no hope of being updated by FDB. Does anyone know how one would go about scripting in a spreadsheet containing the generic name mnemonic and the proper class into the MT MAGIC PHA 5.53 sr 3 application? Is this even possible? Thank-you so much for any insight you may be able to provide! Robin. ====================================== All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l
