Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-17 Thread Kevin Toppenberg
On 3/15/06, Ruben Safir [EMAIL PROTECTED] wrote: They sometimes change the drug and keep the drug code. I think they did that with Tricor if I recall. Ruben So when looking for matches between FDA data and VistA data, a matching NDC is NOT sufficient to say that the drugs are the same

RE: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-16 Thread Ruben Safir
On Wed, 2006-03-15 at 23:32 -0600, Mark Amundson wrote: The paragraphs are pulled directly from the FDA site and they are consistent to what I understand NDC's to be and how I have used them. I understand this but despite this, nobody implements it this way and nobody should. When ever it

RE: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-16 Thread Ruben Safir
On Wed, 2006-03-15 at 23:32 -0600, Mark Amundson wrote: As far as the 12 digit field in VistA for the NDC number it is because the National Drug file stores both NDC's and UPC's in the same field for a product, the UPC used is a 12 digit code. So what they do in the NDF with NDC's is put one

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-16 Thread Steven McPhelan
The resue of standard codes is not unique to pharmacy NDC codes.

RE: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-16 Thread Holloway, Thomas (EDS)
With regard to the following thread: Kevin wrote: I agree that 5+4+2=11, but in the VA database, they seem to be storing 12 digits, with a leading 0. Ruben wrote: I could be wrong but I believe that the programmers added a digit on accident. Mark Amundson wrote: As far

[Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Kevin Toppenberg
I am working to integrate, automatically, the database of ALL drugs as published on the FDA website. They publish about 7 files that are interlinked, holding the data. I have created custom files to hold the data in each of these files. I then automatically load the FDA data into each of the

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Ruben Safir
Because the names often differ in minor ways, I can't just do a name search, instead I have to look at the INGREDIENTS of each entry, and its dosage and form (tab, liquid etc), and units. That won't even help with a drug like Diltiazem. Your going to really need to work with NDC's. The

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Gregory Woodhouse
On Mar 15, 2006, at 3:43 PM, Ruben Safir wrote: The size of the separate fields have changed over the years and different drugs are labeled differently. the largest an NDC can be is 5-4-2 (11 digits). But it can and does vary from 4-4-2 and 2-3-2 and even 5-3-2 So, are the NDC codes

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Gregory Woodhouse
On Mar 15, 2006, at 3:43 PM, Ruben Safir wrote: That won't even help with a drug like Diltiazem. Your going to really need to work with NDC's. The hyphens are a result of the combination of 3 separate numbers being combined into a single number. The first part is a the Manufacture, the

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Ruben Safir
On Wed, 2006-03-15 at 18:25, Gregory Woodhouse wrote: On Mar 15, 2006, at 3:43 PM, Ruben Safir wrote: The size of the separate fields have changed over the years and different drugs are labeled differently. the largest an NDC can be is 5-4-2 (11 digits). But it can and does vary from

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Kevin Toppenberg
Thanks Ruben (and Gregory) for the replies. I agree that 5+4+2=11, but in the VA database, they seem to be storing 12 digits, with a leading 0. E.g: NUMBER: 385 000832027601 QUINIDINE SULFATE QUINIDINE SO4 200MG TAB NUMBER: 386 000364022990 QUINIDINE SULFATE QUINIDINE

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Kevin Toppenberg
On 3/15/06, Gregory Woodhouse [EMAIL PROTECTED] wrote: On Mar 15, 2006, at 3:43 PM, Ruben Safir wrote: The size of the separate fields have changed over the years and different drugs are labeled differently. the largest an NDC can be is 5-4-2 (11 digits). But it can and does vary from

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Ruben Safir
What is the NDC numbers for Singular 10mg Ruben On Wed, 2006-03-15 at 21:47, Kevin Toppenberg wrote: Thanks Ruben (and Gregory) for the replies. I agree that 5+4+2=11, but in the VA database, they seem to be storing 12 digits, with a leading 0. E.g: NUMBER: 385 000832027601

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Kevin Toppenberg
Below are the results for this drug from two places where it is stored. On 3/15/06, Ruben Safir [EMAIL PROTECTED] wrote: What is the NDC numbers for Singular 10mg Ruben In file NDC/UPC: NUMBER: 89055 06011731 -12 digits SINGULAIR 10MG TAB MONTELUKAST NA 10MG

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Kevin Toppenberg
On 3/15/06, Kevin Toppenberg [EMAIL PROTECTED] wrote: Thanks Ruben (and Gregory) for the replies. I agree that 5+4+2=11, but in the VA database, they seem to be storing 12 digits, with a leading 0. E.g: Here is the description for field NDC in file NDC/UPC: FIELD NAME: NDC FLD

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Ruben Safir
I'll look these up when I get the the Pharmacy and give you the exact breakdown. But it does seem that your correct and they added another zero on the front (room to grow) since Merck is Manufacturer 0006 (now most often 6) Ruben On Wed, 2006-03-15 at 22:12, Kevin Toppenberg wrote: Below

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Ruben Safir
And why am I an unemployed Programmer with a Pharmacy degree? I could be wrong but I believe that the programmers added a digit on accident. Ruben On Wed, 2006-03-15 at 22:15, Kevin Toppenberg wrote: On 3/15/06, Kevin Toppenberg [EMAIL PROTECTED] wrote: Thanks Ruben (and Gregory) for the

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Kevin Toppenberg
On 3/15/06, Ruben Safir [EMAIL PROTECTED] wrote: And why am I an unemployed Programmer with a Pharmacy degree? I could be wrong but I believe that the programmers added a digit on accident. Ruben That explaination would make the most sense to me. Because who knows which of three subfields

RE: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Mark Amundson
Codes (NDC) headaches. Anyone have input? On 3/15/06, Gregory Woodhouse [EMAIL PROTECTED] wrote: On Mar 15, 2006, at 3:43 PM, Ruben Safir wrote: The size of the separate fields have changed over the years and different drugs are labeled differently. the largest an NDC can be is 5-4-2 (11

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Nancy Anthracite
Toppenberg Sent: Wednesday, March 15, 2006 8:50 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input? On 3/15/06, Gregory Woodhouse [EMAIL PROTECTED] wrote: On Mar 15, 2006, at 3:43 PM, Ruben Safir wrote: The size

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Ruben Safir
On Wed, 2006-03-15 at 23:23, Nancy Anthracite wrote: Will the same labeler always use the same pattern of product code and package code? No - there is no such restriction but the middle number usually remains constant. They sometimes change the drug and keep the drug code. I think they did

Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Ruben Safir
On Wed, Mar 15, 2006 at 09:33:29PM -0600, Mark Amundson wrote: Here is the official info from fda.gov on NDC codes: NDC Number Each listed drug product listed is assigned a unique 10-digit, 3-segment number. This number, known as the NDC, identifies the labeler, product, and trade

RE: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input?

2006-03-15 Thread Mark Amundson
Safir Sent: Wednesday, March 15, 2006 10:31 PM To: hardhats-members@lists.sourceforge.net Subject: Re: [Hardhats-members] National Drug Codes (NDC) headaches. Anyone have input? On Wed, Mar 15, 2006 at 09:33:29PM -0600, Mark Amundson wrote: Here is the official info from fda.gov on NDC codes: NDC