I'm working on a project to migrate a legacy healthcare system to FHIR, and I need help mapping the current SQL-based fields to the appropriate FHIR resources.
The goal is to enable API integrations that can directly read from and write to the correct FHIR fields after the migration.
One of the fields we currently use is the minimum and maximum time to effect of a medication — which represents the estimated time (in minutes) it takes for the medication to start working after administration.
For example, in the case of Naramig (naratriptan), this time is typically between 60 and 120 minutes.
I am currently using the following FHIR resources for mapping:
- MedicinalProductDefinition
- MedicationKnowledge
- Evidence
- ClinicalUseDefinition
However, I'm having trouble finding a field in any of these resources that directly represents this "time to onset of effect." I've reviewed dosage, administration guidelines, pharmacokinetics, and effectiveness sections, but none seem to capture this specific clinical data in a structured way.
My question is: Is there any field in these resources — or perhaps in another FHIR resource — that can be used (or appropriately extended) to represent this minimum and maximum time until the medication takes effect?
I'd really appreciate any guidance on the best way to represent this data in a FHIR-compliant and interoperable manner. Thanks in advance! Image exemple in a Portuguese System