Open skeating opened 5 months ago
for the same set of mrn and a set of devices we want to produce a table with the following columns: | Name | Datatype | Explanation |
---|---|---|---|
device_exposure_id | bigint | the number that refers to this use of the device | |
person_id | mrn | the unique identifier for the person | |
visit | big int | the foreign key that links the visit to the person | |
oxygen_delivery_device | text | the name of the oxygen delivery device | |
device_exposure_start_datetime | datetime | the time the device was connected | |
device_exposure_end_datetime | datetime | the time the device was removed |
Values for oxygen_delivery_device: Capno mask CPAP/Bi-PAP mask Endotracheal tube High-flow nasal cannula (HFNC) Nasal cannula None Non-rebreather mask Oral pharyngeal airway (Guedel) Servo-u Simple mask