﻿--病种添加系统特别说明
--PIP 围手术期预防感染
if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID =9)
update D_Disease_Category set SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.18岁以下的病例，无需上报</p>
<p>2.同一疾病30日内重复入院，无需上报</p>
<p>3.本次住院天数大于90天，无法上报。</p>
</div>'
where SystemDescription is null and DCID =9
--DVT 围手术期深静脉血栓
if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID =12)
update D_Disease_Category set SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.18岁以下的病例，无需上报</p>
<p>2.同一疾病30日内重复入院，无需上报</p>
<p>3.本次住院天数大于90天，无法上报。</p>
<p>4.住院时间小于24小时无需上报。</p>
</div>'
where SystemDescription is null and DCID =12
--HBIPS 住院精神病患者安全和权益 DG 异位妊娠（手术治疗） UM 子宫肌瘤（手术治疗）
if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID in(14,20,32,34))
update D_Disease_Category set SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.18岁以下的病例，无需上报</p>
<p>2.同一疾病30日内重复入院，无需上报</p>
<p>3.住院时间小于24小时无需上报。</p>
</div>'
where SystemDescription is null and DCID in(14,20,32,34)

if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID  in (19,21,22,23,25,26,27,28,24,29,30,31,37,17,16,33,35,36,37,15))
update D_Disease_Category set SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.同一疾病30日内重复入院，无需上报。</p>
<p>2.住院时间小于24小时无需上报。</p>
</div>'
where SystemDescription is null and DCID  in (19,21,22,23,25,26,27,28,24,29,30,31,37,17,16,33,35,36,37,15)

if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID  in (3,6,13,10,1,2,7,4,5))
update D_Disease_Category set SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.本次住院天数大于90天，无法上报。</p>
<p>2.住院时间小于24小时无需上报。</p>
</div>'
where SystemDescription is null and DCID in (3,6,13,10,1,2,7,4,5)

if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID  in (8,11))
update D_Disease_Category set SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.住院时间小于24小时无需上报。</p>
</div>'
where SystemDescription is null and DCID in (8,11)

