[Gnumed-devel] Re: Future plan for FreeDiams 0.4.0

[Jim Busser]

On 2010-02-22, at 3:28 AM, Eric MAEKER wrote:

> 'Form' should be :
> - Tablet
> - Scored tablet
> - Pills
> - Liquid
> - ...
> 
> So Canadian :
> - DRUGS_UID;FORM ?

The set of 90 Canadian forms are as follows. They would form a  natural key 
that would be reproducible even when the FreeDIams "Canadian" database would be 
purged and reloaded. I was assuming that FreeDiams (for the purpose of 
repeating a prescription, using a saved prescription file) would prefer to 
maintain such a reusable drug key across versions.

It is on account of their length (see list below) that I wondered whether a 
script that would "distill" them down to expressions like

        TABLET.CR
        TABLET-CR
        TABLET_CR

(is there any preferred convention) would be helpful... I should be able to 
generate such a "form_abbrev" and populate it as part of an imported Canadian 
drug "forms" table.

AEROSOL
AEROSOL, METERED
BAR (CHEWABLE)
BOLUS
CAPSULE
CAPSULE (CONTROLLED-DELIVERY)
CAPSULE, DELAYED RELEASE
CAPSULE (ENTERIC-COATED)
CAPSULE, EXTENDED RELEASE
CAPSULE, IMMEDIATE RELEASE
CAPSULE (SUSTAINED-RELEASE)
CREAM
DISC (EXTENDED-RELEASE)
DRESSING
DROPS
DRUG PREMIX
ELIXIR
EMULSION
ENEMA
GAS
GEL
GEL (CONTROLLED-RELEASE)
GLOBULES
GRANULE
GRANULE FOR SUSPENSION
GRANULE FOR SUSPENSION, DELAYED RELEASE
GUM
IMPLANT
INSERT
INSERT (EXTENDED-RELEASE)
JELLY
KIT
LIPOSOMAL
LIQUID
LOTION
LOZENGE
METERED-DOSE (AEROSOL)
METERED-DOSE (PUMP)
MOUTHWASH
OINTMENT
OVULES
PACKAGE
PAD
PASTE
PATCH
PATCH, EXTENDED RELEASE
PELLET
PIECE, CHEWABLE
PLASTER
POWDER
POWDER (EFFERVESCENT)
POWDER, EXTENDED RELEASE
POWDER FOR SOLUTION
POWDER FOR SUSPENSION
POWDER FOR SUSPENSION SUSTAINED-RELEASE
RING (SLOW-RELEASE)
SHAMPOO
SOAP BAR
SOLUTION
SOLUTION (EXTENDED RELEASE)
SOLUTION (LONG-ACTING)
SPONGE
SPRAY
SPRAY, METERED DOSE
STICK
STRIP
SUPPOSITORY
SUSPENSION
SWAB
SYRUP
SYRUP (SUSTAINED-RELEASE)
TABLET
TABLET (CHEWABLE)
TABLET (COMBINED RELEASE)
TABLET (DELAYED AND EXTENDED RELEASE)
TABLET (DELAYED-RELEASE)
TABLET (EFFERVESCENT)
TABLET (ENTERIC-COATED)
TABLET (EXTENDED-RELEASE)
TABLET FOR SUSPENSION
TABLET (IMMEDIATE RELEASE)
TABLET (ORALLY DISINTEGRATING)
TABLET (SLOW-RELEASE)
TEA (HERBAL)
TINCTURE
TOOTHPASTE
VAGINAL TABLET
VAGINAL TABLET, EFFERVESCENT
WAFER
WIPE