User Tools

Site Tools


Add Time Field to Occurrence and Exposure Tables

While v5 visit_occurrence table supports both date and time of event, other occurrence tables and exposure tables such as drug, condition, and procedure support only the date level. It is desirable to have the option to include specific time data for such occurrences.

We propose adding time field to the following tables

  • Condition_Occurrence
  • Procedure_Occurrence
  • Drug_exposure
  • Device_exposure
  • Death

This would support handling data from ICU, Emergency Department, infusions, post-procedure care, etc where multiple events occur on the same day and sequence matters. This granularity would also support the incorporation of data generated from tracking devices.

documentation/next_cdm/add_time.txt · Last modified: 2015/12/21 03:22 by jduke