search

ohdsi-korea / ThemisKorea

한국 THEMIS 워킹 그룹 github입니다.
Apache License 2.0
3 stars 4 forks source link

Pulmonary function test / Bone densitometry 매핑 의견 수렴 #25

Open ChungsooKim opened 3 years ago

ChungsooKim commented 3 years ago

안녕하세요? 아주대학교 의료정보학과 통합과정 김청수입니다.

현재 PFT 및 BMD 관련 자료를 활용하여 CDM 데이터에 포함하는 작업을 진행 중에 있습니다.

PFT 와 BMD 자료에서 다수의 매핑이 불가한 concept 이 발생함에 따라 타 기관 연구자분들의 의견을 먼저 듣고, global OHDSI 에 해당 concept 처리에 대해 논의하고자 합니다.

아래는 자체적으로 매핑을 진행한 PFT 및 BMD 자료의 세부 항목 별 concept을 공유드립니다. 또한 첨부 파일에는 mapping이 가능해보이는 항목과 mapping이 불가능해보이는 항목을 분리하여 정리하였습니다. 완성된 파일은 아니므로, 오류가 있다면, 너그러이 양해해주시고, 지적해주시면 큰 도움 될 것 같습니다.

혹시 PFT나 BMD 관련하여 진행되고 있는 매핑에 대한 의견과 해당 기관의 검사 항목이 적절한 concept 이 없어, 적절히 매핑 되지 못하고 있는 경우를 공유해주시면 감사하겠습니다. 😄

PFT_mapping_ajou.xlsx_수정

BMD_mapping_ajou.xlsx

Pulmonary function test, spirometry, challenge test, FeNO

