Home Explore Help
Register Sign In
zgkw
/
sdqmupdatge
2
0
Fork 0
Files Pull Requests 0
Tree: 50ea9945c1
Branches Tags
sdqmupdatge
/
D_Update.sql

D_Update.sql 162 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443 
  1. --病种添加系统特别说明
    2. 

  2. --PIP 围手术期预防感染
    3. 

  3. if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID =9)
    4. 

  4. update D_Disease_Category set SystemDescription='<div class="content">
    5. 

  5. <p>系统特别说明：</p>
    6. 

  6. <p>1.18岁以下的病例，无需上报</p>
    7. 

  7. <p>2.同一疾病30日内重复入院，无需上报</p>
    8. 

  8. <p>3.本次住院天数大于90天，无法上报。</p>
    9. 

  9. </div>'
    10. 

  10. where SystemDescription is null and DCID =9
    11. 

  11. --DVT 围手术期深静脉血栓
    12. 

  12. if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID =12)
    13. 

  13. update D_Disease_Category set SystemDescription='<div class="content">
    14. 

  14. <p>系统特别说明：</p>
    15. 

  15. <p>1.18岁以下的病例，无需上报</p>
    16. 

  16. <p>2.同一疾病30日内重复入院，无需上报</p>
    17. 

  17. <p>3.本次住院天数大于90天，无法上报。</p>
    18. 

  18. <p>4.住院时间小于24小时无需上报。</p>
    19. 

  19. </div>'
    20. 

  20. where SystemDescription is null and DCID =12
    21. 

  21. --HBIPS 住院精神病患者安全和权益 DG 异位妊娠（手术治疗） UM 子宫肌瘤（手术治疗）
    22. 

  22. if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID in(14,20,32,34))
    23. 

  23. update D_Disease_Category set SystemDescription='<div class="content">
    24. 

  24. <p>系统特别说明：</p>
    25. 

  25. <p>1.18岁以下的病例，无需上报</p>
    26. 

  26. <p>2.同一疾病30日内重复入院，无需上报</p>
    27. 

  27. <p>3.住院时间小于24小时无需上报。</p>
    28. 

  28. </div>'
    29. 

  29. where SystemDescription is null and DCID in(14,20,32,34)
    30. 

  30. 

  31. if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID  in (19,21,22,23,25,26,27,28,24,29,30,31,37,17,16,33,35,36,37,15))
    32. 

  32. update D_Disease_Category set SystemDescription='<div class="content">
    33. 

  33. <p>系统特别说明：</p>
    34. 

  34. <p>1.同一疾病30日内重复入院，无需上报。</p>
    35. 

  35. <p>2.住院时间小于24小时无需上报。</p>
    36. 

  36. </div>'
    37. 

  37. where SystemDescription is null and DCID  in (19,21,22,23,25,26,27,28,24,29,30,31,37,17,16,33,35,36,37,15)
    38. 

  38. 

  39. if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID  in (3,6,13,10,1,2,7,4,5))
    40. 

  40. update D_Disease_Category set SystemDescription='<div class="content">
    41. 

  41. <p>系统特别说明：</p>
    42. 

  42. <p>1.本次住院天数大于90天，无法上报。</p>
    43. 

  43. <p>2.住院时间小于24小时无需上报。</p>
    44. 

  44. </div>'
    45. 

  45. where SystemDescription is null and DCID in (3,6,13,10,1,2,7,4,5)
    46. 

  46. 

  47. if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID  in (8,11))
    48. 

  48. update D_Disease_Category set SystemDescription='<div class="content">
    49. 

  49. <p>系统特别说明：</p>
    50. 

  50. <p>1.住院时间小于24小时无需上报。</p>
    51. 

  51. </div>'
    52. 

  52. where SystemDescription is null and DCID in (8,11)
    53. 

  53. 

  54. --无需上报条件  18岁以下的病例
    55. 

  55. if exists(select * from  D_ReportStaticsQuota  where id=1 and  ReportClassArr<>'1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' )
    56. 

  56. update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' 
    57. 

  57. where id=1 and  ReportClassArr<>'1,2,3,4,5,6,7,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' 
    58. 

  58. --无需上报条件 同一疾病30日内重复入院
    59. 

  59. if exists(select * from  D_ReportStaticsQuota  where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,' )
    60. 

  60. update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,'  
    61. 

  61. where id=12 and   ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,' 
    62. 

  62. --本次住院天数大于90天，无法上报。
    63. 

  63. if exists(select * from  D_ReportStaticsQuota  where id=4 and  ReportClassArr<>'1,2,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' )
    64. 

  64. update D_ReportStaticsQuota set ReportClassArr='1,2,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,'  
    65. 

  65. where id=4 and  ReportClassArr<>'1,2,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' 
    66. 

  66. --本次住院天数大于120天
    67. 

  67. if exists(select * from  D_ReportStaticsQuota  where id=5 and  ReportClassArr is not null )
    68. 

  68. update D_ReportStaticsQuota set ReportClassArr=null  
    69. 

  69. where id=5 and  ReportClassArr is not null 
    70. 

  70. --住院24小时内出院
    71. 

  71. if exists(select * from  D_ReportStaticsQuota  where id=8 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,46,47,48,49,50,52' )
    72. 

  72. update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,46,47,48,49,50,52'  
    73. 

  73. where id=8 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,46,47,48,49,50,52'
    74. 

  74. --编码对应pip卵巢切除术对应修改
    75. 

  75. if exists(select * from  Report_ICDCodeMatch  where ReportClass=9 and ICDCode like '65.%' and SuborderValue='1' )
    76. 

  76. update Report_ICDCodeMatch set SuborderValue='l'  
    77. 

  77. where ReportClass=9 and ICDCode like '65.%' and SuborderValue='1'
    78. 

  78. 

  79. 

  80. 

  81. --更新 疾病系统分类 2021-01-07（增加到51个病种）
    82. 

  82. SET IDENTITY_INSERT [dbo].[D_DiseaseSystem] ON
    83. 

  83. if not exists(select * from  D_DiseaseSystem  where ID=8 )
    84. 

  84. BEGIN
    85. 

  85.   INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (8, N'口腔系统疾病/手术 ', 2)
    86. 

  86. END
    87. 

  87. 

  88. if not exists(select * from  D_DiseaseSystem  where ID=9 )
    89. 

  89. BEGIN
    90. 

  90.   INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (9, N'泌尿系统疾病/手术', 3)
    91. 

  91. END
    92. 

  92. 

  93. if not exists(select * from  D_DiseaseSystem  where ID=10 )
    94. 

  94. BEGIN
    95. 

  95.   INSERT [dbo].[D_DiseaseSystem] ([ID], [DiseaseSystemName], [Sort]) VALUES (10, N'眼科系统疾病/手术', 7)
    96. 

  96. END
    97. 

  97. SET IDENTITY_INSERT [dbo].[D_DiseaseSystem] OFF
    98. 

  98. 

  99. UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =4  WHERE [ID]=2
    100. 

  100. UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =5  WHERE [ID]=3
    101. 

  101. UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =6  WHERE [ID]=4
    102. 

  102. UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =8  WHERE [ID]=5
    103. 

  103. UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =9  WHERE [ID]=6
    104. 

  104. UPDATE [dbo].[D_DiseaseSystem]  SET [Sort] =10  WHERE [ID]=7
    105. 

  105. 

  106. SET IDENTITY_INSERT [dbo].[D_Disease_Category] ON
    107. 

  107. if not exists(select * from  D_Disease_Category  where [DCID]=38 )
    108. 

  108. BEGIN
    109. 

  109. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    110. 

  110. VALUES (38, N'RD', N'RD', 10, N'复杂性视网膜脱离（手术治疗）', 38, 1, N'form-38', 1,
    111. 

  111. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">RD </span><span style="font-family:微软雅黑,sans-serif;color:black">复杂性视网膜脱离（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:H26.2，H40.0，H40.2，H40.9， 且伴主要手术 ICD-9-CM-3 编码:10.1，10.49，10.6，10.91， 10.99，12.11，12.12，12.64，12.66，12.67，12.71 至 12.73， 12.79，12.83，12.85，12.87，12.91，12.92，12.99，13.19， 13.3，13.41，13.59，13.70，13.71，13.90，14.73，14.74， 14.79 的手术出院患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    112. 

  112. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    113. 

  113. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    114. 

  114. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    115. 

  115. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.18岁以下的病例</span> </p>
    116. 

  116. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.同一疾病30日内重复入院的病例</span> </p>
    117. 

  117. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.本次住院超过90天的病例</span> </p>
    118. 

  118. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    119. 

  119. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    120. 

  120. END
    121. 

  121. 

  122. SET IDENTITY_INSERT [dbo].[D_Disease_Category] ON
    123. 

  123. if not exists(select * from  D_Disease_Category  where [DCID]=39 )
    124. 

  124. BEGIN
    125. 

  125. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    126. 

  126. VALUES (39, N'PACG', N'PACG', 10, N'原发性急性闭角型青光眼（手术治疗）', 39, 1, N'form-39', 1,
    127. 

  127. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">PACG </span><span style="font-family:微软雅黑,sans-serif;color:black">原发性急性闭角型青光眼（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:H26.2，H40.0，H40.2，H40.9， 且伴主要手术 ICD-9-CM-3 编码:10.1，10.49，10.6，10.91， 10.99，12.11，12.12，12.64，12.66，12.67，12.71 至 12.73， 12.79，12.83，12.85，12.87，12.91，12.92，12.99，13.19， 13.3，13.41，13.59，13.70，13.71，13.90，14.73，14.74， 14.79 的手术出院患者。</span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    128. 

  128. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    129. 

  129. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    130. 

  130. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    131. 

  131. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.18岁以下的病例</span> </p>
    132. 

  132. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.同一疾病30日内重复入院的病例</span> </p>
    133. 

  133. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.本次住院超过90天的病例</span> </p>
    134. 

  134. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    135. 

  135. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    136. 

  136. END
    137. 

  137. 

  138. if not exists(select * from  D_Disease_Category  where [DCID]=40 )
    139. 

  139. BEGIN
    140. 

  140. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    141. 

  141. VALUES (40, N'TSCC', N'TSCC', 8, N'舌鳞状细胞癌（手术治疗）', 40, 1, N'form-40', 1,
    142. 

  142. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">TSCC </span><span style="font-family:微软雅黑,sans-serif;color:black">舌鳞状细胞癌（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C01，C02，且伴主要手术 ICD-9-CM-3 编码:25.1 至 25.4，40.4 的手术出院患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    143. 

  143. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    144. 

  144. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    145. 

  145. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    146. 

  146. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
    147. 

  147. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以下的病例</span> </p>
    148. 

  148. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
    149. 

  149. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
    150. 

  150. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    151. 

  151. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    152. 

  152. END
    153. 

  153. if not exists(select * from  D_Disease_Category  where [DCID]=41 )
    154. 

  154. BEGIN
    155. 

  155. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    156. 

  156. VALUES (41, N'PT', N'PT', 8, N'腮腺肿瘤（手术治疗）', 41, 1, N'form-41', 1,
    157. 

  157. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">PT </span><span style="font-family:微软雅黑,sans-serif;color:black">腮腺肿瘤（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:D11.0，且伴主要手术 ICD-9-CM-3 编码:26.2，26.3 伴 04.42 的手术出院患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    158. 

  158. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    159. 

  159. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    160. 

  160. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    161. 

  161. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
    162. 

  162. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以下的病例</span> </p>
    163. 

  163. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
    164. 

  164. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
    165. 

  165. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    166. 

  166. END
    167. 

  167. 

  168. if not exists(select * from  D_Disease_Category  where [DCID]=42 )
    169. 

  169. BEGIN
    170. 

  170. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    171. 

  171. VALUES (42, N'CC', N'CC', 6, N'宫颈癌（手术治疗）', 42, 1, N'form-42', 1,
    172. 

  172. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">CC </span><span style="font-family:微软雅黑,sans-serif;color:black">宫颈癌（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C53 开头，且伴主要手术 ICD-9-CM-3 编码:67.2 至 67.4，68.4，68.5，68.6，68.7 的手术出院患者。  </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    173. 

  173. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    174. 

  174. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    175. 

  175. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    176. 

  176. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
    177. 

  177. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以下的病例</span> </p>
    178. 

  178. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
    179. 

  179. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
    180. 

  180. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    181. 

  181. END
    182. 

  182. 

  183. if not exists(select * from  D_Disease_Category  where [DCID]=43 )
    184. 

  184. BEGIN
    185. 

  185. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    186. 

  186. VALUES (43, N'CoC', N'CoC', 6, N'结肠癌（手术治疗）', 43, 1, N'form-43', 1,
    187. 

  187. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">CoC </span><span style="font-family:微软雅黑,sans-serif;color:black">结肠癌（手术治疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C18，D01.0;且伴主要手术操 作 ICD-9-CM-3 编码:45.4,45.73 至 45.79,45.8 的手术出院 患者。</span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    188. 

  188. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    189. 

  189. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    190. 

  190. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    191. 

  191. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
    192. 

  192. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以下的病例</span> </p>
    193. 

  193. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
    194. 

  194. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
    195. 

  195. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    196. 

  196. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    197. 

  197. END
    198. 

  198. 

  199. if not exists(select * from  D_Disease_Category  where [DCID]=44 )
    200. 

  200. BEGIN
    201. 

  201. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    202. 

  202. VALUES (44, N'HD', N'HD', 9, N'终末期肾病血液透析', 44, 1, N'form-44', 1,
    203. 

  203. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">HD </span><span style="font-family:微软雅黑,sans-serif;color:black">终末期肾病血液透析</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:N18.0，且伴主要操作 ICD-9-CM-3 编码:38.95，39.27，39.42，39.95 的血液透析患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    204. 

  204. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    205. 

  205. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.18岁以下的病例</span> </p>
    206. 

  206. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.同一疾病30日内重复入院的病例</span> </p>
    207. 

  207. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.本次住院超过90天的病例</span> </p>
    208. 

  208. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    209. 

  209. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    210. 

  210. END
    211. 

  211. 

  212. if not exists(select * from  D_Disease_Category  where [DCID]=45 )
    213. 

  213. BEGIN
    214. 

  214. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    215. 

  215. VALUES (45, N'DPD', N'DPD', 9, N'终末期肾病腹膜透析', 45, 1, N'form-45', 1,
    216. 

  216. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">DPD </span><span style="font-family:微软雅黑,sans-serif;color:black">终末期肾病腹膜透析</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:N18.0，且伴主要操作 ICD-9-CM-3 编码:54.98 的腹膜透析患者。 </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    217. 

  217. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    218. 

  218. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.18岁以下的病例</span> </p>
    219. 

  219. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.同一疾病30日内重复入院的病例</span> </p>
    220. 

  220. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.本次住院超过90天的病例</span> </p>
    221. 

  221. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    222. 

  222. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    223. 

  223. END
    224. 

  224. 

  225. if not exists(select * from  D_Disease_Category  where [DCID]=46 )
    226. 

  226. BEGIN
    227. 

  227. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    228. 

  228. VALUES (46, N'DKD', N'DKD', 9, N'糖尿病肾病', 46, 1, N'form-46', 1,
    229. 

  229. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">DKD </span><span style="font-family:微软雅黑,sans-serif;color:black">糖尿病肾病</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断和其他诊断 ICD-10 编码:E10 至 E14，且伴主 要操作 ICD-9-CM-3 编码:55.23 的非产妇出院患者。  </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    230. 

  230. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    231. 

  231. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.终末期肾病已行血液净化治疗</span> </p>
    232. 

  232. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.肿瘤患者</span> </p>
    233. 

  233. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.18岁以下的病例</span> </p>
    234. 

  234. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.同一疾病30日内重复入院的病例</span> </p>
    235. 

  235. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.本次住院超过90天的病例</span> </p>
    236. 

  236. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    237. 

  237. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    238. 

  238. END
    239. 

  239. 

  240. if not exists(select * from  D_Disease_Category  where [DCID]=47 )
    241. 

  241. BEGIN
    242. 

  242. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    243. 

  243. VALUES (47, N'CACC', N'CACC', 1, N'哮喘（儿童，住院）', 47, 1, N'form-47', 1,
    244. 

  244. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">CACC </span><span style="font-family:微软雅黑,sans-serif;color:black">哮喘（儿童，住院）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:J45，J46;2 岁≤年龄<18 岁 的出院患儿。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    245. 

  245. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    246. 

  246. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    247. 

  247. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    248. 

  248. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.年龄≥18岁以及<2岁的患者</span> </p>
    249. 

  249. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.同一疾病30日内重复入院的病例</span> </p>
    250. 

  250. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.本次住院超过90天的病例</span> </p>
    251. 

  251. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    252. 

  252. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 2,NULL,NULL)
    253. 

  253. END
    254. 

  254. 

  255. if not exists(select * from  D_Disease_Category  where [DCID]=48 )
    256. 

  256. BEGIN
    257. 

  257. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    258. 

  258. VALUES (48, N'ALL', N'ALL', 7, N'儿童急性淋巴细胞白血病（初始诱导化疗）', 48, 1, N'form-48', 1,
    259. 

  259. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">ALL </span><span style="font-family:微软雅黑,sans-serif;color:black">儿童急性淋巴细胞白血病（初始诱导化疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C91.0，且伴主要操作 ICD-9-CM-3 编码:99.25 的出院患儿。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    260. 

  260. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    261. 

  261. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    262. 

  262. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    263. 

  263. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
    264. 

  264. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以上的病例</span> </p>
    265. 

  265. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
    266. 

  266. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
    267. 

  267. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    268. 

  268. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    269. 

  269. END
    270. 

  270. 

  271. if not exists(select * from  D_Disease_Category  where [DCID]=49 )
    272. 

  272. BEGIN
    273. 

  273. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    274. 

  274. VALUES (49, N'APL', N'APL', 7, N'儿童急性早幼粒细胞白血病（初始化疗）', 49, 1, N'form-49', 1,
    275. 

  275. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">APL </span><span style="font-family:微软雅黑,sans-serif;color:black">儿童急性早幼粒细胞白血病（初始化疗）</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:C92.4，且伴主要操作 ICD-9-CM-3 编码:99.25 的出院患儿。  </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    276. 

  276. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    277. 

  277. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    278. 

  278. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    279. 

  279. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.到达医院前已经被确认采取安慰治疗或姑息治疗者</span> </p>
    280. 

  280. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以上的病例</span> </p>
    281. 

  281. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
    282. 

  282. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
    283. 

  283. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    284. 

  284. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    285. 

  285. END
    286. 

  286. 

  287. if not exists(select * from  D_Disease_Category  where [DCID]=50 )
    288. 

  288. BEGIN
    289. 

  289. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    290. 

  290. VALUES (50, N'HPV', N'HPV', 7, N'HBV 感染分娩母婴阻断', 50, 1, N'form-50', 1,
    291. 

  291. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">HBV 感染分娩母婴阻断</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:O98.4，Z22.5 + O80 至 O84+Z37; 且伴1阴道分娩操作 ICD-9-CM-3 编码 72.0 至 72.9，73.0， 73.1，73.21，73.4 至 73.6,73.9;或伴2剖宫产手术 ICD 9-CM-3 编码:74.0，74.1，74.2，74.4，74.99 的出院患者。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    292. 

  292. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    293. 

  293. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    294. 

  294. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.参与临床药物与器械试验的病例</span> </p>
    295. 

  295. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.病历记录孕期＜28周或不明的</span> </p>
    296. 

  296. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.18岁以上的病例</span> </p>
    297. 

  297. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">5.同一疾病30日内重复入院的病例</span> </p>
    298. 

  298. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">6.本次住院超过90天的病例</span> </p>
    299. 

  299. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    300. 

  300. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    301. 

  301. END
    302. 

  302. 

  303. if not exists(select * from  D_Disease_Category  where [DCID]=51 )
    304. 

  304. BEGIN
    305. 

  305. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    306. 

  306. VALUES (51, N'OIT', N'OIT', 8, N'口腔种植术', 51, 1, N'form-51', 1,
    307. 

  307. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">OIT</span><span style="font-family:微软雅黑,sans-serif;color:black">口腔种植术</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要手术 ICD-9-CM-3 编码:23.5，23.6 的门诊患者或 者 76.09，76.91，76.92，22.79 的手术出院患者。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    308. 

  308. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    309. 

  309. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    310. 

  310. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.18岁以上的病例</span> </p>
    311. 

  311. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.同一疾病30日内重复入院的病例</span> </p>
    312. 

  312. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.本次住院超过90天的病例</span> </p>
    313. 

  313. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>'
    314. 

  314. , 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 1,NULL,NULL)
    315. 

  315. END
    316. 

  316. 

  317. if not exists(select * from  D_Disease_Category  where [DCID]=52 )
    318. 

  318. BEGIN
    319. 

  319. INSERT [dbo].[D_Disease_Category] ([DCID], [DiseaseType], [DiseaseType_API], [DiseaseSystem], [DiseaseDescription], [SortID], [Enabled], [Num], [IsOpen], [DiseaseContent], [IsLeakOpen], [ByMonth_StartYear], [ByMonth_StartMonth], [ByMonth_CurrentYear], [ByMonth_CurrentMonth], [ByDay_StartDate], [ByDay_CurrentDate], [ByDay_LeakDay], [LastLeakDate], [HisDeptList], [HisDeptEnabled], [LeakExtractRuleEnabled], [LeakExtractRule],[IsNcisAutoOpen],[SystemDescription]) 
    320. 

  320. VALUES (52, N'DDH', N'DDH', 5, N'发育性髋关节发育不良', 52, 1, N'form-52', 1,
    321. 

  321. N'<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">DDH</span><span style="font-family:微软雅黑,sans-serif;color:black">发育性髋关节发育不良</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要诊断 ICD-10 编码:Q65.0 至 Q65.6、Q65.8、Q65.9, 伴主要手术 ICD-9-CM-3 编码: 79.85、77.25、77.29;1 岁 ≤年龄≤8 岁(旧称先天性髋关节脱位)的手术出院患儿。  </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    322. 

  322. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    323. 

  323. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.参与临床药物与器械试验的病例</span> </p>
    324. 

  324. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.18岁以上的病例</span> </p>
    325. 

  325. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.本次住院超过90天的病例</span> </p>
    326. 

  326. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, null, 1, 3,NULL,NULL)
    327. 

  327. END
    328. 

  328. 

  329. SET IDENTITY_INSERT [dbo].[D_Disease_Category] OFF
    330. 

  330. 

  331. --新增病种系统特别说明
    332. 

  332. if exists(select * from  D_Disease_Category  where SystemDescription is null and DCID  in (38,39,40,41,46,47,48,49,50,52))
    333. 

  333. update D_Disease_Category set SystemDescription='<div class="content">
    334. 

  334. <p>系统特别说明：</p>
    335. 

  335. <p>1.住院时间小于24小时无需上报。</p>
    336. 

  336. </div>'
    337. 

  337. where SystemDescription is null and DCID in (38,39,40,41,46,47,48,49,50,52)
    338. 

  338. 

  339. update [Q_Roles] set [Quanxian] = [Quanxian] + ',' + (select cast(Id as nvarchar(max)) from Q_Quanxian where QuanxianName = '数据统计')
    340. 

  340. where (CHARINDEX(',6,',',' + [Quanxian] + ',') > 0 or CHARINDEX(',7,',',' + [Quanxian] + ',') > 0) 
    341. 

  341. and  CHARINDEX(','+(select cast(Id as nvarchar(max)) from Q_Quanxian where QuanxianName = '数据统计')+',',',' + [Quanxian] + ',') = 0
    342. 

  342. 

  343. UPDATE  [D_Disease_Category]
    344. 

  344. SET     [LeakExtractRule] = 3
    345. 

  345. WHERE   DiseaseDescription LIKE '%腮腺肿瘤%'
    346. 

  346.         OR DiseaseDescription LIKE '%糖尿病肾病%'
    347. 

  347.         OR DiseaseDescription LIKE '%终末期肾病血液透析%'
    348. 

  348.         OR DiseaseDescription LIKE '%终末期肾病腹膜透析%'
    349. 

  349.         OR DiseaseDescription LIKE '%原发性急性闭角型青光眼%'
    350. 

  350.         OR DiseaseDescription LIKE '%感染分娩母婴阻断%'
    351. 

  351. 

  352. 		--更新admin病种，
    353. 

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

  354. update Q_UserProfile
    355. 

  355. set CID='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52'
    356. 

  356. where UserName='admin'
    357. 

  357. 

  358. if exists(select * from D_Disease_Category where DCID=50 and DiseaseType='HPV')
    359. 

  359. update D_Disease_Category
    360. 

  360. set DiseaseType='HBV',DiseaseType_API='HBV'
    361. 

  361. where  DCID=50 and DiseaseType='HPV'
    362. 

  362. 

  363. --年龄大于18岁以及小于2岁的新生儿肺炎
    364. 

  364. if exists(select * from  D_ReportStaticsQuota  where id=2 and  ReportClassArr<>'8,47,' )
    365. 

  365. update D_ReportStaticsQuota set ReportClassArr='8,47,',StaticsQuotaName='年龄大于等于18岁以及小于2岁的新生儿' 
    366. 

  366. where id=2 and  ReportClassArr<>'8,47,' 
    367. 

  367. 

  368. --同一疾病30日内重复入院
    369. 

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

  370. update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,'
    371. 

  371. where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,' 
    372. 

  372. 

  373. --HBIPS 住院精神病患者安全和权益 无需上报内容
    374. 

  374. if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%小于18周岁的病例%' and DCID = 14)
    375. 

  375. update D_Disease_Category set DiseaseContent='
    376. 

  376. <div class="content"><p>上报内容：</p>
    377. 

  377. <div class="page">
    378. 

  378. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">主要诊断 ICD-10 编码:F00-F99 的出院患者。&nbsp;</span></p>
    379. 

  379. </div>
    380. 

  380. <p>&nbsp;</p>
    381. 

  381. <p>无需上报内容：</p>
    382. 

  382. <p><span style="white-space: pre;"> </span>1.住院时间＞365天（一年）</p>
    383. 

  383. <p><span style="white-space: pre;"> </span>2.住院24小时内出院</p>
    384. 

  384. <p><span style="white-space: pre;"> </span>3.住院24小时内死亡</p>
    385. 

  385. <p><span style="white-space: pre;"> </span>4.临床药物或器械试验的病例</p>
    386. 

  386. <p><span style="white-space: pre;"> </span>5.小于18周岁的病例</p>
    387. 

  387. <p>&nbsp;</p>
    388. 

  388. <p>数据验证</p>
    389. 

  389. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    390. 

  390. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    391. 

  391. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    392. 

  392. <p>&nbsp;</p></div>'
    393. 

  393. where DiseaseContent  not like '%小于18周岁的病例%' and DCID = 14
    394. 

  394. 

  395. if exists(select * from  D_Disease_Category  where SystemDescription is not null  and DCID = 14)
    396. 

  396. update D_Disease_Category set SystemDescription = null
    397. 

  397. where SystemDescription is not null  and DCID = 14
    398. 

  398. 

  399. --pip、dvt重复将pip未报数据标记为无需上报
    400. 

  400. if exists(select * from Report_Leak where ( OpertationICD like  '65.2%'or OpertationICD like  '65.3%%' or OpertationICD like'65.4%' 
    401. 

  401. or OpertationICD like'65.5%'   or OpertationICD like'65.6%' or OpertationICD like'00.7%' or OpertationICD like'81.51%'  
    402. 

  402. or OpertationICD like'81.52%' or OpertationICD like'81.53%' or OpertationICD like'00.80%' or OpertationICD like'00.81%' 
    403. 

  403. or OpertationICD like'00.82%' or OpertationICD like'00.83%'   or OpertationICD like'81.54%' or OpertationICD like'81.55%' or OpertationICD like'36.1') 
    404. 

  404. and ReportClass=9 and DealReport=0 )
    405. 

  405. update Report_Leak set DealReport=2,NoMustReportReason ='PIP与DVT重复的病种'
    406. 

  406. where ( OpertationICD like  '65.2%'or OpertationICD like  '65.3%%' or OpertationICD like'65.4%' 
    407. 

  407. or OpertationICD like'65.5%'   or OpertationICD like'65.6%' or OpertationICD like'00.7%' or OpertationICD like'81.51%'  
    408. 

  408. or OpertationICD like'81.52%' or OpertationICD like'81.53%' or OpertationICD like'00.80%' or OpertationICD like'00.81%' 
    409. 

  409. or OpertationICD like'00.82%' or OpertationICD like'00.83%'   or OpertationICD like'81.54%' or OpertationICD like'81.55%' or OpertationICD like'36.1') 
    410. 

  410. and ReportClass=9 and DealReport=0 
    411. 

  411. 

  412. --修改部分上报说明
    413. 

  413. if exists(select * from  D_Disease_Category  where CHARINDEX('主要手术 ICD-9-CM-3 编码:35.53、35.55、35.62、35.72 的手术出院患者。',DiseaseContent) > 0 and Num='form-31')
    414. 

  414. begin
    415. 

  415. update D_Disease_Category set DiseaseContent=REPLACE(DiseaseContent,'主要手术 ICD-9-CM-3 编码:35.53、35.55、35.62、35.72 的手术出院患者。','主要手术 ICD-9-CM-3 编码:35.51、35.52、35.61、35.71 的手术出院患者。') where Num='form-31'
    416. 

  416. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p><span style="font-family: 宋体; font-size: 12pt;">上报内容:</span></p>
    417. 

  417. <p><span style="font-size: 12pt; font-family: 宋体;">主要手术ICD-9-CM-3 编码如下的手术出院患者：</span></p>
    418. 

  418. <p><span style="font-size: 12pt; font-family: 宋体;"><!-- [if !supportLists]--><span style="letter-spacing: -0.1pt;">（1）</span>闭合性心脏瓣膜切开术：35.00<span style="letter-spacing: -1.4pt;">&nbsp;至 </span>35.04</span></p>
    419. 

  419. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（2）</span>心脏瓣膜切开和其他置换术：35.20<span style="letter-spacing: -2.7pt;">&nbsp;至 </span>35.28</span></p>
    420. 

  420. <p><span style="font-size: 12pt; font-family: 宋体;">（3）脊柱颈融合术：81.04<span style="letter-spacing: -1.5pt;">&nbsp;至 </span>81.08</span></p>
    421. 

  421. <p><span style="font-size: 12pt; font-family: 宋体;">（4）脊柱再融合术：81.34<span style="letter-spacing: -1.5pt;">&nbsp;至 </span>81.38</span></p>
    422. 

  422. <p><span style="font-size: 12pt; font-family: 宋体;"><!-- [if !supportLists]--><span style="letter-spacing: -0.1pt;">（5）</span>胃部分切除术伴胃十二指肠吻合术：43.6</span></p>
    423. 

  423. <p><span style="font-size: 12pt; font-family: 宋体;"><!-- [if !supportLists]--><span style="letter-spacing: -0.1pt;">（6）</span>胃部分切除术伴胃空肠吻合术：43.7</span></p>
    424. 

  424. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（7）</span>其他胃部分切除术：43.8</span></p>
    425. 

  425. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（8）</span>胃全部切除术：43.9</span></p>
    426. 

  426. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（9）</span>开放性和其他部分大肠切除术：45.7</span></p>
    427. 

  427. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（10）</span>腹会阴直肠切除术：48.5</span></p>
    428. 

  428. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（11）</span>直肠</span></p>
    429. 

  429. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="text-indent: -24pt;">其他切除术：</span><span style="text-indent: -24pt;">48.6</span></span></p>
    430. 

  430. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（12）</span>肝叶切除术：50.3</span></p>
    431. 

  431. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（13）</span>部分肾切除术：55.4</span></p>
    432. 

  432. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（14）</span>全部肾切除术：55.5</span></p>
    433. 

  433. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（15）</span>部分膀胱切除术：57.6</span></p>
    434. 

  434. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（16）</span>全部膀胱切除术：57.7</span></p>
    435. 

  435. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（17）</span>卵巢病损或卵巢组织的局部切除术或破坏术：65.2</span></p>
    436. 

  436. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（18）</span>单侧卵巢切除术：65.3</span></p>
    437. 

  437. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（19）</span>单侧输卵管-卵巢切除术：65.4</span></p>
    438. 

  438. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（20）</span>双侧卵巢切除术：65.5</span></p>
    439. 

  439. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（21）</span>双侧输卵管-卵巢切除术：65.6</span></p>
    440. 

  440. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（22）</span>子宫病损或组织的切除术或破坏术：68.2</span></p>
    441. 

  441. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（23）</span>经腹子宫次全切除术：68.3</span></p>
    442. 

  442. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（24）</span>经腹子宫全部切除术：68.4</span></p>
    443. 

  443. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（25）</span>阴道子宫切除术：68.5</span></p>
    444. 

  444. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（26）</span>经腹根治性子宫切除术：68.6</span></p>
    445. 

  445. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（27）</span>根治性阴道子宫切除术：68.7</span></p>
    446. 

  446. <p><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">（28）</span>盆腔脏器去除术：68.8</span></p>
    447. 

  447. <p><span style="font-size: 12pt; font-family: 宋体;">（29）髋关节置换术：00.7，81.51<span style="letter-spacing: -2.75pt;">&nbsp;至 </span>81.53</span></p>
    448. 

  448. <p><span style="font-size: 12pt; font-family: 宋体;">（30）膝关节置换术：00.80<span style="letter-spacing: -2.75pt;">&nbsp;至 </span>00.83，81.54，81.55</span></p>
    449. 

  449. <p><span style="font-family: 宋体; font-size: 12pt;">（31）冠状动脉旁路移植术：36.1</span></p>
    450. 

  450. <p style="white-space: normal;"><span style="font-family: 宋体; font-size: 14pt;">&nbsp;</span><span style="font-family: 宋体;">“围手术期预防深静脉血栓栓塞”（DVT）与“围手术期预防感染”（PIP）有重复的病种：</span></p>
    451. 

  451. <p style="white-space: normal;"><span style="font-family: 宋体;">（1） 闭合性心脏瓣膜切开术</span></p>
    452. 

  452. <p style="white-space: normal;"><span style="font-family: 宋体;">（2） 心脏瓣膜置换术</span></p>
    453. 

  453. <p style="white-space: normal;"><span style="font-family: 宋体;">（3） 脊柱颈融合术</span></p>
    454. 

  454. <p style="white-space: normal;"><span style="font-family: 宋体;">（4） 脊柱再融合术</span></p>
    455. 

  455. <p style="white-space: normal;"><span style="font-family: 宋体;">（5） 冠状动脉搭桥术</span></p>
    456. 

  456. <p style="white-space: normal;"><span style="font-family: 宋体;">（6） 髋关节置换术</span></p>
    457. 

  457. <p style="white-space: normal;"><span style="font-family: 宋体;">（7） 膝关节置换术</span></p>
    458. 

  458. <p style="white-space: normal;"><span style="font-family: 宋体;">因DVT中已包含PIP的内容，此种情况仅填写DVT，无需填报2次。</span></p>
    459. 

  459. <p>&nbsp;</p></div>' where Num='form-17'
    460. 

  460. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容：</p>
    461. 

  461. <div class="page" title="Page 58">
    462. 

  462. <div class="layoutArea">
    463. 

  463. <div class="column">
    464. 

  464. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">主要手术 ICD-9-CM-3 编码如下的手术出院患者: </span></p>
    465. 

  465. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">1.甲状腺叶切除术:06.2 至 06.5 </span></p>
    466. 

  466. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">2.膝半月软骨切除术:80.6</span></p>
    467. 

  467. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;"><br>3.晶状体相关手术:13.0 至 13.9</span></p>
    468. 

  468. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">4.腹股沟疝相关手术:17.11 至 17.13，17.21 至 17.24， 53.00 至 53.17 </span></p>
    469. 

  469. <span style="font-size: 12pt;"> </span>
    470. 

  470. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">5.乳房组织相关手术:85.2 至 85.4 </span></p>
    471. 

  471. <span style="font-size: 12pt;"> </span>
    472. 

  472. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">6.动脉内膜切除术:38.1</span></p>
    473. 

  473. </div>
    474. 

  474. </div>
    475. 

  475. <div class="layoutArea">
    476. 

  476. <div class="column"><span style="font-size: 12pt;"> </span></div>
    477. 

  477. <span style="font-size: 12pt;"> </span></div>
    478. 

  478. <span style="font-size: 12pt;"> </span></div>
    479. 

  479. <div class="page" title="Page 59"><span style="font-size: 12pt;"> </span>
    480. 

  480. <div class="layoutArea"><span style="font-size: 12pt;"> </span>
    481. 

  481. <div class="column"><span style="font-size: 12pt;"> </span>
    482. 

  482. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">7.足和踝关节固定术和关节制动术:81.1 </span></p>
    483. 

  483. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">8.其他颅骨切开术:01.24 </span></p>
    484. 

  484. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">9.椎间盘切除术或破坏术:80.50 至 80.59 </span></p>
    485. 

  485. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">10.骨折切开复位+内固定术:03.53，21.72，76.72 至 76.79，79.30 至 79.39 </span></p>
    486. 

  486. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">11.关节脱位切开复位内固定术:76.94，79.8 </span></p>
    487. 

  487. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">12.骨内固定不伴骨折复位术及置入装置去除:78.5 至 78.6 </span></p>
    488. 

  488. <span style="font-size: 12pt;"> </span>
    489. 

  489. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">13.卵巢相关手术:65.2 至 65.6 </span></p>
    490. 

  490. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">14.肌腱相关手术:83.11 至 83.14 </span></p>
    491. 

  491. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">15.睾丸相关手术:62.0 至 62.9 </span></p>
    492. 

  492. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">16.阴茎相关手术:64.0 至 64.4</span></p>
    493. 

  493. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">17.室间隔缺损修补术:35.62 </span></p>
    494. 

  494. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">18.房间隔缺损修补术:35.61 </span></p>
    495. 

  495. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">19.髋关节置换术:00.7，81.51 至 81.53 </span></p>
    496. 

  496. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">20.膝关节置换术:00.80 至 00.83，81.54，81.55 </span></p>
    497. 

  497. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">21.冠状动脉旁路移植术:36.1 </span></p>
    498. 

  498. <p><span style="font-size: 12pt; font-family: FangSong_GB2312;">22.剖宫产:74.0，74.1，74.2，74.4，74.99</span></p>
    499. 

  499. </div>
    500. 

  500. </div>
    501. 

  501. </div>
    502. 

  502. <p>&nbsp;</p>
    503. 

  503. <p>“围手术期预防感染”（PIP）与“围手术期预防深静脉血栓栓塞”（DVT）有重复的病种：</p>
    504. 

  504. <p>（1）&nbsp; &nbsp;闭合性心脏瓣膜切开术</p>
    505. 

  505. <p>（2）&nbsp; &nbsp;心脏瓣膜置换术</p>
    506. 

  506. <p>（3）&nbsp; &nbsp;脊柱颈融合术</p>
    507. 

  507. <p>（4）&nbsp; &nbsp;脊柱再融合术</p>
    508. 

  508. <p>（5）&nbsp; &nbsp;冠状动脉搭桥术</p>
    509. 

  509. <p>（6）&nbsp; &nbsp;髋关节置换术</p>
    510. 

  510. <p>（7）&nbsp; &nbsp;膝关节置换术</p>
    511. 

  511. <p>因DVT中已包含PIP的内容，此种情况仅填写DVT，无需填报2次。</p>
    512. 

  512. <div class="page" title="Page 59">
    513. 

  513. <div class="layoutArea">
    514. 

  514. <div class="column">
    515. 

  515. <p>&nbsp;</p>
    516. 

  516. </div>
    517. 

  517. </div>
    518. 

  518. </div></div>' where Num='form-18'
    519. 

  519. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容</p>
    520. 

  520. <div class="page" title="Page 53">
    521. 

  521. <div class="layoutArea">
    522. 

  522. <div class="column">
    523. 

  523. <div class="page" title="Page 53">
    524. 

  524. <div class="layoutArea">
    525. 

  525. <div class="column">
    526. 

  526. <p><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:E10.3，E11.3，E14.3，H33.0 至 H33.5，H59.8，且伴主要手术 ICD-9-CM-3 编码:13.19，13.3， 13.41，13.42，13.43，13.59，13.64，13.65，13.69，13.70， 13.71，13.72，13.8，13.90，14.29，14.31，14.49，14.51， 14.52，14.53，14.54，14.59，14.71，14.72，14.73，14.75， 14.9 的手术出院患者。&nbsp;</span></p>
    527. 

  527. </div>
    528. 

  528. </div>
    529. 

  529. </div>
    530. 

  530. </div>
    531. 

  531. </div>
    532. 

  532. </div>
    533. 

  533. <p>无需上报内容：</p>
    534. 

  534. <p>1.由外院住院诊疗后转入本院的病例</p>
    535. 

  535. <p>2.参与临床药物与器械试验的病例</p>
    536. 

  536. <p><span style="white-space: pre;">3</span>.18岁以下的病例,</p>
    537. 

  537. <p><span style="white-space: pre;">4</span>.同一疾病30日内重复入院,</p>
    538. 

  538. <p><span style="white-space: pre;">5</span>.本次住院超过90天！</p>
    539. 

  539. <p>&nbsp;</p>
    540. 

  540. <p>数据验证：</p>
    541. 

  541. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    542. 

  542. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>' where Num='form-38'
    543. 

  543. end
    544. 

  544. 

  545. --修改部分上报说明
    546. 

  546. if exists(select * from  D_Disease_Category  where CHARINDEX('1.年龄大于18岁以及小于2岁的新生儿肺炎',DiseaseContent) > 0 and DCID=8)
    547. 

  547. begin
    548. 

  548. --cap
    549. 

  549. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容</p>
    550. 

  550. <p><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:J13 至 J16，J18;2 岁≤年龄<18 岁的出院患儿。&nbsp;</span></p>
    551. 

  551. <p>&nbsp;</p>
    552. 

  552. <p>无需上报内容：</p>
    553. 

  553. <p><span style="white-space: pre;"> </span>1.年龄大于18岁以及2岁以下</p>
    554. 

  554. <p><span style="white-space: pre;"> </span>2.由外院住院诊疗后转入本院,</p>
    555. 

  555. <p><span style="white-space: pre;"> </span>3.参与临床药物与器械试验,</p>
    556. 

  556. <p><span style="white-space: pre;"> </span>4.肺炎反复门诊抗菌素治疗无效,</p>
    557. 

  557. <p><span style="white-space: pre;"> </span>5.同一疾病30日内重复入院，</p>
    558. 

  558. <p><span style="white-space: pre;"> </span>6.呼吸机相关性肺炎VAP</p>
    559. 

  559. <p><span style="white-space: pre;"> </span>7.医院获得性肺炎HAP</p>
    560. 

  560. <p><span style="white-space: pre;"> </span>8.本次住院时间超过90天</p>
    561. 

  561. <p>&nbsp;</p>
    562. 

  562. <p>数据验证：</p>
    563. 

  563. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    564. 

  564. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    565. 

  565. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    566. 

  566. <p>&nbsp;</p></div>' where DCID=8
    567. 

  567. --stk
    568. 

  568. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容：</p>
    569. 

  569. <p><span style="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断 ICD-10 编码:I63.0 至 I63.9 的出院患者。&nbsp;</span></p>
    570. 

  570. <p>&nbsp;</p>
    571. 

  571. <p>无需上报内容：</p>
    572. 

  572. <p><span style="white-space: pre;"> </span>1.由外院诊疗后转入本院的病例</p>
    573. 

  573. <p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
    574. 

  574. <p><span style="white-space: pre;"> </span>3.18岁以下的病例</p>
    575. 

  575. <p><span style="white-space: pre;"> </span>4.非首次确诊急性脑梗死患者</p>
    576. 

  576. <p><span style="white-space: pre;"> </span>5.脑梗死后遗症I69.3</p>
    577. 

  577. <p><span style="white-space: pre;"> </span>6.脑梗死反复门诊治疗无效</p>
    578. 

  578. <p><span style="white-space: pre;"> </span>7.同一疾病30日内重复入院</p>
    579. 

  579. <p><span style="white-space: pre;"> </span>8.腔隙性脑梗死</p>
    580. 

  580. <p><span style="white-space: pre;"> </span>9.小脑梗死</p>
    581. 

  581. <p><span style="white-space: pre;"> </span>10.出血性脑梗死</p>
    582. 

  582. <p><span style="white-space: pre;"> </span>11.本次住院天数大于90天</p>
    583. 

  583. <p>&nbsp;</p>
    584. 

  584. <p>数据验证：</p>
    585. 

  585. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    586. 

  586. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    587. 

  587. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    588. 

  588. <p>&nbsp;</p></div>',
    589. 

  589. SystemDescription='<div class="content">
    590. 

  590. <p>系统特别说明：</p>
    591. 

  591. <p>1.住院时间小于24小时无需上报。</p>
    592. 

  592. </div>'where DCID=6
    593. 

  593. --cs
    594. 

  594. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容：</p>
    595. 

  595. <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>
    596. 

  596. <div class="page" title="Page 36">
    597. 

  597. <div class="layoutArea">
    598. 

  598. <div class="column"><span style="font-size: 12pt;"> </span></div>
    599. 

  599. <span style="font-size: 12pt;"> </span></div>
    600. 

  600. <span style="font-size: 12pt;"> </span></div>
    601. 

  601. <p>&nbsp;</p>
    602. 

  602. <p>无需上报内容：</p>
    603. 

  603. <p><span style="white-space: pre;"> </span>1.由外院剖宫产术后转入本院的病例</p>
    604. 

  604. <p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
    605. 

  605. <p><span style="white-space: pre;"> </span>3.18岁以下的病例</p>
    606. 

  606. <p><span style="white-space: pre;"> </span>4.同一疾病30日内重复入院</p>
    607. 

  607. <p><span style="white-space: pre;"> </span>5.本次住院超过90天</p>
    608. 

  608. <p><span style="white-space: pre;"> </span>6.病历记录孕期＜28周或不明的</p>
    609. 

  609. <p>&nbsp;</p>
    610. 

  610. <p>数据验证：</p>
    611. 

  611. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    612. 

  612. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    613. 

  613. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    614. 

  614. <p>&nbsp;</p></div>',
    615. 

  615. SystemDescription='<div class="content">
    616. 

  616. <p>系统特别说明：</p>
    617. 

  617. <p>1.住院时间小于24小时无需上报。</p>
    618. 

  618. </div>'where DCID=10
    619. 

  619. --asd
    620. 

  620. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">ASD </span><span style="sans-serif; color: black;">房间隔缺损手术</span></p>
    621. 

  621. <p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">上报内容：</span></p>
    622. 

  622. <p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;"> </span></p>
    623. 

  623. <div class="page" title="Page 13">
    624. 

  624. <div class="layoutArea">
    625. 

  625. <div class="column">
    626. 

  626. <p><span style="font-size: 16.000000pt; "><span style="font-size: 12pt;">&nbsp; &nbsp; &nbsp;主要手术 ICD-9-CM-3 编码:35.51、35.52、35.61、35.71 的手术出院患者。</span>&nbsp;</span></p>
    627. 

  627. </div>
    628. 

  628. </div>
    629. 

  629. </div>
    630. 

  630. <div class="page" title="Page 13">&nbsp;</div>
    631. 

  631. <p style="background: white; margin: 0 0 10px 0;"><span style="font-family:sans-serif; color: black;">无需上报内容：</span></p>
    632. 

  632. <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>
    633. 

  633. <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>
    634. 

  634. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">3.</span><span style="font-family: sans-serif; color: black;">本次住院超过90天</span></p>
    635. 

  635. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
    636. 

  636. <p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">数据验证：</span></p>
    637. 

  637. <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>
    638. 

  638. <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>
    639. 

  639. <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>
    640. 

  640. <p>&nbsp;</p></div>' where DCID=30
    641. 

  641. --vsd
    642. 

  642. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
    643. 

  643. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">&nbsp;上报内容：</span></p>
    644. 

  644. <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>
    645. 

  645. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span style="font-family:sans-serif; color: black;">&nbsp;</span></p>
    646. 

  646. <p style="background: white; margin: 0 0 10px 0;"><span style="font-family: sans-serif; color: black;">&nbsp; &nbsp; &nbsp; 无需上报内容：</span></p>
    647. 

  647. <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>
    648. 

  648. <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>
    649. 

  649. <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>
    650. 

  650. <p style="text-indent: 28px; background: white;"><span style="font-family: sans-serif; color: black;">&nbsp;</span></p>
    651. 

  651. <p style="text-indent: 28px; background: white;"><span style="font-family: sans-serif; color: black;">数据验证：</span></p>
    652. 

  652. <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>
    653. 

  653. <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>
    654. 

  654. <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>
    655. 

  655. <p>&nbsp;</p>
    656. 

  656. <p>&nbsp;</p></div>' where DCID=31
    657. 

  657. --ddh
    658. 

  658. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容</p>
    659. 

  659. <div class="page" title="Page 53">
    660. 

  660. <div class="layoutArea">
    661. 

  661. <div class="column">
    662. 

  662. <div class="page" title="Page 53">
    663. 

  663. <div class="layoutArea">
    664. 

  664. <div class="column">
    665. 

  665. <p><span style="font-size: 12pt;">主要诊断 ICD-10 编码:Q65.0 至 Q65.6、Q65.8、Q65.9, 伴主要手术 ICD-9-CM-3 编码: 79.85、77.25、77.29;1岁 ≤年龄≤8 岁(旧称先天性髋关节脱位)的手术出院患儿。</span><span style="font-family: FangSong; font-size: 16pt;">&nbsp;</span></p>
    666. 

  666. </div>
    667. 

  667. </div>
    668. 

  668. </div>
    669. 

  669. </div>
    670. 

  670. </div>
    671. 

  671. </div>
    672. 

  672. <p>&nbsp;</p>
    673. 

  673. <p>无需上报内容：</p>
    674. 

  674. <p>1.参与临床药物与器械试验的病例</p>
    675. 

  675. <p><span style="white-space: pre;">2.</span>年龄＜18个月或年龄＞8岁的患者</p>
    676. 

  676. <p><span style="white-space: pre;">3</span>.本次住院超过90天！</p>
    677. 

  677. <p>&nbsp;</p>
    678. 

  678. <p>数据验证：</p>
    679. 

  679. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    680. 

  680. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>' where DCID=52
    681. 

  681. --vte
    682. 

  682. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p><!-- [if !supportLists]-->
    683. 

  683. <span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">上报内容：</span></span><br><br>
    684. 

  684. <span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">1.</span><span style="letter-spacing: -1.35pt;">
    685. 

  685. <span style="font-family: 宋体;">入住</span> </span>ICU<span style="letter-spacing: -1.05pt;">&nbsp;<span style="font-family: 宋体;">的患者</span></span></span><br>
    686. 

  686. <span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -0.1pt;">2.</span><span style="font-family: 宋体;">中高危风险患者：</span></span><br>
    687. 

  687. <span style="font-size: 12pt; font-family: 宋体;"><span style="font-family: 宋体;">（</span>1）<span style="font-family: 宋体;">高龄（</span>≥70<span style="letter-spacing: -2.05pt;">&nbsp;<span style="font-family: 宋体;">岁</span></span><span style="font-family: 宋体;">）</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.35pt;">（2）</span><span style="letter-spacing: -1.35pt;"><span style="font-family: 宋体;">既往</span></span>VTE<span style="letter-spacing: -1.65pt;">&nbsp;<span style="font-family: 宋体;">病史或</span></span>VTE<span style="letter-spacing: -1.05pt;">&nbsp;<span style="font-family: 宋体;">家族史</span></span></span><br><span style="font-size: 12pt; font-family: 宋体;">（3）<span style="font-family: 宋体;">恶性肿瘤</span>(ICD-10<span style="letter-spacing: -0.75pt;">&nbsp;<span style="font-family: 宋体;">类目编码</span>:</span>C00-C97)</span><br><span style="font-size: 12pt; font-family: 宋体;">（4）<span style="font-family: 宋体;">严重创伤</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="font-family: 宋体;">（</span><span style="letter-spacing: 0.05pt;">5</span><span style="font-family: 宋体;">）</span><span style="font-family: 宋体;">脓毒症</span><span style="letter-spacing: 0.05pt;">(I</span><span style="letter-spacing: -0.1pt;">C</span><span style="letter-spacing: 0.05pt;">D-</span><span style="letter-spacing: -0.1pt;">1</span>0<span style="letter-spacing: -4.7pt;">&nbsp;</span><span style="font-family: 宋体;">亚目编码</span><span style="letter-spacing: -7.95pt;"><span style="font-family: 宋体;">：</span>“</span><span style="letter-spacing: 0.05pt;">A4</span><span style="letter-spacing: -0.1pt;">0</span><span style="letter-spacing: 0.05pt;">.</span><span style="letter-spacing: -0.1pt;">0</span><span style="letter-spacing: -7.95pt;"><span style="font-family: 宋体;">、</span></span>
    688. 

  688. <span style="letter-spacing: 0.05pt;">A4</span><span style="letter-spacing: -0.1pt;">0</span><span style="letter-spacing: 0.05pt;">.</span>
    689. 

  689. <span style="letter-spacing: -0.1pt;">1</span><span style="letter-spacing: -7.95pt;"><span style="font-family: 宋体;">、</span></span>
    690. 

  690. <span style="letter-spacing: 0.05pt;">A4</span><span style="letter-spacing: -0.1pt;">0</span><span style="letter-spacing: 0.05pt;">.</span>
    691. 

  691. <span style="letter-spacing: -0.1pt;">2</span><span style="font-family: 宋体;">、</span></span><br><span style="font-size: 12pt; font-family: 宋体;">A40.3<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A40.8<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A40.9<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A41.0<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A41.1<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A41.2<span style="letter-spacing: -0.15pt;"><span style="font-family: 宋体;">、</span></span>A41.3、</span><br><span style="font-size: 12pt; font-family: 宋体;">A41.4、A41.5、A41.8、A41.9，R65.2、R65.3、R65.9)</span><br><span style="font-size: 12pt; font-family: 宋体;">（6）<span style="font-family: 宋体;">急性生理和慢性健康评分</span>⁃<span style="letter-spacing: -0.3pt;">Ⅱ（APACHE</span><span style="letter-spacing: -0.3pt;">⁃</span><span style="letter-spacing: -0.8pt;">Ⅱ）＞</span></span><span style="font-size: 12pt; font-family: 宋体;">12 分</span><br><span style="font-size: 12pt; font-family: 宋体;">（7）<span style="font-family: 宋体;">急诊手术及麻醉复苏室转入</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.35pt;">（8）</span><span style="letter-spacing: -1.35pt;"><span style="font-family: 宋体;">转入</span></span>ICU<span style="letter-spacing: -0.65pt;">&nbsp;<span style="font-family: 宋体;">前住院时间长</span></span><span style="font-family: 宋体;">（</span>&gt;30<span style="letter-spacing: -2pt;">&nbsp;<span style="font-family: 宋体;">天</span></span><span style="font-family: 宋体;">）</span></span><br><span style="font-size: 12pt; font-family: 宋体;">（9）<span style="font-family: 宋体;">制动</span></span><br><span style="font-size: 12pt; font-family: 宋体;">（10）<span style="font-family: 宋体;">机械通气</span>(ICD-9-CM-3<span style="letter-spacing: -0.8pt;">&nbsp;<span style="font-family: 宋体;">亚目编码：</span></span>96.7<span style="letter-spacing: -0.95pt;">&nbsp;<span style="font-family: 宋体;">其他持续侵入性机械性通气</span>,93.90、93.91</span><span style="letter-spacing: -0.55pt;">&nbsp;<span style="font-family: 宋体;">无创机械性通气</span>)</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="font-family: 宋体;">（</span><span style="letter-spacing: -6.05pt;">&nbsp;</span>11<span style="letter-spacing: -5.95pt;">&nbsp;</span><span style="font-family: 宋体;">）</span><span style="letter-spacing: 1.25pt;"><span style="font-family: 宋体;">留置中心静脉导管</span></span>(ICD-9-CM-3<span style="letter-spacing: 1pt;">&nbsp;<span style="font-family: 宋体;">亚目编码：</span> 89.60-89.69)</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（12）</span><span style="letter-spacing: -0.3pt;"><span style="font-family: 宋体;">血液净化治疗</span></span><span style="letter-spacing: 0.1pt;"><span style="font-family: 宋体;">（</span></span><span style="letter-spacing: 0.05pt;">IC</span><span style="letter-spacing: -0.1pt;">D</span><span style="letter-spacing: 0.05pt;">-9</span><span style="letter-spacing: -0.1pt;">-</span><span style="letter-spacing: 0.05pt;">CM</span><span style="letter-spacing: -0.1pt;">-</span>3<span style="letter-spacing: -4pt;">&nbsp;</span><span style="letter-spacing: -1.6pt;"><span style="font-family: 宋体;">亚目编码：</span>“</span><span style="letter-spacing: 0.05pt;">39</span><span style="letter-spacing: -0.1pt;">.</span><span style="letter-spacing: 0.05pt;">9</span><span style="letter-spacing: -0.1pt;">5</span><span style="letter-spacing: -7.95pt;">”</span><span style="font-family: 宋体;">）</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（13）</span><span style="font-family: 宋体;">使用肌肉松弛和镇静药物</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（14）</span><span style="font-family: 宋体;">应用收缩血管药物</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（15）</span><span style="font-family: 宋体;">输注血小板</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（16）</span><span style="font-family: 宋体;">血栓预防失败</span></span><br><span style="font-size: 12pt; font-family: 宋体;"><span style="letter-spacing: -1.55pt;">（17）</span><span style="font-family: 宋体;">医师认为需评估的其他中高风险患者</span></span><br><br><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;"><span style="font-family: 宋体; font-size: 14pt;">&nbsp;</span></span></span><br><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;"><span style="font-size: 12pt; font-family: 宋体;">无需上报内容</span></span></span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">1.患者年龄小于18岁</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">2.住院时间超过90天的患者</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">3.参与临床试验的患者</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">4.患者入住或转入ICU的主要诊断或其他诊断ICD-10代码中有以下</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">（1）栓塞和血栓形成ICD-10编码四位亚目及病种名称</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">（2）产科并发栓塞ICD-10编码四位亚目及名称</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">（3）神经内科脑梗死ICD-10编码四位亚目及病种名称</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">（4）精神科ICD-10编码（F00～99）及病种名称</span><br><span style="font-family: 宋体; line-height: 18.2px; font-size: 12pt; background: #ffffff;">5.患者入住或转入ICU的主要手术与操作名称与其ICD-9.CM.3代码中，有血管外科手术名称者（如血管内膜剥脱术等）</span><br><br><span style="font-size: 12pt;"><span style="font-family: 宋体;"><span style="line-height: 18.2px; background: #ffffff;">已报送“</span><span style="line-height: 18.2px; color: #0000ff; background: #ffffff;"><span style="color: #000000;">DVT,STK,STEMI</span>,</span></span><span style="line-height: 18.2px; background: #ffffff;">
    692. 

  692. <span style="font-family: 宋体;">TKR,THR,CABG,AVR,MVR,ASD,VSD"单病种质量监测信息</span>项者，不再重复报送！</span></span></p></div>' where DCID=36
    693. 

  693. --hbv
    694. 

  694. update D_Disease_Category set DiseaseContent='<div data-v-c0d7d944="" class="content"><p>上报内容</p>
    695. 

  695. <p><span style="font-family: FangSong; font-size: 12pt;">主要诊断 ICD-10 编码:O98.4，Z22.5 + O80 至 O84+Z37; 且伴1阴道分娩操作 ICD-9-CM-3 编码 72.0 至 72.9，73.0， 73.1，73.21，73.4 至 73.6,73.9;或伴2剖宫产手术 ICD 9-CM-3 编码:74.0，74.1，74.2，74.4，74.99 的出院患者。&nbsp;</span></p>
    696. 

  696. <p>&nbsp;</p>
    697. 

  697. <p>无需上报内容：</p>
    698. 

  698. <p>1.由外院住院诊疗后转入本院的病例</p>
    699. 

  699. <p>2.参与临床药物与器械试验的病例</p>
    700. 

  700. <p><span style="white-space: pre;">3</span>.18岁以下的病例</p>
    701. 

  701. <p><span style="white-space: pre;">4.</span>同一疾病30日内重复入院</p>
    702. 

  702. <p><span style="white-space: pre;">5.</span>本次住院超过90天！</p>
    703. 

  703. <p>6.病历记录孕期＜28周或不明的</p>
    704. 

  704. <p>&nbsp;</p>
    705. 

  705. <p>数据验证：</p>
    706. 

  706. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    707. 

  707. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>' where DCID=50
    708. 

  708. end
    709. 

  709. 

  710. --根据卫健委变化将STEMI 编码为I21.9的数据再次进行调整
    711. 

  711. if exists(select * from  Report_Leak  where ReportClass = 1 and  DieaseICD like 'I21.9%'  and DealReport=0 )
    712. 

  712. update Report_Leak set DealReport=2
    713. 

  713. where ReportClass=1 and  DieaseICD like 'I21.9%'  and DealReport=0 
    714. 

  714. 

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

  716. update D_MedicalRecord set Ncis_IsCheckToWsb=0
    717. 

  717. where ReportClass = 1  and JSON_VALUE(DataInfo,'$."CM-0-1-3-1"')='e' and DataVersion='2' and Ncis_IsCheckToWsb=1
    718. 

  718. 

  719. --cs 旧数据数据处理 是否有母乳喂养禁忌证、母乳喂养禁忌证选择
    720. 

  720. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CS-8-1-1"')='a'  and   DataVersion='2' and ReportClass =10 )
    721. 

  721. update D_MedicalRecord
    722. 

  722. set DataInfo=JSON_MODIFY(DataInfo, '$."CS-8-2-1"', 'n')
    723. 

  723. where JSON_VALUE(DataInfo,'$."CS-8-1-1"')='a'  and   DataVersion='2' and ReportClass =10 
    724. 

  724. 

  725. if exists(select * from D_MedicalRecord  where  JSON_VALUE(DataInfo,'$."CS-8-1-1"')='a'  and  DataVersion='2' and ReportClass =10 )
    726. 

  726. update D_MedicalRecord
    727. 

  727. set DataInfo=JSON_MODIFY(DataInfo, '$."CS-8-1-1"', null),Ncis_IsJoinError=0
    728. 

  728. where JSON_VALUE(DataInfo,'$."CS-8-1-1"')='a'  and  DataVersion='2' and ReportClass =10 
    729. 

  729. 

  730. --编码对应 APL添加 Z51.200
    731. 

  731. if not exists(select * from Report_ICDCodeMatch where ReportClass=49 and CodeType=10 and ICDCode like 'Z51.200%')
    732. 

  732. BEGIN
    733. 

  733. INSERT [dbo].[Report_ICDCodeMatch] ([ReportClass],[ICDCode],[MatchCode],[CodeType],[IsStart],[ICDCodeValue],[SuborderValue]) 
    734. 

  734. VALUES (49, N'Z51.200', N'Z51.200', N'10',1,N'd',N'b')
    735. 

  735. INSERT [dbo].[Report_ICDCodeMatch] ([ReportClass],[ICDCode],[MatchCode],[CodeType],[IsStart],[ICDCodeValue],[SuborderValue]) 
    736. 

  736. VALUES (49, N'Z51.200x008', N'Z51.200x008', N'10',1,N'e',N'b')
    737. 

  737. END
    738. 

  738. 

  739. --将不符合条件的数据更改为无需上报
    740. 

  740. if exists(select * from  Report_Leak  where DealReport=3 )
    741. 

  741. update Report_Leak set DealReport=2 where DealReport=3
    742. 

  742. 

  743. --自定义字典表
    744. 

  744. if exists(select * from syscolumns where id=object_id('Report_DropList') and name='ReportClass') 
    745. 

  745. BEGIN
    746. 

  746. 	update Report_DropList set ReportClass=9 where Id=1
    747. 

  747. END
    748. 

  748. 

  749. if exists(select * from syscolumns where id=object_id('Report_DropListValue') and name='ReportClass') 
    750. 

  750. BEGIN
    751. 

  751. 	update Report_DropListValue set ReportClass=9 where DropListId=1
    752. 

  752. END
    753. 

  753. 

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

  755. 

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

  757. 

  758. update D_MedicalRecord set Add_OperDeptId=0 where Add_OperDeptId is null
    759. 

  759. 

  760. --暂时保留 开始--
    761. 

  761. --5.3.0版本医院未全部升级因此以下代码和5.3文件夹内代码重复，后期都普遍升级后此处可删除
    762. 

  762. --20210326卫健委变化
    763. 

  763. --住院24小时内出院  PACG 住院时间应大于24小时取消(存在日间手术) 
    764. 

  764. if exists(select * from  D_ReportStaticsQuota  where id=8 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,40,41,46,47,48,49,50,52' )
    765. 

  765. update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,40,41,46,47,48,49,50,52'  
    766. 

  766. where id=8 and  ReportClassArr<>'1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,40,41,46,47,48,49,50,52'
    767. 

  767. 

  768. --更新自动对接卫健委
    769. 

  769. if exists(select * from  Q_Options  where Name='NcisAutoOpenList' and Value<>'' and Value is not null)
    770. 

  770. update D_Disease_Category set IsNcisAutoOpen=1 
    771. 

  771. where IsNcisChange=1 and 
    772. 

  772. CHARINDEX(','+ cast(DCID as nvarchar(max)) +',',(select top 1 ','+ Value from Q_Options where Name='NcisAutoOpenList')) > 0
    773. 

  773. --将程序中卫健委变化标志取消
    774. 

  774. if exists(select * from  D_Disease_Category  where IsNcisChange=1)
    775. 

  775. update D_Disease_Category set IsNcisChange=null
    776. 

  776. where IsNcisChange=1
    777. 

  777. --更新公告
    778. 

  778. if exists(select * from  Report_InterAnnounce  where  IsTop=1 and CHARINDEX('因国家单病种平台填报内容发生变化',Title) > 0)
    779. 

  779. update Report_InterAnnounce set IsTop=0 
    780. 

  780. where  IsTop=1 and CHARINDEX('因国家单病种平台填报内容发生变化',Title) > 0
    781. 

  781. if exists(select * from  Q_Options where Name='NcisAutoOpenList' and Value<>'' and Value is not null)
    782. 

  782. update Q_Options set Value=''
    783. 

  783. where Name='NcisAutoOpenList' and Value<>'' and Value is not null
    784. 

  784. 

  785. --病种重复病除外设置 VTE-BC
    786. 

  786. if exists(select * from  D_RepeatReportSetting  where ReportClass=36 and RepeatReportClass=17 and Icd9Code is null)
    787. 

  787. update D_RepeatReportSetting set Icd9Code='85.2、85.3、85.4'
    788. 

  788. where ReportClass=36 and RepeatReportClass=17 and Icd9Code is null
    789. 

  789. 

  790. --pip 无需上报内容
    791. 

  791. if exists(select * from  D_Disease_Category  where SystemDescription like '%18岁以下的病例%' and DCID = 9)
    792. 

  792. update D_Disease_Category set SystemDescription='
    793. 

  793. <div class="content">
    794. 

  794. <p>系统特别说明：</p>
    795. 

  795. <p>1.同一疾病30日内重复入院，无需上报</p>
    796. 

  796. <p>2.本次住院天数大于90天，无法上报。</p>
    797. 

  797. </div>'
    798. 

  798. where SystemDescription like '%18岁以下的病例%' and DCID = 9
    799. 

  799. 

  800. --无需上报条件 18岁以下的病例
    801. 

  801. if exists(select * from  D_ReportStaticsQuota  where id=1 and  ReportClassArr<>'1,2,3,4,5,6,7,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' )
    802. 

  802. update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' 
    803. 

  803. where id=1 and  ReportClassArr<>'1,2,3,4,5,6,7,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,50,51,' 
    804. 

  804. 

  805. --漏报设置更新科室改为关闭状态
    806. 

  806. if exists(select * from  D_Disease_Category  where HisDeptEnabled=1 )
    807. 

  807. update D_Disease_Category set HisDeptEnabled=0  
    808. 

  808. where HisDeptEnabled=1
    809. 

  809. 

  810. --cacc 去除编码 O99.5
    811. 

  811. if exists(select * from  Report_Leak  where ReportClass = 47 and  DieaseICD like 'O99.5%'  and DealReport=0 )
    812. 

  812. update Report_Leak set DealReport=2
    813. 

  813. where ReportClass = 47 and  DieaseICD like 'O99.5%'  and DealReport=0 
    814. 

  814. 

  815. --tia 去除编码G45.004
    816. 

  816. if exists(select * from  Report_Leak  where ReportClass = 13 and  DieaseICD like 'G45.004%'  and DealReport=0 )
    817. 

  817. update Report_Leak set DealReport=2
    818. 

  818. where ReportClass=13 and  DieaseICD like 'G45.004%'  and DealReport=0 
    819. 

  819. 

  820. --根据处理记录更新漏报管理状态
    821. 

  821. update Report_Leak set NoMustReportReason=
    822. 

  822. (NoMustReportReason+' '+
    823. 

  823. (select top(1) ChangeNote from Report_LeakLog where Report_Leak.ID=Report_LeakLog.LeakId  order by ChangeDate desc)
    824. 

  824. ),DealReport=2
    825. 

  825. where  id in (
    826. 

  826. select ID from (SELECT (select top(1) ChangeNote from Report_LeakLog where Report_Leak.ID=Report_LeakLog.LeakId  order by ChangeDate desc) as note 
    827. 

  827. ,(select top(1) Status from Report_LeakLog where Report_Leak.ID=Report_LeakLog.LeakId  order by ChangeDate desc) as Status 
    828. 

  828. ,*	  
    829. 

  829. FROM Report_Leak ) a   
    830. 

  830. where DealReport=0  and Status =2   
    831. 

  831. )
    832. 

  832. 

  833. --原“数据统计”权限，改为“指标统计”
    834. 

  834. update Q_Quanxian set QuanxianName='指标统计' where QuanxianName='数据统计' and id=24
    835. 

  835. --数据预警将接口自动对接改为 对接失败
    836. 

  836. if exists(select * from  Q_DiseaseGrade  where DiseaseGradeID=5 and DiseaseGradeName='接口自动对接')
    837. 

  837. update Q_DiseaseGrade set DiseaseGradeName='对接失败'
    838. 

  838. where DiseaseGradeID=5 and DiseaseGradeName='接口自动对接'
    839. 

  839. 

  840. --asd vsd 上报说明
    841. 

  841. --asd
    842. 

  842. if not exists(select * from  D_Disease_Category  where DiseaseContent like '%18岁人群%' and DCID = 30)
    843. 

  843. update D_Disease_Category set DiseaseContent=
    844. 

  844. '<div class="content">
    845. 

  845. <p style="background: white; margin: 0 0 10px 0;"><span>上报内容：</span></p>
    846. 

  846. <div class="column">
    847. 

  847. <p><span ><span style="font-size: 12pt;">&nbsp; &nbsp; &nbsp;主要手术 ICD-9-CM-3 编码:35.51、35.52、35.61、35.71 的手术出院患者。</span>&nbsp;</span></p>
    848. 

  848. </div>
    849. 

  849. <div class="page" title="Page 13">&nbsp;</div>
    850. 

  850. <p style="background: white; margin: 0 0 10px 0;"><span>无需上报内容：</span></p>
    851. 

  851. <p style="text-indent: 28px; background: white;"><span>1.参与临床药物与器械试验的病例,</span></p>
    852. 

  852. <p style="text-indent: 28px; background: white;"><span>2.外院转入手术失敗病例</span></p>
    853. 

  853. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span>3.本次住院超过90天</span></p>
    854. 

  854. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span>4.年龄＜2岁，年龄＞18岁人群</span></p>
    855. 

  855. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
    856. 

  856. <p style="background: white; margin: 0 0 10px 0;"><span>数据验证：</span></p>
    857. 

  857. <p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span>是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
    858. 

  858. <p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span>强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
    859. 

  859. <p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3. </span><span>其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
    860. 

  860. <p>&nbsp;</p></div>' 
    861. 

  861. where DCID = 30
    862. 

  862. --vsd
    863. 

  863. if not exists(select * from  D_Disease_Category  where DiseaseContent like '%18岁人群%' and DCID = 31)
    864. 

  864. update D_Disease_Category set DiseaseContent=
    865. 

  865. '<div class="content">
    866. 

  866. <p style="background: white; margin: 0 0 10px 0;"><span>上报内容：</span></p>
    867. 

  867. <div class="column">
    868. 

  868. <p><span ><span style="font-size: 12pt;">&nbsp; &nbsp; &nbsp;主要手术 ICD-9-CM-3 编码:35.53、35.55、35.62、35.72 的手术出院患者。 </span>&nbsp;</span></p>
    869. 

  869. </div>
    870. 

  870. <div class="page" title="Page 13">&nbsp;</div>
    871. 

  871. <p style="background: white; margin: 0 0 10px 0;"><span>无需上报内容：</span></p>
    872. 

  872. <p style="text-indent: 28px; background: white;"><span>1.参与临床药物与器械试验的病例,</span></p>
    873. 

  873. <p style="text-indent: 28px; background: white;"><span>2.外院转入手术失敗病例</span></p>
    874. 

  874. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span>3.本次住院超过90天</span></p>
    875. 

  875. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;"><span>4.年龄＜2岁，年龄＞18岁人群</span></p>
    876. 

  876. <p style="text-indent: 28px; background: white; margin: 0 0 10px 0;">&nbsp;</p>
    877. 

  877. <p style="background: white; margin: 0 0 10px 0;"><span>数据验证：</span></p>
    878. 

  878. <p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span>是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
    879. 

  879. <p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span>强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
    880. 

  880. <p style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; widows: 2; -webkit-text-stroke-width: 0px; word-spacing: 0px; margin: 0 0 10px 0;"><span style="box-sizing: border-box;"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3. </span><span>其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p>
    881. 

  881. <p>&nbsp;</p></div>' 
    882. 

  882. where DCID = 31
    883. 

  883. 

  884. --无需上报条件 年龄大于等于18岁以及小于2岁的新生儿
    885. 

  885. if exists(select * from  D_ReportStaticsQuota  where id=2 and  ReportClassArr<>'8,30,31,47,' )
    886. 

  886. update D_ReportStaticsQuota set ReportClassArr='8,30,31,47,' 
    887. 

  887. where id=2 and  ReportClassArr<>'8,30,31,47,' 
    888. 

  888. 

  889. 

  890. --修改口腔种植术的说明文字
    891. 

  891. if exists(select * from  D_Disease_Category  where DiseaseContent like '%18岁以上%' and DCID = 51)
    892. 

  892. update D_Disease_Category set DiseaseContent=
    893. 

  893. '<div><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">OIT</span><span style="font-family:微软雅黑,sans-serif;color:black">口腔种植术</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white"><span style="font-family:微软雅黑,sans-serif;color:black"><br></span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">主要手术 ICD-9-CM-3 编码:23.5，23.6 的门诊患者或 者 76.09，76.91，76.92，22.79 的手术出院患者。   </span></p><p style="text-indent:28px;background:white"></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white">
    894. 

  894. <p><br></p><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 无需上报内容：</span></p>
    895. 

  895. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">1.由外院住院诊疗后转入本院的病例</span> </p>
    896. 

  896. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">2.18岁以下的病例</span> </p>
    897. 

  897. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">3.同一疾病30日内重复入院的病例</span> </p>
    898. 

  898. <p style="text-indent:28px;background:white"><span style="font-family:微软雅黑,sans-serif;color:black">4.本次住院超过90天的病例</span> </p>
    899. 

  899. <p><br></p<p style="text-indent:28px;background:white"><span style="font-family: 微软雅黑, sans-serif;">数据验证：</span><br></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>1. *</span><span style="font-family:微软雅黑,sans-serif;color:black">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p><p style="margin-top:0;margin-right:0;margin-bottom:10px;margin-left:0;background:white;box-sizing: border-box;font-variant-ligatures: normal;font-variant-caps: normal;orphans: 2;widows: 2;-webkit-text-stroke-width: 0px;word-spacing:0px"><span style="box-sizing: border-box"><span style="font-family:微软雅黑,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2. </span><span style="font-family:微软雅黑,sans-serif;color:black">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p><p><br></p></div>' 
    900. 

  900. where DCID = 51
    901. 

  901. 

  902. --修改vte抽取规则
    903. 

  903. if exists(select * from  D_Disease_Category  where LeakExtractRule<>0 and  DCID =36)
    904. 

  904. update D_Disease_Category set LeakExtractRule=0 
    905. 

  905. where  LeakExtractRule<>0 and  DCID =36
    906. 

  906. 

  907. 

  908. --设定 [DataBaseAutoBak] AutoDbBakAtMinute默认值0
    909. 

  909. if exists(select * from  [DataBaseAutoBak]  where AutoDbBakAtMinute is null )
    910. 

  910. update [DataBaseAutoBak] set AutoDbBakAtMinute=0 
    911. 

  911. where AutoDbBakAtMinute is null
    912. 

  912. 

  913. --无需上报条件 同一疾病30日内重复入院
    914. 

  914. if exists(select * from  D_ReportStaticsQuota  where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' )
    915. 

  915. update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' 
    916. 

  916. where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' 
    917. 

  917. 

  918. --对接卫健委code旧数据赋值
    919. 

  919. if exists(select * from  D_MedicalRecord  where Ncis_JoinErrorMessage like '%该项为必填项，请进行填写%' and Ncis_IsJoinError=1)
    920. 

  920. update D_MedicalRecord set Ncis_JoinCode=1000 
    921. 

  921. where Ncis_JoinErrorMessage like '%该项为必填项，请进行填写%' and Ncis_IsJoinError=1
    922. 

  922. 

  923. --在1.1版本数据中对应添加2.0数据统计需要字段
    924. 

  924. --离院方式
    925. 

  925. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-4-3"') is null  and  DataVersion='1.1' )
    926. 

  926. update D_MedicalRecord set DataInfo=
    927. 

  927. JSON_MODIFY(DataInfo, '$."CM-4-3"',
    928. 

  928. case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-2-1"')   --STEMI 
    929. 

  929. 	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-2-1"')    --HF
    930. 

  930. 	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-2-1"')   --Cap-Adult
    931. 

  931. 	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-2"')   --Hip
    932. 

  932. 	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-2"')    --Knee
    933. 

  933. 	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-2-1"')    --STK
    934. 

  934. 	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-2"')    --CABG
    935. 

  935. 	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-2-1"')   --Cap 
    936. 

  936. 	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-2"')    --PIP
    937. 

  937. 	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-2"')   --CS
    938. 

  938. 	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-2-1"')   --AECOPD
    939. 

  939. 	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-2"')   --DVT
    940. 

  940. 	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-2-1"')   --TIA
    941. 

  941. 	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-2-1"')   --HBIPS
    942. 

  942. 	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-2-1"')   --TC
    943. 

  943. 	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-2-1"')   --LC
    944. 

  944. 	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-2-1"')   --BC
    945. 

  945. end
    946. 

  946. )where DataVersion='1.1'
    947. 

  947. --入院日期时间
    948. 

  948. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-0-2-4-1"') is null  and  DataVersion='1.1' )
    949. 

  949. update D_MedicalRecord set DataInfo=
    950. 

  950. JSON_MODIFY(DataInfo, '$."CM-0-2-4-1"',
    951. 

  951. case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-0-2-4"')   --STEMI
    952. 

  952. 	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-0-2-4"')   --HF
    953. 

  953. 	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-0-2-4"')   --Cap-Adult
    954. 

  954. 	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-0-2-2-1"')   --Hip
    955. 

  955. 	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-0-2-2"')   --Knee
    956. 

  956. 	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-0-2-4"')   --STK
    957. 

  957. 	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-0-2-2"')   --CABG
    958. 

  958. 	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-0-2-4"')   --Cap
    959. 

  959. 	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-0-2-2-1"')   --PIP
    960. 

  960. 	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-0-2-4"')  --CS
    961. 

  961. 	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-0-2-4"')  --AECOPD
    962. 

  962. 	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-0-2-2-1"')  --DVT
    963. 

  963. 	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-0-2-4"')  --TIA
    964. 

  964. 	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-0-3-1"')  --HBIPS
    965. 

  965. 	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-0-2-4"')  --TC
    966. 

  966. 	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-0-2-4"')  --LC
    967. 

  967. 	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-0-2-4-1"')  --BC
    968. 

  968. end 
    969. 

  969. )where DataVersion='1.1'
    970. 

  970. --出院日期时间
    971. 

  971. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-0-2-4-2"') is null  and  DataVersion='1.1' )
    972. 

  972. update D_MedicalRecord set DataInfo=
    973. 

  973. JSON_MODIFY(DataInfo, '$."CM-0-2-4-2"', 
    974. 

  974. case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-0-2-5"')   --STEMI
    975. 

  975. 	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-0-2-5"')   --HF
    976. 

  976. 	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-0-2-5"')   --Cap-Adult
    977. 

  977. 	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-0-2-3"')   --Hip
    978. 

  978. 	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-0-2-3"')   --Knee
    979. 

  979. 	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-0-2-5"')   --STK
    980. 

  980. 	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-0-2-3"')   --CABG
    981. 

  981. 	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-0-2-5"')   --Cap
    982. 

  982. 	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-0-2-3"')   --PIP
    983. 

  983. 	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-0-2-5"')  --CS
    984. 

  984. 	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-0-2-5"')  --AECOPD
    985. 

  985. 	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-0-2-3"')  --DVT
    986. 

  986. 	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-0-2-5"')  --TIA
    987. 

  987. 	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-0-3-2"')  --HBIPS
    988. 

  988. 	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-0-2-5"')  --TC
    989. 

  989. 	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-0-2-5"')  --LC
    990. 

  990. 	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-0-2-4-2"')  --BC
    991. 

  991. end
    992. 

  992. ) where DataVersion='1.1'
    993. 

  993. --住院总费用
    994. 

  994. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-6-1"') is null  and  DataVersion='1.1' )
    995. 

  995. update D_MedicalRecord set DataInfo=
    996. 

  996. JSON_MODIFY(DataInfo, '$."CM-6-1"', 
    997. 

  997. case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-3-1"')   --STEMI
    998. 

  998. 	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-3-1"')   --HF
    999. 

  999. 	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-3-1"')   --Cap-Adult
    1000. 

  1000. 	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-4-1"')   --Hip
    1001. 

  1001. 	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-4-1"')   --Knee
    1002. 

  1002. 	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-3-1"')   --STK
    1003. 

  1003. 	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-4-1"')   --CABG
    1004. 

  1004. 	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-3-1"')   --Cap
    1005. 

  1005. 	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-4-1"')   --PIP
    1006. 

  1006. 	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-4-1"')  --CS
    1007. 

  1007. 	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-3-1"')  --AECOPD
    1008. 

  1008. 	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-4-1"')  --DVT
    1009. 

  1009. 	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-3-1"')  --TIA
    1010. 

  1010. 	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-3-1"')  --HBIPS
    1011. 

  1011. 	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-3-1"')  --TC
    1012. 

  1012. 	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-3-1"')  --LC
    1013. 

  1013. 	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-3-1"')  --BC
    1014. 

  1014. end
    1015. 

  1015. ) where DataVersion='1.1'
    1016. 

  1016. --手术治疗费
    1017. 

  1017. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-6-13"') is null  and  DataVersion='1.1' )
    1018. 

  1018. update D_MedicalRecord set DataInfo=
    1019. 

  1019. JSON_MODIFY(DataInfo, '$."CM-6-13"', 
    1020. 

  1020. case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-3-5"')   --STEMI
    1021. 

  1021. 	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-3-5"')   --HF
    1022. 

  1022. 	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-3-5"')   --Cap-Adult
    1023. 

  1023. 	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-4-5"')   --Hip
    1024. 

  1024. 	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-4-5"')   --Knee
    1025. 

  1025. 	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-3-5"')   --STK
    1026. 

  1026. 	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-4-5"')   --CABG
    1027. 

  1027. 	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-3-5"')   --Cap
    1028. 

  1028. 	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-4-5"')   --PIP
    1029. 

  1029. 	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-4-5"')  --CS
    1030. 

  1030. 	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-3-5"')  --AECOPD
    1031. 

  1031. 	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-4-5"')  --DVT
    1032. 

  1032. 	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-3-5"')  --TIA
    1033. 

  1033. 	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-3-5"')  --HBIPS
    1034. 

  1034. 	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-3-5"')  --TC
    1035. 

  1035. 	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-3-5"')  --LC
    1036. 

  1036. 	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-3-5"')  --BC
    1037. 

  1037. end
    1038. 

  1038. ) where DataVersion='1.1'
    1039. 

  1039. --西药费
    1040. 

  1040. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-6-18"') is null  and  DataVersion='1.1' )
    1041. 

  1041. update D_MedicalRecord set DataInfo=
    1042. 

  1042. JSON_MODIFY(DataInfo, '$."CM-6-18"', 
    1043. 

  1043. case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-3-2"')   --STEMI
    1044. 

  1044. 	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-3-2"')   --HF
    1045. 

  1045. 	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-3-2"')   --Cap-Adult
    1046. 

  1046. 	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-4-2"')   --Hip
    1047. 

  1047. 	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-4-2"')   --Knee
    1048. 

  1048. 	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-3-2"')   --STK
    1049. 

  1049. 	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-4-2"')   --CABG
    1050. 

  1050. 	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-3-2"')   --Cap
    1051. 

  1051. 	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-4-2"')   --PIP
    1052. 

  1052. 	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-4-2"')  --CS
    1053. 

  1053. 	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-3-2"')  --AECOPD
    1054. 

  1054. 	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-4-2"')  --DVT
    1055. 

  1055. 	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-3-2"')  --TIA
    1056. 

  1056. 	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-3-2"')  --HBIPS
    1057. 

  1057. 	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-3-2"')  --TC
    1058. 

  1058. 	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-3-2"')  --LC
    1059. 

  1059. 	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-3-2"')  --BC
    1060. 

  1060. end
    1061. 

  1061. ) where DataVersion='1.1'
    1062. 

  1062. --中成药费
    1063. 

  1063. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-6-20"') is null  and  DataVersion='1.1' )
    1064. 

  1064. update D_MedicalRecord set DataInfo=
    1065. 

  1065. JSON_MODIFY(DataInfo, '$."CM-6-20"', 
    1066. 

  1066. case when DataVersion='1.1' and ReportClass=1 then JSON_VALUE(DataInfo,'$."STEMI-9-1-3-3"')   --STEMI
    1067. 

  1067. 	 when DataVersion='1.1' and ReportClass=2 then JSON_VALUE(DataInfo,'$."HF-9-1-3-3"')   --HF
    1068. 

  1068. 	 when DataVersion='1.1' and ReportClass=3 then JSON_VALUE(DataInfo,'$."Cap-Adult-10-3-3"')   --Cap-Adult
    1069. 

  1069. 	 when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-10-4-3"')   --Hip
    1070. 

  1070. 	 when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-10-4-3"')   --Knee
    1071. 

  1071. 	 when DataVersion='1.1' and ReportClass=6 then JSON_VALUE(DataInfo,'$."STK-11-3-3"')   --STK
    1072. 

  1072. 	 when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-10-4-3"')   --CABG
    1073. 

  1073. 	 when DataVersion='1.1' and ReportClass=8 then JSON_VALUE(DataInfo,'$."Cap-9-3-3"')   --Cap
    1074. 

  1074. 	 when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-5-4-3"')   --PIP
    1075. 

  1075. 	 when DataVersion='1.1' and ReportClass=10 then JSON_VALUE(DataInfo,'$."CS-10-4-3"')  --CS
    1076. 

  1076. 	 when DataVersion='1.1' and ReportClass=11 then JSON_VALUE(DataInfo,'$."AECOPD-9-3-3"')  --AECOPD
    1077. 

  1077. 	 when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-5-4-3"')  --DVT
    1078. 

  1078. 	 when DataVersion='1.1' and ReportClass=13 then JSON_VALUE(DataInfo,'$."TIA-8-3-3"')  --TIA
    1079. 

  1079. 	 when DataVersion='1.1' and ReportClass=14 then JSON_VALUE(DataInfo,'$."HBIPS-13-3-3"')  --HBIPS
    1080. 

  1080. 	 when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-9-3-3"')  --TC
    1081. 

  1081. 	 when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-14-3-3"')  --LC
    1082. 

  1082. 	 when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-13-3-3"')  --BC
    1083. 

  1083. end
    1084. 

  1084. ) where DataVersion='1.1'
    1085. 

  1085. --评价
    1086. 

  1086. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-1"') is null  and  DataVersion='1.1' )
    1087. 

  1087. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-1"', 'y') where DataVersion='1.1'
    1088. 

  1088. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-1"') is null  and  DataVersion='1.1' )
    1089. 

  1089. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-1"', 'a') where DataVersion='1.1'
    1090. 

  1090. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-2"') is null  and  DataVersion='1.1' )
    1091. 

  1091. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-2"', 'a') where DataVersion='1.1'
    1092. 

  1092. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-3"') is null  and  DataVersion='1.1' )
    1093. 

  1093. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-3"', 'a') where DataVersion='1.1'
    1094. 

  1094. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-4"') is null  and  DataVersion='1.1' )
    1095. 

  1095. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-4"', 'a') where DataVersion='1.1'
    1096. 

  1096. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-5"') is null  and  DataVersion='1.1' )
    1097. 

  1097. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-5"', 'a') where DataVersion='1.1'
    1098. 

  1098. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-6"') is null  and  DataVersion='1.1' )
    1099. 

  1099. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-6"', 'a') where DataVersion='1.1'
    1100. 

  1100. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-7"') is null  and  DataVersion='1.1' )
    1101. 

  1101. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-7"', 'a') where DataVersion='1.1'
    1102. 

  1102. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-8"') is null  and  DataVersion='1.1' )
    1103. 

  1103. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-8"', 'a') where DataVersion='1.1'
    1104. 

  1104. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-9"') is null  and  DataVersion='1.1' )
    1105. 

  1105. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-9"', 'a') where DataVersion='1.1'
    1106. 

  1106. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-10"') is null  and  DataVersion='1.1' )
    1107. 

  1107. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-10"', 'a') where DataVersion='1.1'
    1108. 

  1108. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-5-2-11"') is null  and  DataVersion='1.1' )
    1109. 

  1109. update D_MedicalRecord set DataInfo=JSON_MODIFY(DataInfo, '$."CM-5-2-11"', 'a') where DataVersion='1.1'
    1110. 

  1110. 

  1111. --手术并发症
    1112. 

  1112. if exists(select * from D_MedicalRecord  where JSON_VALUE(DataInfo,'$."CM-2-1"') is null  and  DataVersion='1.1' and ReportClass in (4,5,7,9,12,15,16,17) )
    1113. 

  1113. update D_MedicalRecord set DataInfo=
    1114. 

  1114. JSON_MODIFY(DataInfo, '$."CM-2-1"', 
    1115. 

  1115. case 
    1116. 

  1116. when DataVersion='1.1' and ReportClass=4 then JSON_VALUE(DataInfo,'$."Hip-7-1"')   --Hip
    1117. 

  1117. when DataVersion='1.1' and ReportClass=5 then JSON_VALUE(DataInfo,'$."Knee-7-1"')   --Knee
    1118. 

  1118. when DataVersion='1.1' and ReportClass=7 then JSON_VALUE(DataInfo,'$."CABG-6-2-1"')   --CABG
    1119. 

  1119. when DataVersion='1.1' and ReportClass=9 then JSON_VALUE(DataInfo,'$."PIP-3-1"')   --PIP	 
    1120. 

  1120. when DataVersion='1.1' and ReportClass=12 then JSON_VALUE(DataInfo,'$."DVT-3-1"')  --DVT
    1121. 

  1121. when DataVersion='1.1' and ReportClass=15 then JSON_VALUE(DataInfo,'$."TC-3-1"')  --TC
    1122. 

  1122. when DataVersion='1.1' and ReportClass=16 then JSON_VALUE(DataInfo,'$."LC-6-1"')  --LC
    1123. 

  1123. when DataVersion='1.1' and ReportClass=17 then JSON_VALUE(DataInfo,'$."BC-7-1"')  --BC 
    1124. 

  1124. end
    1125. 

  1125. ) where DataVersion='1.1' and ReportClass in (4,5,7,9,12,15,16,17)
    1126. 

  1126. 

  1127. --sep 去除编码 B73.7、R65.2、R65.3、R65.9
    1128. 

  1128. if exists(select * from  Report_Leak  where ReportClass = 35 and 
    1129. 

  1129. (DieaseICD like '%B73.7%' or DieaseICD like '%R65.2%' or DieaseICD like '%R65.3%' or DieaseICD like '%R65.9%'
    1130. 

  1130. or ICD10_oth like '%B73.7%' or ICD10_oth like '%R65.2%' or ICD10_oth like '%R65.3%' or ICD10_oth like '%R65.9%'
    1131. 

  1131. ) 
    1132. 

  1132. and DieaseICD not like '%A0%' and  DieaseICD not like '%A2%'  and  DieaseICD not like '%A3%' and  DieaseICD not like '%A4%' 
    1133. 

  1133. and  DieaseICD not like '%A5%'  and  DieaseICD not like '%B3%'  
    1134. 

  1134. and ICD10_oth not like '%A0%' and  ICD10_oth not like '%A2%'  and  ICD10_oth not like '%A3%' and  ICD10_oth not like '%A4%' 
    1135. 

  1135. and  ICD10_oth not like '%A5%'  and  ICD10_oth not like '%B3%'
    1136. 

  1136. and DealReport=0 )
    1137. 

  1137. update Report_Leak set DealReport=2,NoMustReportReason='B73.7、R65.2、R65.3、R65.9 无需上报'
    1138. 

  1138. where ReportClass = 35 and (DieaseICD like '%B73.7%' or DieaseICD like '%R65.2%' or DieaseICD like '%R65.3%' or DieaseICD like '%R65.9%'
    1139. 

  1139. or ICD10_oth like '%B73.7%' or ICD10_oth like '%R65.2%' or ICD10_oth like '%R65.3%' or ICD10_oth like '%R65.9%'
    1140. 

  1140. ) 
    1141. 

  1141. and DieaseICD not like '%A0%' and  DieaseICD not like '%A2%'  and  DieaseICD not like '%A3%' and  DieaseICD not like '%A4%' 
    1142. 

  1142. and  DieaseICD not like '%A5%'  and  DieaseICD not like '%B3%'  
    1143. 

  1143. and ICD10_oth not like '%A0%' and  ICD10_oth not like '%A2%'  and  ICD10_oth not like '%A3%' and  ICD10_oth not like '%A4%' 
    1144. 

  1144. and  ICD10_oth not like '%A5%'  and  ICD10_oth not like '%B3%'
    1145. 

  1145. and DealReport=0 
    1146. 

  1146. 

  1147. --sep上报说明
    1148. 

  1148. if  exists(select * from  D_Disease_Category  where DiseaseContent like '%R65.2%' and DCID = 35)
    1149. 

  1149. update D_Disease_Category set DiseaseContent=
    1150. 

  1150. '<div class="content"><p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;">上报内容</span></span></p>
    1151. 

  1151. <p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;"> </span></span></p>
    1152. 

  1152. <div class="page" title="Page 65">
    1153. 

  1153. <div class="layoutArea">
    1154. 

  1154. <div class="column">
    1155. 

  1155. <p><span style="font-size: 12pt; font-family: FangSong;">主要诊断/其他诊断 ICD-10 编码:A02.1，A22.7，A32.7， A40.1 至 A40.9， A41.0 至 A41.9，A42.7，A54.8，B37.7的出院患者。&nbsp;</span></p>
    1156. 

  1156. <p>&nbsp;</p>
    1157. 

  1157. <span style="font-size: 12pt;"> </span></div>
    1158. 

  1158. <span style="font-size: 12pt;"> </span></div>
    1159. 

  1159. <span style="font-size: 12pt;"> </span></div>
    1160. 

  1160. <p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;"><span style="line-height: 18.2px; font-size: 10.5pt; background: #ffffff;"><span style="font-family: Helvetica Neue;">无需上报内容</span></span></p>
    1161. 

  1161. <p class="p" style="font-family: Calibri; font-size: 12pt; margin-top: 4pt; margin-bottom: 4pt; line-height: 20.8px;">&nbsp;</p>
    1162. 

  1162. <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>
    1163. 

  1163. <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>
    1164. 

  1164. <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>
    1165. 

  1165. <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>
    1166. 

  1166. <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>
    1167. 

  1167. <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>
    1168. 

  1168. <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>
    1169. 

  1169. <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>' 
    1170. 

  1170. where DCID = 35
    1171. 

  1171. 

  1172. --HBV上报说明
    1173. 

  1173. if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%任意一项诊断%' and DCID = 50)
    1174. 

  1174. update D_Disease_Category set DiseaseContent='
    1175. 

  1175. <div class="content"><p>上报内容：</p>
    1176. 

  1176. <div class="page">
    1177. 

  1177. <p><span>出院诊断中任意一项诊断(包含主要诊断和其他诊断)编码为:O98.4，Z22.5 + O80 至 O84+Z37; 且伴1阴道分娩操作 ICD-9-CM-3 编码 72.0 至 72.9，73.0， 73.1，73.21，73.4 至 73.6,73.9;或伴2剖宫产手术 ICD 9-CM-3 编码:74.0，74.1，74.2，74.4，74.99 的出院患者。 </span></p>
    1178. 

  1178. </div>
    1179. 

  1179. <p>&nbsp;</p>
    1180. 

  1180. <p>无需上报内容：</p>
    1181. 

  1181. <p>1.由外院住院诊疗后转入本院的病例</p>
    1182. 

  1182. <p>2.参与临床药物与器械试验的病例</p>
    1183. 

  1183. <p><span style="white-space: pre;">3</span>.18岁以下的病例</p>
    1184. 

  1184. <p><span style="white-space: pre;">4.</span>同一疾病30日内重复入院</p>
    1185. 

  1185. <p><span style="white-space: pre;">5.</span>本次住院超过90天！</p>
    1186. 

  1186. <p>6.病历记录孕期＜28周或不明的</p>
    1187. 

  1187. <p>&nbsp;</p>
    1188. 

  1188. <p>数据验证：</p>
    1189. 

  1189. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    1190. 

  1190. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>'
    1191. 

  1191. where DiseaseContent  not like '%任意一项诊断%' and DCID = 50
    1192. 

  1192. 

  1193. --HF上报说明
    1194. 

  1194. if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%本次住院天数大于90天%' and DCID = 2)
    1195. 

  1195. update D_Disease_Category set DiseaseContent='
    1196. 

  1196. <div data-v-c0d7d944="" class="content"><p>上报内容</p>
    1197. 

  1197. <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>
    1198. 

  1198. <p><span style="font-size: 12pt;"> </span></p>
    1199. 

  1199. <p>&nbsp;</p>
    1200. 

  1200. <p>无需上报内容：</p>
    1201. 

  1201. <p><span style="white-space: pre;"> </span>1.由外院诊疗后转入本院的病例</p>
    1202. 

  1202. <p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
    1203. 

  1203. <p><span style="white-space: pre;"> </span>3.非心源性的心力衰竭和各种疾病的终末情况</p>
    1204. 

  1204. <p><span style="white-space: pre;"> </span>4.心功能Ⅰ级的病例</p>
    1205. 

  1205. <p><span style="white-space: pre;"> </span>5.18岁以下的病例</p>
    1206. 

  1206. <p><span style="white-space: pre;"> </span>6.同一疾病30日内重复入院</p>
    1207. 

  1207. <p><span style="white-space: pre;"> </span>7.心脏外科手术后</p>
    1208. 

  1208. <p><span style="white-space: pre;"> </span>8.产科手术和操作的其他并发症（O75.4）</p>
    1209. 

  1209. <p><span style="white-space: pre;"> </span>9.流产、异位妊娠或葡萄胎妊娠（O00～O07、O08.8）</p>
    1210. 

  1210. <p><span style="white-space: pre;"> </span>10.新生儿心力衰竭（P29.0）</p>
    1211. 

  1211. <p><span style="white-space: pre;"> </span>11.继发性高血压 （I15）</p>
    1212. 

  1212. <p><span style="white-space: pre;"> </span>12.入院前心脏有各类置入物（心脏起搏、除颤等辅助装置，ICD-9-CM-3编码37.61003～37.95001）</p>
    1213. 

  1213. <p><span style="white-space: pre;"> </span>13.本次住院天数大于90天</p>
    1214. 

  1214. <p>&nbsp;</p>
    1215. 

  1215. <p>数据验证：</p>
    1216. 

  1216. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    1217. 

  1217. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    1218. 

  1218. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    1219. 

  1219. <p>&nbsp;</p></div>'
    1220. 

  1220. where DiseaseContent  not like '%本次住院天数大于90天%' and DCID = 2
    1221. 

  1221. 

  1222. --CABG 上报说明
    1223. 

  1223. if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%本次住院超过90天%' and DCID = 7)
    1224. 

  1224. update D_Disease_Category set DiseaseContent='
    1225. 

  1225. <div data-v-c0d7d944="" class="content"><p>CABG 冠状动脉旁路移植术</p>
    1226. 

  1226. <p>上报内容</p>
    1227. 

  1227. <p><span style="font-size: 12pt;"><span style="font-family: FangSong_GB2312;">主要手术 ICD-9-CM-3 编码:36.1 的手术出院患者</span></span></p>
    1228. 

  1228. <p>&nbsp;</p>
    1229. 

  1229. <p>无需上报内容：</p>
    1230. 

  1230. <p><span style="white-space: pre;"> </span>1.参与临床药物与器械试验的病例,</p>
    1231. 

  1231. <p><span style="white-space: pre;"> </span>2.18岁以下的病例,</p>
    1232. 

  1232. <p><span style="white-space: pre;"> </span>3.同一疾病30日内重复入院,</p>
    1233. 

  1233. <p><span style="white-space: pre;"> </span>4.本次住院超过90天！</p>
    1234. 

  1234. <p>&nbsp;</p>
    1235. 

  1235. <p>数据验证：</p>
    1236. 

  1236. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    1237. 

  1237. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    1238. 

  1238. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    1239. 

  1239. <p>&nbsp;</p></div>'
    1240. 

  1240. where DiseaseContent  not like '%本次住院超过90天%' and DCID = 7
    1241. 

  1241. --Knee 上报说明
    1242. 

  1242. if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%本次住院超过90天%' and DCID = 5)
    1243. 

  1243. update D_Disease_Category set DiseaseContent='
    1244. 

  1244. <div data-v-c0d7d944="" class="content"><p>上报内容</p>
    1245. 

  1245. <div class="page" title="Page 34">
    1246. 

  1246. <div class="layoutArea">
    1247. 

  1247. <div class="column">
    1248. 

  1248. <p><span style="font-size: 12pt; font-family: FangSong;">主要手术 ICD-9-CM-3 编码:00.80 至 00.84，81.54， 81.55 的手术出院患者。&nbsp;</span></p>
    1249. 

  1249. </div>
    1250. 

  1250. </div>
    1251. 

  1251. </div>
    1252. 

  1252. <p>&nbsp;</p>
    1253. 

  1253. <p>无需上报内容：</p>
    1254. 

  1254. <p><span style="white-space: pre;"> </span>1.参与临床药物与器械试验的病例,</p>
    1255. 

  1255. <p><span style="white-space: pre;"> </span>2.18岁以下的病例,</p>
    1256. 

  1256. <p><span style="white-space: pre;"> </span>3.同一疾病30日内重复入院,</p>
    1257. 

  1257. <p><span style="white-space: pre;"> </span>4.本次住院超过90天！</p>
    1258. 

  1258. <p>&nbsp;</p>
    1259. 

  1259. <p>数据验证：</p>
    1260. 

  1260. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    1261. 

  1261. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    1262. 

  1262. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    1263. 

  1263. <p>&nbsp;</p></div>'
    1264. 

  1264. where DiseaseContent  not like '%本次住院超过90天%' and DCID = 5
    1265. 

  1265. --Hip 上报说明
    1266. 

  1266. if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%本次住院超过90天%' and DCID = 4)
    1267. 

  1267. update D_Disease_Category set DiseaseContent='
    1268. 

  1268. <div data-v-c0d7d944="" class="content"><p>上报内容</p>
    1269. 

  1269. <div class="page" title="Page 33">
    1270. 

  1270. <div class="layoutArea">
    1271. 

  1271. <div class="column">
    1272. 

  1272. <p><span style="font-size: 12pt; font-family: FangSong;">主要手术 ICD-9-CM-3 编码:00.7，81.51 至 81.53 的手术出院患者。&nbsp;</span></p>
    1273. 

  1273. </div>
    1274. 

  1274. </div>
    1275. 

  1275. </div>
    1276. 

  1276. <p>&nbsp;</p>
    1277. 

  1277. <p>无需上报内容：</p>
    1278. 

  1278. <p><span style="white-space: pre;"> </span>1.参与临床药物与器械试验的病例,</p>
    1279. 

  1279. <p><span style="white-space: pre;"> </span>2.18岁以下的病例,</p>
    1280. 

  1280. <p><span style="white-space: pre;"> </span>3.同一疾病30日内重复入院,</p>
    1281. 

  1281. <p><span style="white-space: pre;"> </span>4.本次住院超过90天！</p>
    1282. 

  1282. <p>&nbsp;</p>
    1283. 

  1283. <p>数据验证：</p>
    1284. 

  1284. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    1285. 

  1285. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    1286. 

  1286. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    1287. 

  1287. <p>&nbsp;</p></div>'
    1288. 

  1288. where DiseaseContent  not like '%本次住院超过90天%' and DCID = 4
    1289. 

  1289. --STEMI 上报说明
    1290. 

  1290. if exists(select * from  D_Disease_Category  where DiseaseContent  like '%I21.3、I21.9的病例%' and DCID = 1)
    1291. 

  1291. update D_Disease_Category set DiseaseContent='
    1292. 

  1292. <div data-v-c0d7d944="" class="content"><p>上报内容</p>
    1293. 

  1293. <p><span style="white-space: pre;"> </span> 1.主要诊断疾病编码（ICD-10）为I21.0~I21.3的病例</p>
    1294. 

  1294. <p>&nbsp;</p>
    1295. 

  1295. <p>无需上报内容：</p>
    1296. 

  1296. <p><span style="white-space: pre;"> </span>1.由外院诊疗后转入本院的病例</p>
    1297. 

  1297. <p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
    1298. 

  1298. <p><span style="white-space: pre;"> </span>3.18岁以下的病例</p>
    1299. 

  1299. <p><span style="white-space: pre;"> </span>4.非首次确诊急性心肌梗死患者</p>
    1300. 

  1300. <p><span style="white-space: pre;"> </span>5.同一疾病30日内重复入院</p>
    1301. 

  1301. <p><span style="white-space: pre;"> </span>6.本次住院天数大于90天</p>
    1302. 

  1302. <p><span style="white-space: pre;"> </span>7.急性小灶心肌梗死 ICD-10 I21.401 </p>
    1303. 

  1303. <p><span style="white-space: pre;"> </span>8.急性心内膜下心肌梗死 ICD-10 I21.402 </p>
    1304. 

  1304. <p><span style="white-space: pre;"> </span>9.非ST抬高性心肌梗死 ICD-10 I21.403 </p>
    1305. 

  1305. <p><span style="white-space: pre;"> </span>10.非冠心病心肌梗死 ICD-10 I21.901</p>
    1306. 

  1306. <p>&nbsp;</p>
    1307. 

  1307. <p>数据验证：</p>
    1308. 

  1308. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    1309. 

  1309. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    1310. 

  1310. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    1311. 

  1311. <p>&nbsp;</p></div>'
    1312. 

  1312. where DiseaseContent  like '%I21.3、I21.9的病例%' and DCID = 1
    1313. 

  1313. 

  1314. --AF 上报说明
    1315. 

  1315. if exists(select * from  D_Disease_Category  where DiseaseContent not like '%18岁以下人群%' and DCID = 32)
    1316. 

  1316. update D_Disease_Category set DiseaseContent='
    1317. 

  1317. <div data-v-c0d7d944="" class="content">
    1318. 

  1318. <p style="background: white;"><span style=" color: black;">上报内容</span></p>
    1319. 

  1319. <p style="background: white;"><span style="font-family: FangSong_GB2312; font-size: 12pt;">主要诊断/其他诊断ICD-10 编码:I48 的出院患者 </span></p>
    1320. 

  1320. <p style="background: white;">&nbsp;</p>
    1321. 

  1321. <p style="background: white;"><span style="color: black;">无需上报内容：</span></p>
    1322. 

  1322. <p style="background: white;"><span style="color: black;">1.</span><span style=" color: black;">参与临床药物与器械试验的病例,</span></p>
    1323. 

  1323. <p style="background: white;"><span style="color: black;">2.</span><span style=" color: black;">有记录的理由不列质控管理的病例,</span></p>
    1324. 

  1324. <p style="background: white;"><span style="color: black;">3.</span><span style=" color: black;">本次住院超过90天！</span></p>
    1325. 

  1325. <p style="background: white;"><span style="color: black;">4.</span><span style=" color: black;">18岁以下人群</span></p>
    1326. 

  1326. <p style="background: white;">&nbsp;</p>
    1327. 

  1327. <p style="background: white;"><span style=" color: black;">数据验证：</span></p>
    1328. 

  1328. <p style="background: white;"><span style="box-sizing: border-box;">1. *</span><span style=" color: black;">是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</span></p>
    1329. 

  1329. <p style="background: white;"><span style="box-sizing: border-box;">2. </span><span style=" color: black;">强制验证项若超过正常值，系统给予提示，不允许填写。</span></p>
    1330. 

  1330. <p style="background: white;"><span style="box-sizing: border-box;">3. </span><span style=" color: black;">其他项若超出正常值范围，系统给予提示，但允许填写实际数据。</span></p></div>'
    1331. 

  1331. where DiseaseContent  not like '%18岁以下人群%' and DCID = 32
    1332. 

  1332. 

  1333. --HF上报说明
    1334. 

  1334. if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%主要诊断/其他诊断原发病%' and DCID = 2)
    1335. 

  1335. update D_Disease_Category set DiseaseContent='
    1336. 

  1336. <div data-v-c0d7d944="" class="content"><p>上报内容</p>
    1337. 

  1337. <p><span style="font-size: 12pt;"><span style="white-space: pre;"> </span>1.<span style="font-family: FangSong;">1.主要诊断/其他诊断原发病 ICD-10 编码:I05 至 I09、或 I11 至 I13、 或 I20 至 I21、或 I40 至 I41、或 I42 至 I43 伴第二诊断为 I50 的出院患者。</span></span></p>
    1338. 

  1338. <p><span style="font-size: 12pt;"> </span></p>
    1339. 

  1339. <p>&nbsp;</p>
    1340. 

  1340. <p>无需上报内容：</p>
    1341. 

  1341. <p><span style="white-space: pre;"> </span>1.由外院诊疗后转入本院的病例</p>
    1342. 

  1342. <p><span style="white-space: pre;"> </span>2.参与临床药物与器械试验的病例</p>
    1343. 

  1343. <p><span style="white-space: pre;"> </span>3.非心源性的心力衰竭和各种疾病的终末情况</p>
    1344. 

  1344. <p><span style="white-space: pre;"> </span>4.心功能Ⅰ级的病例</p>
    1345. 

  1345. <p><span style="white-space: pre;"> </span>5.18岁以下的病例</p>
    1346. 

  1346. <p><span style="white-space: pre;"> </span>6.同一疾病30日内重复入院</p>
    1347. 

  1347. <p><span style="white-space: pre;"> </span>7.心脏外科手术后</p>
    1348. 

  1348. <p><span style="white-space: pre;"> </span>8.产科手术和操作的其他并发症（O75.4）</p>
    1349. 

  1349. <p><span style="white-space: pre;"> </span>9.流产、异位妊娠或葡萄胎妊娠（O00～O07、O08.8）</p>
    1350. 

  1350. <p><span style="white-space: pre;"> </span>10.新生儿心力衰竭（P29.0）</p>
    1351. 

  1351. <p><span style="white-space: pre;"> </span>11.继发性高血压 （I15）</p>
    1352. 

  1352. <p><span style="white-space: pre;"> </span>12.入院前心脏有各类置入物（心脏起搏、除颤等辅助装置，ICD-9-CM-3编码37.61003～37.95001）</p>
    1353. 

  1353. <p><span style="white-space: pre;"> </span>13.本次住院天数大于90天</p>
    1354. 

  1354. <p>&nbsp;</p>
    1355. 

  1355. <p>数据验证：</p>
    1356. 

  1356. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    1357. 

  1357. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p>
    1358. 

  1358. <p><span style="white-space: pre;"> </span>3. 其他项若超出正常值范围，系统给予提示，但允许填写实际数据</p>
    1359. 

  1359. <p>&nbsp;</p></div>'
    1360. 

  1360. where DiseaseContent  not like '%主要诊断/其他诊断原发病%' and DCID = 2
    1361. 

  1361. 

  1362. --省市区县字段名更改
    1363. 

  1363. --DPD
    1364. 

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

  1365. update D_MedicalRecord
    1366. 

  1366. set DataInfo=JSON_MODIFY(DataInfo, '$."provinceId"',  JSON_VALUE(DataInfo,'$."DPD-0-1-4-4"'))
    1367. 

  1367. where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-4"') is not null  and  DataVersion='2' and ReportClass =45 
    1368. 

  1368. 

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

  1370. update D_MedicalRecord
    1371. 

  1371. set DataInfo=JSON_MODIFY(DataInfo, '$."cityId"',  JSON_VALUE(DataInfo,'$."DPD-0-1-4-5"'))
    1372. 

  1372. where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-5"') is not null  and  DataVersion='2' and ReportClass =45 
    1373. 

  1373. 

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

  1375. update D_MedicalRecord
    1376. 

  1376. set DataInfo=JSON_MODIFY(DataInfo, '$."areaId"',  JSON_VALUE(DataInfo,'$."DPD-0-1-4-6"'))
    1377. 

  1377. where  JSON_VALUE(DataInfo,'$."DPD-0-1-4-6"') is not null  and  DataVersion='2' and ReportClass =45 
    1378. 

  1378. 

  1379. --HD
    1380. 

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

  1381. update D_MedicalRecord
    1382. 

  1382. set DataInfo=JSON_MODIFY(DataInfo, '$."provinceId"',  JSON_VALUE(DataInfo,'$."HD-0-1-4-1"'))
    1383. 

  1383. where  JSON_VALUE(DataInfo,'$."HD-0-1-4-1"') is not null  and  DataVersion='2' and ReportClass =44 
    1384. 

  1384. 

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

  1386. update D_MedicalRecord
    1387. 

  1387. set DataInfo=JSON_MODIFY(DataInfo, '$."cityId"',  JSON_VALUE(DataInfo,'$."HD-0-1-4-4"'))
    1388. 

  1388. where  JSON_VALUE(DataInfo,'$."HD-0-1-4-4"') is not null  and  DataVersion='2' and ReportClass =44 
    1389. 

  1389. 

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

  1391. update D_MedicalRecord
    1392. 

  1392. set DataInfo=JSON_MODIFY(DataInfo, '$."areaId"',  JSON_VALUE(DataInfo,'$."HD-0-1-4-5"'))
    1393. 

  1393. where  JSON_VALUE(DataInfo,'$."HD-0-1-4-5"') is not null  and  DataVersion='2' and ReportClass =44 
    1394. 

  1394. 

  1395. --编码范围调整 未报改为无需上报
    1396. 

  1396. --GC 43.8904
    1397. 

  1397. if exists(select * from  Report_Leak  where ReportClass = 33 and  OpertationICD like '43.8904%'  and DealReport=0 )
    1398. 

  1398. update Report_Leak set DealReport=2
    1399. 

  1399. where ReportClass=33 and  OpertationICD like '43.8904%'  and DealReport=0 
    1400. 

  1400. --TN 06.1
    1401. 

  1401. if exists(select * from  Report_Leak  where ReportClass = 37 and  OpertationICD like '06.1%'  and DealReport=0 )
    1402. 

  1402. update Report_Leak set DealReport=2
    1403. 

  1403. where ReportClass=37 and  OpertationICD like '06.1%'  and DealReport=0 
    1404. 

  1404. 

  1405. --同一疾病30日内重复入院
    1406. 

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

  1407. update D_ReportStaticsQuota set ReportClassArr='1,2,3,4,5,6,7,8,9,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,'
    1408. 

  1408. where id=12 and  ReportClassArr<>'1,2,3,4,5,6,7,8,9,10,11,12,13,15,16,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,' 
    1409. 

  1409. 

  1410. --VTE重复病例默认勾选上以下病种
    1411. 

  1411. update D_RepeatReportSetting set [Enabled]=1
    1412. 

  1412. where ReportClass=36 and RepeatReportClass in(12,6,1,4,5,7,29,24,30,31)
    1413. 

  1413. 

  1414. 

  1415. 

  1416. --PACG编码调整
    1417. 

  1417.   UPDATE Report_ICDCodeMatch Set SuborderValue='b' Where ReportClass=39 AND ICDCode like 'H40.0%'
    1418. 

  1418.   UPDATE Report_ICDCodeMatch Set SuborderValue='c' Where ReportClass=39 AND ICDCode like 'H40.2%'
    1419. 

  1419.   UPDATE Report_ICDCodeMatch Set SuborderValue='a' Where ReportClass=39 AND ICDCode like 'H26.2%'
    1420. 

  1420.   UPDATE Report_ICDCodeMatch Set SuborderValue='oth' Where ReportClass=39 AND ICDCode like 'H40.9%'
    1421. 

  1421. 

  1422. --HBV上报说明
    1423. 

  1423. if exists(select * from  D_Disease_Category  where DiseaseContent  not like '%O98.1,B24,%' and DCID = 50)
    1424. 

  1424. update D_Disease_Category set DiseaseContent='
    1425. 

  1425. <div class="content"><p>上报内容：</p>
    1426. 

  1426. <div class="page">
    1427. 

  1427. <p><span>出院诊断中任意一项诊断(包含主要诊断和其他诊断)编码为:O98.4,O98.1,B24,Z22.5 + O80 至 O84+Z37; 且伴1阴道分娩操作 ICD-9-CM-3 编码 72.0 至 72.9，73.0， 73.1，73.21，73.4 至 73.6,73.9;或伴2剖宫产手术 ICD 9-CM-3 编码:74.0，74.1，74.2，74.4，74.99 的出院患者。 </span></p>
    1428. 

  1428. </div>
    1429. 

  1429. <p>&nbsp;</p>
    1430. 

  1430. <p>无需上报内容：</p>
    1431. 

  1431. <p>1.由外院住院诊疗后转入本院的病例</p>
    1432. 

  1432. <p>2.参与临床药物与器械试验的病例</p>
    1433. 

  1433. <p><span style="white-space: pre;">3</span>.18岁以下的病例</p>
    1434. 

  1434. <p><span style="white-space: pre;">4.</span>同一疾病30日内重复入院</p>
    1435. 

  1435. <p><span style="white-space: pre;">5.</span>本次住院超过90天！</p>
    1436. 

  1436. <p>6.病历记录孕期＜28周或不明的</p>
    1437. 

  1437. <p>&nbsp;</p>
    1438. 

  1438. <p>数据验证：</p>
    1439. 

  1439. <p><span style="white-space: pre;"> </span>1. *是必填项目，其他项未填则按未做统计，★为本病种的核心（重点）质量监控指标。</p>
    1440. 

  1440. <p><span style="white-space: pre;"> </span>2. 强制验证项若超过正常值，系统给予提示，不允许填写。</p></div>'
    1441. 

  1441. where DiseaseContent  not like '%O98.1,B24,%' and DCID = 50
    1442. 

  1442. 

  1443. --暂时保留 结束--
    1444.