[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams

From: Jim Busser
Subject: Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams
Date: Sat, 20 Feb 2010 23:23:34 -0800

On 2010-02-20, at 10:58 PM, Eric MAEKER wrote:

> You can avoid my bug by adding to each CIS.CIS +10000000

In Canada, the same drug code may be used for a drug / dosage that can be 
administered by 2 routes. This is mostly encountered with liquids that can be 
injected multiple ways, maybe occasionally for something that can be taken 

In Canada, this is addressed by normalizing "Routes" into a separate table.

The CIS.CIP workaround sounds like it will work in the old FD schema.

What about the new schema? Can ROUTE be normalized and offered as a 
concatenation of values within something like a GROUP BY?

-- Jim

reply via email to

[Prev in Thread] Current Thread [Next in Thread]