Format name name detail1 detail2 OMOP_concept_id OMOP_concept_code OMOP_concept_name unit_concept_id unit_source_value etc
Allergen broncho provocation test PC 20 - - 40768552 65866-6 Methacholine [Mass] of Dose 8861 mg/ml  
Exercise challenge test FEV1 (L) 10 min - 3044378 43263-3 FEV1 --10 minutes post exercise 8519 L  
Exercise challenge test FEV1 (L) 5 min - 3046526 43261-7 FEV1 --5 minutes post exercise 8519 L  
Lys Asp broncho provocation test Baseline FEV1(%) - - 3005600 19872-1 FVC measrued/predicted 8554 %  
Lys Asp broncho provocation test FEV1 (L) Pre-Bronch % of pred 3011708 20152-5 FEV1 measured/predicted 8554 %
Lys Asp broncho provocation test FEV1 (L) Pre-Bronch Test 3024653 20150-9 FEV1 8519 L  
Lys Asp broncho provocation test FEV1/FVC (%) Pre-Bronch Test 3011505 19926-5 FEV1/FVC 8554 %  
Lys Asp broncho provocation test MMEF 75/25 (L/sec) Pre-Bronch % of pred 42868466 69977-7 Maximum expiratory gas flow/Predicted maximum expiratory gas flow Respiratory system airway --pre bronchodilation 8554 %  
Lys Asp broncho provocation test MMEF 75/25 (L/sec) Pre-Bronch Test 4092631 251922005 Maximum mid-expiratory flow rate 32700 L/sec  
Lys Asp broncho provocation test PC 20 - - 40768552 65866-6 Methacholine [Mass] of Dose 8861 mg/ml  
Metacholine challenge Test FEF25-75%(L/sec) Pre-Bronch Actual 3011417 19927-3 Gas flow FEV 25-75% 32700 L/sec  
Metacholine challenge Test FEF25-75%(L/sec) Pre-Bronch Pred 42868460 69971-0 FEF 25-75% Predicted 32700 L/sec  
Metacholine challenge Test FEV1 (L) Challenge %Chng 42868472 69983-5 FEV1 percent change 8554 %  
Metacholine challenge Test FEV1 (L) Post-Bronch %Chng 42868472 69983-5 FEV1 percent change 8554 %  
Metacholine challenge Test FEV1 (L) Post-Bronch Actual 3023550 20155-8 FEV1 --post bronchodilation 8519 L  
Metacholine challenge Test FEV1 (L) Pre-Bronch %Pred 3011708 20152-5 FEV1 measured/predicted 8554 %  
Metacholine challenge Test FEV1 (L) Pre-Bronch Actual 3024653 20150-9 FEV1 8519 L  
Metacholine challenge Test FEV1 (L) Pre-Bronch Pred 3022891 20149-1 FEV1 Predicted 8519 L  
Metacholine challenge Test FEV1/FVC (%) Challenge %Chng 42868473 69984-3 FEV1/FVC percent change 8554 %  
Metacholine challenge Test FEV1/FVC (%) Post-Bronch %Chng 42868473 69984-3 FEV1/FVC percent change 8554 %  
Metacholine challenge Test FEV1/FVC (%) Post-Bronch Actual 42868459 69970-2 FEV1/FVC --post bronchodilation 8554 %  
Metacholine challenge Test FEV1/FVC (%) Pre-Bronch Actual 3011505 19926-5 FEV1/FVC 8554 %  
Metacholine challenge Test FEV1/FVC (%) Pre-Bronch Pred 3024594 19925-7 FEV1/FVC Predicted 8554 %  
Metacholine challenge Test FVC (L) Challenge %Chng 42868471 69982-7 FVC percent change Respiratory system 8554 %  
Metacholine challenge Test FVC (L) Post-Bronch %Chng 42868471 69982-7 FVC percent change Respiratory system 8554 %  
Oral provocation test FEV1 (%) Baseline - 3011708 20152-5 FEV1 measured/predicted 8554 %  
Oral provocation test FEV1 (L) Baseline - 3024653 20150-9 FEV1 8519 L  
Oral provocation test (복합) FEV1 (%) Baseline - 3011708 20152-5 FEV1 measured/predicted 8554 %  
Oral provocation test (복합) FEV1 (L) Baseline - 3024653 20150-9 FEV1 8519 L  
Pulmonary Function Test DL/VA(ml/min/mmHg/L) Pre-Bronch Actual 3027232 19916-6 Diffussion capacity/Alveolar volume 32699 ml/min/mmHg
Pulmonary Function Test DL/VA(ml/min/mmHg/L) Pre-Bronch Pred 3025555 11915-8 Diffussion capacity/Alveolar volumen Predicted 32699 ml/min/mmHg
Pulmonary Function Test DLCO cor (ml/min/mmHg) Pre-Bronch Actual 3006400 19913-3 Diffusion capacity.carbon monoxide adjusted for hemoglobin 32699 ml/min/mmHg
Pulmonary Function Test DLCO unc (ml/min/mmHg) Pre-Bronch Actual 3008905 19911-7 Diffusion capacity.carbon monoxide 32699 ml/min/mmHg
Pulmonary Function Test DLCO unc (ml/min/mmHg) Pre-Bronch Pred 3015145 19910-9 Diffusion capacity.carbon monoxide Predicted 32699 ml/min/mmHg
Pulmonary Function Test FEF25-75%(L/sec) Post-Bronch Actual 42868462 69973-6 FEF 25-75% --post bronchodilation 32700 L/sec  
Pulmonary Function Test FEF25-75%(L/sec) Pre-Bronch Actual 3011417 19927-3 Gas flow FEV 25-75% 32700 L/sec  
Pulmonary Function Test FEF25-75%(L/sec) Pre-Bronch Pred 42868460 69971-0 FEF 25-75% Predicted 32700 L/sec  
Pulmonary Function Test FEV1 (L) Post-Bronch %Chng 42868472 69983-5 FEV1 percent change 8554 %  
Pulmonary Function Test FEV1 (L) Post-Bronch Actual 3023550 20155-8 FEV1 --post bronchodilation 8519 L  
Pulmonary Function Test FEV1 (L) Pre-Bronch %Pred 3011708 20152-5 FEV1 measured/predicted 8554 %  
Pulmonary Function Test FEV1 (L) Pre-Bronch Actual 3024653 20150-9 FEV1 8519 L  
Pulmonary Function Test FEV1 (L) Pre-Bronch Pred 3022891 20149-1 FEV1 Predicted 8519 L  
Pulmonary Function Test FEV1/FVC (%) Post-Bronch %Chng 42868473 69984-3 FEV1/FVC percent change 8554 %  
Pulmonary Function Test FEV1/FVC (%) Post-Bronch Actual 42868459 69970-2 FEV1/FVC --post bronchodilation 8554 %  
Pulmonary Function Test FEV1/FVC (%) Pre-Bronch Actual 3011505 19926-5 FEV1/FVC 8554 %  
Pulmonary Function Test FEV1/FVC (%) Pre-Bronch Pred 3024594 19925-7 FEV1/FVC Predicted 8554 %  
Pulmonary Function Test FVC (L) Post-Bronch %Chng 42868471 69982-7 FVC percent change Respiratory system 8554 %  
Pulmonary Function Test FVC (L) Post-Bronch %Pred 3004424 19873-9 FVC post bronchodilation measured/predicted 8554 %  
Pulmonary Function Test FVC (L) Post-Bronch Actual 3002777 19874-7 Forced vital capacity [Volume] Respiratory system --post bronchodilation 8519 L  
Pulmonary Function Test FVC (L) Pre-Bronch %Pred 3005600 19872-1 FVC measured/predicted 8554 %  
Pulmonary Function Test FVC (L) Pre-Bronch Actual 3020158 19870-5 Forced vital capacity [Volume] Respiratory system 8519 L  
Pulmonary Function Test FVC (L) Pre-Bronch Pred 3002094 19869-7 Forced vital capacity [Volume] Respiratory system Predicted 8519 L  
Pulmonary Function Test Gaw(L/s/cmH2O) Pre-Bronch Actual 4092508 251882007 Airway conductance   L/s/cmH2O
Pulmonary Function Test Raw(cmH2O/L/s) Pre-Bronch %Pred 37020604 91981-1 Airway resistance measured/predicted by Plethysmograph body box   cmH2O/L/s
Pulmonary Function Test Raw(cmH2O/L/s) Pre-Bronch Actual 21490740 75946-4 Airway resistance   cmH2O/L/s
Pulmonary Function Test RV(Pleth)(L) Pre-Bronch %Pred 1002029 94125-2 Residual volume/Predicted by Plethysmograph body box 8554 %  
Pulmonary Function Test RV(Pleth)(L) Pre-Bronch Actual 3010798 20146-7 Residual volume 8519 L  
Pulmonary Function Test RV(Pleth)(L) Pre-Bronch Pred 3010263 20145-9 Residual volume Predicted 8519 L  
Pulmonary Function Test RV/TLC(Pleth)(%) Pre-Bronch Actual 21493446 81454-1 Residual volume/Total capacity --pre bronchodilation 8554 %  
Pulmonary Function Test RV/TLC(Pleth)(%) Pre-Bronch Pred 3047243 43252-6 Residual volume/Total capacity Predicted 8554 %  
Pulmonary Function Test sGaw(a/cmH2O*s) Pre-Bronch Actual 4194810 79412009 Specific airway conductance   a/cmH2O*s
Pulmonary Function Test sRaw(cmH2O*s) Pre-Bronch %Pred 37020030 91982-9 Specific airway resistance measured/predicted by Plethysmograph body box 44777590 cmH2O*s  
Pulmonary Function Test sRaw(cmH2O*s) Pre-Bronch Actual 37019516 91980-3 Specific airway resistance by Plethysmograph body box 44777590 cmH2O*s  
Pulmonary Function Test TLC(Pleth)(L) Pre-Bronch %Pred 36303283 89085-5 Total lung capacity measured/predicted by Plethysmograph body box 8554 %  
Pulmonary Function Test TLC(Pleth)(L) Pre-Bronch Actual 3009425 19862-2 Total lung capacity 8519 L  
Pulmonary Function Test TLC(Pleth)(L) Pre-Bronch Pred 3012004 19861-4 Total lung capacity Predicted 8519 L  
Spirometry (ALMD) FEV1 (%) - - 3005600 19872-1 FVC measrued/predicted 8554 %  
Spirometry (ALMD) FEV1 (L) - - 3024653 20150-9 FEV1 8519 L  
Spirometry (ALMD) FEV1 (L) Pre-Bronch % of pred 3011708 20152-5 FEV1 measured/predicted 8554 %  
Spirometry (ALMD) FEV1 (L) Pre-Bronch Test 3024653 20150-9 FEV1 8519 L  
Spirometry (ALMD) FEV1/FVC (%) Pre-Bronch Test 3011505 19926-5 FEV1/FVC 8554 %  
Spirometry (ALMD) FVC (L) Pre-Bronch % of pred 3005600 19872-1 FVC measrued/predicted 8554 %  
Spirometry (ALMD) FVC (L) Pre-Bronch Test 3020158 19870-5 Forced vital capacity [Volume] Respiratory system 8519 L  
Spirometry (ALMD) MMEF 75/25 (L/sec) Pre-Bronch % of pred 42868466 69977-7 Maximum expiratory gas flow/Predicted maximum expiratory gas flow Respiratory system airway --pre bronchodilation 8554 %  
Spirometry (ALMD) MMEF 75/25 (L/sec) Pre-Bronch Test 4092631 251922005 Maximum mid-expiratory flow rate 32700 L/sec  
TDI broncho provocation test Baseline FEV1(%) - - 3005600 19872-1 FVC measrued/predicted 8554 %  
TDI broncho provocation test PC 20 - - 40768552 65866-6 Methacholine [Mass] of Dose 8861 mg/ml  
기관지가역성검사(Broncho reversibility test) Baseline FEV1(%) - - 3005600 19872-1 FVC measrued/predicted 8554 %  
기관지가역성검사(Broncho reversibility test) FEV1 (%) - - 3005600 19872-1 FVC measrued/predicted 8554 %  
기관지가역성검사(Broncho reversibility test) FEV1 (L) - - 3024653 20150-9 FEV1 8519 L  
기관지가역성검사(Broncho reversibility test) FEV1 (L) Post-Bronch Post 3023550 20155-8 FEV1 --post bronchodilation 8519 L  
기관지가역성검사(Broncho reversibility test) FEV1 (L) Pre-Bronch %Pred 3011708 20152-5 FEV1 measured/predicted 8554 %  
기관지가역성검사(Broncho reversibility test) FEV1 (L) Pre-Bronch Pre 3024653 20150-9 FEV1 8519 L  
기관지가역성검사(Broncho reversibility test) FEV1/FVC (%) Pre-Bronch Pre 3011505 19926-5 FEV1/FVC 8554 %  
기관지가역성검사(Broncho reversibility test) FVC (L) Post-Bronch Post 3002777 19874-7 Forced vital capacity [Volume] Respiratory system --post bronchodilation 8519 L  
기관지가역성검사(Broncho reversibility test) FVC (L) Pre-Bronch %Pred 3005600 19872-1 FVC measured/predicted 8554 %  
기관지가역성검사(Broncho reversibility test) FVC (L) Pre-Bronch Pre 3020158 19870-5 Forced vital capacity [Volume] Respiratory system 8519 L  
기관지가역성검사(Broncho reversibility test) MMEF 75/25 (L/sec) Pre-Bronch %Pred 42868466 69977-7 Maximum expiratory gas flow/Predicted maximum expiratory gas flow Respiratory system airway --pre bronchodilation 8554 %  
기관지가역성검사(Broncho reversibility test) MMEF 75/25 (L/sec) Pre-Bronch Pre 4092631 251922005 Maximum mid-expiratory flow rate 32700 L/sec  
기관지과민증검사 (Broncho sensitivity test) At FEV1 (L) - - 3024653 20150-9 FEV1 8519 L  
기관지과민증검사 (Broncho sensitivity test) Baseline FEV1(%) - - 3005600 19872-1 FVC measrued/predicted 8554 %  
기관지과민증검사 (Broncho sensitivity test) FEV1 (%) - - 3005600 19872-1 FVC measrued/predicted 8554 %  
기관지과민증검사 (Broncho sensitivity test) FEV1 (L) - - 3024653 20150-9 FEV1 8519 L  
기관지과민증검사 (Broncho sensitivity test) FEV1 (L) Pre-Bronch % of pred 3011708 20152-5 FEV1 measured/predicted 8554 %  
기관지과민증검사 (Broncho sensitivity test) FEV1 (L) Pre-Bronch Test 3024653 20150-9 FEV1 8519 L  
기관지과민증검사 (Broncho sensitivity test) FEV1/FVC (%) Pre-Bronch Test 3011505 19926-5 FEV1/FVC 8554 %  
기관지과민증검사 (Broncho sensitivity test) FVC (L) Pre-Bronch % of pred 3005600 19872-1 FVC measured/predicted 8554 %  
기관지과민증검사 (Broncho sensitivity test) FVC (L) Pre-Bronch Test 3020158 19870-5 Forced vital capacity [Volume] Respiratory system 8519 L  
기관지과민증검사 (Broncho sensitivity test) MMEF 75/25 (L/sec) Pre-Bronch % of pred 42868466 69977-7 Maximum expiratory gas flow/Predicted maximum expiratory gas flow Respiratory system airway --pre bronchodilation 8554 %  
기관지과민증검사 (Broncho sensitivity test) MMEF 75/25 (L/sec) Pre-Bronch Test 4092631 251922005 Maximum mid-expiratory flow rate 32700 L/sec  
기관지과민증검사 (Broncho sensitivity test) PC 20 - - 40768552 65866-6 Methacholine [Mass] of Dose 8861 mg/ml  
호기 산화질소 검사 결과 (Fractional exhaled nitric oxide test) No - - 40480257 444642008 Measurement of expired nitric oxide 8703 ppb LOINC 96269-6
호기 산화질소 검사 결과 (Fractional exhaled nitric oxide test) No level (ppb) - - 40480257 444642008 Measurement of expired nitric oxide 8703 ppb LOINC 96269-6

