﻿if not exists(select * from sysobjects where id=object_id('D_ReportStaticsQuota'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[D_ReportStaticsQuota](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ReportClassArr] [nvarchar](200) NULL,
	[StaticsQuotaName] [nvarchar](500) NULL,
	[StaticsQuotaValue] [nvarchar](20) NULL,
	[ZBIndex] [int] NOT NULL,
 CONSTRAINT [PK_D_ReportStaticsQuota] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
'
SET IDENTITY_INSERT [dbo].[D_ReportStaticsQuota] ON 

INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (1, N'1,2,3,4,5,6,7,10,11,13,15,16,17,19,21,22,23,24,25,26,27,28,29,33,35,36,37,', N'18岁以下的病例', N'-18Y', 2)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (2, N'8,', N'年龄大于18岁的病例，及出生28天的新生儿肺炎', N'-2Y|18Y-', 2)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (3, N'3,', N'本次住院时间超过60天', N'60D-', 3)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (4, N'8,11,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,', N'本次住院超过90天', N'90D-', 3)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (5, N'1,2,4,5,6,7,10,13,', N'本次住院天数大于120天', N'120D-', 3)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (6, N'14,', N'住院时间＞365天（一年）', N'365D-', 3)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (8, N'14,', N'住院24小时内出院', NULL, 4)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (9, N'14,15,16,17,33,', N'住院24小时内死亡', N'e,5', 4)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (10, N'15,16,17,33,', N'在入院后24小时内转院的病人', N'b,c,2,3', 4)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (11, N'15,16,17,', N'在入院后24小时内非医嘱离院的病人', N'd,4', 4)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (12, N'1,2,3,4,5,6,7,8,10,11,13,', N'同一疾病30日内重复入院', NULL, 5)
SET IDENTITY_INSERT [dbo].[D_ReportStaticsQuota] OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病种类型id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_ReportStaticsQuota', @level2type=N'COLUMN',@level2name=N'ReportClassArr'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排除项' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_ReportStaticsQuota', @level2type=N'COLUMN',@level2name=N'StaticsQuotaName'

End

--疾病系统分类
if not exists(select * from sysobjects where id=object_id('D_DiseaseSystem'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[D_DiseaseSystem](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[DiseaseSystemName] [nvarchar](50) NULL,
	[Sort] [int] NULL,
 CONSTRAINT [PK_D_DiseaseSystem] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
'
SET IDENTITY_INSERT [dbo].[D_DiseaseSystem] ON
INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (1, N'呼吸系统疾病/手术 ', 1)
INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (2, N'神经系统疾病/手术', 2)
INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (3, N'生殖系统疾病/手术', 3)
INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (4, N'心血管系统疾病/手术', 4)
INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (5, N'运动系统疾病/手术', 5)
INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (6, N'肿瘤(手术治疗)', 6)
INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (7, N'其他疾病/手术', 7)
SET IDENTITY_INSERT [dbo].[D_DiseaseSystem] OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'疾病系统分类名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_DiseaseSystem', @level2type=N'COLUMN',@level2name=N'DiseaseSystemName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_DiseaseSystem', @level2type=N'COLUMN',@level2name=N'Sort'
End

if not exists(select * from sysobjects where id=object_id('D_Disease_Category'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[D_Disease_Category](
	[DCID] [int] IDENTITY(1,1) NOT NULL,
	[DiseaseType] [nvarchar](50) NOT NULL,
	[DiseaseType_API] [nvarchar](50) NULL,
	[DiseaseSystem] [int] NOT NULL,
	[DiseaseDescription] [nvarchar](100) NOT NULL,
	[SortID] [int] NOT NULL,
	[Enabled] [bit] NOT NULL,
	[Num] [nvarchar](20) NOT NULL,
	[IsOpen] [bit] NOT NULL,
	[DiseaseContent] [nvarchar](max) NULL,
	[IsLeakOpen] [bit] NULL,
	[ByMonth_StartYear] [int] NULL,
	[ByMonth_StartMonth] [int] NULL,
	[ByMonth_CurrentYear] [int] NULL,
	[ByMonth_CurrentMonth] [int] NULL,
	[ByDay_StartDate] [datetime] NULL,
	[ByDay_CurrentDate] [datetime] NULL,
	[ByDay_LeakDay] [int] NULL,
	[LastLeakDate] [datetime] NULL,
	[HisDeptList] [nvarchar](max) NULL,
	[HisDeptEnabled] [bit] NULL,
	[LeakExtractRuleEnabled] [bit] NULL,
	[LeakExtractRule] [int] NULL,
 CONSTRAINT [PK_D_Disease_Category] PRIMARY KEY CLUSTERED 
(
	[DCID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
'

SET IDENTITY_INSERT [dbo].[D_Disease_Category] ON 
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]) VALUES (1, N'STEMI', N'AMI', 4, N'急性心肌梗死（ST 段抬高型，首次住院）', 1, 1, N'form-1', 1, N'<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="white-space: pre;"> </span>1.主要诊断疾病编码（ICD-10）为I21.0~I21.3、I21.9的病例</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.本次住院天数大于120天</p>
<p><span style="white-space: pre;"> </span>7.急性小灶心肌梗死&nbsp; ICD-10&nbsp; I21.401&nbsp;</p>
<p><span style="white-space: pre;"> </span>8.急性心内膜下心肌梗死&nbsp; ICD-10&nbsp; I21.402&nbsp;</p>
<p><span style="white-space: pre;"> </span>9.非ST抬高性心肌梗死&nbsp; ICD-10&nbsp; I21.403&nbsp;</p>
<p><span style="white-space: pre;"> </span>10.非冠心病心肌梗死&nbsp; &nbsp; ICD-10&nbsp; 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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 2)
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]) VALUES (2, N'HF', N'HF', 4, N'心力衰竭', 2, 1, N'form-2', 1, N'<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.本次住院天数大于120天</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 2)
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]) VALUES (3, N'Cap-Adult', N'CAP', 1, N'社区获得性肺炎（成人，首次住院）', 13, 1, N'form-13', 1, N'<div data-v-c0d7d944="" class="content"><p style="white-space: normal;">上报内容</p>
<p style="white-space: normal;"><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:J13 至 J16，J18;年龄≥18 岁的出院患者。&nbsp;</span></p>
<p style="white-space: normal;">&nbsp;</p>
<p style="white-space: normal;">无需上报内容：</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>1.年龄小于18岁的病例</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>2.由外院住院诊疗后转入本院</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>3.参与临床药物与器械试验</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>4.肺炎反复门诊抗菌素治疗无效</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>5.同一疾病30日内重复入院</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>6.呼吸机相关性肺炎VAP</p>
<p style="white-space: normal;">&nbsp;7.医院获得性肺炎HAP</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>8.本次住院时间超过60天</p>
<p style="white-space: normal;">&nbsp;</p>
<p style="white-space: normal;">数据验证：</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p style="white-space: normal;"><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 2)
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]) VALUES (4, N'Hip', N'HIP', 5, N'髋关节置换术', 5, 1, N'form-5', 1, N'<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.本次住院超过120天！</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1)
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]) VALUES (5, N'Knee', N'KNEE', 5, N'膝关节置换术', 6, 1, N'form-6', 1, N'<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.83，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.本次住院超过120天！</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1)
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]) VALUES (6, N'STK', N'STK', 2, N'脑梗死（首次 住院）', 3, 1, N'form-3', 1, N'<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.本次住院天数大于120天</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 2)
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]) VALUES (7, N'CABG', N'CABG', 4, N'冠状动脉旁路移植术', 7, 1, N'form-7', 1, N'<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.本次住院超过120天！</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1)
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]) VALUES (8, N'Cap', N'CAP2', 1, N'社区获得性肺炎（儿童，首次住院）', 4, 1, N'form-4', 1, N'<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:J13 至 J16，J18;2 岁≤年龄&lt; 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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 2)
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]) VALUES (9, N'PIP', N'PIP', 7, N'围手术期预防感染', 18, 1, N'form-18', 1, N'<div data-v-c0d7d944="" class="content"><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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1)
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]) VALUES (10, N'CS', N'CS', 3, N'剖宫产', 12, 1, N'form-12', 1, N'<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.本次住院超过120天！</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1)
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]) VALUES (11, N'AECOPD', N'COPD', 1, N'慢性阻塞性肺疾病急性发作（住院）', 10, 1, N'form-10', 1, N'<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断 ICD-10 编码:J44.0，J44.1 的出院患者。&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.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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 2)
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]) VALUES (12, N'DVT', N'DVT', 7, N'围手术期深静脉血栓', 17, 1, N'form-17', 1, N'<div data-v-c0d7d944="" class="content"><p style="white-space: normal;">“围手术期预防深静脉血栓栓塞”（DVT）与“围手术期预防感染”（PIP）有重复的病种：</p><p style="white-space: normal;">（1）&nbsp; &nbsp;闭合性心脏瓣膜切开术</p><p style="white-space: normal;">（2）&nbsp; &nbsp;心脏瓣膜置换术</p><p style="white-space: normal;">（3）&nbsp; &nbsp;脊柱颈融合术</p><p style="white-space: normal;">（4）&nbsp; &nbsp;脊柱再融合术</p><p style="white-space: normal;">（5）&nbsp; &nbsp;冠状动脉搭桥术</p><p style="white-space: normal;">（6）&nbsp; &nbsp;髋关节置换术</p><p style="white-space: normal;">（7）&nbsp; &nbsp;膝关节置换术</p><p style="white-space: normal;">因DVT中已包含PIP的内容，此种情况仅填写DVT，无需填报2次。</p><p><br></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1)
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]) VALUES (13, N'TIA', N'TIA', 2, N'短暂性脑缺血发作', 8, 1, N'form-8', 1, N'<div data-v-c0d7d944="" class="content"><p>上报内容：</p>
<p><span style="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断 ICD-10 编码:G45.0 至 G45.9 的出院患者。&nbsp;</span></p>
<div class="page" title="Page 17">
<div class="layoutArea">
<div class="column">
<p>&nbsp;</p>
</div>
</div>
</div>
<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.非首次确诊TIA患者</p>
<p><span style="white-space: pre;"> </span>5.同一疾病30日内重复入院</p>
<p><span style="white-space: pre;"> </span>6.本次住院天数大于120天</p>
<p><span style="white-space: pre;"> </span>7.TIA反复门诊治疗无效</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2)
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]) VALUES (14, N'HBIPS', N'HBIPS', 7, N'住院精神病患者安全和权益', 9, 1, N'form-9', 1, N'<div data-v-c0d7d944="" class="content"><p>上报内容：</p>
<div class="page" title="Page 63">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">主要诊断 ICD-10 编码:F00-F99 的出院患者。&nbsp;</span></p>
</div>
</div>
</div>
<div class="page" title="Page 63">&nbsp;</div>
<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>&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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 2)
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]) VALUES (15, N'TC', N'TC', 6, N'甲状腺癌（手术治疗）', 14, 1, N'form-14', 1, N'<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<div class="page" title="Page 42">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 16.000000pt; font-family: ''FangSong'';"><span style="font-size: 12pt;">主要诊断 ICD-10 编码:C73 开头，且伴主要手术操作 ICD-9-CM-3 编码:06.2 至 06.5 的手术出院患者</span>。&nbsp;</span></p>
</div>
</div>
</div>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1. 18岁以下的病例；</p>
<p><span style="white-space: pre;"> </span>2. 参与临床药物器械试验者；</p>
<p><span style="white-space: pre;"> </span>3. 本次住院超过90天；</p>
<p><span style="white-space: pre;"> </span>4. 在入院后24小时内死亡的患者；</p>
<p><span style="white-space: pre;"> </span>5. 在入院后24小时内转院的病人；</p>
<p><span style="white-space: pre;"> </span>6. 在入院后24小时内非医嘱离院的病人。</p>
<p>&nbsp;</p>
<p>数据验证：</p>
<p>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
<p>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
<p>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 3)
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]) VALUES (16, N'LC', N'LC', 6, N'肺癌（手术治疗）', 16, 1, N'form-16', 1, N'<div data-v-c0d7d944="" class="content"><p><span style="font-family: -apple-system, BlinkMacSystemFont, ''Segoe UI'', Roboto, Oxygen, Ubuntu, Cantarell, ''Open Sans'', ''Helvetica Neue'', sans-serif;">上报内容</span></p>
<p><span style="font-size: 12pt;">主要诊断 ICD-10 编码:C34 开头，且伴主要手术 ICD-9-CM-3 编码:32.2 至 32.6，&nbsp; &nbsp; &nbsp; 32.9 的手术出院患者。</span><span style="font-family: FangSong; font-size: 16pt;">&nbsp;</span></p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1. 18岁以下的病例；</p>
<p><span style="white-space: pre;"> </span>2. 参与临床药物器械试验者；</p>
<p><span style="white-space: pre;"> </span>3. 本次住院超过90天；</p>
<p><span style="white-space: pre;"> </span>4. 在入院后24小时内死亡的患者；</p>
<p><span style="white-space: pre;"> </span>5. 在入院后24小时内转院的病人；</p>
<p><span style="white-space: pre;"> </span>6. 在入院后24小时内非医嘱离院的病人。</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></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 3)
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]) VALUES (17, N'BC', N'BC', 6, N'乳腺癌（手术治疗）', 15, 1, N'form-15', 1, N'<div data-v-c0d7d944="" class="content"><p>上报内容</p>
<p><span style="font-size: 12pt;">主要诊断 ICD-10 编码:C50 开头，且伴主要手术 ICD-9-CM-3 编码:85.2 至 85.4 的手术出院患者。</span><span style="font-family: FangSong; font-size: 16pt;">&nbsp;</span></p>
<p>&nbsp;</p>
<p>无需上报内容：</p>
<p><span style="white-space: pre;"> </span>1. 18岁以下的病例；</p>
<p><span style="white-space: pre;"> </span>2. 参与临床药物器械试验者；</p>
<p><span style="white-space: pre;"> </span>3. 本次住院超过90天；</p>
<p><span style="white-space: pre;"> </span>4. 在入院后24小时内死亡的患者；</p>
<p><span style="white-space: pre;"> </span>5. 在入院后24小时内转院的病人；</p>
<p><span style="white-space: pre;"> </span>6. 在入院后24小时内非医嘱离院的病人。</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 3)
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]) VALUES (19, N'CAC', N'CAC', 1, N'哮喘（成人，急性发作，住院）', 19, 1, N'form-19', 1, N'<div data-v-c0d7d944="" class="content"><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 30">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">主要诊断 ICD-10 编码:J45，J46;年龄≥18 岁的出院患者。&nbsp;</span></p>
<p>&nbsp;</p>
</div>
</div>
</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. 18</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; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">4. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">参与临床药物器械试验者</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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2)
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]) VALUES (20, N'DG', N'DG', 3, N'异位妊娠（手术治疗）', 20, 1, N'form-20', 1, N'<div data-v-c0d7d944="" class="content"><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 38">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong;">主要诊断 ICD-10 编码:O00 开头，且伴主要手术 ICD-9-CM-3 编码:66.01，66.02，&nbsp; &nbsp; &nbsp; 66.62，66.95， 74.30 的手术出院患者。&nbsp;</span></p>
</div>
</div>
</div>
<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;">无需上报内容：</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">1.</span><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;">2.</span><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;">3.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院超过90天</span></p>
<p style="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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3)
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]) VALUES (21, N'PD', N'PD', 2, N'帕金森病', 21, 1, N'form-21', 1, N'<div data-v-c0d7d944="" class="content"><p style="margin: 0 0 10px; background: white; box-sizing: border-box;"><span style="font-family: 微软雅黑, sans-serif;">上报内容</span></p>
<p style=";background: white;"><span style="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断 ICD-10 编码:G20.x00 的出院患者。&nbsp;</span></p>
<div class="page" title="Page 19">
<div class="layoutArea">
<div class="column">
<div class="page" title="Page 26">
<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>
</div>
</div>
<p style="background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">无需上报内容：</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">1.</span><span style="font-family: 微软雅黑, sans-serif;">由外院诊疗后转入本院的病例</span></p>
<p style=";background: white;"><span style="font-family: 微软雅黑, sans-serif;">2.</span><span style="font-family: 微软雅黑, sans-serif;">参与临床药物与器械试验的病例</span></p>
<p style=";background: white;"><span style="font-family: 微软雅黑, sans-serif;">3.</span><span style="font-family: 微软雅黑, sans-serif;">到达医院前已经被确认采取安慰治疗或姑息治疗者</span></p>
<p style=";background: white;"><span style="font-family: 微软雅黑, sans-serif;">4.18</span><span style="font-family: 微软雅黑, sans-serif;">岁以下的病例</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">5.</span><span style="font-family: 微软雅黑, sans-serif;">本次住院天数大于90天</span></p>
<p style="background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span></p>
<p style="margin: 0 0 10px; background: white; box-sizing: border-box;"><span style="box-sizing: border-box;">1. *</span><span style="font-family: 微软雅黑, sans-serif;">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
<p style="margin: 0 0 10px; background: white; box-sizing: border-box;"><span style="box-sizing: border-box;">2. </span><span style="font-family: 微软雅黑, sans-serif;">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
<p><span style="font-size: 14px; font-family: 微软雅黑, sans-serif;">3. </span><span style="font-size: 14px; font-family: 微软雅黑, sans-serif;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2)
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]) VALUES (22, N'CSE', N'CSE', 2, N'惊厥性癫痫持续状态', 22, 1, N'form-22', 1, N'<div data-v-c0d7d944="" class="content"><p style="background: white; margin: 0 0 10px 0;">上报内容：</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-size: 12pt;">主要诊断 ICD-10 编码:G41.0、G41.8、G41.9 的出院患者。</span><span style="font-family: FangSong_GB2312; font-size: 16pt;">&nbsp;</span></p>
<p style="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; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">1. </span><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;">2.</span><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;">3.</span><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;">4.18</span><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;">5.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院天数大于90天</span></p>
<p style="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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2)
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]) VALUES (23, N'aSAH', N'aSAH', 2, N'急性动脉瘤性蛛网膜下腔出血', 23, 1, N'form-23', 1, N'<div data-v-c0d7d944="" class="content"><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: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:I60.0 至 I60.9，且伴主要手术 ICD-9-CM 编码:01.3，02.2，02.3，38.3，38.4，38.6，39.5 的手术出院患者。&nbsp;</span></p>
<p style="background: white; margin: 0 0 10px 0;">&nbsp;</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="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="font-family: ''微软雅黑'',sans-serif; color: black;">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="font-family: ''微软雅黑'',sans-serif; color: black;">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="font-family: ''微软雅黑'',sans-serif; color: black;">3.</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="font-family: ''微软雅黑'',sans-serif; color: black;">4.18</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="font-family: ''微软雅黑'',sans-serif; color: black;">5.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院天数大于90天</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;">&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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3)
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]) VALUES (24, N'MVR', N'MVR', 4, N'二尖瓣置换术', 24, 1, N'form-24', 1, N'<div data-v-c0d7d944="" class="content"><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: FangSong; font-size: 12pt;">&nbsp; 主要手术 ICD-9-CM-3 编码:35.02、35.12、35.23、35.24 的手术出院患者。&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;">无需上报内容：</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">&nbsp; 1.</span><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;">&nbsp; 2.18</span><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;">&nbsp; 3.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院超过90天</span></p>
<p style="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; margin: 0 0 10px 0;"><span style="box-sizing: border-box;">1. *</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监</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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1)
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]) VALUES (25, N'MEN', N'MEN', 2, N'脑膜瘤（初发手术治疗）', 25, 1, N'form-25', 1, N'<div data-v-c0d7d944="" class="content"><p style="margin: 0 0 10px; background: white; box-sizing: border-box;"><span style="font-family: 微软雅黑, sans-serif;">上报内容：</span></p>
<p style="margin: 0 0 10px; background: white; box-sizing: border-box;"><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:C70.0、C70.9、D32.0、D32.9、 D42.9，伴 ICD-9-CM-3 编码:01.51、01.59 的手术出院患者&nbsp;</span></p>
<p style="background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">无需上报内容：</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">1.</span><span style="font-family: 微软雅黑, sans-serif;">由外院诊疗后转入本院的病例</span></p>
<p style=";background: white;"><span style="font-family: 微软雅黑, sans-serif;">2.</span><span style="font-family: 微软雅黑, sans-serif;">参与临床药物与器械试验的病例</span></p>
<p style=";background: white;"><span style="font-family: 微软雅黑, sans-serif;">3.</span><span style="font-family: 微软雅黑, sans-serif;">到达医院前已经被确认采取安慰治疗或姑息治疗者</span></p>
<p style=";background: white;"><span style="font-family: 微软雅黑, sans-serif;">4.18</span><span style="font-family: 微软雅黑, sans-serif;">岁以下的病例</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">5.</span><span style="font-family: 微软雅黑, sans-serif;">本次住院天数大于90天</span></p>
<p style="background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span></p>
<p style="margin: 0 0 10px; background: white; box-sizing: border-box;"><span style="box-sizing: border-box;">1. *</span><span style="font-family: 微软雅黑, sans-serif;">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
<p style="margin: 0 0 10px; background: white; box-sizing: border-box;"><span style="box-sizing: border-box;">2. </span><span style="font-family: 微软雅黑, sans-serif;">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
<p><span style="font-size: 14px; font-family: 微软雅黑, sans-serif;">3. </span><span style="font-size: 14px; font-family: 微软雅黑, sans-serif;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3)
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]) VALUES (26, N'ICH', N'ICH', 2, N'脑出血', 26, 1, N'form-26', 1, N'<div data-v-c0d7d944="" class="content"><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: FangSong_GB2312; font-size: 12pt;">主要诊断 ICD-10 编码:I61.0 至 I61.9 的出院患者&nbsp;</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; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">1.</span><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;">2.</span><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;">3.</span><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;">4.</span><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;">5.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">创伤性脑出血S06.80</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">6.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">脑出血后遗症 I69.10</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">7.</span><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;">8.18</span><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;">9.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院天数大于90天</span></p>
<p style="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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2)
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]) VALUES (27, N'GLI', N'GLI', 2, N'胶质瘤（初发，手术治疗）', 27, 1, N'form-27', 1, N'<div data-v-c0d7d944="" class="content"><p style="background: white; margin: 0 0 10px 0;">上报内容：</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:C71，伴 ICD-9-CM-3 编码:01.52 至 01.59 的手术出院患者。&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;">无需上报内容：</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">1.</span><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;">2.</span><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;">3.</span><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;">4.18</span><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;">5.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院天数大于90天</span></p>
<p style="background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3)
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]) VALUES (28, N'PA', N'PA', 2, N'垂体腺瘤（初发，手术治疗）', 28, 1, N'form-28', 1, N'<div data-v-c0d7d944="" class="content"><p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">上报内容：</p>
<p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
<div class="page" title="Page 22">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 16.000000pt; font-family: ''FangSong'';"><span style="font-size: 12pt;">&nbsp; &nbsp; &nbsp;主要诊断 ICD-10 编码:D35.2、C75.1、D44.3、E22.0、 E23.6，伴 ICD-9-CM-3 编&nbsp; &nbsp; &nbsp; &nbsp; 码:07.61 至 07.69、07.71、07.72、 07.79 和 01.59 的手术出院患者。</span>&nbsp;</span></p>
</div>
</div>
</div>
<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;">到达医院前已经被确认采取安慰治疗或姑息治疗者</span></p>
<p style="text-indent: 28px; background: white;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">4.18</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;">5.</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></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3)
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]) VALUES (29, N'AVR', N'AVR', 4, N'主动脉瓣置换术', 29, 1, N'form-29', 1, N'<div data-v-c0d7d944="" class="content"><p style="background: white; margin: 0 0 10px 0;"><span style="font-size: 12pt; font-family: FangSong;">上报内容：</span></p>
<div class="page" title="Page 11">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong;">主要手术 ICD-9-CM-3 编码:35.0、35.2 的手术出院患者。&nbsp;</span></p>
<p>&nbsp;</p>
</div>
</div>
</div>
<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;">1. </span><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;">2. 18</span><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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院超过90天</span></p>
<p style="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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1)
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]) VALUES (30, N'ASD', N'ASD', 4, N'房间隔缺损手术', 30, 1, N'form-30', 1, N'<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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1)
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]) VALUES (31, N'VSD', N'VSD', 4, N'室间隔缺损手术', 31, 1, N'form-31', 1, N'<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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1)
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]) VALUES (32, N'AF', N'AF', 4, N'房颤', 32, 1, N'form-32', 1, N'<div data-v-c0d7d944="" class="content"><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="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="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断 ICD-10 编码:I48 的出院患者&nbsp;</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;">&nbsp;</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="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="font-family: ''微软雅黑'',sans-serif; color: black;">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="font-family: ''微软雅黑'',sans-serif; color: black;">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="font-family: ''微软雅黑'',sans-serif; color: black;">3.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院超过90天！</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;">&nbsp;</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="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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2)
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]) VALUES (33, N'GC', N'GC', 6, N'胃癌（手术治疗）', 33, 1, N'form-33', 1, N'<div data-v-c0d7d944="" class="content"><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 44">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong;">主要诊断 ICD-10 编码:C16 开头，且伴主要手术 ICD-9-CM-3 编码:43.4 至 43.9 的手术出院患者。&nbsp;</span></p>
</div>
</div>
</div>
<p style="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;">无需上报内容：</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">1.</span> <span style="font-family: ''微软雅黑'',sans-serif; color: black;">18</span><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;">2. </span><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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院超过90天</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">4. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">在入院后24小时内死亡的患者</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">5. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">在入院后24小时内转院的病人</span></p>
<p style="background: white; margin: 0 0 10px 0;">&nbsp;</p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3)
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]) VALUES (34, N'UM', N'UM', 3, N'子宫肌瘤（手术治疗）', 34, 1, N'form-34', 1, N'<div data-v-c0d7d944="" class="content"><p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;"> </span></span></p>
<div class="page" title="Page 39">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong;">上报内容：</span></p>
<p><span style="font-size: 12pt; font-family: FangSong;">主要诊断 ICD-10 编码与名称:D25 开头，且伴主要手术 ICD-9-CM-3 编码:68.29，68.3 至 68.5，68.9 的手术出院 患者。&nbsp;</span></p>
<p>&nbsp;</p>
</div>
</div>
</div>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: ''Helvetica Neue''; line-height: 18.2px; font-size: 12pt; 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: ''Helvetica Neue''; line-height: 18.2px; font-size: 12pt; background: #ffffff;">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-size: 12pt;"><span style="font-family: ''Helvetica Neue''; line-height: 18.2px; background: #ffffff;">2.医师</span><span style="font-family: ''Helvetica Neue''; line-height: 18.2px; background: #ffffff;"><span style="font-family: Helvetica Neue;">有记录的理由</span></span><span style="font-family: 宋体; line-height: 18.2px; background: #ffffff;"><span style="font-family: 宋体;">，</span></span><span style="font-family: ''Helvetica Neue''; line-height: 18.2px; background: #ffffff;"><span style="font-family: Helvetica Neue;">不列质控管理的病例</span>,</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="font-family: ''Helvetica Neue''; line-height: 18.2px; font-size: 12pt; background: #ffffff;">4.本次住院超过90天！</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>数据验证：</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 class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;">&nbsp;</p>
<p>&nbsp;</p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3)
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]) VALUES (35, N'SEP', N'SEP', 7, N'严重脓毒症和脓毒症休克早期治疗', 35, 1, N'form-35', 1, N'<div data-v-c0d7d944="" class="content"><p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: ''Helvetica Neue''; 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="font-family: ''Helvetica Neue''; 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，B73.7， R65.2，R65.3，R65.9 的出院患者。&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="font-family: ''Helvetica Neue''; 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>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2)
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]) VALUES (36, N'VTE', N'VTE', 7, N'中高危风险患者预防静脉血栓栓塞症', 36, 1, N'form-36', 1, N'<div data-v-c0d7d944="" class="content"><p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: ''Helvetica Neue''; 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="font-family: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">1.患者年龄小于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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">2.住院时间超过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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">4.患者入住或转入ICU的主要诊断或其他诊断ICD-10代码中有以下</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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;">（</span>1）栓塞和血栓形成ICD-10编码四位亚目及病种名称</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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;">（</span>2）产科并发栓塞ICD-10编码四位亚目及名称</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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;">（</span>3）神经内科脑梗死ICD-10编码四位亚目及病种名称</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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;">（</span>4）经神科ICD-10编码（F00～99）及病种名称</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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">5.患者入住或转入ICU的主要手术与操作名称与其ICD-9.CM.3代码中，有血管外科手术名称者（如血管内膜剥脱术等）</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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">6.已报送“</span><span style="font-family: ''Helvetica Neue''; line-height: 18.2px; color: #0000ff; font-size: 10.5pt; background: #ffffff;"><span style="color: #000000;">DVT,STK,STEMI</span>,</span><span style="font-family: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">TKR,THR,CABG,AVR,MVR,ASD,VSD"单病种质量监测信息项者，不再重复报送！</span></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2)
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]) VALUES (37, N'TN', N'TN', 7, N'甲状腺结节（手术治疗）', 37, 1, N'form-37', 1, N'<div data-v-c0d7d944="" class="content"><p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: ''Helvetica Neue''; 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="font-family: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;"> </span></span></p>
<div class="page" title="Page 68">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 16.000000pt; font-family: ''FangSong'';"><span style="font-size: 12pt;">主要诊断 ICD-10 编码:D34，E04.0，E04.1，E04.2， 且伴主要手术 ICD-9-CM-3 编码:06.2 至 06.5 的手术出院患者。</span>&nbsp;</span></p>
<p>&nbsp;</p>
</div>
</div>
</div>
<p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="font-family: ''Helvetica Neue''; 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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">1、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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">3、本次住院超过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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">4、甲状腺恶性病变</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: ''Helvetica Neue''; line-height: 18.2px; font-size: 10.5pt; background: #ffffff;">5、超声诊断分类“甲状腺结节TI--RADS 4类以上者</span></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3)
SET IDENTITY_INSERT [dbo].[D_Disease_Category] OFF

ALTER TABLE [dbo].[D_Disease_Category] ADD  CONSTRAINT [DF_D_Disease_Category_CEName]  DEFAULT (N'a') FOR [DiseaseDescription]
ALTER TABLE [dbo].[D_Disease_Category] ADD  CONSTRAINT [DF__D_Dise__SortI__6442E2C9]  DEFAULT ((1)) FOR [SortID]
ALTER TABLE [dbo].[D_Disease_Category] ADD  CONSTRAINT [DF_D_Disease_Category_Enabled]  DEFAULT ((0)) FOR [Enabled]
ALTER TABLE [dbo].[D_Disease_Category] ADD  CONSTRAINT [DF_D_Disease_Category_IsOpen]  DEFAULT ((1)) FOR [IsOpen]

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'id自增' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'DCID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病种类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'DiseaseType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接口使用的病种类型，为了兼容接口调用使用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'DiseaseType_API'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'疾病系统分类' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'DiseaseSystem'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'DiseaseDescription'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'SortID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否启用，控制填报界面是都显示' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'Enabled'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'卫健委唯一标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'Num'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否开启。不开启则前端页面不显示，为隐藏记录' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'IsOpen'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'DiseaseContent'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否开启漏报抽取' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'IsLeakOpen'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'按月抽取-' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'ByMonth_StartYear'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'按月抽取-抽取数据起始月份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'ByMonth_StartMonth'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'按月抽取-抽取数据执行到某年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'ByMonth_CurrentYear'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'按月抽取-抽取数据执行到某个月份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'ByMonth_CurrentMonth'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'按天抽取-抽取开始日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'ByDay_StartDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'按天抽取-抽取执行到哪天' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'ByDay_CurrentDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'按天抽取-每次抽取天数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'ByDay_LeakDay'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后一次抽取时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'LastLeakDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出院科室数据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'HisDeptList'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否按照出院科室抽取' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'HisDeptEnabled'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'漏报抽取规则是否可以更改  ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'LeakExtractRuleEnabled'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'漏报抽取规则 {0, "Icd9、Icd10满足其一"},{1, "Icd9满足"},{2, "Icd10满足"},{3, "Icd10、Icd9同时满足"},' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category', @level2type=N'COLUMN',@level2name=N'LeakExtractRule'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病种类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_Disease_Category'

update [D_Disease_Category] set 
[D_Disease_Category].[Enabled]=[Dict_Disease_Category].[Enabled],
[D_Disease_Category].[IsLeakOpen]=[Dict_Disease_Category].[IsLeakOpen],
[D_Disease_Category].[ByMonth_StartYear]=[Dict_Disease_Category].[StartYear],
[D_Disease_Category].[ByMonth_StartMonth]=[Dict_Disease_Category].[StartMonth],
[D_Disease_Category].[ByMonth_CurrentYear]=[Dict_Disease_Category].[CurrentYear],
[D_Disease_Category].[ByMonth_CurrentMonth]=[Dict_Disease_Category].[CurrentMonth],
[D_Disease_Category].[ByDay_CurrentDate]=[Dict_Disease_Category].[CurrentDate],
[D_Disease_Category].[ByDay_LeakDay]=[Dict_Disease_Category].[LeakDay],
[D_Disease_Category].[HisDeptList]=[Dict_Disease_Category].HISDeptList,
[D_Disease_Category].[HisDeptEnabled]=[Dict_Disease_Category].[HISDeptEnabled]
from [D_Disease_Category]
join [Dict_Disease_Category]
on [D_Disease_Category].[DCID] =[Dict_Disease_Category].CID

END


if not exists(select * from sysobjects where id=object_id('D_MedicalRecord'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE TABLE [dbo].[D_MedicalRecord](
[ID] [int] IDENTITY(1,1) NOT NULL,
	[ReportNo] [nvarchar](50) NOT NULL,
	[ReportClass] [int] NULL,
	[Status] [smallint] NULL,
	[Hospital_HBH] [nvarchar](50) NULL,
	[Base_HNumber] [nvarchar](50) NULL,
	[Base_VisitId] [nvarchar](50) NULL,
	[Base_Inpatientno] [nvarchar](50) NULL,
	[Base_BGName] [nvarchar](50) NULL,
	[Base_ZKHSName] [nvarchar](max) NULL,
	[Base_LYFS] [nvarchar](50) NULL,
	[Base_ZGYSName] [nvarchar](50) NULL,
	[Base_RYDate] [datetime] NULL,
	[Base_CYDate] [datetime] NULL,
	[Base_ICD10] [nvarchar](50) NULL,
	[Base_ICD9] [nvarchar](50) NULL,
	[Base_CSRQ] [datetime] NULL,
	[Base_Sex] [nvarchar](50) NULL,
	[Base_IsDRGs] [nvarchar](50) NULL,
	[DataInfo] [nvarchar](max) NULL,
	[Edit_DBGTime] [datetime] NULL,
	[Add_TJTime] [datetime] NULL,
	[Add_UserName] [nvarchar](50) NULL,
	[Add_UserProfileId] [int] NULL,
	[Add_OperDeptId] [int] NULL,
	[SBWorkDayCha] [int] NULL,
	[DealDiseaseDeptId] [int] NULL,
	[SHTime] [datetime] NULL,
	[BackUpFlag] [int] NOT NULL,
	[Ncis_IsCheckToWsb] [bit] NULL,
	[Ncis_IsExportWsb] [bit] NULL,
	[Ncis_ExportDate] [datetime] NULL,
	[Ncis_JoinErrorMessage] [nvarchar](max) NULL,
	[Ncis_IsJoinError] [bit] NULL,
	[DeleteId] [int] NULL,
	[DeleteTime] [datetime] NULL,
	[DeleteHostName] [nvarchar](max) NULL,
	[DeleteHostIP] [nvarchar](max) NULL,
 CONSTRAINT [PK_D_Base] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
'

ALTER TABLE [dbo].[D_MedicalRecord] ADD  CONSTRAINT [DF__D_Medical__BackU__75785BC3]  DEFAULT ((0)) FOR [BackUpFlag]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'序列号，唯一标识，医院的编码加提交时间加userid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'ReportNo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病种类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'ReportClass'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据状态（{0, "暂存"}, {1, "审核中"}, {2, "移交待审"},{11, "审核通过"},{20,"终审" },{8, "退回"},{9, "作废"}）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Status'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'医院代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Hospital_HBH'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病案号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_HNumber'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'VisitId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_VisitId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_Inpatientno'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上报医师、报告医生' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_BGName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'质控护士' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_ZKHSName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'离院方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_LYFS'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主管医师、质控医师(管床医师)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_ZGYSName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入院时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_RYDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出院时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_CYDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要诊断编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_ICD10'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手术编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_ICD9'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_CSRQ'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_Sex'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本院是否按病种付费' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Base_IsDRGs'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上报数据json' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'DataInfo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报告时间、对接卫健委时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Edit_DBGTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提交时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Add_TJTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Add_UserName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Add_UserProfileId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上报科室' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Add_OperDeptId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'实际报送时间差（单位为整数天）出院时间和提交时间差' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'SBWorkDayCha'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'处理部门' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'DealDiseaseDeptId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'SHTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'回收站标志，0表示数据正常,1表示该数据已经删除到回收站' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'BackUpFlag'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否要上报到卫健委' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Ncis_IsCheckToWsb'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据对接：是否对接成功' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Ncis_IsExportWsb'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'导出到卫健委对接时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Ncis_ExportDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对接卫计委系统，返回的错误信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Ncis_JoinErrorMessage'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对接卫计委系统' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'Ncis_IsJoinError'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除这条数据的用户Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'DeleteId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除数据的时间 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'DeleteTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除该记录的计算机名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'DeleteHostName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除该记录的用户IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord', @level2type=N'COLUMN',@level2name=N'DeleteHostIP'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病例数据表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord'

END

if not exists(select * from sysobjects where id=object_id('D_MedicalRecord_YYFX'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[D_MedicalRecord_YYFX](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[RecordNo] [nvarchar](50) NOT NULL,
	[YYFX_Result] [nvarchar](max) NULL,
	[UpdateDateTime] [datetime] NOT NULL,
 CONSTRAINT [PK_D_MedicalRecord_YYFX] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'填报记录序列号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_YYFX', @level2type=N'COLUMN',@level2name=N'RecordNo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'语义分析结果' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_YYFX', @level2type=N'COLUMN',@level2name=N'YYFX_Result'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_YYFX', @level2type=N'COLUMN',@level2name=N'UpdateDateTime'
END

--表Q_UserProfile字段CID长度扩大到256
if exists(select * from syscolumns where id=object_id('Q_UserProfile') and name='CID') 
EXEC dbo.sp_executesql @statement = N'ALTER TABLE Q_UserProfile ALTER COLUMN CID nvarchar(256)'

--无需上报理由
if not exists(select * from Report_NoReportNote where ReportClass >17)
BEGIN
SET IDENTITY_INSERT [dbo].[Report_NoReportNote] ON 
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (111, 19, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (112, 19, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (114, 19, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (115, 19, N'参与临床药物器械试验者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (116, 20, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (117, 20, N'有记录的理由不列质控管理的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (118, 20, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (119, 21, N'由外院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (120, 21, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (121, 21, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (122, 21, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (123, 21, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (125, 22, N'由外院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (126, 22, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (127, 22, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (128, 22, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (129, 22, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (130, 23, N'由外院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (131, 23, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (132, 23, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (133, 23, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (134, 23, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (135, 24, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (136, 24, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (137, 24, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (138, 25, N'由外院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (139, 25, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (140, 25, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (141, 25, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (142, 25, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (143, 26, N'由外院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (144, 26, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (145, 26, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (146, 26, N'非首次确诊急性出血性卒中', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (147, 26, N'创伤性脑出血S06.80', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (148, 26, N'脑出血后遗症 I69.10', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (149, 26, N'出血性脑梗死', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (150, 26, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (151, 26, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (152, 27, N'由外院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (153, 27, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (154, 27, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (155, 27, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (156, 27, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (157, 28, N'由外院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (158, 28, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (159, 28, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (160, 28, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (161, 28, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (162, 29, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (163, 29, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (164, 29, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (165, 30, N'参与临床药物与器械试验的病例,', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (166, 30, N'外院转入手术失敗病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (167, 30, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (168, 31, N'参与临床药物与器械试验的病例,', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (169, 31, N'外院转入手术失敗病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (170, 31, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (171, 32, N'参与临床药物与器械试验的病例,', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (172, 32, N'有记录的理由不列质控管理的病例,', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (173, 32, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (174, 33, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (175, 33, N'参与临床药物器械试验者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (176, 33, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (177, 33, N'在入院后24小时内死亡的患者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (178, 33, N'在入院后24小时内转院的病人', 1)
SET IDENTITY_INSERT [dbo].[Report_NoReportNote] OFF
END

--修改 [Report_Leak] IsReport：是否上报，数据抽取时的状态，不会改变， 
--将DealReport为空的按照IsReport赋值
if exists(select * from syscolumns where id=object_id('Report_Leak') and name='IsReport') 
BEGIN
if exists (select * from Report_Leak where  DealReport is  null and IsReport is not null)
update Report_Leak set DealReport = IsReport   where  DealReport is  null and IsReport is not null
--将IsReport为 2 无需上报,3 不符合条件 的数据，DealReport不为此值的按照IsReport
if exists (select * from  Report_Leak where DealReport<>IsReport and IsReport in (2,3) and DealReport not in (2,3))
update Report_Leak set DealReport = IsReport   where DealReport<>IsReport and IsReport in (2,3) and DealReport not in (2,3)
END

--是否更新漏报出院科室
if not exists (select * from Q_Options where Name = 'IsUpdateLeakDept')
insert into Q_Options([Name],[Value] )values(N'IsUpdateLeakDept',N'true')


--填报记录表添加数据版本号字段D_MedicalRecord
if not exists(select * from syscolumns where id=object_id('D_MedicalRecord') and name='DataVersion') 
EXEC dbo.sp_executesql @statement = N'alter table D_MedicalRecord add DataVersion nvarchar(10)'


if not exists(select * from syscolumns where id=object_id('D_MedicalRecord') and name='BuildVersion') 
EXEC dbo.sp_executesql @statement = N'alter table D_MedicalRecord add BuildVersion nvarchar(10)'


if not exists(select * from syscolumns where id=object_id('Report_ICDCodeMatch') and name='ICDCodeValue') 
begin
EXEC dbo.sp_executesql @statement = N'alter table Report_ICDCodeMatch add ICDCodeValue nvarchar(10)'
EXEC dbo.sp_executesql @statement = N'alter table Report_ICDCodeMatch add SuborderValue nvarchar(10)'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'细目字典值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Report_ICDCodeMatch', @level2type=N'COLUMN',@level2name=N'ICDCodeValue'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'亚目字典值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Report_ICDCodeMatch', @level2type=N'COLUMN',@level2name=N'SuborderValue'
end

--更新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')
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'
where UserName='admin'

--无需上报理由更新
if  exists(select * from D_ReportStaticsQuota where StaticsQuotaName='年龄大于18岁的病例，及出生28天的新生儿肺炎' )
update D_ReportStaticsQuota
set StaticsQuotaName='年龄大于18岁以及小于2岁的新生儿肺炎'
where StaticsQuotaName='年龄大于18岁的病例，及出生28天的新生儿肺炎' 

--是否开启自动对接卫健委
if not exists(select * from syscolumns where id=object_id('D_Disease_Category') and name='IsNcisAutoOpen') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table D_Disease_Category add [IsNcisAutoOpen] [bit] NULL default 0'
END

--卫健委日期格式不对调整  yyyy-MM-dd 改为 yyyy-MM-dd HH:mm
--入院
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-4-1"'))=10  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-4-1"', JSON_VALUE(DataInfo,'$."CM-0-2-4-1"') + ' 00:00')
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-4-1"'))=10 and DataVersion='2'
--出院
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-4-2"'))=10  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-4-2"', JSON_VALUE(DataInfo,'$."CM-0-2-4-2"') + ' 00:00')
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-4-2"'))=10 and DataVersion='2'

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-2-2"'))=10  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-2-2"', JSON_VALUE(DataInfo,'$."CM-0-2-2-2"') + ' 00:00')
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-2-2"'))=10 and DataVersion='2'

--yyyy-MM-dd HH 改为 yyyy-MM-dd HH:mm
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-4-1"'))=13  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-4-1"', JSON_VALUE(DataInfo,'$."CM-0-2-4-1"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-4-1"'))=13 and DataVersion='2'

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-4-2"'))=13  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-4-2"', JSON_VALUE(DataInfo,'$."CM-0-2-4-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-4-2"'))=13 and DataVersion='2'

--发病日期时间
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-2-2"'))=13  and DataVersion='2' and ReportClass not in(3,10,20) )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-2-2"', JSON_VALUE(DataInfo,'$."CM-0-2-2-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-2-2"'))=13 and DataVersion='2'  and ReportClass not in(3,10,20) 
--术前使用抗菌药物时间
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-1-4-1"'))=13  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-1-4-1"', JSON_VALUE(DataInfo,'$."CM-1-4-1"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."CM-1-4-1"'))=13 and DataVersion='2'
--术后抗菌药物停止使用时间
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-1-6-1"'))=13  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-1-6-1"', JSON_VALUE(DataInfo,'$."CM-1-6-1"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."CM-1-6-1"'))=13 and DataVersion='2'
--发病日期时间 cap-adult 为 yyyy-MM-dd  CS、DG
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-2-2"'))>10  and DataVersion='2' and ReportClass in(3,10,20))
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-2-2"', left(JSON_VALUE(DataInfo,'$."CM-0-2-2-2"'),10) )
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-2-2"'))>10 and DataVersion='2'  and ReportClass  in(3,10,20) 

--cs 胎儿娩出日期时间
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CS-2-4-2"'))>16  and DataVersion='2' and ReportClass =10)
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CS-2-4-2"', left(JSON_VALUE(DataInfo,'$."CS-2-4-2"'),16) )
where LEN(JSON_VALUE(DataInfo,'$."CS-2-4-2"'))>16 and DataVersion='2'  and ReportClass =10

--icu日期时间
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-5-1"'))=13  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-5-1"', JSON_VALUE(DataInfo,'$."CM-0-2-5-1"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-5-1"'))=13 and DataVersion='2'

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-5-2"'))=13  and DataVersion='2'  )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."CM-0-2-5-2"', JSON_VALUE(DataInfo,'$."CM-0-2-5-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."CM-0-2-5-2"'))=13 and DataVersion='2'

--修改ReportClass可为空
if  exists(select * from syscolumns where id=object_id('ReportLeakJoinLogs') and name='ReportClass') 
EXEC dbo.sp_executesql @statement = N'alter table  ReportLeakJoinLogs  alter column ReportClass int null'

--根据病种设置最小时间设置通用视图的抽取设置
if not exists (select * from Q_Options where Name='LeakStartDate' )
insert into Q_Options([Name],[Value] )values(N'LeakStartDate',(SELECT convert(nvarchar(100),min(ByDay_StartDate),111) FROM D_Disease_Category where ByDay_StartDate is not null ))
if not exists (select * from Q_Options where Name='LeakCurrentDate' )
insert into Q_Options([Name],[Value] )values(N'LeakCurrentDate',(SELECT convert(nvarchar(100),min(ByDay_CurrentDate),111) FROM D_Disease_Category where ByDay_CurrentDate is not null ))
if not exists (select * from Q_Options where Name='LeakLeakDay' )
insert into Q_Options([Name],[Value] )values(N'LeakLeakDay',(SELECT min(ByDay_LeakDay) FROM D_Disease_Category  where ByDay_LeakDay is not null ))

--hf 时间格式
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."HF-5-3"'))=13  and DataVersion='2' and ReportClass =2 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."HF-5-3"', JSON_VALUE(DataInfo,'$."HF-5-3"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."HF-5-3"'))=13 and DataVersion='2'  and ReportClass =2 
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."HF-5-3"'))>16  and DataVersion='2' and ReportClass =2)
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."HF-5-3"', left(JSON_VALUE(DataInfo,'$."HF-5-3"'),16) )
where LEN(JSON_VALUE(DataInfo,'$."HF-5-3"'))>16 and DataVersion='2'  and ReportClass =2

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."HF-2-2"'))=13  and DataVersion='2' and ReportClass =2 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."HF-2-2"', JSON_VALUE(DataInfo,'$."HF-2-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."HF-2-2"'))=13 and DataVersion='2'  and ReportClass =2 
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."HF-2-2"'))>16  and DataVersion='2' and ReportClass =2)
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."HF-2-2"', left(JSON_VALUE(DataInfo,'$."HF-2-2"'),16) )
where LEN(JSON_VALUE(DataInfo,'$."HF-2-2"'))>16 and DataVersion='2'  and ReportClass =2

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."HF-3-3"'))=13  and DataVersion='2' and ReportClass =2 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."HF-3-3"', JSON_VALUE(DataInfo,'$."HF-3-3"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."HF-3-3"'))=13 and DataVersion='2'  and ReportClass =2 
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."HF-3-3"'))>16  and DataVersion='2' and ReportClass =2)
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."HF-3-3"', left(JSON_VALUE(DataInfo,'$."HF-3-3"'),16) )
where LEN(JSON_VALUE(DataInfo,'$."HF-3-3"'))>16 and DataVersion='2'  and ReportClass =2

--stk  时间类型不对
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Knee-5-1-4"'))=16  and DataVersion='2' and ReportClass =5 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Knee-5-1-4"', JSON_VALUE(DataInfo,'$."Knee-5-1-4"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Knee-5-1-4"'))=16 and DataVersion='2'  and ReportClass =5


--Hip 时间格式: yyyy-MM-dd HH:mm
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Hip-3-3-4"'))=13  and DataVersion='2' and ReportClass =4 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Hip-3-3-4"', JSON_VALUE(DataInfo,'$."Hip-3-3-4"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Hip-3-3-4"'))=13 and DataVersion='2'  and ReportClass =4

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Hip-3-3-2"'))=13  and DataVersion='2' and ReportClass =4 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Hip-3-3-2"', JSON_VALUE(DataInfo,'$."Hip-3-3-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Hip-3-3-2"'))=13 and DataVersion='2'  and ReportClass =4

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Hip-3-2-4"'))=13  and DataVersion='2' and ReportClass =4 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Hip-3-2-4"', JSON_VALUE(DataInfo,'$."Hip-3-2-4"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Hip-3-2-4"'))=13 and DataVersion='2'  and ReportClass =4

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Hip-3-3-6"'))=13  and DataVersion='2' and ReportClass =4 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Hip-3-3-6"', JSON_VALUE(DataInfo,'$."Hip-3-3-6"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Hip-3-3-6"'))=13 and DataVersion='2'  and ReportClass =4

--KNEE 时间格式: yyyy-MM-dd HH:mm
if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Knee-3-4-1-2"'))=13  and DataVersion='2' and ReportClass =5 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Knee-3-4-1-2"', JSON_VALUE(DataInfo,'$."Knee-3-4-1-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Knee-3-4-1-2"'))=13 and DataVersion='2'  and ReportClass =5

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Knee-3-4-2-2"'))=13  and DataVersion='2' and ReportClass =5 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Knee-3-4-2-2"', JSON_VALUE(DataInfo,'$."Knee-3-4-2-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Knee-3-4-2-2"'))=13 and DataVersion='2'  and ReportClass =5

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Knee-3-4-3-2"'))=13  and DataVersion='2' and ReportClass =5 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Knee-3-4-3-2"', JSON_VALUE(DataInfo,'$."Knee-3-4-3-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Knee-3-4-3-2"'))=13 and DataVersion='2'  and ReportClass =5

--AECOPD 时间格式: yyyy-MM-dd HH:mm

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."AECOPD-5-2-3"'))=13  and DataVersion='2' and ReportClass =11 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."AECOPD-5-2-3"', JSON_VALUE(DataInfo,'$."AECOPD-5-2-3"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."AECOPD-5-2-3"'))=13 and DataVersion='2'  and ReportClass =11

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."AECOPD-5-2-2"'))=13  and DataVersion='2' and ReportClass =11 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."AECOPD-5-2-2"', JSON_VALUE(DataInfo,'$."AECOPD-5-2-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."AECOPD-5-2-2"'))=13 and DataVersion='2'  and ReportClass =11

--Cap 时间格式: yyyy-MM-dd HH:mm

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Cap-11-1-2"'))=13  and DataVersion='2' and ReportClass =8 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Cap-11-1-2"', JSON_VALUE(DataInfo,'$."Cap-11-1-2"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Cap-11-1-2"'))=13 and DataVersion='2'  and ReportClass =8

if exists(select * from D_MedicalRecord where LEN(JSON_VALUE(DataInfo,'$."Cap-11-1-1"'))=13  and DataVersion='2' and ReportClass =8 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."Cap-11-1-1"', JSON_VALUE(DataInfo,'$."Cap-11-1-1"') + ':00')
where LEN(JSON_VALUE(DataInfo,'$."Cap-11-1-1"'))=13 and DataVersion='2'  and ReportClass =8

--根据病种无需上报条件将符合无需上报要求并且未报的数据状态进行更新
if exists(select * from  Report_Leak  where DieaseICD in('I63.801','I50.902')  and DealReport=0 )
update Report_Leak set DealReport=2
where DieaseICD in('I63.801','I50.902')  and DealReport=0 

--无需上报条件增加所有病种住院24小时出院
if exists(select * from  D_ReportStaticsQuota  where id=8 and  ReportClassArr='14,'  )
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,'  where id=8 and  ReportClassArr='14,' 

--无需上报条件  18岁以下的病例
if exists(select * from  D_ReportStaticsQuota  where id=1 and  ReportClassArr='1,2,3,4,5,6,7,10,11,13,15,16,17,19,21,22,23,24,25,26,27,28,29,33,35,36,37,'  )
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,35,36,37,'  where id=1 and  ReportClassArr='1,2,3,4,5,6,7,10,11,13,15,16,17,19,21,22,23,24,25,26,27,28,29,33,35,36,37,' 

if exists(select * from  D_Disease_Category  where CHARINDEX('18岁',DiseaseContent) > 0 and DCID=9)
update D_Disease_Category set DiseaseContent='<div class="content">
<p>无需上报内容：</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>
<p>&nbsp;</p></div>'
where CHARINDEX('18岁',DiseaseContent) > 0 and DCID =9

if exists(select * from  D_Disease_Category  where CHARINDEX('18岁',DiseaseContent) > 0 and DCID =12)
update D_Disease_Category set DiseaseContent='<div class="content">
<p>无需上报内容：</p>
<p style="white-space: normal;">“围手术期预防深静脉血栓栓塞”（DVT）与“围手术期预防感染”（PIP）有重复的病种：</p>
<p style="white-space: normal;">（1）&nbsp; &nbsp;闭合性心脏瓣膜切开术</p>
<p style="white-space: normal;">（2）&nbsp; &nbsp;心脏瓣膜置换术</p>
<p style="white-space: normal;">（3）&nbsp; &nbsp;脊柱颈融合术</p>
<p style="white-space: normal;">（4）&nbsp; &nbsp;脊柱再融合术</p>
<p style="white-space: normal;">（5）&nbsp; &nbsp;冠状动脉搭桥术</p>
<p style="white-space: normal;">（6）&nbsp; &nbsp;髋关节置换术</p>
<p style="white-space: normal;">（7）&nbsp; &nbsp;膝关节置换术</p>
<p style="white-space: normal;">因DVT中已包含PIP的内容，此种情况仅填写DVT，无需填报2次。</p>
<p>&nbsp;</p></div>'
where CHARINDEX('18岁',DiseaseContent) > 0 and DCID =12

if exists(select * from  D_Disease_Category  where CHARINDEX('18岁',DiseaseContent) > 0 and DCID =14)
update D_Disease_Category set DiseaseContent='<div class="content"><p>上报内容：</p>
<p><span style="font-size: 12pt; font-family: FangSong_GB2312;">主要诊断 ICD-10 编码:F00-F99 的出院患者。&nbsp;</span></p>
<div class="page" title="Page 63">&nbsp;</div>
<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>&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 CHARINDEX('18岁',DiseaseContent) > 0 and  DCID =14

if exists(select * from  D_Disease_Category  where CHARINDEX('18岁',DiseaseContent) > 0 and DCID =20)
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;">上报内容：</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 38">
<div class="layoutArea">
<div class="column">
<p><span style="font-size: 12pt; font-family: FangSong;">主要诊断 ICD-10 编码:O00 开头，且伴主要手术 ICD-9-CM-3 编码:66.01，66.02，&nbsp; &nbsp; &nbsp; 66.62，66.95， 74.30 的手术出院患者。&nbsp;</span></p>
</div>
</div>
</div>
<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;">无需上报内容：</span></p>
<p style="background: white; margin: 0 0 10px 0;"><span style="font-family: ''微软雅黑'',sans-serif; color: black;">1.</span><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;">2.</span><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;">3.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院超过90天</span></p>
<p style="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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
<p>&nbsp;</p></div>'
where CHARINDEX('18岁',DiseaseContent) > 0 and DCID =20

if exists(select * from  D_Disease_Category  where CHARINDEX('18岁',DiseaseContent) > 0 and DCID =32)
update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><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="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="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断 ICD-10 编码:I48 的出院患者&nbsp;</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;">&nbsp;</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="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="font-family: ''微软雅黑'',sans-serif; color: black;">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="font-family: ''微软雅黑'',sans-serif; color: black;">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="font-family: ''微软雅黑'',sans-serif; color: black;">3.</span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">本次住院超过90天！</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;">&nbsp;</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="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;">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;">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;">3. </span><span style="font-family: ''微软雅黑'',sans-serif; color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p></div>'
where CHARINDEX('18岁',DiseaseContent) > 0 and DCID =32

--reportleak 添加CM_0_1_1_3 ICD10_oth DiseaseType
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='CM_0_1_1_3') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add CM_0_1_1_3 nvarchar(max) NULL'
END
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='ICD10_oth') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add ICD10_oth nvarchar(max) NULL'
END
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='DiseaseType') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add DiseaseType nvarchar(max) NULL'
END

--是否开启主治医师筛选
if not exists (select * from Q_Options where Name = 'OpenCM_0_1_1_3')
insert into Q_Options([Name],[Value] )values(N'OpenCM_0_1_1_3',N'false')

--sep 给予复苏液体种类
--if exists(select * from D_MedicalRecord where JSON_VALUE(DataInfo,'$."SEP-2-4-4"') is null   and DataVersion='2' and reportclass=35 )
--update D_MedicalRecord
--set DataInfo=JSON_MODIFY(DataInfo, '$."SEP-2-4-4"', 'a')
--where JSON_VALUE(DataInfo,'$."SEP-2-4-4"') is null   and DataVersion='2' and reportclass=35 

--hf 第一诊断或第二诊断对应的原发疾病ICD-10的三位类目编码与名称
if exists(select * from D_MedicalRecord where (JSON_VALUE(DataInfo,'$."HF-0-1-4-2"')='1' or JSON_VALUE(DataInfo,'$."HF-0-1-4-2"')='45') and DataVersion='2' and ReportClass =2 )
update D_MedicalRecord
set DataInfo=JSON_MODIFY(DataInfo, '$."HF-0-1-4-2"', 'UTD')
where (JSON_VALUE(DataInfo,'$."HF-0-1-4-2"')='1' or JSON_VALUE(DataInfo,'$."HF-0-1-4-2"')='45') and DataVersion='2' and ReportClass =2 

--无需上报理由 UM SEP VTE TN
if not exists(select * from Report_NoReportNote where ReportClass >33)
BEGIN
SET IDENTITY_INSERT [dbo].[Report_NoReportNote] ON 
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (179, 34, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (180, 34, N'医师有记录的理由，不列质控管理的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (181, 34, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (182, 35, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (183, 35, N'到达医院前,已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (184, 35, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (185, 35, N'本次住院天数大于90天', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (186, 35, N'由外院感染性休克诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (187, 35, N'在医师病程记录，有在严重脓毒症出现后3小时内出现被确认采取安慰治疗或姑息治疗的医嘱', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (188, 35, N'在医师病程记录，在感染性休克出现后6小时内出现被确认采取安慰治疗或姑息治疗的医嘱', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (189, 36, N'患者年龄小于18岁', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (190, 36, N'住院时间超过90天的患者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (191, 36, N'参与临床试验的患者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (192, 36, N'患者入住或转入ICU的主要诊断或其他诊断ICD-10代码中有 栓塞和血栓形成ICD-10编码四位亚目及病种名称', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (193, 36, N'患者入住或转入ICU的主要诊断或其他诊断ICD-10代码中有 产科并发栓塞ICD-10编码四位亚目及名称', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (194, 36, N'患者入住或转入ICU的主要诊断或其他诊断ICD-10代码中有 神经内科脑梗死ICD-10编码四位亚目及病种名称', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (195, 36, N'患者入住或转入ICU的主要诊断或其他诊断ICD-10代码中有 经神科ICD-10编码（F00～99）及病种名称', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (196, 36, N'患者入住或转入ICU的主要手术与操作名称与其ICD-9.CM.3代码中，有血管外科手术名称者（如血管内膜剥脱术等）', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (197, 36, N'已报送“DVT,STK,STEMI,TKR,THR,CABG,AVR,MVR,ASD,VSD"单病种质量监测信息项者，不再重复报送！', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (198, 37, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (199, 37, N'参与临床药物器械试验者', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (200, 37, N'本次住院超过90天！', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (201, 37, N'甲状腺恶性病变', 1)
INSERT [dbo].[Report_NoReportNote] ([Id], [ReportClass], [Note], [Selected]) VALUES (202, 37, N'超声诊断分类“甲状腺结节TI--RADS 4类以上者', 1)
SET IDENTITY_INSERT [dbo].[Report_NoReportNote] OFF
END

--病种添加系统特别说明
if not exists(select * from syscolumns where id=object_id('D_Disease_Category') and name='SystemDescription') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table D_Disease_Category add SystemDescription nvarchar(max) NULL'
END

--系统属性设置：增加自动化更新科室信息
set Identity_insert [dbo].[Report_DistributeDept] ON
if not exists (select * from [Report_DistributeDept] where ID = 26)
INSERT [dbo].[Report_DistributeDept] ([ID] ,[DistributeDeptName] ,[IsStart] ,[HasValue]) VALUES (26, N'自动同步HIS科室信息', 0, NULL)
set Identity_insert [dbo].[Report_DistributeDept] OFF

if not exists(select * from sysobjects where id=object_id('Report_DeptSyncLog'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE TABLE [dbo].[Report_DeptSyncLog](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NULL,
	[Status] [int] NULL,
	[Description] [nvarchar](max) NULL,
	[SyncTime] [datetime] NULL,
 CONSTRAINT [PK_Report_DeptSyncLog] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
'
END 

if not exists(select * from sysobjects where id=object_id('Report_LeakDataRemind'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE TABLE [dbo].[Report_LeakDataRemind](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NOT NULL,
	[RemindNum] [int] NULL,
	[RemindStart] [bit] NOT NULL,
	[RemindRoles] [nvarchar](max) NULL,
 CONSTRAINT [PK_Report_LeakDataRemind] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
'

INSERT INTO [dbo].[Report_LeakDataRemind]([Name],[RemindNum],[RemindStart],[RemindRoles]) VALUES(N'第一次提醒',7,0,NULL)
INSERT INTO [dbo].[Report_LeakDataRemind]([Name],[RemindNum],[RemindStart],[RemindRoles]) VALUES(N'第二次提醒',14,0,NULL)
END

if not exists(select * from  Report_NoReportNote  where [ReportClass]=14 and [Note] = '小于18周岁的病例')
BEGIN
INSERT [dbo].[Report_NoReportNote] ([ReportClass], [Note], [Selected])
VALUES (14, N'小于18周岁的病例', 1)
END

if not exists(select * from  Q_Quanxian where QuanxianName = '数据统计' or  QuanxianName='指标统计')
BEGIN
INSERT [dbo].[Q_Quanxian] ([QuanxianName], [Sort]) VALUES (N'指标统计', 24)
END

if not exists( select * from sysindexes where id=object_id('D_MedicalRecord') and name='NonClusteredIndex-D_MedicalRecord')
begin
CREATE NONCLUSTERED INDEX [NonClusteredIndex-D_MedicalRecord] ON [dbo].[D_MedicalRecord]
(
	[ReportClass] ASC,
	[Base_HNumber] ASC,
	[Base_CYDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
end 

if not exists (select * from D_ReportStaticsQuota where ID >12)
BEGIN
set Identity_insert [dbo].[D_ReportStaticsQuota] ON
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (13, N'48,49,', N'18岁以上的病例', N'18Y-', 2)
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (14, N'52,', N'年龄<18个月或年龄>8岁的患者', N'-545D|8Y-', 2)
set Identity_insert [dbo].[D_ReportStaticsQuota] OFF
end

--统计所用索引
if not exists( select * from sysindexes where id=object_id('D_MedicalRecord') and name='NonClusteredIndex-Stats')
begin
CREATE NONCLUSTERED INDEX [NonClusteredIndex-Stats] ON [dbo].[D_MedicalRecord]
(
	[Status] ASC,
	[DataVersion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

end 

--Report_Leak 添加 住院天数 CM_4_1、其中：手术费 CM_6_15
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='CM_4_1') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add CM_4_1 int NULL'
END
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='CM_6_15') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add CM_6_15 float NULL'
END

--卫健委变化
if not exists(select * from syscolumns where id=object_id('D_Disease_Category') and name='IsNcisChange') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table D_Disease_Category add IsNcisChange [bit] NULL default 0'
END

--开启自动对接卫健委的病种
if not exists (select * from Q_Options where Name = 'NcisAutoOpenList')
BEGIN
insert into Q_Options([Name],[Value] )values(N'NcisAutoOpenList',N'')
END

--Report_Leak 添加 年龄 age
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='age') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add age int NULL'
END

--病种重复病例设置 D_RepeatReportSetting
if not exists(select * from sysobjects where id=object_id('D_RepeatReportSetting'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[D_RepeatReportSetting](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ReportClass] [int] NOT NULL,
	[RepeatReportClass] [int] NOT NULL,
	[Icd9Code] [nvarchar](max) NULL,
	[Icd10Code] [nvarchar](max) NULL,
	[Enabled] [bit] NOT NULL,
 CONSTRAINT [PK_D_RepeatReportSetting] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
'
SET IDENTITY_INSERT [dbo].[D_RepeatReportSetting] ON 
INSERT [dbo].[D_RepeatReportSetting] ([Id], [ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (1, 9, 10, N'74.0、74.1、74.2、74.4、74.99', NULL, 1)
INSERT [dbo].[D_RepeatReportSetting] ([Id], [ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (2, 12, 4, N'00.7、81.51~81.53', NULL, 1)
INSERT [dbo].[D_RepeatReportSetting] ([Id], [ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (3, 12, 5, N'00.80~00.83、81.54、81.55', NULL, 1)
INSERT [dbo].[D_RepeatReportSetting] ([Id], [ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (4, 12, 7, N'36.1', NULL, 1)
SET IDENTITY_INSERT [dbo].[D_RepeatReportSetting] OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病种类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_RepeatReportSetting', @level2type=N'COLUMN',@level2name=N'ReportClass'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病例重复的病种类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_RepeatReportSetting', @level2type=N'COLUMN',@level2name=N'RepeatReportClass'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'icd9编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_RepeatReportSetting', @level2type=N'COLUMN',@level2name=N'Icd9Code'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'icd10编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_RepeatReportSetting', @level2type=N'COLUMN',@level2name=N'Icd10Code'

End

--指标统计删除表
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Report_ComIndiSum')) drop table Report_ComIndiSum
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Report_ComIndiSum_New')) drop table Report_ComIndiSum_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('ReportStaticsQuota')) drop table ReportStaticsQuota

--总体统计公共表
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_Diease_BaseInfo_New')) drop table Statics_Diease_BaseInfo_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_Diease_BaseInfo')) drop table Statics_Diease_BaseInfo
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_Year_TJ')) drop table Statics_Year_TJ

--重构 总体统计删除表
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_Result')) drop table Statics_Result

--重构 总体统计删除存储过程
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_TJ_Year'))  drop proc Pro_Statics_TJ_Year
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_CAP_Adult_CYTime'))  drop proc Pro_Statics_ZT_CAP_Adult_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_CAP_Adult_TJTime'))  drop proc Pro_Statics_ZT_CAP_Adult_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_HF_CYTime'))  drop proc Pro_Statics_ZT_HF_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_HF_TJTime'))  drop proc Pro_Statics_ZT_HF_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_HIP_CYTime'))  drop proc Pro_Statics_ZT_HIP_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_HIP_TJTime'))  drop proc Pro_Statics_ZT_HIP_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_Knee_CYTime'))  drop proc Pro_Statics_ZT_Knee_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_Knee_TJTime'))  drop proc Pro_Statics_ZT_Knee_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_STEMI_CYTime'))  drop proc Pro_Statics_ZT_STEMI_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_STEMI_TJTime'))  drop proc Pro_Statics_ZT_STEMI_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_STK_CYTime'))  drop proc Pro_Statics_ZT_STK_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_STK_TJTime'))  drop proc Pro_Statics_ZT_STK_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_CABG_CYTime'))  drop proc Pro_Statics_ZT_CABG_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Pro_Statics_ZT_CABG_TJTime'))  drop proc Pro_Statics_ZT_CABG_TJTime

--旧 总体统计删除表
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_AMI')) drop table Statics_TJ_AMI
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_AMI_New')) drop table Statics_TJ_AMI_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_BC_New')) drop table Statics_TJ_BC_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CABG')) drop table Statics_TJ_CABG
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CABG_New')) drop table Statics_TJ_CABG_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP')) drop table Statics_TJ_CAP
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP_New')) drop table Statics_TJ_CAP_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP2')) drop table Statics_TJ_CAP2
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP2_New')) drop table Statics_TJ_CAP2_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_COPD')) drop table Statics_TJ_COPD
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_COPD_New')) drop table Statics_TJ_COPD_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CS')) drop table Statics_TJ_CS
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CS_New')) drop table Statics_TJ_CS_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_DVT')) drop table Statics_TJ_DVT
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_DVT_New')) drop table Statics_TJ_DVT_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HBIPS_New')) drop table Statics_TJ_HBIPS_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HF')) drop table Statics_TJ_HF
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HF_New')) drop table Statics_TJ_HF_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HIP')) drop table Statics_TJ_HIP
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HIP_New')) drop table Statics_TJ_HIP_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_KNEE')) drop table Statics_TJ_KNEE
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_KNEE_New')) drop table Statics_TJ_KNEE_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_LC_New')) drop table Statics_TJ_LC_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_PIP')) drop table Statics_TJ_PIP
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_PIP_New')) drop table Statics_TJ_PIP_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_STK')) drop table Statics_TJ_STK
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_STK_New')) drop table Statics_TJ_STK_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_TC_New')) drop table Statics_TJ_TC_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_TIA_New')) drop table Statics_TJ_TIA_New

--旧 总体统计删除存储过程
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_Year'))  drop proc Statics_TJ_Year
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_AMI_CYTime'))  drop proc Statics_TJ_AMI_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_AMI_CYTime_AllTerm'))  drop proc Statics_TJ_AMI_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_AMI_CYTime_AllTerm_New'))  drop proc Statics_TJ_AMI_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_AMI_TJTime'))  drop proc Statics_TJ_AMI_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_AMI_TJTime_AllTerm'))  drop proc Statics_TJ_AMI_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_AMI_TJTime_AllTerm_New'))  drop proc Statics_TJ_AMI_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_BC_CYTime_AllTerm_New'))  drop proc Statics_TJ_BC_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_BC_TJTime_AllTerm_New'))  drop proc Statics_TJ_BC_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CABG_CYTime'))  drop proc Statics_TJ_CABG_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CABG_CYTime_AllTerm'))  drop proc Statics_TJ_CABG_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CABG_CYTime_AllTerm_New'))  drop proc Statics_TJ_CABG_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CABG_TJTime'))  drop proc Statics_TJ_CABG_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CABG_TJTime_AllTerm'))  drop proc Statics_TJ_CABG_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CABG_TJTime_AllTerm_New'))  drop proc Statics_TJ_CABG_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP_CYTime'))  drop proc Statics_TJ_CAP_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP_CYTime_AllTerm'))  drop proc Statics_TJ_CAP_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP_CYTime_AllTerm_New'))  drop proc Statics_TJ_CAP_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP_TJTime'))  drop proc Statics_TJ_CAP_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP_TJTime_AllTerm'))  drop proc Statics_TJ_CAP_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP_TJTime_AllTerm_New'))  drop proc Statics_TJ_CAP_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP2_CYTime'))  drop proc Statics_TJ_CAP2_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP2_CYTime_AllTerm'))  drop proc Statics_TJ_CAP2_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP2_CYTime_AllTerm_New'))  drop proc Statics_TJ_CAP2_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP2_TJTime'))  drop proc Statics_TJ_CAP2_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP2_TJTime_AllTerm'))  drop proc Statics_TJ_CAP2_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CAP2_TJTime_AllTerm_New'))  drop proc Statics_TJ_CAP2_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_COPD_CYTime'))  drop proc Statics_TJ_COPD_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_COPD_CYTime_AllTerm'))  drop proc Statics_TJ_COPD_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_COPD_CYTime_AllTerm_New'))  drop proc Statics_TJ_COPD_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_COPD_TJTime'))  drop proc Statics_TJ_COPD_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_COPD_TJTime_AllTerm'))  drop proc Statics_TJ_COPD_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_COPD_TJTime_AllTerm_New'))  drop proc Statics_TJ_COPD_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CS_CYTime'))  drop proc Statics_TJ_CS_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CS_CYTime_AllTerm'))  drop proc Statics_TJ_CS_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CS_CYTime_AllTerm_New'))  drop proc Statics_TJ_CS_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CS_TJTime'))  drop proc Statics_TJ_CS_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CS_TJTime_AllTerm'))  drop proc Statics_TJ_CS_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_CS_TJTime_AllTerm_New'))  drop proc Statics_TJ_CS_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_DVT_CYTime'))  drop proc Statics_TJ_DVT_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_DVT_CYTime_AllTerm'))  drop proc Statics_TJ_DVT_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_DVT_CYTime_AllTerm_New'))  drop proc Statics_TJ_DVT_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_DVT_TJTime'))  drop proc Statics_TJ_DVT_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_DVT_TJTime_AllTerm'))  drop proc Statics_TJ_DVT_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_DVT_TJTime_AllTerm_New'))  drop proc Statics_TJ_DVT_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HBIPS_CYTime_AllTerm_New'))  drop proc Statics_TJ_HBIPS_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HBIPS_TJTime_AllTerm_New'))  drop proc Statics_TJ_HBIPS_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HF_CYTime'))  drop proc Statics_TJ_HF_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HF_CYTime_AllTerm'))  drop proc Statics_TJ_HF_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HF_CYTime_AllTerm_New'))  drop proc Statics_TJ_HF_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HF_TJTime'))  drop proc Statics_TJ_HF_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HF_TJTime_AllTerm'))  drop proc Statics_TJ_HF_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HF_TJTime_AllTerm_New'))  drop proc Statics_TJ_HF_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HIP_CYTime'))  drop proc Statics_TJ_HIP_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HIP_CYTime_AllTerm'))  drop proc Statics_TJ_HIP_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HIP_CYTime_AllTerm_New'))  drop proc Statics_TJ_HIP_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HIP_TJTime'))  drop proc Statics_TJ_HIP_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HIP_TJTime_AllTerm'))  drop proc Statics_TJ_HIP_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_HIP_TJTime_AllTerm_New'))  drop proc Statics_TJ_HIP_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_KNEE_CYTime'))  drop proc Statics_TJ_KNEE_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_KNEE_CYTime_AllTerm'))  drop proc Statics_TJ_KNEE_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_KNEE_CYTime_AllTerm_New'))  drop proc Statics_TJ_KNEE_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_KNEE_TJTime'))  drop proc Statics_TJ_KNEE_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_KNEE_TJTime_AllTerm'))  drop proc Statics_TJ_KNEE_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_KNEE_TJTime_AllTerm_New'))  drop proc Statics_TJ_KNEE_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_LC_CYTime_AllTerm_New'))  drop proc Statics_TJ_LC_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_LC_TJTime_AllTerm_New'))  drop proc Statics_TJ_LC_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_PIP_CYTime'))  drop proc Statics_TJ_PIP_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_PIP_CYTime_AllTerm'))  drop proc Statics_TJ_PIP_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_PIP_CYTime_AllTerm_New'))  drop proc Statics_TJ_PIP_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_PIP_TJTime'))  drop proc Statics_TJ_PIP_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_PIP_TJTime_AllTerm'))  drop proc Statics_TJ_PIP_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_PIP_TJTime_AllTerm_New'))  drop proc Statics_TJ_PIP_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_STK_CYTime'))  drop proc Statics_TJ_STK_CYTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_STK_CYTime_AllTerm'))  drop proc Statics_TJ_STK_CYTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_STK_CYTime_AllTerm_New'))  drop proc Statics_TJ_STK_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_STK_TJTime'))  drop proc Statics_TJ_STK_TJTime
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_STK_TJTime_AllTerm'))  drop proc Statics_TJ_STK_TJTime_AllTerm
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_STK_TJTime_AllTerm_New'))  drop proc Statics_TJ_STK_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_TC_CYTime_AllTerm_New'))  drop proc Statics_TJ_TC_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_TC_TJTime_AllTerm_New'))  drop proc Statics_TJ_TC_TJTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_TIA_CYTime_AllTerm_New'))  drop proc Statics_TJ_TIA_CYTime_AllTerm_New
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID('Statics_TJ_TIA_TJTime_AllTerm_New'))  drop proc Statics_TJ_TIA_TJTime_AllTerm_New

