SELECT *
FROM cdm.concept
WHERE CONCEPT_ID = 44361362
ALKA-SELTZER PLUS COLD AND COUGH COOL MENTHOL - dextromethorphan hydrobromide, chlorpheniramine maleate, acetaminophen, phenylephrine hydrochloride capsule, liquid filled
This is listed as a CONCEPT_CLASS_ID = ingredient. I know the STANDARD_CONCEPT = 'C' but the DRUG_ERA logic doesn't filter by 'C' and this drug gets pulled in as an ingredient. Is CONCEPT_CLASS_ID = ingredient correct?
ALKA-SELTZER PLUS COLD AND COUGH COOL MENTHOL - dextromethorphan hydrobromide, chlorpheniramine maleate, acetaminophen, phenylephrine hydrochloride capsule, liquid filled
This is listed as a CONCEPT_CLASS_ID = ingredient. I know the STANDARD_CONCEPT = 'C' but the DRUG_ERA logic doesn't filter by 'C' and this drug gets pulled in as an ingredient. Is CONCEPT_CLASS_ID = ingredient correct?