--无需上报条件  18岁以下的病例
if exists(select * from  D_ReportStaticsQuota  where id=1 and  ReportClassArr<>'1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' )
update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' 
where id=1 and  ReportClassArr<>'1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' 
--无需上报条件 同一疾病30日内重复入院
if exists(select * from  D_ReportStaticsQuota  where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,' )
update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,'  
where id=12 and   ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,' 
--本次住院天数大于90天，无法上报。
if exists(select * from  D_ReportStaticsQuota  where id=4 and  ReportClassArr<>'1,2,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' )
update D_ReportStaticsQuota set ReportClassArr='1,2,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,'  
where id=4 and  ReportClassArr<>'1,2,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' 
--本次住院天数大于120天
if exists(select * from  D_ReportStaticsQuota  where id=5 and  ReportClassArr is not null )
update D_ReportStaticsQuota set ReportClassArr=null  
where id=5 and  ReportClassArr is not null 
--住院24小时内出院
if exists(select * from  D_ReportStaticsQuota  where id=8 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,46,47,48,49,50,52' )
update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,46,47,48,49,50,52'  
where id=8 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,46,47,48,49,50,52'
--编码对应pip卵巢切除术对应修改
if exists(select * from  Report_ICDCodeMatch  where ReportClass=9 and ICDCode like '65.%' and SuborderValue='1' )
update Report_ICDCodeMatch set SuborderValue='l'  
where ReportClass=9 and ICDCode like '65.%' and SuborderValue='1'



--更新 疾病系统分类 2021-01-07（增加到51个病种）
SET IDENTITY_INSERT [dbo].[D_DiseaseSystem] ON
if not exists(select * from  D_DiseaseSystem  where ID=8 )
BEGIN
  INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (8, N'口腔系统疾病/手术 ', 2)
END

if not exists(select * from  D_DiseaseSystem  where ID=9 )
BEGIN
  INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (9, N'泌尿系统疾病/手术', 3)
END

if not exists(select * from  D_DiseaseSystem  where ID=10 )
BEGIN
  INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (10, N'眼科系统疾病/手术', 7)
END
SET IDENTITY_INSERT [dbo].[D_DiseaseSystem] OFF

UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =4  WHERE [ID]=2
UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =5  WHERE [ID]=3
UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =6  WHERE [ID]=4
UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =8  WHERE [ID]=5
UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =9  WHERE [ID]=6
UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =10  WHERE [ID]=7

SET IDENTITY_INSERT [dbo].[D_Disease_Category] ON
if not exists(select * from  D_Disease_Category  where [DCID]=38 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (38, N'RD', N'RD', 10, N'复杂性视网膜脱离（手术治疗）', 38, 1, N'form-38', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">RD </span><span style="font-family:微软雅黑,sans-serif;color:black">复杂性视网膜脱离（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:H26.2，H40.0，H40.2，H40.9， 且伴主要手术 ICD-9-CM-3 编码:10.1，10.49，10.6，10.91， 10.99，12.11，12.12，12.64，12.66，12.67，12.71 至 12.73， 12.79，12.83，12.85，12.87，12.91，12.92，12.99，13.19， 13.3，13.41，13.59，13.70，13.71，13.90，14.73，14.74， 14.79 的手术出院患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

SET IDENTITY_INSERT [dbo].[D_Disease_Category] ON
if not exists(select * from  D_Disease_Category  where [DCID]=39 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (39, N'PACG', N'PACG', 10, N'原发性急性闭角型青光眼（手术治疗）', 39, 1, N'form-39', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">PACG </span><span style="font-family:微软雅黑,sans-serif;color:black">原发性急性闭角型青光眼（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:H26.2，H40.0，H40.2，H40.9， 且伴主要手术 ICD-9-CM-3 编码:10.1，10.49，10.6，10.91， 10.99，12.11，12.12，12.64，12.66，12.67，12.71 至 12.73， 12.79，12.83，12.85，12.87，12.91，12.92，12.99，13.19， 13.3，13.41，13.59，13.70，13.71，13.90，14.73，14.74， 14.79 的手术出院患者。</span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=40 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (40, N'TSCC', N'TSCC', 8, N'舌鳞状细胞癌（手术治疗）', 40, 1, N'form-40', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">TSCC </span><span style="font-family:微软雅黑,sans-serif;color:black">舌鳞状细胞癌（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C01，C02，且伴主要手术 ICD-9-CM-3 编码:25.1 至 25.4，40.4 的手术出院患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END
if not exists(select * from  D_Disease_Category  where [DCID]=41 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (41, N'PT', N'PT', 8, N'腮腺肿瘤（手术治疗）', 41, 1, N'form-41', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">PT </span><span style="font-family:微软雅黑,sans-serif;color:black">腮腺肿瘤（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:D11.0，且伴主要手术 ICD-9-CM-3 编码:26.2，26.3 伴 04.42 的手术出院患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=42 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (42, N'CC', N'CC', 6, N'宫颈癌（手术治疗）', 42, 1, N'form-42', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">CC </span><span style="font-family:微软雅黑,sans-serif;color:black">宫颈癌（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C53 开头，且伴主要手术 ICD-9-CM-3 编码:67.2 至 67.4，68.4，68.5，68.6，68.7 的手术出院患者。  </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=43 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (43, N'CoC', N'CoC', 6, N'结肠癌（手术治疗）', 43, 1, N'form-43', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">CoC </span><span style="font-family:微软雅黑,sans-serif;color:black">结肠癌（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C18，D01.0;且伴主要手术操 作 ICD-9-CM-3 编码:45.4,45.73 至 45.79,45.8 的手术出院 患者。</span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=44 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (44, N'HD', N'HD', 9, N'终末期肾病血液透析', 44, 1, N'form-44', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">HD </span><span style="font-family:微软雅黑,sans-serif;color:black">终末期肾病血液透析</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:N18.0，且伴主要操作 ICD-9-CM-3 编码:38.95，39.27，39.42，39.95 的血液透析患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=45 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (45, N'DPD', N'DPD', 9, N'终末期肾病腹膜透析', 45, 1, N'form-45', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">DPD </span><span style="font-family:微软雅黑,sans-serif;color:black">终末期肾病腹膜透析</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:N18.0，且伴主要操作 ICD-9-CM-3 编码:54.98 的腹膜透析患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=46 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (46, N'DKD', N'DKD', 9, N'糖尿病肾病', 46, 1, N'form-46', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">DKD </span><span style="font-family:微软雅黑,sans-serif;color:black">糖尿病肾病</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断和其他诊断 ICD-10 编码:E10 至 E14，且伴主 要操作 ICD-9-CM-3 编码:55.23 的非产妇出院患者。  </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.终末期肾病已行血液净化治疗</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.肿瘤患者</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=47 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (47, N'CACC', N'CACC', 1, N'哮喘（儿童，住院）', 47, 1, N'form-47', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">CACC </span><span style="font-family:微软雅黑,sans-serif;color:black">哮喘（儿童，住院）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:J45，J46;2 岁≤年龄<18 岁 的出院患儿。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.年龄≥18岁以及<2岁的患者</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 2,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=48 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (48, N'ALL', N'ALL', 7, N'儿童急性淋巴细胞白血病（初始诱导化疗）', 48, 1, N'form-48', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">ALL </span><span style="font-family:微软雅黑,sans-serif;color:black">儿童急性淋巴细胞白血病（初始诱导化疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C91.0，且伴主要操作 ICD-9-CM-3 编码:99.25 的出院患儿。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以上的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=49 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (49, N'APL', N'APL', 7, N'儿童急性早幼粒细胞白血病（初始化疗）', 49, 1, N'form-49', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">APL </span><span style="font-family:微软雅黑,sans-serif;color:black">儿童急性早幼粒细胞白血病（初始化疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C92.4，且伴主要操作 ICD-9-CM-3 编码:99.25 的出院患儿。  </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以上的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=50 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (50, N'HPV', N'HPV', 7, N'HBV 感染分娩母婴阻断', 50, 1, N'form-50', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">HBV 感染分娩母婴阻断</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:O98.4，Z22.5 + O80 至 O84+Z37; 且伴1阴道分娩操作 ICD-9-CM-3 编码 72.0 至 72.9，73.0， 73.1，73.21，73.4 至 73.6,73.9;或伴2剖宫产手术 ICD 9-CM-3 编码:74.0，74.1，74.2，74.4，74.99 的出院患者。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.病历记录孕期＜28周或不明的</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以上的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=51 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (51, N'OIT', N'OIT', 8, N'口腔种植术', 51, 1, N'form-51', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">OIT</span><span style="font-family:微软雅黑,sans-serif;color:black">口腔种植术</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要手术 ICD-9-CM-3 编码:23.5，23.6 的门诊患者或 者 76.09，76.91，76.92，22.79 的手术出院患者。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.18岁以上的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 1,NULL,NULL)
END

if not exists(select * from  D_Disease_Category  where [DCID]=52 )
BEGIN
INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
VALUES (52, N'DDH', N'DDH', 5, N'发育性髋关节发育不良', 52, 1, N'form-52', 1,
N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">DDH</span><span style="font-family:微软雅黑,sans-serif;color:black">发育性髋关节发育不良</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:Q65.0 至 Q65.6、Q65.8、Q65.9, 伴主要手术 ICD-9-CM-3 编码: 79.85、77.25、77.29;1 岁 ≤年龄≤8 岁(旧称先天性髋关节脱位)的手术出院患儿。  </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.参与临床药物与器械试验的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.18岁以上的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
END

SET IDENTITY_INSERT [dbo].[D_Disease_Category] OFF

--新增病种系统特别说明
if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID  in (38,39,40,41,46,47,48,49,50,52))
update D_Disease_Category set SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.住院时间小于24小时无需上报。</p>
</div>'
where SystemDescription is null and DCID in (38,39,40,41,46,47,48,49,50,52)

update [Q_Roles] set [Quanxian] = [Quanxian] + ',' + (select cast(Id as nvarchar(max)) from Q_Quanxian where QuanxianName = '数据统计')
where (CHARINDEX(',6,',',' + [Quanxian] + ',') > 0 or CHARINDEX(',7,',',' + [Quanxian] + ',') > 0) 
and  CHARINDEX(','+(select cast(Id as nvarchar(max)) from Q_Quanxian where QuanxianName = '数据统计')+',',',' + [Quanxian] + ',') = 0

UPDATE  [D_Disease_Category]
SET     [LeakExtractRule] = 3
WHERE   DiseaseDescription LIKE '%腮腺肿瘤%'
        OR DiseaseDescription LIKE '%糖尿病肾病%'
        OR DiseaseDescription LIKE '%终末期肾病血液透析%'
        OR DiseaseDescription LIKE '%终末期肾病腹膜透析%'
        OR DiseaseDescription LIKE '%原发性急性闭角型青光眼%'
        OR DiseaseDescription LIKE '%感染分娩母婴阻断%'

		--更新admin病种，
if not exists(select * from Q_UserProfile where UserName='admin'and CID='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52')
update Q_UserProfile
set CID='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52'
where UserName='admin'

if exists(select * from D_Disease_Category where DCID=50 and DiseaseType='HPV')
update D_Disease_Category
set DiseaseType='HBV',DiseaseType_API='HBV'
where  DCID=50 and DiseaseType='HPV'

--年龄大于18岁以及小于2岁的新生儿肺炎
if exists(select * from  D_ReportStaticsQuota  where id=2 and  ReportClassArr<>'8,47,' )
update D_ReportStaticsQuota set ReportClassArr='8,47,',StaticsQuotaName='年龄大于等于18岁以及小于2岁的新生儿' 
where id=2 and  ReportClassArr<>'8,47,' 

--同一疾病30日内重复入院
if exists(select * from  D_ReportStaticsQuota  where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,' )
update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,'
where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,' 

--HBIPS 住院精神病患者安全和权益 无需上报内容
if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%小于18周岁的病例%' and DCID = 14)
update D_Disease_Category set DiseaseContent='
<div class="content"><p>上报内容：</p>
<div class="page">
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">主要诊断 ICD-10 编码:F00-F99 的出院患者。&nbsp;</span></p>
</div>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.住院时间＞365天（一年）</p>
<p><span style="white-space: pre;"> </span>2.住院24小时内出院</p>
<p><span style="white-space: pre;"> </span>3.住院24小时内死亡</p>
<p><span style="white-space: pre;"> </span>4.临床药物或器械试验的病例</p>
<p><span style="white-space: pre;"> </span>5.小于18周岁的病例</p>
<p>&nbsp;</p>
<p>数据验证</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>'
where DiseaseContent  not like '%小于18周岁的病例%' and DCID = 14

if exists(select * from  D_Disease_Category  where SystemDescription is not null  and DCID = 14)
update D_Disease_Category set SystemDescription = null
where SystemDescription is not null  and DCID = 14

--pip、dvt重复将pip未报数据标记为无需上报
if exists(select * from Report_Leak where ( OpertationICD like  '65.2%'or OpertationICD like  '65.3%%' or OpertationICD like'65.4%' 
or OpertationICD like'65.5%'   or OpertationICD like'65.6%' or OpertationICD like'00.7%' or OpertationICD like'81.51%'  
or OpertationICD like'81.52%' or OpertationICD like'81.53%' or OpertationICD like'00.80%' or OpertationICD like'00.81%' 
or OpertationICD like'00.82%' or OpertationICD like'00.83%'   or OpertationICD like'81.54%' or OpertationICD like'81.55%' or OpertationICD like'36.1') 
and ReportClass=9 and DealReport=0 )
update Report_Leak set DealReport=2,NoMustReportReason ='PIP与DVT重复的病种'
where ( OpertationICD like  '65.2%'or OpertationICD like  '65.3%%' or OpertationICD like'65.4%' 
or OpertationICD like'65.5%'   or OpertationICD like'65.6%' or OpertationICD like'00.7%' or OpertationICD like'81.51%'  
or OpertationICD like'81.52%' or OpertationICD like'81.53%' or OpertationICD like'00.80%' or OpertationICD like'00.81%' 
or OpertationICD like'00.82%' or OpertationICD like'00.83%'   or OpertationICD like'81.54%' or OpertationICD like'81.55%' or OpertationICD like'36.1') 
and ReportClass=9 and DealReport=0 

--修改部分上报说明
if exists(select * from  D_Disease_Category  where CHARINDEX('主要手术 ICD-9-CM-3 编码:35.53、35.55、35.62、35.72 的手术出院患者。',DiseaseContent) > 0 and Num='form-31')
begin
update D_Disease_Category set DiseaseContent=REPLACE(DiseaseContent,'主要手术 ICD-9-CM-3 编码:35.53、35.55、35.62、35.72 的手术出院患者。','主要手术 ICD-9-CM-3 编码:35.51、35.52、35.61、35.71 的手术出院患者。') where Num='form-31'
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p><span style="font-family: 宋体; font-size: 12pt;">上报内容:</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;">主要手术ICD-9-CM-3 编码如下的手术出院患者：</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><!-- [if !supportLists]--><span style="letter-spacing: -0.1pt;">（1）</span>闭合性心脏瓣膜切开术：35.00<span style="letter-spacing: -1.4pt;">&nbsp;至 </span>35.04</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（2）</span>心脏瓣膜切开和其他置换术：35.20<span style="letter-spacing: -2.7pt;">&nbsp;至 </span>35.28</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;">（3）脊柱颈融合术：81.04<span style="letter-spacing: -1.5pt;">&nbsp;至 </span>81.08</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;">（4）脊柱再融合术：81.34<span style="letter-spacing: -1.5pt;">&nbsp;至 </span>81.38</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><!-- [if !supportLists]--><span style="letter-spacing: -0.1pt;">（5）</span>胃部分切除术伴胃十二指肠吻合术：43.6</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><!-- [if !supportLists]--><span style="letter-spacing: -0.1pt;">（6）</span>胃部分切除术伴胃空肠吻合术：43.7</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（7）</span>其他胃部分切除术：43.8</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（8）</span>胃全部切除术：43.9</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（9）</span>开放性和其他部分大肠切除术：45.7</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（10）</span>腹会阴直肠切除术：48.5</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（11）</span>直肠</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="text-indent: -24pt;">其他切除术：</span><span style="text-indent: -24pt;">48.6</span></span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（12）</span>肝叶切除术：50.3</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（13）</span>部分肾切除术：55.4</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（14）</span>全部肾切除术：55.5</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（15）</span>部分膀胱切除术：57.6</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（16）</span>全部膀胱切除术：57.7</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（17）</span>卵巢病损或卵巢组织的局部切除术或破坏术：65.2</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（18）</span>单侧卵巢切除术：65.3</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（19）</span>单侧输卵管-卵巢切除术：65.4</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（20）</span>双侧卵巢切除术：65.5</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（21）</span>双侧输卵管-卵巢切除术：65.6</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（22）</span>子宫病损或组织的切除术或破坏术：68.2</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（23）</span>经腹子宫次全切除术：68.3</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（24）</span>经腹子宫全部切除术：68.4</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（25）</span>阴道子宫切除术：68.5</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（26）</span>经腹根治性子宫切除术：68.6</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（27）</span>根治性阴道子宫切除术：68.7</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（28）</span>盆腔脏器去除术：68.8</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;">（29）髋关节置换术：00.7，81.51<span style="letter-spacing: -2.75pt;">&nbsp;至 </span>81.53</span></p>
<p><span style="font-size: 12pt; font-family: 宋体;">（30）膝关节置换术：00.80<span style="letter-spacing: -2.75pt;">&nbsp;至 </span>00.83，81.54，81.55</span></p>
<p><span style="font-family: 宋体; font-size: 12pt;">（31）冠状动脉旁路移植术：36.1</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体; font-size: 14pt;">&nbsp;</span><span style="font-family: 宋体;">“围手术期预防深静脉血栓栓塞”（DVT）与“围手术期预防感染”（PIP）有重复的病种：</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体;">（1） 闭合性心脏瓣膜切开术</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体;">（2） 心脏瓣膜置换术</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体;">（3） 脊柱颈融合术</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体;">（4） 脊柱再融合术</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体;">（5） 冠状动脉搭桥术</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体;">（6） 髋关节置换术</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体;">（7） 膝关节置换术</span></p>
<p style="white-space: normal;"><span style="font-family: 宋体;">因DVT中已包含PIP的内容，此种情况仅填写DVT，无需填报2次。</span></p>
<p>&nbsp;</p></div>' where Num='form-17'
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容：</p>
<div class="page" title="Page 58">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">主要手术 ICD-9-CM-3 编码如下的手术出院患者: </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">1.甲状腺叶切除术:06.2 至 06.5 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">2.膝半月软骨切除术:80.6</span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;"><br>3.晶状体相关手术:13.0 至 13.9</span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">4.腹股沟疝相关手术:17.11 至 17.13，17.21 至 17.24， 53.00 至 53.17 </span></p>
<span style="font-size: 12pt;"> </span>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">5.乳房组织相关手术:85.2 至 85.4 </span></p>
<span style="font-size: 12pt;"> </span>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">6.动脉内膜切除术:38.1</span></p>
</div>
</div>
<div class="layoutArea">
<div class="column"><span style="font-size: 12pt;"> </span></div>
<span style="font-size: 12pt;"> </span></div>
<span style="font-size: 12pt;"> </span></div>
<div class="page" title="Page 59"><span style="font-size: 12pt;"> </span>
<div class="layoutArea"><span style="font-size: 12pt;"> </span>
<div class="column"><span style="font-size: 12pt;"> </span>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">7.足和踝关节固定术和关节制动术:81.1 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">8.其他颅骨切开术:01.24 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">9.椎间盘切除术或破坏术:80.50 至 80.59 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">10.骨折切开复位+内固定术:03.53，21.72，76.72 至 76.79，79.30 至 79.39 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">11.关节脱位切开复位内固定术:76.94，79.8 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">12.骨内固定不伴骨折复位术及置入装置去除:78.5 至 78.6 </span></p>
<span style="font-size: 12pt;"> </span>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">13.卵巢相关手术:65.2 至 65.6 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">14.肌腱相关手术:83.11 至 83.14 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">15.睾丸相关手术:62.0 至 62.9 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">16.阴茎相关手术:64.0 至 64.4</span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">17.室间隔缺损修补术:35.62 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">18.房间隔缺损修补术:35.61 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">19.髋关节置换术:00.7，81.51 至 81.53 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">20.膝关节置换术:00.80 至 00.83，81.54，81.55 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">21.冠状动脉旁路移植术:36.1 </span></p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">22.剖宫产:74.0，74.1，74.2，74.4，74.99</span></p>
</div>
</div>
</div>
<p>&nbsp;</p>
<p>“围手术期预防感染”（PIP）与“围手术期预防深静脉血栓栓塞”（DVT）有重复的病种：</p>
<p>（1）&nbsp; &nbsp;闭合性心脏瓣膜切开术</p>
<p>（2）&nbsp; &nbsp;心脏瓣膜置换术</p>
<p>（3）&nbsp; &nbsp;脊柱颈融合术</p>
<p>（4）&nbsp; &nbsp;脊柱再融合术</p>
<p>（5）&nbsp; &nbsp;冠状动脉搭桥术</p>
<p>（6）&nbsp; &nbsp;髋关节置换术</p>
<p>（7）&nbsp; &nbsp;膝关节置换术</p>
<p>因DVT中已包含PIP的内容，此种情况仅填写DVT，无需填报2次。</p>
<div class="page" title="Page 59">
<div class="layoutArea">
<div class="column">
<p>&nbsp;</p>
</div>
</div>
</div></div>' where Num='form-18'
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<div class="page" title="Page 53">
<div class="layoutArea">
<div class="column">
<div class="page" title="Page 53">
<div class="layoutArea">
<div class="column">
<p><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:E10.3，E11.3，E14.3，H33.0 至 H33.5，H59.8，且伴主要手术 ICD-9-CM-3 编码:13.19，13.3， 13.41，13.42，13.43，13.59，13.64，13.65，13.69，13.70， 13.71，13.72，13.8，13.90，14.29，14.31，14.49，14.51， 14.52，14.53，14.54，14.59，14.71，14.72，14.73，14.75， 14.9 的手术出院患者。&nbsp;</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p>无需上报内容：</p>
<p>1.由外院住院诊疗后转入本院的病例</p>
<p>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;">3</span>.18岁以下的病例,</p>
<p><span style="white-space: pre;">4</span>.同一疾病30日内重复入院,</p>
<p><span style="white-space: pre;">5</span>.本次住院超过90天！</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>' where Num='form-38'
end

--修改部分上报说明
if exists(select * from  D_Disease_Category  where CHARINDEX('1.年龄大于18岁以及小于2岁的新生儿肺炎',DiseaseContent) > 0 and DCID=8)
begin
--cap
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:J13 至 J16，J18;2 岁≤年龄<18 岁的出院患儿。&nbsp;</span></p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.年龄大于18岁以及2岁以下</p>
<p><span style="white-space: pre;"> </span>2.由外院住院诊疗后转入本院,</p>
<p><span style="white-space: pre;"> </span>3.参与临床药物与器械试验,</p>
<p><span style="white-space: pre;"> </span>4.肺炎反复门诊抗菌素治疗无效,</p>
<p><span style="white-space: pre;"> </span>5.同一疾病30日内重复入院，</p>
<p><span style="white-space: pre;"> </span>6.呼吸机相关性肺炎VAP</p>
<p><span style="white-space: pre;"> </span>7.医院获得性肺炎HAP</p>
<p><span style="white-space: pre;"> </span>8.本次住院时间超过90天</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>' where DCID=8
--stk
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容：</p>
<p><span style="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断 ICD-10 编码:I63.0 至 I63.9 的出院患者。&nbsp;</span></p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.由外院诊疗后转入本院的病例</p>
<p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;"> </span>3.18岁以下的病例</p>
<p><span style="white-space: pre;"> </span>4.非首次确诊急性脑梗死患者</p>
<p><span style="white-space: pre;"> </span>5.脑梗死后遗症I69.3</p>
<p><span style="white-space: pre;"> </span>6.脑梗死反复门诊治疗无效</p>
<p><span style="white-space: pre;"> </span>7.同一疾病30日内重复入院</p>
<p><span style="white-space: pre;"> </span>8.腔隙性脑梗死</p>
<p><span style="white-space: pre;"> </span>9.小脑梗死</p>
<p><span style="white-space: pre;"> </span>10.出血性脑梗死</p>
<p><span style="white-space: pre;"> </span>11.本次住院天数大于90天</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>',
SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.住院时间小于24小时无需上报。</p>
</div>'where DCID=6
--cs
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容：</p>
<p><span style="font-family: FangSong; font-size: 12pt;">主要手术 ICD-9-CM-3 编码:74.0，74.1，74.2，74.4， 74.99 的手术出院患者。&nbsp;</span></p>
<div class="page" title="Page 36">
<div class="layoutArea">
<div class="column"><span style="font-size: 12pt;"> </span></div>
<span style="font-size: 12pt;"> </span></div>
<span style="font-size: 12pt;"> </span></div>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.由外院剖宫产术后转入本院的病例</p>
<p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;"> </span>3.18岁以下的病例</p>
<p><span style="white-space: pre;"> </span>4.同一疾病30日内重复入院</p>
<p><span style="white-space: pre;"> </span>5.本次住院超过90天</p>
<p><span style="white-space: pre;"> </span>6.病历记录孕期＜28周或不明的</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>',
SystemDescription='<div class="content">
<p>系统特别说明：</p>
<p>1.住院时间小于24小时无需上报。</p>
</div>'where DCID=10
--asd
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">ASD </span><span style="sans-serif; color: black;">房间隔缺损手术</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">上报内容：</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;"> </span></p>
<div class="page" title="Page 13">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 16.000000pt; "><span style="font-size: 12pt;">&nbsp; &nbsp; &nbsp;主要手术 ICD-9-CM-3 编码:35.51、35.52、35.61、35.71 的手术出院患者。</span>&nbsp;</span></p>
</div>
</div>
</div>
<div class="page" title="Page 13">&nbsp;</div>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family:sans-serif; color: black;">无需上报内容：</span></p>
<p style="text-indent: 28px; background: white;"><span style="font-family: sans-serif; color: black;">1.</span><span style="font-family: sans-serif; color: black;">参与临床药物与器械试验的病例,</span></p>
<p style="text-indent: 28px; background: white;"><span style="font-family:sans-serif; color: black;">2.</span><span style="font-family: sans-serif; color: black;">外院转入手术失敗病例</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">3.</span><span style="font-family: sans-serif; color: black;">本次住院超过90天</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">数据验证：</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span style="font-family: sans-serif; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:sans-serif; color: black;">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span style="font-family: sans-serif; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family: sans-serif; color: black;">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span style="font-family: sans-serif; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3. </span><span style="font-family:sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>' where DCID=30
--vsd
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">&nbsp;上报内容：</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span style="font-family: FangSong; font-size: 16pt;"><span style="font-size: 12pt;">&nbsp; 主要手术 ICD-9-CM-3 编码:35.53、35.55、35.62、35.72 的手术出院患者。</span>&nbsp;</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span style="font-family:sans-serif; color: black;">&nbsp;</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">&nbsp; &nbsp; &nbsp; 无需上报内容：</span></p>
<p style="text-indent: 28px; background: white;"><span style="font-family: sans-serif; color: black;">1.</span><span style="font-family: sans-serif; color: black;">参与临床药物与器械试验的病例,</span></p>
<p style="text-indent: 28px; background: white;"><span style="font-family: sans-serif; color: black;">2.</span><span style="font-family: sans-serif; color: black;">外院转入手术失敗病例</span></p>
<p style="text-indent: 28px; background: white;"><span style="font-family: sans-serif; color: black;">3.</span><span style="font-family: sans-serif; color: black;">本次住院超过90天</span></p>
<p style="text-indent: 28px; background: white;"><span style="font-family: sans-serif; color: black;">&nbsp;</span></p>
<p style="text-indent: 28px; background: white;"><span style="font-family: sans-serif; color: black;">数据验证：</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span style="font-family: sans-serif; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family: sans-serif; color: black;">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span style="font-family: sans-serif; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family: sans-serif; color: black;">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span style="font-family: sans-serif; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3. </span><span style="font-family: sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p>
<p>&nbsp;</p></div>' where DCID=31
--ddh
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<div class="page" title="Page 53">
<div class="layoutArea">
<div class="column">
<div class="page" title="Page 53">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt;">主要诊断 ICD-10 编码:Q65.0 至 Q65.6、Q65.8、Q65.9, 伴主要手术 ICD-9-CM-3 编码: 79.85、77.25、77.29;1岁 ≤年龄≤8 岁(旧称先天性髋关节脱位)的手术出院患儿。</span><span style="font-family: FangSong; font-size: 16pt;">&nbsp;</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p>1.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;">2.</span>年龄＜18个月或年龄＞8岁的患者</p>
<p><span style="white-space: pre;">3</span>.本次住院超过90天！</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>' where DCID=52
--vte
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p><!-- [if !supportLists]-->
<span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">上报内容：</span></span><br><br>
<span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">1.</span><span style="letter-spacing: -1.35pt;">
<span style="font-family: 宋体;">入住</span> </span>ICU<span style="letter-spacing: -1.05pt;">&nbsp;<span style="font-family: 宋体;">的患者</span></span></span><br>
<span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">2.</span><span style="font-family: 宋体;">中高危风险患者：</span></span><br>
<span style="font-size: 12pt; font-family: 宋体;"><span style="font-family: 宋体;">（</span>1）<span style="font-family: 宋体;">高龄（</span>≥70<span style="letter-spacing: -2.05pt;">&nbsp;<span style="font-family: 宋体;">岁</span></span><span style="font-family: 宋体;">）</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.35pt;">（2）</span><span style="letter-spacing: -1.35pt;"><span style="font-family: 宋体;">既往</span></span>VTE<span style="letter-spacing: -1.65pt;">&nbsp;<span style="font-family: 宋体;">病史或</span></span>VTE<span style="letter-spacing: -1.05pt;">&nbsp;<span style="font-family: 宋体;">家族史</span></span></span><br><span style="font-size: 12pt; font-family: 宋体;">（3）<span style="font-family: 宋体;">恶性肿瘤</span>(ICD-10<span style="letter-spacing: -0.75pt;">&nbsp;<span style="font-family: 宋体;">类目编码</span>:</span>C00-C97)</span><br><span style="font-size: 12pt; font-family: 宋体;">（4）<span style="font-family: 宋体;">严重创伤</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="font-family: 宋体;">（</span><span style="letter-spacing: 0.05pt;">5</span><span style="font-family: 宋体;">）</span><span style="font-family: 宋体;">脓毒症</span><span style="letter-spacing: 0.05pt;">(I</span><span style="letter-spacing: -0.1pt;">C</span><span style="letter-spacing: 0.05pt;">D-</span><span style="letter-spacing: -0.1pt;">1</span>0<span style="letter-spacing: -4.7pt;">&nbsp;</span><span style="font-family: 宋体;">亚目编码</span><span style="letter-spacing: -7.95pt;"><span style="font-family: 宋体;">：</span>“</span><span style="letter-spacing: 0.05pt;">A4</span><span style="letter-spacing: -0.1pt;">0</span><span style="letter-spacing: 0.05pt;">.</span><span style="letter-spacing: -0.1pt;">0</span><span style="letter-spacing: -7.95pt;"><span style="font-family: 宋体;">、</span></span>
<span style="letter-spacing: 0.05pt;">A4</span><span style="letter-spacing: -0.1pt;">0</span><span style="letter-spacing: 0.05pt;">.</span>
<span style="letter-spacing: -0.1pt;">1</span><span style="letter-spacing: -7.95pt;"><span style="font-family: 宋体;">、</span></span>
<span style="letter-spacing: 0.05pt;">A4</span><span style="letter-spacing: -0.1pt;">0</span><span style="letter-spacing: 0.05pt;">.</span>
<span style="letter-spacing: -0.1pt;">2</span><span style="font-family: 宋体;">、</span></span><br><span style="font-size: 12pt; font-family: 宋体;">A40.3<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A40.8<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A40.9<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A41.0<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A41.1<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A41.2<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A41.3、</span><br><span style="font-size: 12pt; font-family: 宋体;">A41.4、A41.5、A41.8、A41.9，R65.2、R65.3、R65.9)</span><br><span style="font-size: 12pt; font-family: 宋体;">（6）<span style="font-family: 宋体;">急性生理和慢性健康评分</span>⁃<span style="letter-spacing: -0.3pt;">Ⅱ（APACHE</span><span style="letter-spacing: -0.3pt;">⁃</span><span style="letter-spacing: -0.8pt;">Ⅱ）＞</span></span><span style="font-size: 12pt; font-family: 宋体;">12 分</span><br><span style="font-size: 12pt; font-family: 宋体;">（7）<span style="font-family: 宋体;">急诊手术及麻醉复苏室转入</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.35pt;">（8）</span><span style="letter-spacing: -1.35pt;"><span style="font-family: 宋体;">转入</span></span>ICU<span style="letter-spacing: -0.65pt;">&nbsp;<span style="font-family: 宋体;">前住院时间长</span></span><span style="font-family: 宋体;">（</span>&gt;30<span style="letter-spacing: -2pt;">&nbsp;<span style="font-family: 宋体;">天</span></span><span style="font-family: 宋体;">）</span></span><br><span style="font-size: 12pt; font-family: 宋体;">（9）<span style="font-family: 宋体;">制动</span></span><br><span style="font-size: 12pt; font-family: 宋体;">（10）<span style="font-family: 宋体;">机械通气</span>(ICD-9-CM-3<span style="letter-spacing: -0.8pt;">&nbsp;<span style="font-family: 宋体;">亚目编码：</span></span>96.7<span style="letter-spacing: -0.95pt;">&nbsp;<span style="font-family: 宋体;">其他持续侵入性机械性通气</span>,93.90、93.91</span><span style="letter-spacing: -0.55pt;">&nbsp;<span style="font-family: 宋体;">无创机械性通气</span>)</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="font-family: 宋体;">（</span><span style="letter-spacing: -6.05pt;">&nbsp;</span>11<span style="letter-spacing: -5.95pt;">&nbsp;</span><span style="font-family: 宋体;">）</span><span style="letter-spacing: 1.25pt;"><span style="font-family: 宋体;">留置中心静脉导管</span></span>(ICD-9-CM-3<span style="letter-spacing: 1pt;">&nbsp;<span style="font-family: 宋体;">亚目编码：</span> 89.60-89.69)</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（12）</span><span style="letter-spacing: -0.3pt;"><span style="font-family: 宋体;">血液净化治疗</span></span><span style="letter-spacing: 0.1pt;"><span style="font-family: 宋体;">（</span></span><span style="letter-spacing: 0.05pt;">IC</span><span style="letter-spacing: -0.1pt;">D</span><span style="letter-spacing: 0.05pt;">-9</span><span style="letter-spacing: -0.1pt;">-</span><span style="letter-spacing: 0.05pt;">CM</span><span style="letter-spacing: -0.1pt;">-</span>3<span style="letter-spacing: -4pt;">&nbsp;</span><span style="letter-spacing: -1.6pt;"><span style="font-family: 宋体;">亚目编码：</span>“</span><span style="letter-spacing: 0.05pt;">39</span><span style="letter-spacing: -0.1pt;">.</span><span style="letter-spacing: 0.05pt;">9</span><span style="letter-spacing: -0.1pt;">5</span><span style="letter-spacing: -7.95pt;">”</span><span style="font-family: 宋体;">）</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（13）</span><span style="font-family: 宋体;">使用肌肉松弛和镇静药物</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（14）</span><span style="font-family: 宋体;">应用收缩血管药物</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（15）</span><span style="font-family: 宋体;">输注血小板</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（16）</span><span style="font-family: 宋体;">血栓预防失败</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（17）</span><span style="font-family: 宋体;">医师认为需评估的其他中高风险患者</span></span><br><br><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;"><span style="font-family: 宋体; font-size: 14pt;">&nbsp;</span></span></span><br><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;"><span style="font-size: 12pt; font-family: 宋体;">无需上报内容</span></span></span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">1.患者年龄小于18岁</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">2.住院时间超过90天的患者</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">3.参与临床试验的患者</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">4.患者入住或转入ICU的主要诊断或其他诊断ICD-10代码中有以下</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">（1）栓塞和血栓形成ICD-10编码四位亚目及病种名称</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">（2）产科并发栓塞ICD-10编码四位亚目及名称</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">（3）神经内科脑梗死ICD-10编码四位亚目及病种名称</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">（4）精神科ICD-10编码（F00～99）及病种名称</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">5.患者入住或转入ICU的主要手术与操作名称与其ICD-9.CM.3代码中，有血管外科手术名称者（如血管内膜剥脱术等）</span><br><br><span style="font-size: 12pt;"><span style="font-family: 宋体;"><span style="line-height: 18.2px; background: #ffffff;">已报送“</span><span style="line-height: 18.2px; color: #0000ff; background: #ffffff;"><span style="color: #000000;">DVT,STK,STEMI</span>,</span></span><span style="line-height: 18.2px; background: #ffffff;">
<span style="font-family: 宋体;">TKR,THR,CABG,AVR,MVR,ASD,VSD"单病种质量监测信息</span>项者，不再重复报送！</span></span></p></div>' where DCID=36
--hbv
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:O98.4，Z22.5 + O80 至 O84+Z37; 且伴1阴道分娩操作 ICD-9-CM-3 编码 72.0 至 72.9，73.0， 73.1，73.21，73.4 至 73.6,73.9;或伴2剖宫产手术 ICD 9-CM-3 编码:74.0，74.1，74.2，74.4，74.99 的出院患者。&nbsp;</span></p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p>1.由外院住院诊疗后转入本院的病例</p>
<p>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;">3</span>.18岁以下的病例</p>
<p><span style="white-space: pre;">4.</span>同一疾病30日内重复入院</p>
<p><span style="white-space: pre;">5.</span>本次住院超过90天！</p>
<p>6.病历记录孕期＜28周或不明的</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>' where DCID=50
end

--根据卫健委变化将STEMI 编码为I21.9的数据再次进行调整
if exists(select * from  Report_Leak  where ReportClass = 1 and  DieaseICD like 'I21.9%'  and DealReport=0 )
update Report_Leak set DealReport=2
where ReportClass=1 and  DieaseICD like 'I21.9%'  and DealReport=0 

if exists(select * from D_MedicalRecord where ReportClass = 1 and JSON_VALUE(DataInfo,'$."CM-0-1-3-1"')='e' and DataVersion='2'  and Ncis_IsCheckToWsb=1)
update D_MedicalRecord set Ncis_IsCheckToWsb=0
where ReportClass = 1  and JSON_VALUE(DataInfo,'$."CM-0-1-3-1"')='e' and DataVersion='2' and Ncis_IsCheckToWsb=1

--cs 旧数据数据处理 是否有母乳喂养禁忌证、母乳喂养禁忌证选择
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CS-8-1-1"')='a'  and   DataVersion='2' and ReportClass =10 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CS-8-2-1"', 'n')
where JSON_VALUE(DataInfo,'$."CS-8-1-1"')='a'  and   DataVersion='2' and ReportClass =10 

if exists(select * from D_MedicalRecord  where  JSON_VALUE(DataInfo,'$."CS-8-1-1"')='a'  and  DataVersion='2' and ReportClass =10 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CS-8-1-1"', null),Ncis_IsJoinError=0
where JSON_VALUE(DataInfo,'$."CS-8-1-1"')='a'  and  DataVersion='2' and ReportClass =10 

--编码对应 APL添加 Z51.200
if not exists(select * from Report_ICDCodeMatch where ReportClass=49 and CodeType=10 and ICDCode like 'Z51.200%')
BEGIN
INSERT [dbo].[Report_ICDCodeMatch] ([ReportClass],[ICDCode],[MatchCode],[CodeType],[IsStart],[ICDCodeValue],[SuborderValue]) 
VALUES (49, N'Z51.200', N'Z51.200', N'10',1,N'd',N'b')
INSERT [dbo].[Report_ICDCodeMatch] ([ReportClass],[ICDCode],[MatchCode],[CodeType],[IsStart],[ICDCodeValue],[SuborderValue]) 
VALUES (49, N'Z51.200x008', N'Z51.200x008', N'10',1,N'e',N'b')
END

--将不符合条件的数据更改为无需上报
if exists(select * from  Report_Leak  where DealReport=3 )
update Report_Leak set DealReport=2 where DealReport=3

--自定义字典表
if exists(select * from syscolumns where id=object_id('Report_DropList') and name='ReportClass') 
BEGIN
	update Report_DropList set ReportClass=9 where Id=1
END

if exists(select * from syscolumns where id=object_id('Report_DropListValue') and name='ReportClass') 
BEGIN
	update Report_DropListValue set ReportClass=9 where DropListId=1
END

update D_Disease_Category set DiseaseDescription='围手术期预防深静脉血栓栓塞' where dcid=12 and DiseaseDescription='围手术期深静脉血栓'

update D_Disease_Category set DiseaseDescription='脑出血' where dcid=26

update D_MedicalRecord set Add_OperDeptId=0 where Add_OperDeptId is null

--暂时保留 开始--
--5.3.0版本医院未全部升级因此以下代码和5.3文件夹内代码重复，后期都普遍升级后此处可删除
--20210326卫健委变化
--住院24小时内出院  PACG 住院时间应大于24小时取消(存在日间手术) 
if exists(select * from  D_ReportStaticsQuota  where id=8 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,40,41,46,47,48,49,50,52' )
update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,40,41,46,47,48,49,50,52'  
where id=8 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,40,41,46,47,48,49,50,52'

--更新自动对接卫健委
if exists(select * from  Q_Options  where Name='NcisAutoOpenList' and Value<>'' and Value is not null)
update D_Disease_Category set IsNcisAutoOpen=1 
where IsNcisChange=1 and 
CHARINDEX(','+ cast(DCID as nvarchar(max)) +',',(select top 1 ','+ Value from Q_Options where Name='NcisAutoOpenList')) > 0
--将程序中卫健委变化标志取消
if exists(select * from  D_Disease_Category  where IsNcisChange=1)
update D_Disease_Category set IsNcisChange=null
where IsNcisChange=1
--更新公告
if exists(select * from  Report_InterAnnounce  where  IsTop=1 and CHARINDEX('因国家单病种平台填报内容发生变化',Title) > 0)
update Report_InterAnnounce set IsTop=0 
where  IsTop=1 and CHARINDEX('因国家单病种平台填报内容发生变化',Title) > 0
if exists(select * from  Q_Options where Name='NcisAutoOpenList' and Value<>'' and Value is not null)
update Q_Options set Value=''
where Name='NcisAutoOpenList' and Value<>'' and Value is not null

--病种重复病除外设置 VTE-BC
if exists(select * from  D_RepeatReportSetting  where ReportClass=36 and RepeatReportClass=17 and Icd9Code is null)
update D_RepeatReportSetting set Icd9Code='85.2、85.3、85.4'
where ReportClass=36 and RepeatReportClass=17 and Icd9Code is null

--pip 无需上报内容
if exists(select * from  D_Disease_Category  where SystemDescription like '%18岁以下的病例%' and DCID = 9)
update D_Disease_Category set SystemDescription='
<div class="content">
<p>系统特别说明：</p>
<p>1.同一疾病30日内重复入院，无需上报</p>
<p>2.本次住院天数大于90天，无法上报。</p>
</div>'
where SystemDescription like '%18岁以下的病例%' and DCID = 9

--无需上报条件 18岁以下的病例
if exists(select * from  D_ReportStaticsQuota  where id=1 and  ReportClassArr<>'1,2,3,4,5,6,7,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' )
update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' 
where id=1 and  ReportClassArr<>'1,2,3,4,5,6,7,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' 

--漏报设置更新科室改为关闭状态
if exists(select * from  D_Disease_Category  where HisDeptEnabled=1 )
update D_Disease_Category set HisDeptEnabled=0  
where HisDeptEnabled=1

--cacc 去除编码 O99.5
if exists(select * from  Report_Leak  where ReportClass = 47 and  DieaseICD like 'O99.5%'  and DealReport=0 )
update Report_Leak set DealReport=2
where ReportClass = 47 and  DieaseICD like 'O99.5%'  and DealReport=0 

--tia 去除编码G45.004
if exists(select * from  Report_Leak  where ReportClass = 13 and  DieaseICD like 'G45.004%'  and DealReport=0 )
update Report_Leak set DealReport=2
where ReportClass=13 and  DieaseICD like 'G45.004%'  and DealReport=0 

--根据处理记录更新漏报管理状态
update Report_Leak set NoMustReportReason=
(NoMustReportReason+' '+
(select top(1) ChangeNote from Report_LeakLog where Report_Leak.ID=Report_LeakLog.LeakId  order by ChangeDate desc)
),DealReport=2
where  id in (
select ID from (SELECT (select top(1) ChangeNote from Report_LeakLog where Report_Leak.ID=Report_LeakLog.LeakId  order by ChangeDate desc) as note 
,(select top(1) Status from Report_LeakLog where Report_Leak.ID=Report_LeakLog.LeakId  order by ChangeDate desc) as Status 
,*	  
FROM Report_Leak ) a   
where DealReport=0  and Status =2   
)

--原“数据统计”权限，改为“指标统计”
update Q_Quanxian set QuanxianName='指标统计' where QuanxianName='数据统计' and id=24
--数据预警将接口自动对接改为 对接失败
if exists(select * from  Q_DiseaseGrade  where DiseaseGradeID=5 and DiseaseGradeName='接口自动对接')
update Q_DiseaseGrade set DiseaseGradeName='对接失败'
where DiseaseGradeID=5 and DiseaseGradeName='接口自动对接'

--asd vsd 上报说明
--asd
if not exists(select * from  D_Disease_Category  where DiseaseContent like '%18岁人群%' and DCID = 30)
update D_Disease_Category set DiseaseContent=
'<div class="content">
<p style="background: white; margin: 0 0 10px 0;"><span>上报内容：</span></p>
<div class="column">
<p><span ><span style="font-size: 12pt;">&nbsp; &nbsp; &nbsp;主要手术 ICD-9-CM-3 编码:35.51、35.52、35.61、35.71 的手术出院患者。</span>&nbsp;</span></p>
</div>
<div class="page" title="Page 13">&nbsp;</div>
<p style="background: white; margin: 0 0 10px 0;"><span>无需上报内容：</span></p>
<p style="text-indent: 28px; background: white;"><span>1.参与临床药物与器械试验的病例,</span></p>
<p style="text-indent: 28px; background: white;"><span>2.外院转入手术失敗病例</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span>3.本次住院超过90天</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span>4.年龄＜2岁，年龄＞18岁人群</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span>数据验证：</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span>是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span>强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3. </span><span>其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>' 
where DCID = 30
--vsd
if not exists(select * from  D_Disease_Category  where DiseaseContent like '%18岁人群%' and DCID = 31)
update D_Disease_Category set DiseaseContent=
'<div class="content">
<p style="background: white; margin: 0 0 10px 0;"><span>上报内容：</span></p>
<div class="column">
<p><span ><span style="font-size: 12pt;">&nbsp; &nbsp; &nbsp;主要手术 ICD-9-CM-3 编码:35.53、35.55、35.62、35.72 的手术出院患者。 </span>&nbsp;</span></p>
</div>
<div class="page" title="Page 13">&nbsp;</div>
<p style="background: white; margin: 0 0 10px 0;"><span>无需上报内容：</span></p>
<p style="text-indent: 28px; background: white;"><span>1.参与临床药物与器械试验的病例,</span></p>
<p style="text-indent: 28px; background: white;"><span>2.外院转入手术失敗病例</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span>3.本次住院超过90天</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span>4.年龄＜2岁，年龄＞18岁人群</span></p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span>数据验证：</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span>是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span>强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
<p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3. </span><span>其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>' 
where DCID = 31

--无需上报条件 年龄大于等于18岁以及小于2岁的新生儿
if exists(select * from  D_ReportStaticsQuota  where id=2 and  ReportClassArr<>'8,30,31,47,' )
update D_ReportStaticsQuota set ReportClassArr='8,30,31,47,' 
where id=2 and  ReportClassArr<>'8,30,31,47,' 


--修改口腔种植术的说明文字
if exists(select * from  D_Disease_Category  where DiseaseContent like '%18岁以上%' and DCID = 51)
update D_Disease_Category set DiseaseContent=
'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">OIT</span><span style="font-family:微软雅黑,sans-serif;color:black">口腔种植术</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要手术 ICD-9-CM-3 编码:23.5，23.6 的门诊患者或 者 76.09，76.91，76.92，22.79 的手术出院患者。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
<p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.18岁以下的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.同一疾病30日内重复入院的病例</span> </p>
<p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.本次住院超过90天的病例</span> </p>
<p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>' 
where DCID = 51

--修改vte抽取规则
if exists(select * from  D_Disease_Category  where LeakExtractRule<>0 and  DCID =36)
update D_Disease_Category set LeakExtractRule=0 
where  LeakExtractRule<>0 and  DCID =36


--设定 [DataBaseAutoBak] AutoDbBakAtMinute默认值0
if exists(select * from  [DataBaseAutoBak]  where AutoDbBakAtMinute is null )
update [DataBaseAutoBak] set AutoDbBakAtMinute=0 
where AutoDbBakAtMinute is null

--无需上报条件 同一疾病30日内重复入院
if exists(select * from  D_ReportStaticsQuota  where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' )
update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' 
where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' 

--对接卫健委code旧数据赋值
if exists(select * from  D_MedicalRecord  where Ncis_JoinErrorMessage like '%该项为必填项，请进行填写%' and Ncis_IsJoinError=1)
update D_MedicalRecord set Ncis_JoinCode=1000 
where Ncis_JoinErrorMessage like '%该项为必填项，请进行填写%' and Ncis_IsJoinError=1

--在1.1版本数据中对应添加2.0数据统计需要字段
--离院方式
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-4-3"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=
JSON_MODIFY(DataInfo, '$."CM-4-3"',
case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-2-1"')   --STEMI 
	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-2-1"')    --HF
	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-2-1"')   --Cap-Adult
	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-2"')   --Hip
	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-2"')    --Knee
	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-2-1"')    --STK
	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-2"')    --CABG
	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-2-1"')   --Cap 
	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-2"')    --PIP
	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-2"')   --CS
	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-2-1"')   --AECOPD
	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-2"')   --DVT
	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-2-1"')   --TIA
	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-2-1"')   --HBIPS
	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-2-1"')   --TC
	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-2-1"')   --LC
	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-2-1"')   --BC
end
)where DataVersion='1.1'
--入院日期时间
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-0-2-4-1"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=
JSON_MODIFY(DataInfo, '$."CM-0-2-4-1"',
case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-0-2-4"')   --STEMI
	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-0-2-4"')   --HF
	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-0-2-4"')   --Cap-Adult
	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-0-2-2-1"')   --Hip
	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-0-2-2"')   --Knee
	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-0-2-4"')   --STK
	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-0-2-2"')   --CABG
	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-0-2-4"')   --Cap
	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-0-2-2-1"')   --PIP
	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-0-2-4"')  --CS
	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-0-2-4"')  --AECOPD
	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-0-2-2-1"')  --DVT
	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-0-2-4"')  --TIA
	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-0-3-1"')  --HBIPS
	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-0-2-4"')  --TC
	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-0-2-4"')  --LC
	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-0-2-4-1"')  --BC
end 
)where DataVersion='1.1'
--出院日期时间
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-0-2-4-2"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=
JSON_MODIFY(DataInfo, '$."CM-0-2-4-2"', 
case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-0-2-5"')   --STEMI
	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-0-2-5"')   --HF
	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-0-2-5"')   --Cap-Adult
	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-0-2-3"')   --Hip
	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-0-2-3"')   --Knee
	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-0-2-5"')   --STK
	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-0-2-3"')   --CABG
	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-0-2-5"')   --Cap
	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-0-2-3"')   --PIP
	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-0-2-5"')  --CS
	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-0-2-5"')  --AECOPD
	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-0-2-3"')  --DVT
	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-0-2-5"')  --TIA
	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-0-3-2"')  --HBIPS
	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-0-2-5"')  --TC
	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-0-2-5"')  --LC
	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-0-2-4-2"')  --BC
end
) where DataVersion='1.1'
--住院总费用
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-6-1"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=
JSON_MODIFY(DataInfo, '$."CM-6-1"', 
case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-3-1"')   --STEMI
	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-3-1"')   --HF
	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-3-1"')   --Cap-Adult
	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-4-1"')   --Hip
	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-4-1"')   --Knee
	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-3-1"')   --STK
	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-4-1"')   --CABG
	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-3-1"')   --Cap
	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-4-1"')   --PIP
	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-4-1"')  --CS
	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-3-1"')  --AECOPD
	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-4-1"')  --DVT
	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-3-1"')  --TIA
	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-3-1"')  --HBIPS
	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-3-1"')  --TC
	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-3-1"')  --LC
	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-3-1"')  --BC
end
) where DataVersion='1.1'
--手术治疗费
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-6-13"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=
JSON_MODIFY(DataInfo, '$."CM-6-13"', 
case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-3-5"')   --STEMI
	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-3-5"')   --HF
	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-3-5"')   --Cap-Adult
	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-4-5"')   --Hip
	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-4-5"')   --Knee
	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-3-5"')   --STK
	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-4-5"')   --CABG
	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-3-5"')   --Cap
	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-4-5"')   --PIP
	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-4-5"')  --CS
	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-3-5"')  --AECOPD
	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-4-5"')  --DVT
	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-3-5"')  --TIA
	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-3-5"')  --HBIPS
	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-3-5"')  --TC
	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-3-5"')  --LC
	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-3-5"')  --BC
end
) where DataVersion='1.1'
--西药费
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-6-18"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=
JSON_MODIFY(DataInfo, '$."CM-6-18"', 
case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-3-2"')   --STEMI
	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-3-2"')   --HF
	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-3-2"')   --Cap-Adult
	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-4-2"')   --Hip
	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-4-2"')   --Knee
	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-3-2"')   --STK
	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-4-2"')   --CABG
	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-3-2"')   --Cap
	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-4-2"')   --PIP
	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-4-2"')  --CS
	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-3-2"')  --AECOPD
	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-4-2"')  --DVT
	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-3-2"')  --TIA
	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-3-2"')  --HBIPS
	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-3-2"')  --TC
	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-3-2"')  --LC
	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-3-2"')  --BC
end
) where DataVersion='1.1'
--中成药费
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-6-20"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=
JSON_MODIFY(DataInfo, '$."CM-6-20"', 
case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-3-3"')   --STEMI
	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-3-3"')   --HF
	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-3-3"')   --Cap-Adult
	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-4-3"')   --Hip
	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-4-3"')   --Knee
	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-3-3"')   --STK
	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-4-3"')   --CABG
	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-3-3"')   --Cap
	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-4-3"')   --PIP
	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-4-3"')  --CS
	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-3-3"')  --AECOPD
	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-4-3"')  --DVT
	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-3-3"')  --TIA
	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-3-3"')  --HBIPS
	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-3-3"')  --TC
	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-3-3"')  --LC
	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-3-3"')  --BC
end
) where DataVersion='1.1'
--评价
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-1"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-1"', 'y') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-1"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-1"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-2"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-2"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-3"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-3"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-4"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-4"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-5"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-5"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-6"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-6"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-7"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-7"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-8"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-8"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-9"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-9"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-10"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-10"', 'a') where DataVersion='1.1'
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-11"') is null  and  DataVersion='1.1' )
update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-11"', 'a') where DataVersion='1.1'

--手术并发症
if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-2-1"') is null  and  DataVersion='1.1' and ReportClass in (4,5,7,9,12,15,16,17) )
update D_MedicalRecord set DataInfo=
JSON_MODIFY(DataInfo, '$."CM-2-1"', 
case 
when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-7-1"')   --Hip
when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-7-1"')   --Knee
when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-6-2-1"')   --CABG
when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-3-1"')   --PIP	 
when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-3-1"')  --DVT
when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-3-1"')  --TC
when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-6-1"')  --LC
when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-7-1"')  --BC 
end
) where DataVersion='1.1' and ReportClass in (4,5,7,9,12,15,16,17)

--sep 去除编码 B73.7、R65.2、R65.3、R65.9
if exists(select * from  Report_Leak  where ReportClass = 35 and 
(DieaseICD like '%B73.7%' or DieaseICD like '%R65.2%' or DieaseICD like '%R65.3%' or DieaseICD like '%R65.9%'
or ICD10_oth like '%B73.7%' or ICD10_oth like '%R65.2%' or ICD10_oth like '%R65.3%' or ICD10_oth like '%R65.9%'
) 
and DieaseICD not like '%A0%' and  DieaseICD not like '%A2%'  and  DieaseICD not like '%A3%' and  DieaseICD not like '%A4%' 
and  DieaseICD not like '%A5%'  and  DieaseICD not like '%B3%'  
and ICD10_oth not like '%A0%' and  ICD10_oth not like '%A2%'  and  ICD10_oth not like '%A3%' and  ICD10_oth not like '%A4%' 
and  ICD10_oth not like '%A5%'  and  ICD10_oth not like '%B3%'
and DealReport=0 )
update Report_Leak set DealReport=2,NoMustReportReason='B73.7、R65.2、R65.3、R65.9 无需上报'
where ReportClass = 35 and (DieaseICD like '%B73.7%' or DieaseICD like '%R65.2%' or DieaseICD like '%R65.3%' or DieaseICD like '%R65.9%'
or ICD10_oth like '%B73.7%' or ICD10_oth like '%R65.2%' or ICD10_oth like '%R65.3%' or ICD10_oth like '%R65.9%'
) 
and DieaseICD not like '%A0%' and  DieaseICD not like '%A2%'  and  DieaseICD not like '%A3%' and  DieaseICD not like '%A4%' 
and  DieaseICD not like '%A5%'  and  DieaseICD not like '%B3%'  
and ICD10_oth not like '%A0%' and  ICD10_oth not like '%A2%'  and  ICD10_oth not like '%A3%' and  ICD10_oth not like '%A4%' 
and  ICD10_oth not like '%A5%'  and  ICD10_oth not like '%B3%'
and DealReport=0 

--sep上报说明
if  exists(select * from  D_Disease_Category  where DiseaseContent like '%R65.2%' and DCID = 35)
update D_Disease_Category set DiseaseContent=
'<div class="content"><p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;">上报内容</span></span></p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;"> </span></span></p>
<div class="page" title="Page 65">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong;">主要诊断/其他诊断 ICD-10 编码:A02.1，A22.7，A32.7， A40.1 至 A40.9， A41.0 至 A41.9，A42.7，A54.8，B37.7的出院患者。&nbsp;</span></p>
<p>&nbsp;</p>
<span style="font-size: 12pt;"> </span></div>
<span style="font-size: 12pt;"> </span></div>
<span style="font-size: 12pt;"> </span></div>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;">无需上报内容</span></span></p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;">&nbsp;</p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: -apple-system; line-height: 19.0667px; color: #333333; font-size: 11pt;">1、参与临床药物与器械试验的病例</span></p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: -apple-system; line-height: 19.0667px; color: #333333; font-size: 11pt;">2、到达医院前,已经被确认采取安慰治疗或姑息治疗者</span></p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: -apple-system; line-height: 19.0667px; color: #333333; font-size: 11pt;">3、18岁以下的病例</span></p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: -apple-system; line-height: 19.0667px; color: #333333; font-size: 11pt;">4、本次住院天数大于90天</span></p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: -apple-system; line-height: 19.0667px; color: #333333; font-size: 11pt;">5、由外院感染性休克诊疗后转入本院的病例</span></p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: -apple-system; line-height: 19.0667px; color: #333333; font-size: 11pt;">6、在医师病程记录，有在严重脓毒症出现后3小时内出现被确认采取安慰治疗或姑息治疗的医嘱</span></p>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: -apple-system; line-height: 19.0667px; color: #333333; font-size: 11pt;">7、在医师病程记录，在感染性休克出现后6小时内出现被确认采取安慰治疗或姑息治疗的医嘱</span></p>
<p class="MsoNormal" style="margin: 0pt 0pt 0.0001pt; text-align: justify; font-family: Calibri; font-size: 10.5pt;"><span style="font-size: 10.5pt;">&nbsp;</span></p></div>' 
where DCID = 35

--HBV上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%任意一项诊断%' and DCID = 50)
update D_Disease_Category set DiseaseContent='
<div class="content"><p>上报内容：</p>
<div class="page">
<p><span>出院诊断中任意一项诊断(包含主要诊断和其他诊断)编码为:O98.4，Z22.5 + O80 至 O84+Z37; 且伴1阴道分娩操作 ICD-9-CM-3 编码 72.0 至 72.9，73.0， 73.1，73.21，73.4 至 73.6,73.9;或伴2剖宫产手术 ICD 9-CM-3 编码:74.0，74.1，74.2，74.4，74.99 的出院患者。 </span></p>
</div>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p>1.由外院住院诊疗后转入本院的病例</p>
<p>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;">3</span>.18岁以下的病例</p>
<p><span style="white-space: pre;">4.</span>同一疾病30日内重复入院</p>
<p><span style="white-space: pre;">5.</span>本次住院超过90天！</p>
<p>6.病历记录孕期＜28周或不明的</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>'
where DiseaseContent  not like '%任意一项诊断%' and DCID = 50

--HF上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%本次住院天数大于90天%' and DCID = 2)
update D_Disease_Category set DiseaseContent='
<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="font-size: 12pt;"><span style="white-space: pre;"> </span>1.<span style="font-family: FangSong;">主要诊断原发病 ICD-10 编码:I05 至 I09、或 I11 至 I13、 或 I20 至 I21、或 I40 至 I41、或 I42 至 I43 伴第二诊断为 I50 的出院患者。&nbsp;</span></span></p>
<p><span style="font-size: 12pt;"> </span></p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.由外院诊疗后转入本院的病例</p>
<p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;"> </span>3.非心源性的心力衰竭和各种疾病的终末情况</p>
<p><span style="white-space: pre;"> </span>4.心功能Ⅰ级的病例</p>
<p><span style="white-space: pre;"> </span>5.18岁以下的病例</p>
<p><span style="white-space: pre;"> </span>6.同一疾病30日内重复入院</p>
<p><span style="white-space: pre;"> </span>7.心脏外科手术后</p>
<p><span style="white-space: pre;"> </span>8.产科手术和操作的其他并发症（O75.4）</p>
<p><span style="white-space: pre;"> </span>9.流产、异位妊娠或葡萄胎妊娠（O00～O07、O08.8）</p>
<p><span style="white-space: pre;"> </span>10.新生儿心力衰竭（P29.0）</p>
<p><span style="white-space: pre;"> </span>11.继发性高血压 （I15）</p>
<p><span style="white-space: pre;"> </span>12.入院前心脏有各类置入物（心脏起搏、除颤等辅助装置，ICD-9-CM-3编码37.61003～37.95001）</p>
<p><span style="white-space: pre;"> </span>13.本次住院天数大于90天</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>'
where DiseaseContent  not like '%本次住院天数大于90天%' and DCID = 2

--CABG 上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%本次住院超过90天%' and DCID = 7)
update D_Disease_Category set DiseaseContent='
<div data-v-c0d7d944="" class="content"><p>CABG 冠状动脉旁路移植术</p>
<p>上报内容</p>
<p><span style="font-size: 12pt;"><span style="font-family: FangSong_GB2312;">主要手术 ICD-9-CM-3 编码:36.1 的手术出院患者</span></span></p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.参与临床药物与器械试验的病例,</p>
<p><span style="white-space: pre;"> </span>2.18岁以下的病例,</p>
<p><span style="white-space: pre;"> </span>3.同一疾病30日内重复入院,</p>
<p><span style="white-space: pre;"> </span>4.本次住院超过90天！</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>'
where DiseaseContent  not like '%本次住院超过90天%' and DCID = 7
--Knee 上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%本次住院超过90天%' and DCID = 5)
update D_Disease_Category set DiseaseContent='
<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<div class="page" title="Page 34">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong;">主要手术 ICD-9-CM-3 编码:00.80 至 00.84，81.54， 81.55 的手术出院患者。&nbsp;</span></p>
</div>
</div>
</div>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.参与临床药物与器械试验的病例,</p>
<p><span style="white-space: pre;"> </span>2.18岁以下的病例,</p>
<p><span style="white-space: pre;"> </span>3.同一疾病30日内重复入院,</p>
<p><span style="white-space: pre;"> </span>4.本次住院超过90天！</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>'
where DiseaseContent  not like '%本次住院超过90天%' and DCID = 5
--Hip 上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%本次住院超过90天%' and DCID = 4)
update D_Disease_Category set DiseaseContent='
<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<div class="page" title="Page 33">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong;">主要手术 ICD-9-CM-3 编码:00.7，81.51 至 81.53 的手术出院患者。&nbsp;</span></p>
</div>
</div>
</div>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.参与临床药物与器械试验的病例,</p>
<p><span style="white-space: pre;"> </span>2.18岁以下的病例,</p>
<p><span style="white-space: pre;"> </span>3.同一疾病30日内重复入院,</p>
<p><span style="white-space: pre;"> </span>4.本次住院超过90天！</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>'
where DiseaseContent  not like '%本次住院超过90天%' and DCID = 4
--STEMI 上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent  like '%I21.3、I21.9的病例%' and DCID = 1)
update D_Disease_Category set DiseaseContent='
<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="white-space: pre;"> </span> 1.主要诊断疾病编码（ICD-10）为I21.0~I21.3的病例</p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.由外院诊疗后转入本院的病例</p>
<p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;"> </span>3.18岁以下的病例</p>
<p><span style="white-space: pre;"> </span>4.非首次确诊急性心肌梗死患者</p>
<p><span style="white-space: pre;"> </span>5.同一疾病30日内重复入院</p>
<p><span style="white-space: pre;"> </span>6.本次住院天数大于90天</p>
<p><span style="white-space: pre;"> </span>7.急性小灶心肌梗死 ICD-10 I21.401 </p>
<p><span style="white-space: pre;"> </span>8.急性心内膜下心肌梗死 ICD-10 I21.402 </p>
<p><span style="white-space: pre;"> </span>9.非ST抬高性心肌梗死 ICD-10 I21.403 </p>
<p><span style="white-space: pre;"> </span>10.非冠心病心肌梗死 ICD-10 I21.901</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>'
where DiseaseContent  like '%I21.3、I21.9的病例%' and DCID = 1

--AF 上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent not like '%18岁以下人群%' and DCID = 32)
update D_Disease_Category set DiseaseContent='
<div data-v-c0d7d944="" class="content">
<p style="background: white;"><span style=" color: black;">上报内容</span></p>
<p style="background: white;"><span style="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断/其他诊断ICD-10 编码:I48 的出院患者 </span></p>
<p style="background: white;">&nbsp;</p>
<p style="background: white;"><span style="color: black;">无需上报内容：</span></p>
<p style="background: white;"><span style="color: black;">1.</span><span style=" color: black;">参与临床药物与器械试验的病例,</span></p>
<p style="background: white;"><span style="color: black;">2.</span><span style=" color: black;">有记录的理由不列质控管理的病例,</span></p>
<p style="background: white;"><span style="color: black;">3.</span><span style=" color: black;">本次住院超过90天！</span></p>
<p style="background: white;"><span style="color: black;">4.</span><span style=" color: black;">18岁以下人群</span></p>
<p style="background: white;">&nbsp;</p>
<p style="background: white;"><span style=" color: black;">数据验证：</span></p>
<p style="background: white;"><span style="box-sizing: border-box;">1. *</span><span style=" color: black;">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
<p style="background: white;"><span style="box-sizing: border-box;">2. </span><span style=" color: black;">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
<p style="background: white;"><span style="box-sizing: border-box;">3. </span><span style=" color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p></div>'
where DiseaseContent  not like '%18岁以下人群%' and DCID = 32

--HF上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%主要诊断/其他诊断原发病%' and DCID = 2)
update D_Disease_Category set DiseaseContent='
<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="font-size: 12pt;"><span style="white-space: pre;"> </span>1.<span style="font-family: FangSong;">1.主要诊断/其他诊断原发病 ICD-10 编码:I05 至 I09、或 I11 至 I13、 或 I20 至 I21、或 I40 至 I41、或 I42 至 I43 伴第二诊断为 I50 的出院患者。</span></span></p>
<p><span style="font-size: 12pt;"> </span></p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1.由外院诊疗后转入本院的病例</p>
<p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;"> </span>3.非心源性的心力衰竭和各种疾病的终末情况</p>
<p><span style="white-space: pre;"> </span>4.心功能Ⅰ级的病例</p>
<p><span style="white-space: pre;"> </span>5.18岁以下的病例</p>
<p><span style="white-space: pre;"> </span>6.同一疾病30日内重复入院</p>
<p><span style="white-space: pre;"> </span>7.心脏外科手术后</p>
<p><span style="white-space: pre;"> </span>8.产科手术和操作的其他并发症（O75.4）</p>
<p><span style="white-space: pre;"> </span>9.流产、异位妊娠或葡萄胎妊娠（O00～O07、O08.8）</p>
<p><span style="white-space: pre;"> </span>10.新生儿心力衰竭（P29.0）</p>
<p><span style="white-space: pre;"> </span>11.继发性高血压 （I15）</p>
<p><span style="white-space: pre;"> </span>12.入院前心脏有各类置入物（心脏起搏、除颤等辅助装置，ICD-9-CM-3编码37.61003～37.95001）</p>
<p><span style="white-space: pre;"> </span>13.本次住院天数大于90天</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>'
where DiseaseContent  not like '%主要诊断/其他诊断原发病%' and DCID = 2

--省市区县字段名更改
--DPD
if exists(select * from D_MedicalRecord  where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-4"') is not null  and  DataVersion='2' and ReportClass =45 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."provinceId"',  JSON_VALUE(DataInfo,'$."DPD-0-1-4-4"'))
where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-4"') is not null  and  DataVersion='2' and ReportClass =45 

if exists(select * from D_MedicalRecord  where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-5"') is not null  and  DataVersion='2' and ReportClass =45 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."cityId"',  JSON_VALUE(DataInfo,'$."DPD-0-1-4-5"'))
where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-5"') is not null  and  DataVersion='2' and ReportClass =45 

if exists(select * from D_MedicalRecord  where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-6"') is not null  and  DataVersion='2' and ReportClass =45 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."areaId"',  JSON_VALUE(DataInfo,'$."DPD-0-1-4-6"'))
where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-6"') is not null  and  DataVersion='2' and ReportClass =45 

--HD
if exists(select * from D_MedicalRecord  where  JSON_VALUE(DataInfo,'$."HD-0-1-4-1"') is not null  and  DataVersion='2' and ReportClass =44 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."provinceId"',  JSON_VALUE(DataInfo,'$."HD-0-1-4-1"'))
where  JSON_VALUE(DataInfo,'$."HD-0-1-4-1"') is not null  and  DataVersion='2' and ReportClass =44 

if exists(select * from D_MedicalRecord  where  JSON_VALUE(DataInfo,'$."HD-0-1-4-4"') is not null  and  DataVersion='2' and ReportClass =44 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."cityId"',  JSON_VALUE(DataInfo,'$."HD-0-1-4-4"'))
where  JSON_VALUE(DataInfo,'$."HD-0-1-4-4"') is not null  and  DataVersion='2' and ReportClass =44 

if exists(select * from D_MedicalRecord  where  JSON_VALUE(DataInfo,'$."HD-0-1-4-5"') is not null  and  DataVersion='2' and ReportClass =44 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."areaId"',  JSON_VALUE(DataInfo,'$."HD-0-1-4-5"'))
where  JSON_VALUE(DataInfo,'$."HD-0-1-4-5"') is not null  and  DataVersion='2' and ReportClass =44 

--编码范围调整 未报改为无需上报
--GC 43.8904
if exists(select * from  Report_Leak  where ReportClass = 33 and  OpertationICD like '43.8904%'  and DealReport=0 )
update Report_Leak set DealReport=2
where ReportClass=33 and  OpertationICD like '43.8904%'  and DealReport=0 
--TN 06.1
if exists(select * from  Report_Leak  where ReportClass = 37 and  OpertationICD like '06.1%'  and DealReport=0 )
update Report_Leak set DealReport=2
where ReportClass=37 and  OpertationICD like '06.1%'  and DealReport=0 

--同一疾病30日内重复入院
if exists(select * from  D_ReportStaticsQuota  where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,9,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' )
update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,9,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,'
where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,9,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' 

--VTE重复病例默认勾选上以下病种
update D_RepeatReportSetting set [Enabled]=1
where ReportClass=36 and RepeatReportClass in(12,6,1,4,5,7,29,24,30,31)



--PACG编码调整
  UPDATE Report_ICDCodeMatch Set SuborderValue='b' Where ReportClass=39 AND ICDCode like 'H40.0%'
  UPDATE Report_ICDCodeMatch Set SuborderValue='c' Where ReportClass=39 AND ICDCode like 'H40.2%'
  UPDATE Report_ICDCodeMatch Set SuborderValue='a' Where ReportClass=39 AND ICDCode like 'H26.2%'
  UPDATE Report_ICDCodeMatch Set SuborderValue='oth' Where ReportClass=39 AND ICDCode like 'H40.9%'

--HBV上报说明
if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%O98.1,B24,%' and DCID = 50)
update D_Disease_Category set DiseaseContent='
<div class="content"><p>上报内容：</p>
<div class="page">
<p><span>出院诊断中任意一项诊断(包含主要诊断和其他诊断)编码为:O98.4,O98.1,B24,Z22.5 + O80 至 O84+Z37; 且伴1阴道分娩操作 ICD-9-CM-3 编码 72.0 至 72.9，73.0， 73.1，73.21，73.4 至 73.6,73.9;或伴2剖宫产手术 ICD 9-CM-3 编码:74.0，74.1，74.2，74.4，74.99 的出院患者。 </span></p>
</div>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p>1.由外院住院诊疗后转入本院的病例</p>
<p>2.参与临床药物与器械试验的病例</p>
<p><span style="white-space: pre;">3</span>.18岁以下的病例</p>
<p><span style="white-space: pre;">4.</span>同一疾病30日内重复入院</p>
<p><span style="white-space: pre;">5.</span>本次住院超过90天！</p>
<p>6.病历记录孕期＜28周或不明的</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>'
where DiseaseContent  not like '%O98.1,B24,%' and DCID = 50

--暂时保留 结束--