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?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members