Hi, I’m currently working on using the PFT (Pulmonary function test) data of our medical center. but I have a problem storing it to CDM v5. we just stored FEV(%) and FVC/FEV(%) data only in the measurement table regardless of the type of detailed test before. however, I think it is needed to store whole PFT data.
PFT data consists of various measurements related to lung status and function. For example, there are FEV1 (Forced Expiratory Volume in 1 second), FVC (forced vital capacity) which measured when pre- and post-bronchodilator applied. here is an example result.
Also to diagnose asthmatics in more detail, there are bronchial provocation tests like oral provocation test, methacholine challenge test, lys-asp broncho-provocation test, and so on. especially these data recorded the pulmonary functions by the concentration of a substance or by the time from when applied the substance to 3 min, 5 min, 10min, 20 min, and 1 hour. also I attached one example.
how can we store this PFT data with detailed information in CDM 5.3.1? it seemed that it could be stored in the measurement table, but I realized that detailed information would be lost. Should we store this in the observation table? Or should we use the fact_relationship table like bacterial culture and antibiotics susceptibility data?
Is there any prior discussion or anyone who has experience related to storing the PFT data to CDM? If you can share your experiences, that would be wonderful.