This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
documentation:next_cdm:add_time [2015/12/21 03:21] jduke created |
documentation:next_cdm:add_time [2015/12/21 03:22] jduke |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== Add Time Field to Occurrence and Exposure Tables ===== | ===== Add Time Field to Occurrence and Exposure Tables ===== | ||
- | While Visit_Occurrence supports both date and time of event, other occurrence 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. |