เล่าเรื่องการใช้เงื่อนไขรหัส ICD10 ที่ใช้ดึงกลุ่มเป้าหมายตามต้องการ

เล่าเรื่องการใช้เงื่อนไขรหัส ICD10 ที่ใช้ดึงกลุ่มเป้าหมายตามต้องการ

1. เบาหวาน                    icd10 like ("E11%")
2. ความดันโลหิตสูง      icd10 LIKE ("i10%")
3. ไตวาย                       icd10   BETWEEN "N180" and "N189"
4. CVA                         icd10   BETWEEN "I60" and "I69"
5. โรคหัวใจ                   icd10 in ("I05","I050","I051","I052","I058","I059","I06","I060","I061","I062","I068","I069","I07","I070","I071","I072","I078","I079","I08","I080","I081","I082","I083",
              '"I088","I089","I09","I090","I091","I092","I098","I099","I20","I200","I201","I208","I209","I21","I210","I211","I212","I213","I214","I219","I22","I220","I221","I228",          
              '"I229","I23","I230","I231","I232","I233","I234","I235","I236","I238","I24","I240","I241","I248","I249","I25","I250","I251","I252","I253","I254","I255","I256",                  
              '"I258","I259","I30","I300","I301","I308","I309","I31","I310","I311","I312","I313","I318","I319","I32","I320","I321","I328","I33","I330","I339","I34","I340","I341",              
              '"I342","I348","I349","I35","I350","I351","I352","I358","I359","I36","I360","I361","I362","I368","I369","I37","I370","I371","I372","I378","I379","I38","I39","I390",                
              '"I391","I392","I393","I394","I398","I40","I400","I401","I408","I409","I41","I410","I411","I412","I418","I42","I420","I421","I422","I423","I424","I425","I426","I427",                
              '"I428","I429","I43","I430","I431","I432","I438","I44","I440","I441","I442","I443","I444","I445","I446","I447","I45","I450","I451","I452","I453","I454","I455","I456",                  
              '"I458","I459","I46","I460","I461","I469","I47","I470","I471","I472","I479","I48","I49","I490","I4900","I4901","I4908","I4909","I491","I492","I493","I494","I495",                        
              '"I498","I499","I50","I500","I501","I509","I51","I510","I511","I512","I513","I514","I515","I516","I517","I518","I519","I52")

6. โรคมะเร็ง             icd10 BETWEEN "C00" and "D48"

อธิบายคำสั่ง 
1. คำสั่ง like คือมีส่วนใดส่วนหนึ่งเหมือนก็เลือกมา
2. คำสั่ง between คือเลือกข้อมูลที่อยู่ในช่วงนั้นออกมา
3. คำสั่ง in คือเลือกข้อมูลในชุดข้อมูลที่เรากำหนด

*** ขอบคุณข้อมูลจาก A เวชสถิติ Chakkarat Hos
#keepper