--自定义字典表
if not exists(select * from syscolumns where id=object_id('Report_DropList') and name='ReportClass') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_DropList add ReportClass int NULL'
END

if not exists(select * from syscolumns where id=object_id('Report_DropListValue') and name='ReportClass') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_DropListValue add ReportClass int NULL'
END

if not exists(select * from syscolumns where id=object_id('D_MedicalRecord') and name='IsCustom') 
BEGIN
	EXEC dbo.sp_executesql @statement = N'alter table D_MedicalRecord add IsCustom bit NULL'
END

--自动抽取语义分析任务
if not exists (select * from [DataBaseAutoBak] where ID = 6)
exec dbo.sp_executesql @statement = N'
SET IDENTITY_INSERT [dbo].[DataBaseAutoBak] ON 
INSERT [dbo].[DataBaseAutoBak] ([Id], [AutoDbBakEnabled], [AutoDbBakEveryDay], [AutoDbBakAtHour]) VALUES (6, 0, 1, 0) 
SET IDENTITY_INSERT [dbo].[DataBaseAutoBak] OFF
'

--自动抽取语义分析漏报表修改
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='AutoYyfxState') 
BEGIN
	--自动抽取状态：-2抽取时异常，需尝试重新抽取、-1语义分析返回抽取失败、0待抽取、1语义分析返回抽取成功
	EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add AutoYyfxState int NULL'
	--最后一次抽取时间
	EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add AutoYyfxLastDateTime datetime NULL'
	--自动抽取失败次数
	EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add AutoYyfxFailCount int NULL'
	--语义分析成功抽取字段数
	EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add AutoYyfxSuccessFieldCount int NULL'
	--语义分析返回结果
	EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add AutoYyfxResult nvarchar(MAX) NULL'
