首页 发现 帮助
注册 登录
java
/
mrqc-sys
2
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
目录树: 11f856a897
分支列表 标签列表
mrqc-sys
/
doc
/
031.20210326v2.0.2
/
qc_initv2.0.3.sql

qc_initv2.0.3.sql 8.2 KB
文件历史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566 
  1. use `qc`;
    2. 

  2. 

  3. /**
    4. 

  4. 执行脚本前请先看注意事项：
    5. 

  5.     此脚本默认医院为北仑医院，其他医院执行此脚本需要更改为对应医院id
    6. 

  6.     下面此表的新增操作，执行此脚本的医院需要修改对应的医院id,此脚本默认北仑医院id
    7. 

  7.     1、qc_cases_relevance_entry
    8. 

  8.     2、qc_cases_entry_hospital
    9. 

  9.  */
    10. 

  10. 

  11. /**
    12. 

  12. 编码添加
    13. 

  13.  */
    14. 

  14. INSERT INTO `qc_cases_entry` (`id`, `cases_id`, `cases_name`, `mode_id`, `code`, `name`, `drgs`, `type`, `rule_type`, `dev_type`, `accuracy_type`, `precond`, `order_no`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ('3120', '241', '三级查房制度', '4', 'THR03123', '病程记录未记录恶性肿瘤化学治疗相关信息', '2', '1', '0', '1', '2', '', NULL, '', 'N', '2021-05-12 10:00:43', '2021-05-12 10:00:43', '0', '邵启华');
    15. 

  15. INSERT INTO `qc_cases_entry` (`id`, `cases_id`, `cases_name`, `mode_id`, `code`, `name`, `drgs`, `type`, `rule_type`, `dev_type`, `accuracy_type`, `precond`, `order_no`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ('3119', '241', '三级查房制度', '4', 'THR03122', '有抗菌药物使用病程无记录', '2', '1', '0', '1', '1', '', NULL, '【指标十一】抗菌药物使用记录符合率(MER-D&T-01)', 'N', '2021-05-11 14:31:38', '2021-05-11 14:31:38', '0', '邵启华');
    16. 

  16. INSERT INTO `qc_cases_entry` (`id`, `cases_id`, `cases_name`, `mode_id`, `code`, `name`, `drgs`, `type`, `rule_type`, `dev_type`, `accuracy_type`, `precond`, `order_no`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ('3118', '241', '三级查房制度', '4', 'THR03121', '报告单或病程记录缺少细菌培养记录', '2', '1', '0', '1', '1', '', NULL, '【指标十】细菌培养检查记录符合率(MER-ME-03)', 'N', '2021-05-11 14:27:57', '2021-05-11 14:27:57', '0', '邵启华');
    17. 

  17. 

  18. 

  19. 

  20. /**
    21. 

  21. qc_cases_entry_hospital、qc_type_cases_entry 分值确定添加
    22. 

  22.  */
    23. 

  23.  -- 需要修改对应的医院id,此脚本默认北仑医院id
    24. 

  24. SET @id ='4';
    25. 

  25. 

  26. INSERT INTO `qc_cases_entry_hospital` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `cases_entry_id`, `hospital_id`, `score`, `score_run`, `msg`, `is_used`, `is_used_run`, `is_reject`, `remark`) VALUES ( 'N', '2021-05-12 10:00:43', '2021-05-12 10:00:43', '0', '邵启华', '3123', @id, '0.0', '0.0', '病程记录未记录恶性肿瘤化学治疗相关信息', '1', '1', '0', '');
    27. 

  27. INSERT INTO `qc_cases_entry_hospital` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `cases_entry_id`, `hospital_id`, `score`, `score_run`, `msg`, `is_used`, `is_used_run`, `is_reject`, `remark`) VALUES ( 'N', '2021-05-11 14:31:38', '2021-05-11 14:31:38', '0', '邵启华', '3122', @id, '0.0', '0.0', '有抗菌药物使用病程无记录', '1', '1', '0', '');
    28. 

  28. INSERT INTO `qc_cases_entry_hospital` ( `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `cases_entry_id`, `hospital_id`, `score`, `score_run`, `msg`, `is_used`, `is_used_run`, `is_reject`, `remark`) VALUES ( 'N', '2021-05-11 14:27:57', '2021-05-11 14:27:57', '0', '邵启华', '3121', @id, '0.0', '0.0', '报告单或病程记录缺少细菌培养记录', '1', '1', '0', '');
    29. 

  29. 

  30. 

  31. -- ----------------------------
    32. 

  32. -- Records of qc_cases_relevance_entry
    33. 

  33. -- ----------------------------
    34. 

  34. -- 执行此脚本的医院需要修改对应的医院id,此脚本默认北仑医院id
    35. 

  35. SET @id ='4';
    36. 

  36. INSERT INTO `qc_cases_relevance_entry` ( `type`, `hospital_id`, `cases_name`, `relevance_id`, `name`, `is_deleted`) VALUES ( '11', @id, '指标十一：细菌培养检查记录符合率', '3121', '报告单或病程记录缺少细菌培养记录', 'N');
    37. 

  37. INSERT INTO `qc_cases_relevance_entry` ( `type`, `hospital_id`, `cases_name`, `relevance_id`, `name`, `is_deleted`) VALUES ( '12', @id, '指标十二：抗菌药物使用记录符合率', '3122', '有抗菌药物使用病程无记录', 'N');
    38. 

  38. INSERT INTO `qc_cases_relevance_entry` ( `type`, `hospital_id`, `cases_name`, `relevance_id`, `name`, `is_deleted`) VALUES ( '13', @id, '指标十三：恶性肿瘤化学治疗记录符合率', '3123', '病程记录未记录恶性肿瘤化学治疗相关信息', 'N');
    39. 

  39. 

  40. 

  41. 

  42. 

  43. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '65', '3123', NULL, 'N', '2021-05-14 15:42:39', '2021-05-14 15:42:39', '99', '99');
    44. 

  44. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '66', '3123', NULL, 'N', '2021-05-14 15:42:39', '2021-05-14 15:42:39', '99', '99');
    45. 

  45. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '74', '3123', NULL, 'N', '2021-05-14 15:42:39', '2021-05-14 15:42:39', '99', '99');
    46. 

  46. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '80', '3123', NULL, 'N', '2021-05-14 15:42:39', '2021-05-14 15:42:39', '99', '99');
    47. 

  47. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '109', '3123', NULL, 'N', '2021-05-14 15:42:39', '2021-05-14 15:42:39', '99', '99');
    48. 

  48. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '110', '3123', NULL, 'N', '2021-05-14 15:42:39', '2021-05-14 15:42:39', '99', '99');
    49. 

  49. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '65', '3122', NULL, 'N', '2021-05-14 15:42:32', '2021-05-14 15:42:32', '99', '99');
    50. 

  50. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '66', '3122', NULL, 'N', '2021-05-14 15:42:32', '2021-05-14 15:42:32', '99', '99');
    51. 

  51. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '80', '3122', NULL, 'N', '2021-05-14 15:42:32', '2021-05-14 15:42:32', '99', '99');
    52. 

  52. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '74', '3122', NULL, 'N', '2021-05-14 15:42:32', '2021-05-14 15:42:32', '99', '99');
    53. 

  53. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '109', '3122', NULL, 'N', '2021-05-14 15:42:32', '2021-05-14 15:42:32', '99', '99');
    54. 

  54. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '110', '3122', NULL, 'N', '2021-05-14 15:42:32', '2021-05-14 15:42:32', '99', '99');
    55. 

  55. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '65', '3121', NULL, 'N', '2021-05-14 15:42:20', '2021-05-14 15:42:20', '99', '99');
    56. 

  56. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '66', '3121', NULL, 'N', '2021-05-14 15:42:20', '2021-05-14 15:42:20', '99', '99');
    57. 

  57. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '74', '3121', NULL, 'N', '2021-05-14 15:42:20', '2021-05-14 15:42:20', '99', '99');
    58. 

  58. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '80', '3121', NULL, 'N', '2021-05-14 15:42:20', '2021-05-14 15:42:20', '99', '99');
    59. 

  59. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '109', '3121', NULL, 'N', '2021-05-14 15:42:20', '2021-05-14 15:42:20', '99', '99');
    60. 

  60. INSERT INTO `qc_type_cases_entry` ( `type_id`, `case_entry_id`, `remark`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`) VALUES ( '110', '3121', NULL, 'N', '2021-05-14 15:42:20', '2021-05-14 15:42:20', '99', '99');
    61. 

  61. 

  62. 

  63. 

  64. 

  65. 

  66.