Bone densitometry

Form_name Name Detail1 Detail2 OMOP_concept_id OMOP_concept_name unit_concept_id unit_source_value
Bone densitometry Age matched Z-score Femur bone density 21494100 DXA Femur [Z-score] Bone density - -
Bone densitometry Age matched Z-score Lumbar spine bone density 36204417 DXA Lumbar spine [Z-score] Bone density - -
Bone densitometry BMC (g) BMC (g) Total body tissue quantitation 44809654 Total bone mass 8504 g
Bone densitometry BMD (g/cm2) BMD (g/cm2) Femur bone density 3021722 DXA Femur [Mass/Area] Bone density 32701 g/cm2
Bone densitometry BMD (g/cm2) BMD (g/cm2) Lumbar spine bone density 3033804 DXA Lumbar spine [Mass/Area] Bone density 32701 g/cm2
Bone densitometry BMD (g/cm2) BMD (g/cm2) Total body bone density 3051343 DXA Bone [Mass/Area] Bone density 32701 g/cm2
Bone densitometry Centile Centile Total body tissue quantitation 40490382 Body mass index centile 8554 %
Bone densitometry Fat (g) Fat (g) Total body tissue quantitation 43533733 Body fat [Mass] Calculated 8504 g
Bone densitometry Femur Total BMD 최소 유의 변화 (Least Significant Change : LSC) 단위 3021722 DXA Femur [Mass/Area] Bone density 32701 g/cm2
Bone densitometry Femur Total T-Score 최소 유의 변화 (Least Significant Change : LSC) 단위 3051450 DXA Femur [T-score] Bone density - -
Bone densitometry Lean (g) Lean (g) Total body tissue quantitation 36305481 Lean body weight Calculated 8504 g
Bone densitometry LSC 값 (g/cm2) LSC 값 (g/cm2) 최소 유의 변화 (Least Significant Change : LSC) 42709909 Bone density below reference range 32701 g/cm2
Bone densitometry Spine L1-L4 BMD 최소 유의 변화 (Least Significant Change : LSC) 단위 3033804 DXA Lumbar spine [Mass/Area] Bone density 32701 g/cm2
Bone densitometry Spine L1-L4 T-Score 최소 유의 변화 (Least Significant Change : LSC) 단위 3049654 DXA Lumbar spine [T-score] Bone density - -
Bone densitometry Tissue (% fat) Tissue (% fat) Total body tissue quantitation 4087498 Total body fat 8554 %
Bone densitometry Total mass (kg) Total mass (kg) Total body tissue quantitation 3013762 Body weight Measured 9529 kg
Bone densitometry Young adult T-score Femur bone density 3051450 DXA Femur [T-score] Bone density - -
Bone densitometry Young adult T-score Lumbar spine bone density 3049654 DXA Lumbar spine [T-score] Bone density - -