END

-- 51个病种无需上报理由
if not exists(select * from Report_NoReportNote where ReportClass >37)
BEGIN
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (38, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (38, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (38, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (38, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (38, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (39, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (39, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (39, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (39, N'同一疾病30日内重复入院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (39, N'本次住院超过90天的病例', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (40, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (40, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (40, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (40, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (40, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (40, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (41, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (41, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (41, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (41, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (41, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (41, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (42, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (42, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (42, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (42, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (42, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (42, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (43, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (43, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (43, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (43, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (43, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (43, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (44, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (44, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (44, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (45, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (45, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (45, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (46, N'终末期肾病已行血液净化治疗', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (46, N'肿瘤患者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (46, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (46, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (46, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (47, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (47, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (47, N'年龄≥18岁以及<2岁的患者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (47, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (47, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (48, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (48, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (48, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (48, N'18岁以上的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (48, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (48, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (49, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (49, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (49, N'到达医院前已经被确认采取安慰治疗或姑息治疗者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (49, N'18岁以上的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (49, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (49, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (50, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (50, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (50, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (50, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (50, N'本次住院超过90天', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (50, N'病历记录孕期＜28周或不明的', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (51, N'由外院住院诊疗后转入本院的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (51, N'18岁以下的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (51, N'同一疾病30日内重复入院', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (51, N'本次住院超过90天', 1)

INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (52, N'参与临床药物与器械试验的病例', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (52, N'年龄＜18个月或年龄＞8岁的患者', 1)
INSERT [dbo].[Report_NoReportNote] ( [ReportClass], [Note], [Selected]) VALUES (52, N'本次住院超过90天', 1)

END



--漏报统计所用索引
if not exists( select * from sysindexes where id=object_id('Report_Leak') and name='NonClusteredIndex-ReporotLeakStats')
begin
CREATE NONCLUSTERED INDEX [NonClusteredIndex-ReporotLeakStats] ON [dbo].[Report_Leak]
(
	[ReportClass] ASC,
	[HNumber] ASC,
	[CYDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

end 

--上报汇总所用索引
if not exists( select * from sysindexes where id=object_id('Report_Log') and name='NonClusteredIndex-ReportStats')
begin
	CREATE NONCLUSTERED INDEX [NonClusteredIndex-ReportStats] ON [dbo].[Report_Log]
	(
		[ReportID] ASC,
		[UserProfileId] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
END


--添加 SEP、VTE 病种重复病例除外设置
if not exists(select * from D_RepeatReportSetting where ReportClass =35)
BEGIN
--SEP与各病种重复
--Cap-Adult
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (35, 3, N'31.1、93.90、93.91、93.94、93.96、93.98、93.99、96.04、96.70、96.71、96.72', NULL, 1)
--Cap
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (35, 8, N'31.1、93.90、93.91、93.94、93.96、93.98、93.99、96.04、96.70、96.71、96.72', NULL, 1)
--AECOPD
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (35, 11, N'31.1、93.90、93.91、93.94、93.96、93.98、93.99、96.70、96.71、96.72', NULL, 1)
--CAC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (35, 19, N'31.1、93.90、93.91、93.94、93.96、93.98、93.99、96.70、96.71、96.72', NULL, 1)
--CACC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (35, 47, N'31.1、93.90、93.91、93.94、93.96、93.98、93.99、96.70、96.71、96.72', NULL, 1)

--VTE与各病种重复
--Cap-Adult
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 3, N'96.70、96.71、96.72、93.90、93.91、39.65', NULL, 1)
--Cap
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 8, N'96.70、96.71、96.72、93.90、93.91、39.65', NULL, 1)
--AECOPD
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 11, N'96.70、96.71、96.72、93.90、93.91、39.65', NULL, 1)
--TC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 15, NULL, N'C73', 1)
--BC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 17, NULL, N'C50',1)
--CAC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 19, N'96.70、96.71、96.72、93.90、93.91', NULL, 1)
--SEP
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 35, N'96.70、96.71、96.72、93.90、93.91、89.60、89.61 、89.62、89.63、89.64、89.65、89.66、89.67、89.68', N'A40.1、A40.2、A40.3、A40.8、A40.9、A41.0、A41.1、A41.2、A41.3、A41.4、A41.5、A41.8、A41.9、R65.2、R65.3、R65.9', 1)
--PT
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 41, NULL, N'C07', 1)
--HD
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 44, N'39.95', NULL, 1)
--CACC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 47, N'96.70、96.71、96.72、93.90、93.91', NULL, 1)

END

--reportleak 添加ICD9_oth 
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='ICD9_oth') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add ICD9_oth nvarchar(max) NULL'
END

--暂时保留 开始--
--5.3.0版本医院未全部升级因此以下代码和5.3文件夹内代码重复，后期都普遍升级后此处可删除
--添加病种重复病例除外设置
--pip与各病种重复
if not exists(select * from D_RepeatReportSetting where ReportClass =9 and RepeatReportClass>10)
BEGIN
--甲状腺癌（手术治疗）·TC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (9, 15, N'06.2、06.3、06.4、06.5', NULL, 1)
--房间隔缺损手术·ASD
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (9, 30, N'35.61', NULL, 1)
--室间隔缺损手术·VSD
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (9, 31, N'35.62', NULL, 1)
--甲状腺结节（手术治疗）·TN
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (9,37, N'06.2、06.3、06.4、06.5', NULL, 1)
--复杂性视网膜脱离（手术治疗）·RD
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (9, 38, N'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', NULL, 1)
--原发性急性闭角型青光眼（手术治疗）·PACG
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (9, 39, N'13.19、13.3、13.41、13.59、13.70、13.71、13.90', NULL, 1)
--发育性髋关节发育不良·DDH
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (9, 52, N'76.94、79.8', NULL, 1)
END

--DVT与各病种重复
if not exists(select * from D_RepeatReportSetting where ReportClass =12 and RepeatReportClass>7)
BEGIN
--二尖瓣置换术·MVR
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (12, 24, N'35.0、35.2', NULL, 1)
--主动脉瓣置换术·AVR
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (12, 29, N'35.0、35.2', NULL, 1)
--胃癌（手术治疗）·GC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (12, 33, N'43.6、43.7、43.8、43.9', NULL, 1)
--子宫肌瘤（手术治疗）·UM
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (12, 34, N'68.2', NULL, 1)
--宫颈癌（手术治疗）·CC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (12, 42, N'68.3、68.4、68.5、68.6、68.7', NULL, 1)
--结肠癌（手术治疗）·CoC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (12, 43, N'45.7', NULL, 1)
END

--VTE与各病种重复
if not exists(select * from D_RepeatReportSetting where ReportClass =36 and RepeatReportClass=16)
BEGIN
--肺癌（手术治疗）·LC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 16, NULL, N'C34.0、C34.1、C34.2、C34.3、C34.8、C34.9', 1)
--脑膜瘤（初发手术治疗）·MEN
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 25, NULL, N'C70.0、C70.9', 1)
--胶质瘤（初发，手术治疗）·GLI
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 27, NULL, N'C71.0、C71.1、C71.2、C71.3、C71.4、C71.5、C71.6、C71.7、C71.8、C71.9', 1)
--垂体腺瘤（初发，手术治疗）·PA
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 28, NULL, N'C75.1', 1)
--胃癌（手术治疗）·GC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 33, NULL, N'C16.0、C16.1、C16.2、C16.3、C16.4、C16.5、C16.6、C16.8、C16.9', 1)
--舌鳞状细胞癌（手术治疗）·TSCC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 40, NULL, N'C01.x、C02.0、C02.1、C02.2、C02.3、C02.4、C02.8、C02.9', 1)
--宫颈癌（手术治疗）·CC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 42, NULL, N'C53.0、C53.1、C53.8、C53.9', 1)
--结肠癌（手术治疗）·CoC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 43, NULL, N'C18.0、C18.1、C18.2、C18.3、C18.4、C18.5、C18.6、C18.7、C18.8、C18.9', 1)
--儿童急性淋巴细胞白血病（初始诱导化疗）·ALL
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 48, NULL, N'C91.0', 1)
--儿童急性早幼粒细胞白血病（初始化疗）·APL
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 49, NULL, N'C92.4', 1)
END

--HF与各病种重复
if not exists(select * from D_RepeatReportSetting where ReportClass =2)
BEGIN
--急性心肌梗死（ST 段抬高型，首次住院）·STEMI
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (2, 1, NULL, N'I21.0、I21.1、I21.2、I21.3', 1)
END

--CS与各病种重复
if not exists(select * from D_RepeatReportSetting where ReportClass =10)
BEGIN
--感染分娩母婴阻断·HBV
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (10, 50, N'74.0、74.1、74.2、74.4、74.99', N'Z37', 1)
END

--AVR与各病种重复
if not exists(select * from D_RepeatReportSetting where ReportClass =29)
BEGIN
--二尖瓣置换术·MVR
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (29, 24, N'35.0、35.2',NULL, 1)
END

--VTE与pip
if not exists(select * from D_RepeatReportSetting where ReportClass =36 and RepeatReportClass=9)
BEGIN
--pip
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (36, 9, N'06.2~06.5、80.6、13.0~13.9、17.11~17.13、17.21~17.24、53.00~53.17、85.2~85.4、38.1、81.1、01.24、80.50~80.59、03.53、21.72、76.72~76.79、79.31~79.39、76.94、79.8、78.5~78.6、83.13~83.14、62.0~62.9、64.0~64.4、35.62、35.61、74.0、74.1、74.2、74.4、74.99', NULL, 1)
END

--reportleak 添加RepeatReportClass 
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='RepeatReportClass') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add RepeatReportClass nvarchar(max) NULL'
END

--[Q_Quanxian]表添加分析图表权限
if not exists (select * from [Q_Quanxian] where ID = 25)
begin
SET IDENTITY_INSERT [dbo].[Q_Quanxian] ON 
INSERT [dbo].[Q_Quanxian] ([Id], [QuanxianName], [Sort]) VALUES (25, N'分析图表', 25)
SET IDENTITY_INSERT [dbo].[Q_Quanxian] OFF 
end

--科室表增加根目录字段
if not exists(select * from syscolumns where id=object_id('Report_UserDept') and name='FullPath') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_UserDept add ParentPath nvarchar(max) NULL'
EXEC dbo.sp_executesql @statement = N'alter table Report_UserDept add FullPath nvarchar(max) NULL'
EXEC dbo.sp_executesql @statement = N'alter table Report_UserDept add FullName nvarchar(max) NULL'
END

--pip与BC
if not exists(select * from D_RepeatReportSetting where ReportClass =9 and RepeatReportClass=17)
BEGIN
--乳腺癌（手术治疗）·BC
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) 
VALUES (9, 17, N'85.2、85.3、85.4', NULL, 1)
END

--系统属性设置：对接失败数据是否自动退回填报员设置
set Identity_insert [dbo].[Report_DistributeDept] ON
if not exists (select * from [Report_DistributeDept] where ID = 27)
INSERT [dbo].[Report_DistributeDept] ([ID] ,[DistributeDeptName] ,[IsStart] ,[HasValue]) VALUES (27, N'对接失败数据是否自动退回填报员', 0, NULL)
set Identity_insert [dbo].[Report_DistributeDept] OFF

--增加 D_MedicalRecord 扩展属性字段
if not exists(select * from syscolumns where id=object_id('D_MedicalRecord') and name='ExtFields') 
BEGIN
	EXEC dbo.sp_executesql @statement = N'alter table D_MedicalRecord add ExtFields nvarchar(max) NULL'
END

--漏报表提取率相关字段
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='filedNum') 
BEGIN
	EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add FiledNum int NULL'
	EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add NoFilledNum int NULL'
	EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add FiledRate float NULL'
END

--增加 DataBaseAutoBak 分钟字段
if not exists(select * from syscolumns where id=object_id('DataBaseAutoBak') and name='AutoDbBakAtMinute') 
BEGIN
	EXEC dbo.sp_executesql @statement = N'alter table DataBaseAutoBak add AutoDbBakAtMinute int default 0'
END


--添加回收站权限
if not exists (select * from [Q_Quanxian] where ID = 27)
begin
SET IDENTITY_INSERT [dbo].[Q_Quanxian] ON 
INSERT [dbo].[Q_Quanxian] ([Id], [QuanxianName], [Sort]) VALUES (27, N'回收站', 27)
SET IDENTITY_INSERT [dbo].[Q_Quanxian] OFF 
end

--D_MedicalRecord 卫健委对接code
if not exists(select * from syscolumns where id=object_id('D_MedicalRecord') and name='Ncis_JoinCode') 
BEGIN
	EXEC dbo.sp_executesql @statement = N'alter table D_MedicalRecord add Ncis_JoinCode int NULL'
END

--系统属性设置：账号禁用设置
set Identity_insert [dbo].[Report_DistributeDept] ON
if not exists (select * from [Report_DistributeDept] where ID = 28)
INSERT [dbo].[Report_DistributeDept] ([ID] ,[DistributeDeptName] ,[IsStart] ,[HasValue]) VALUES (28, N'账号禁用设置', 0, '5')
set Identity_insert [dbo].[Report_DistributeDept] OFF

--增加 Q_UserProfile LoginDate：登录时间 UserLoginFailNum：登录失败次数
if not exists(select * from syscolumns where id=object_id('Q_UserProfile') and name='LoginDate') 
BEGIN
	EXEC dbo.sp_executesql @statement = N'alter table Q_UserProfile add LoginDate datetime NULL'
	EXEC dbo.sp_executesql @statement = N'alter table Q_UserProfile add UserLoginFailNum int NULL'
END


--增加Report_LeakLog LeakId的索引
if not exists( select * from sysindexes where id=object_id('Report_LeakLog') and name='NonClusteredIndex-LeakID')
begin
CREATE NONCLUSTERED INDEX [NonClusteredIndex-LeakID] ON [dbo].[Report_LeakLog]
(
	[LeakId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
end 

--系统属性设置：是否启用时间粘贴设置
set Identity_insert [dbo].[Report_DistributeDept] ON
if not exists (select * from [Report_DistributeDept] where ID = 29)
INSERT [dbo].[Report_DistributeDept] ([ID] ,[DistributeDeptName] ,[IsStart] ,[HasValue]) VALUES (29, N'时间粘贴设置', 0, NULL)
set Identity_insert [dbo].[Report_DistributeDept] OFF

--系统属性设置：数据抽取是否覆盖已填写项
set Identity_insert [dbo].[Report_DistributeDept] ON
if not exists (select * from [Report_DistributeDept] where ID = 30)
INSERT [dbo].[Report_DistributeDept] ([ID] ,[DistributeDeptName] ,[IsStart] ,[HasValue]) VALUES (30, N'数据抽取是否覆盖已填写项', 0, NULL)
set Identity_insert [dbo].[Report_DistributeDept] OFF

--自动抽取应上报数据任务
if not exists (select * from [DataBaseAutoBak] where ID = 7)
exec dbo.sp_executesql @statement = N'
SET IDENTITY_INSERT [dbo].[DataBaseAutoBak] ON 
INSERT [dbo].[DataBaseAutoBak] ([Id], [AutoDbBakEnabled], [AutoDbBakEveryDay], [AutoDbBakAtHour],[AutoDbBakAtMinute]) VALUES (7, 0, 1, 0, 0) 
SET IDENTITY_INSERT [dbo].[DataBaseAutoBak] OFF
'

--添加 VTE 病种重复病例除外设置
if not exists(select * from D_RepeatReportSetting where ReportClass =36 and RepeatReportClass=1)
BEGIN
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 1, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 2, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 4, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 5, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 6, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 7, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 10, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 12, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 13, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 14, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 20, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 21, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 22, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 23, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 24, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 26, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 29, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 30, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 31, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 32, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 34, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 36, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 37, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 38, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 39, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 45, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 46, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 50, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 51, NULL, NULL, 0)
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (36, 52, NULL, NULL, 0)
END

--系统属性设置：评审指标设置
set Identity_insert [dbo].[Report_DistributeDept] ON
if not exists (select * from [Report_DistributeDept] where ID = 31)
INSERT [dbo].[Report_DistributeDept] ([ID] ,[DistributeDeptName] ,[IsStart] ,[HasValue]) VALUES (31, N'评审指标设置', 0, NULL)
set Identity_insert [dbo].[Report_DistributeDept] OFF

--系统属性设置：完成上报后自动审核设置
set Identity_insert [dbo].[Report_DistributeDept] ON
if not exists (select * from [Report_DistributeDept] where ID = 32)
INSERT [dbo].[Report_DistributeDept] ([ID] ,[DistributeDeptName] ,[IsStart] ,[HasValue]) VALUES (32, N'完成上报的同时自动审核通过', 0, NULL)
set Identity_insert [dbo].[Report_DistributeDept] OFF

--无需上报内容添加0类接口
if not exists (select * from D_ReportStaticsQuota where StaticsQuotaName ='0类切口')
BEGIN
set Identity_insert [dbo].[D_ReportStaticsQuota] ON
INSERT [dbo].[D_ReportStaticsQuota] ([Id], [ReportClassArr], [StaticsQuotaName], [StaticsQuotaValue], [ZBIndex]) VALUES (15, N'9,', N'0类切口 ', N'a', 6)
set Identity_insert [dbo].[D_ReportStaticsQuota] OFF
end

--系统属性设置：是否开启 0类切口无需上报
set Identity_insert [dbo].[Report_DistributeDept] ON
if not exists (select * from [Report_DistributeDept] where ID = 33)
INSERT [dbo].[Report_DistributeDept] ([ID] ,[DistributeDeptName] ,[IsStart] ,[HasValue]) VALUES (33, N'0类切口无需上报', 0, NULL)
set Identity_insert [dbo].[Report_DistributeDept] OFF

--reportleak 添加 CM_3_3
if not exists(select * from syscolumns where id=object_id('Report_Leak') and name='CM_3_3') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_Leak add CM_3_3 nvarchar(max) NULL'
END

--菜单设置
if not exists(select * from sysobjects where id=object_id('D_MenuSetting'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[D_MenuSetting](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[MenuName] [nvarchar](max) NULL,
	[DisplayName] [nvarchar](max) NULL,
 CONSTRAINT [PK_D_MenuSetting] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
'
SET IDENTITY_INSERT [dbo].[D_MenuSetting] ON 
INSERT [dbo].[D_MenuSetting] ([ID], [MenuName], [DisplayName]) VALUES (1, N'手工填报数据', NULL)
INSERT [dbo].[D_MenuSetting] ([ID], [MenuName], [DisplayName]) VALUES (2, N'待报数据', NULL)
INSERT [dbo].[D_MenuSetting] ([ID], [MenuName], [DisplayName]) VALUES (3, N'管理数据', NULL)
INSERT [dbo].[D_MenuSetting] ([ID], [MenuName], [DisplayName]) VALUES (4, N'上报汇总', NULL)
INSERT [dbo].[D_MenuSetting] ([ID], [MenuName], [DisplayName]) VALUES (5, N'漏报管理', NULL)
INSERT [dbo].[D_MenuSetting] ([ID], [MenuName], [DisplayName]) VALUES (6, N'漏报汇总', NULL)
SET IDENTITY_INSERT [dbo].[D_MenuSetting] OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MenuSetting', @level2type=N'COLUMN',@level2name=N'MenuName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MenuSetting', @level2type=N'COLUMN',@level2name=N'DisplayName'

End
--用于导入卫计委上报数据
if not exists(select * from sysobjects where id=object_id('D_MedicalRecord_Rank'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE TABLE [dbo].[D_MedicalRecord_Rank](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ReportClass] [int] NULL,
	[Base_HNumber] [nvarchar](50) NULL,
	[Base_RYDate] [datetime] NULL,
	[Base_CYDate] [datetime] NULL,
	[Base_CSRQ] [datetime] NULL,
	[DataInfo] [nvarchar](max) NULL,
	[Add_TJTime] [datetime]  NOT NULL,
	[Add_OperDeptId] [int] NULL,
 CONSTRAINT [PK_D_MedicalRecord_Rank_Base] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病种类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_Rank', @level2type=N'COLUMN',@level2name=N'ReportClass'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病案号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_Rank', @level2type=N'COLUMN',@level2name=N'Base_HNumber'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入院时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_Rank', @level2type=N'COLUMN',@level2name=N'Base_RYDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出院时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_Rank', @level2type=N'COLUMN',@level2name=N'Base_CYDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_Rank', @level2type=N'COLUMN',@level2name=N'Base_CSRQ'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上报数据json' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_Rank', @level2type=N'COLUMN',@level2name=N'DataInfo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提交时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_Rank', @level2type=N'COLUMN',@level2name=N'Add_TJTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'科室代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'D_MedicalRecord_Rank', @level2type=N'COLUMN',@level2name=N'Add_OperDeptId'
CREATE NONCLUSTERED INDEX [NonClusteredIndex-ReportClass] ON [dbo].[D_MedicalRecord_Rank]
(
	[ReportClass] ASC,
	[Add_TJTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


END


--用于导入医院病案首页数据，计算评审指标
if not exists(select * from sysobjects where id=object_id('D_MedicalRecord_Previous'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE TABLE [dbo].[D_MedicalRecord_Previous](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ReportClass] [int] NULL,
	[Base_HNumber] [nvarchar](50) NULL,
	[Base_VisitId] [nvarchar](50) NULL,
	[Base_LYFS] [nvarchar](50) NULL,
	[Base_RYDate] [datetime] NULL,
	[Base_CYDate] [datetime] NULL,
	[Base_CSRQ] [datetime] NULL,
	[DataInfo] [nvarchar](max) NULL,
	[BC30] [nvarchar](50) NULL,
	[Base_BGName] [nvarchar](50) NULL,
	[Base_ZGYSName] [nvarchar](50) NULL,
	[CM_0_1_1_3] [nvarchar](50) NULL,
	[ICD10] [nvarchar](max) NULL,
	[ICD10_oth] [nvarchar](max) NULL,
	[ICDD10] [nvarchar](max) NULL,
	[ICD9] [nvarchar](max) NULL,
	[ICD9_oth] [nvarchar](max) NULL,
	[DiseaseType] [nvarchar](50) NULL,
	[DealReport] [int] NULL,
	[NoMustReportReason] [nvarchar](max) NULL,
	[RepeatReportClass] [nvarchar](max) NULL,
	[IsAuto] [bit] NULL,
	[GainDate] [datetime] NULL,
 CONSTRAINT [PK_D_MedicalRecord_Previous] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
'
END

if not exists( select * from sysindexes where id=object_id('D_MedicalRecord_Previous') and name='NonClusteredIndex-D_MedicalRecord_Previous')
BEGIN
CREATE NONCLUSTERED INDEX [NonClusteredIndex-D_MedicalRecord_Previous] ON [dbo].[D_MedicalRecord_Previous]
(
	[ReportClass] ASC,
	[Base_HNumber] ASC,
	[Base_CYDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
END 

--医院信息添加医院logo
if not exists(select * from syscolumns where id=object_id('Report_HospitalInfo') and name='HospitalLogo') 
BEGIN
EXEC dbo.sp_executesql @statement = N'alter table Report_HospitalInfo add HospitalLogo nvarchar(max) NULL'
END

--添加权限 控制 标记上报卫健委功能
if not exists(select * from  Q_Quanxian where QuanxianName = '隐藏标记上报卫健委功能（与数据管理、部门数据管理权限关联）')
BEGIN
INSERT [dbo].[Q_Quanxian] ([QuanxianName], [Sort]) VALUES (N'隐藏标记上报卫健委功能（与数据管理、部门数据管理权限关联）', 29)
END

--增加心梗和房颤的重复病种重复病例除外设置
if not exists(select * from D_RepeatReportSetting where ReportClass =32 and RepeatReportClass=1)
BEGIN
INSERT [dbo].[D_RepeatReportSetting] ([ReportClass], [RepeatReportClass], [Icd9Code], [Icd10Code], [Enabled]) VALUES (32, 1, NULL, NULL, 0)
END

--增加下一次运行时间字段NextRun，缺省值null
if not exists(select * from syscolumns where id=object_id('DataBaseAutoBak') and name='NextRun') 
EXEC dbo.sp_executesql @statement = N'alter table DataBaseAutoBak add [NextRun] DateTime NULL'

if not exists(select * from syscolumns where id=object_id('D_ReportLeak_TaskSettings') and name='NextRun') 
EXEC dbo.sp_executesql @statement = N'alter table D_ReportLeak_TaskSettings add [NextRun] DateTime NULL'
--暂时保留 结束--