We had a discussion a about NDC codes a few weeks ago. A message from
Mark is included at the end of this message, that include the FDA
documentation describing use of *'s in NDC's
I am now faced with filing many drugs with * in the NDC, and the
Fileman input transform doesn't allow this. Here is the input
transform for field 31 (NDC) in file 50.
K:$L(X)>20!($L(X)<5)!'((X?4N1"-"4N1"-"2N)!(X?5N1"-"3N1"-"2N
)!(X?5N1"-"4N1"-"1N)!(X?5N1"-"4N1"-"2N)!(X?6N1"-"4N1"-"2N))
X
Heer is some examples of entries that will be rejected.
TMG FDA IMPORT COMPILED SEARCH MAY 28,2006 11:39 PAGE 5
TMG FDA
LISTING
ENTRY TRADENAME NDC
--------------------------------------------------------------------------------
18580 LYMPHAZURIN RADIOPAQUE INJECTI 010130-*250-21
18582 EPHEDRINE SULFATE INJECTION 010130-*875-01
18583 LEVOTHYROXINE SODIUM FOR INJEC 010130-*880-10
18592 SODIUM CHLORIDE INJECTION CONC 010130-*950-30
18595 PULMOLITE INJECTION 010130-0010-*1
18597 BICNU CARMUSTINE INJECTION 010130-0012-*1
18602 OSTEOLITE INJECTION 010130-0052-*1
18603 DTIC DOME INJECTION 010130-8151-*1
18636 CARBON DIOXIDE-OXYGEN MIXTURE 010167-0006-*1
18643 OXYGEN 010221-9900-*2
18644 CETACAINE AEROSOL SPRAY 010223-0201-*1
18645 CETACAINE LIQUID IMPROVED 010223-0202-*1
18646 CETACAINE OINTMENT 010223-0210-*1
18647 CETACAINE GEL 010223-0215-*1
18648 POTASSIUM CHLORIDE SOLUTION 010235-1001-*8
So my options are: rewrite the input transform, or bypass the input
transform, or somehow "FIX" these different NDC's to fit with VA's
format? I'm wondering if the *'s could just be removed, i.e.
010235-1001-*8 --> 010235-1001-8 or 010235-1001-08??
Any suggestions?
Thanks
Kevin
---------- Forwarded message ----------
From: Mark Amundson <[EMAIL PROTECTED]>
Date: Mar 15, 2006 11:33 PM
Subject: RE: [Hardhats-members] National Drug Codes (NDC) headaches.
Anyone have input?
To: hardhats-members@lists.sourceforge.net
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 package size. The first segment, the labeler code, is assigned by the
FDA. A labeler is any firm that manufactures (including repackers or
relabelers), or distributes (under its own name) the drug. The second
segment, the product code, identifies a specific strength, dosage form, and
formulation for a particular firm. The third segment, the package code,
identifies package sizes and types. Both the product and package codes are
assigned by the firm. The NDC will be in one of the following
configurations: 4-4-2, 5-3-2, or 5-4-1.
An asterisk may appear in either a product code or a package code. It
simply acts as a place holder and indicates the configuration of the NDC.
Since the NDC is limited to 10 digits, a firm with a 5 digit labeler code
must choose between a 3 digit product code and 2 digit package code, or a 4
digit product code and 1 digit package code.
Thus, you have either a 5-4-1 or a 5-3-2 configuration for the three
segments of the NDC. Because of a conflict with the HIPAA standard of an 11
digit NDC, many programs will pad the product code or package code segments
of the NDC with a leading zero instead of the asterisk.
Since a zero can be a valid digit in the NDC, this can lead to confusion
when trying to reconstitute the NDC back to its FDA standard. Example:
12345-0678-09 (11 digits) could be 12345-678-09 or 12345-678-90 depending on
the firm's configuration. By storing the segments as character data and
using the * as place holders we eliminate the confusion. In the example, FDA
stores the segments as 12345-*678-09 for a 5-3-2 configuration or
12345-0678-*9 for a 5-4-1 configuration.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin
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 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 without the hyphens ambiguous?
I think so, hence my confusion. Thus I don't think you could write an
output transform with 100% correctness.
But Ruben's input re 5-4-2 helps.
Kevin
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid7521&bid$8729&dat1642
_______________________________________________
Hardhats-members mailing list
Hardhats-members@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hardhats-members
