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 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 more leading zero one the 11 digit code to make it a 12 digit. I worked on this issue in VistA several years ago. Several VA sites were requesting that the 11 digit NDC fields in VistA be lengthened to 12 with a leading zero because one or more insurance companies were requiring it to be 12 digits on claims forms or electronic billing records, I forget which. So Mark may be right about the UPC code but at least part of the motivation came from insurance companies. Over the years, I have written code to do the "wrong" thing simply because insurance companies misinterpreted UB and HIPAA standards or were unable to implement them (due to poor choice of database or programming language) and I had to make my system talk to theirs in order to collect payment. Thom H. ------------------------------------------------------- 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