Hello everyone!
I have a different question in the topic, about conventions on storing ventilation data. In our HIS the ventilation data for more days is stored as a quantity for a ventilation procedure, without exact dates.
For example:
Intermittent positive pressure mechanical ventilation with endotracheal intubation (days of care), quantity: 15
It means the patient was at the hospital and was intubated and mehcanically ventilated for 15 days, but if the patient stayed in the hospital for more than 15 days (it is usually the case), the exact date of the ventilation is unknown.
We have two ideas about mapping this:
Prodecure occurence table:
procedure_concept_id = 44790095 Invasive ventilation
quantity = 15
Observation table:
observation_concept_id = 4163858 Ventilation
value_as_number = 15
unit_concept_id = 8512 day
The problem with the first one, that no one will know, that the quantity represents the days. The problem with the second one, that there is no standard concept in the observation domain, which represents the invasive ventillation, and also there is no unit_source_value in our system.
Do you have any ideas or other solutions?
The use case is, that maybe someone would want to do a research about lenght of ventillation among COVID patients.
Thank you in advance! 