Storing time of administering medication

[Vimala_Jacob]

Hello,

I have a request to store the time of administering medication to a patient. However DRUG_EXPOSURE does not have any time columns.

So should I change the datatype for the DRUG_EXPOSURE_START_DATE from date to date with timestamp

OR

Use the OBSERVATION table to store this specific piece of information ?

Regards,
Vimala

[rtmill (Robert Miller)]

The latest version of the DRUG_EXPOSURE table includes drug_exposure_start_datetime.

Details are found here: https://github.com/OHDSI/CommonDataModel/wiki/DRUG_EXPOSURE

You can specify drug exposures as administered by physician using the drug_type_concept_id. Some options: