[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Vaccine routes: values in clin.vacc_route
From: |
Jim Busser |
Subject: |
Re: [Gnumed-devel] Vaccine routes: values in clin.vacc_route |
Date: |
Thu, 15 Sep 2011 07:48:28 -0700 |
On 2011-09-15, at 4:18 AM, Karsten Hilbert wrote:
> On Tue, Sep 13, 2011 at 05:05:34PM -0700, Jim Busser wrote:
>
>> INSERT INTO clin.vacc_route (
>> abbreviation,
>> description
>> ) VALUES (
>> 'nasal',
>> 'nasal'
>> );
>
> I wonder which vaccine(s) are available for nasal
> application ?
drug_code | external_code | description | atc_code | route |
description
-----------+---------------+-------------+----------+-------+-------------------------------
83789 | 02352621 | Flumist | J07BB03 | NASAL | Influenza Virus
Type B
83789 | 02352621 | Flumist | J07BB03 | NASAL | Influenza Virus
Type A (H1N1)
83789 | 02352621 | Flumist | J07BB03 | NASAL | Influenza Virus
Type A (H3N2)
(3 rows)
-- Jim
[Gnumed-devel] Vaccine indications: values in clin.vacc_indication, Jim Busser, 2011/09/13