Re: [Gnumed-devel] Vaccine routes: values in clin.vacc_route

[Jim Busser]

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