User Tools

Site Tools


documentation:next_cdm:add_time

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
documentation:next_cdm:add_time [2015/12/21 03:22]
jduke
documentation:next_cdm:add_time [2015/12/21 03:22] (current)
jduke
Line 2: Line 2:
  
 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. 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. 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