Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

NDC code version for MIMIC 3? #132

Open
yoon100 opened this Issue Sep 24, 2016 · 1 comment

Comments

Projects
None yet
1 participant

yoon100 commented Sep 24, 2016

Just wondering what version of NDC code that MIMIC 3 has used.
For example, NDC code thus far has three versions:
4-4-2, 5-3-2, or 5-4-1. (https://en.wikipedia.org/wiki/National_Drug_Code)
While I am searching the PRESCRIPTIONS table, however, I was not able to find the code version.

Thank you in advance!
Joo

yoon100 commented Sep 26, 2016

I think I got the answer.
After downloading and reviewing the NDC files all.. I found:
4-4-2 only applies to NDC code starts from 0 (i.e. 0001-1234 to 0999-1234).
5-3-2 applies to NDC codes starts from 1 (i.e. 1000-1234 to 9999-1234).
5-4-1 just randomly shows up, often overlaps with other existing meds (in which case I think meds were already in market, and came up with different mode of delivery etc)
So I guess we can match NDC with med names from MIMIC without knowing which version they belong to.

Please add if any other thoughts / comments on my answer.
Thanks.
Joo

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment