NDC Codes with Letters

[ericaVoss]

@Christian_Reich,

Whey do some of these NDC codes have letters in them?

SELECT *
FROM CONCEPT
WHERE CONCEPT_ID IN (
45230379,44974409,45845457,45013042,45008419,45093776,46350536,46350537,46357134,45166080,46337880,46362232,45834379,45110835,46342902,46339981,46350769,46351586,44889509,44889510,44889511,46356931,46344652,46359549,45161753,45337605,46346268,46344130
)

Examples:

531570122BA  NUTRICEL ADDITIVE SOLUTION - CP2D - cp2d/as-3 anticoagulant and additive system solution
00019N120  thallous chloride, Tl 201 1 mCi/mL INJECTION, SOLUTION [THALLOUS CHLORIDE Tl 201]
00019N180  gallium citrate ga-67 2 mCi/mL INJECTION, SOLUTION [GALLIUM CITRATE GA-67]

[Christian_Reich]

@ericaVoss:

Because they are not drugs. They are radiopharmaceuticals for imaging and products for processing blood bank products. So, they are not real NDC, but they will pop up in the data and hence we need to be able to handle them.