Continuing on this thread here:
Currently, in the PIH EMR, we have a drug list, but do not utilize the drug ingredient table nor the dosage form and dosage strength fields on drug. For instacce, we have the following four drug formlaries in our drug table for different types of “Aciclovir”:
mysql> mysql> select uuid, name, concept_id, strength,dosage_form from drug where name like 'Aciclovir%';
+--------------------------------------+---------------------------------------------------------+------------+----------+-------------+
| uuid | name | concept_id | strength | dosage_form |
+--------------------------------------+---------------------------------------------------------+------------+----------+-------------+
| 0962492b-295e-4f61-8d7b-717a61f43997 | Aciclovir, 200mg tablet | 3678 | NULL | NULL |
| f1403640-6911-4758-bbdb-183329c65708 | Aciclovir, Eye ointment, 3%, 4.5 gram tube | 3678 | NULL | NULL |
| 78fb8eaa-dfbe-11e9-8a34-2a2ae2dbcce4 | Aciclovir, Powder for solution for infusion, 500mg vial | 3678 | NULL | NULL |
| af8c4162-dfbe-11e9-8a34-2a2ae2dbcce4 | Aciclovir, Powder for solution for infusion, 250mg vial | 3678 | NULL | NULL |
+--------------------------------------+---------------------------------------------------------+------------+----------+-------------+
4 rows in set (0.00 sec)
The only thing that distinguishes them is “name”… note that dosage_form and strength are empty, and we don’t use drug_ingredients. Then accessing these drugs via FHIR they all basically return identical information, for example:
{
"resourceType": "Medication",
"id": "0962492b-295e-4f61-8d7b-717a61f43997",
"meta": {
"lastUpdated": "2021-05-24T09:51:20.000-04:00"
},
"text": {
"status": "generated",
"div": "<div xmlns=\"http://www.w3.org/1999/xhtml\"><table class=\"hapiPropertyTable\"><tbody><tr><td>Id:</td><td>0962492b-295e-4f61-8d7b-717a61f43997</td></tr><tr><td>Code:</td><td> Acyclovir </td></tr><tr><td>Status:</td><td>ACTIVE</td></tr></tbody></table></div>"
},
"code": {
"coding": [
"code": "3cd3d4de-26fe-102b-80cb-0017a47871b2",
"display": "Acyclovir"
}
]
},
"status": "active"
}
and
{
"resourceType": "Medication",
"id": "f1403640-6911-4758-bbdb-183329c65708",
"meta": {
"lastUpdated": "2021-05-24T09:51:20.000-04:00"
},
"text": {
"status": "generated",
"div": "<div xmlns=\"http://www.w3.org/1999/xhtml\"><table class=\"hapiPropertyTable\"><tbody><tr><td>Id:</td><td>f1403640-6911-4758-bbdb-183329c65708</td></tr><tr><td>Code:</td><td> Acyclovir </td></tr><tr><td>Status:</td><td>ACTIVE</td></tr></tbody></table></div>"
},
"code": {
"coding": [
{
"code": "3cd3d4de-26fe-102b-80cb-0017a47871b2",
"display": "Acyclovir"
}
]
},
"status": "active"
}
Ideally, we’d like to get to a point where we populate all these fields, but, in the meanwhile, while we work toward that, is there a proper place to but the full drug display name in the FHIR resource? We were thinking of the “text” field, but it looks like it has a specific use case. There doesn’t seem to be any “display” field on Medication.
Thoughts on pursuing @ibacher 's suggest from the other thread:
Thoughts @ibacher @mksd @mksrom @burke ?
fyi @mseaton
Take care, Mark