graph TD A[患者入院] --> B{术前评估} B --> C[颞骨高分辨率 CT] B --> D[纯音听力 & 声导抗测试] C --> E[影像关键词识别: 骨质破坏/胆脂瘤影] D --> F[术前 ABG 基准值录入] E & F --> G[EMR 强制分型树录入] G --> H{逻辑校验} H -- 冲突 --> I[系统弹出预警: 诊断与影像不符] H -- 一致 --> J[生成规范化手术医嘱] J --> K[术中发现确认: 记录听骨链活动度] K --> L[术后病理送检: 胆脂瘤 vs 肉芽] L --> M[三位一体对账引擎] M --> N{审计结果} N -- 异常 --> O[红榜标记: 评估失准/术中漏诊] N -- 正常 --> P[入组高权重 DRG 组] P --> Q[发放“分型符合率奖”红利]
/* * PIT-2026-41: 中耳炎手术精准性“三位一体”监测逻辑 * 核心逻辑:交叉验证 PACS(CT影像)、EMR(术中记录)、LIS(病理金标准) */ WITH Triad_Check AS ( SELECT s.Patient_ID, s.Patient_Name, s.Surgery_Date, s.Surgeon_Name, -- 1. 影像侧(PACS):抓取术前 CT 报告中的分型关键词 CASE WHEN p.Report_Content LIKE'%胆脂瘤%'OR p.Report_Content LIKE'%骨质破坏%'THEN'Cholesteatoma' WHEN p.Report_Content LIKE'%肉芽%'OR p.Report_Content LIKE'%软组织影%'THEN'Granulation' ELSE'Simple' ENDAS Imaging_Type, -- 2. 手术侧(EMR):抓取手术记录中“术中所见”的结构化语义 CASE WHEN e.Operation_Finding LIKE'%胆脂瘤%'OR e.Operation_Finding LIKE'%上皮样%'THEN'Cholesteatoma' WHEN e.Operation_Finding LIKE'%肉芽%'OR e.Operation_Finding LIKE'%血性物%'THEN'Granulation' ELSE'Simple' ENDAS Intraop_Finding, -- 3. 病理侧(LIS):抓取病理报告金标准 CASE WHEN l.Pathology_Result LIKE'%胆脂瘤%'OR l.Pathology_Result LIKE'%鳞状上皮%'THEN'Cholesteatoma' WHEN l.Pathology_Result LIKE'%慢性肉芽%'THEN'Granulation' ELSE'Simple' ENDAS Pathology_Type, s.Main_Diagnosis AS [首页诊断], s.Operation_Code AS [手术编码] FROM EMR_Surgery_Record s LEFTJOIN PACS_Report p ON s.Patient_ID = p.Patient_ID AND p.Exam_Date BETWEEN DATEADD(day, -30, s.Surgery_Date) AND s.Surgery_Date LEFTJOIN EMR_Progress_Note e ON s.Patient_ID = e.Patient_ID AND e.Note_Type ='Operation_Finding'AND e.Record_Time <= DATEADD(hour, 24, s.Surgery_Date) LEFTJOIN LIS_Pathology_Result l ON s.Patient_ID = l.Patient_ID AND l.Report_Date BETWEEN s.Surgery_Date AND DATEADD(day, 14, s.Surgery_Date) WHERE s.ICD10_Code LIKE'H66.1%'-- 慢性中耳炎 AND s.Surgery_Date >='2026-01-01' ) SELECT Patient_ID, Patient_Name, Surgeon_Name AS [主刀医生], Imaging_Type AS [CT评估分型], Intraop_Finding AS [术中记录分型], Pathology_Type AS [病理确认分型], [首页诊断], -- 异常判定逻辑 CASE WHEN Imaging_Type = Pathology_Type AND Pathology_Type = Intraop_Finding THEN'诊疗规范' WHEN Imaging_Type <> Pathology_Type AND [首页诊断] NOTLIKE'%胆脂瘤%'AND Pathology_Type ='Cholesteatoma'THEN'严重漏诊/低报' WHEN [首页诊断] LIKE'%中耳炎%'AND [首页诊断] NOTLIKE'%分型%'THEN'诊断模糊' ELSE'逻辑偏差' ENDAS [规范性判定结果] FROM Triad_Check WHERE Surgery_Date >= DATEADD(month, -1, GETDATE());