documentation:next_cdm:add_time
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious 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. | 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. | ||
| + | |||
| + | 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 would support handling data from ICU, Emergency Department, infusions, post-procedure care, etc where multiple events occur on the same day and sequence matters. | ||
documentation/next_cdm/add_time.1450668133.txt.gz · Last modified: by jduke