[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDi
From: |
Jim Busser |
Subject: |
Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams |
Date: |
Tue, 04 Jan 2011 11:37:05 -0800 |
On 2011-01-04, at 12:04 AM, Karsten Hilbert wrote:
>> --> then create links between
>>
>> branded-drug
>> consumable.substances
>>
>> where branded-drug keyed to source table links to
>> consumable.substances keyed to source table
>
> Sounds about right.
I am hoping:
1) that I can cleanly populate ref.branded-drug from my FreeDiams hybrid output
table
2) that substances prescribed in GNUmed can keep a linkage (even if indirect) to
ref.branded-drug.pk
**********
re #1
Canadian brand names are sometimes (but not always) specific to their drug
strengths, for example the second manufacturer names all strengths ""ZYPREXA
ZYDIS"
"02229250"|"ZYPREXA -2.5MG"|"N05AH03"|"2.5"|"MG"
"02229269"|"ZYPREXA - 5MG"|"N05AH03"|"5"|"MG"
"02229277"|"ZYPREXA -7.5MG"|"N05AH03"|"7.5"|"MG"
"02243086"|"ZYPREXA ZYDIS"|"N05AH03"|"5"|"MG"
"02243087"|"ZYPREXA ZYDIS"|"N05AH03"|"10"|"MG"
"02243088"|"ZYPREXA ZYDIS"|"N05AH03"|"15"|"MG"
conflicts with
> From: Karsten Hilbert <address@hidden>
> Date: January 2, 2011 6:15:10 AM PST
> To: address@hidden
> Subject: Re: [Gnumed-devel] Re: GNUmed and FreeDiams
> ...
> Brands across different strengths must have (ever so
> slightly) differing names, say
> "MetoPharm comp 100/12.5"
> "MetoPharm comp 100/25"
why, in branded-drugs, do we need UNIQUE (description, preparation) meaning
UNIQUE (brand_name, form) ?
**********
re #2
> From: Karsten Hilbert <address@hidden>
> Date: January 2, 2011 6:15:10 AM PST
> To: address@hidden
> Subject: Re: [Gnumed-devel] Re: GNUmed and FreeDiams
> ...
> ... is there some way that the addition of a
> substance to a patient drug list would keep resolvable the
> [specific-to-strength] external_code?
>
> I am not sure I follow this question.
My question "is there some way" is maybe better understood by ignoring
[specific-to-strength] … In table clin.substance_intake, there is a warning on
column
fk_substance (FKEY ref.consumable_substance.pk)
which warns
DO NOT TRY TO USE THIS TO FIND OUT THE BRAND. IT WILL BE WRONG.
is it wrong because the reference substance may have been linked-to multiple
brands, and therefore is unable to completely resolve which one?
*But* the column ref.lnk_substance2brand.pk *will* resolve it --- provided the
user *bothered* to specify/distinguish the Brand, right?
-- Jim
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, (continued)
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Jim Busser, 2011/01/01
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/02
- Re: [Gnumed-devel] Re: GNUmed and FreeDiams, Jim Busser, 2011/01/02
- [Gnumed-devel] GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/03
- [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/03
- [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/03
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Eric Maeker, 2011/01/03
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams,
Jim Busser <=
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/04
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/05
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Jim Busser, 2011/01/05
- Re: [Gnumed-devel] Re: GNUmed substance schema was Re: GNUmed and FreeDiams, Karsten Hilbert, 2011/01/05
- Message not available
- [Gnumed-devel] Re: TODO 0.9: component/substance PRW, Karsten Hilbert, 2011/01/14