天健医院信息系统数据结构手册

4.10 4.11 4.12 4.13 4.14 4.15 4.16 4.17 4.18 4.19 4.20 4.21 4.22 4.23 4.24 4.25 4.26 4.27 4.28 4.29 4.30 4.31 4.32 4.33 4.34 4.35 4.36 4.37 4.38 4.39 4.40 4.41 4.42 4.43 4.44 4.45 4.46 4.47

护理项目字典 NURSING_DICT ......................................................................................... 36 膳食项目字典 DIET_DICT .................................................................................................. 36 临床诊疗项目名称字典 CLINIC_ITEM_NAME_DICT ..................................................... 36 检验项目名称字典 LAB_ITEM_NAME_DICT .................................................................. 37 治疗操作名称字典 TREAT_ITEM_NAME_DICT ............................................................. 37 护理等级字典 NURSING_CLASS_DICT ............................................................................. 37 手术等级字典 OPERATION_SCALE_DICT ........................................................................ 37 给药途径字典ADMINISTRATION_DICT ........................................................................... 38 麻醉方法字典 ANAESTHESIA_DICT ................................................................................. 38 医嘱状态字典 ORDER_STATUS_DICT .............................................................................. 38 剂量单位字典 DOSAGE_UNITS_DICT ............................................................................... 38 医嘱执行频率字典 PERFORM_FREQ_DICT ...................................................................... 38 医嘱执行缺省时间表 PERFORM_DEFAULT_SCHEDULE ............................................... 39 辅助诊断项目字典 ANCI_EXAM_ITEM_DICT ................................................................ 39 辅助治疗项目字典 ANCI_TREAT_ITEM_DICT ............................................................... 39 检验单定义 LAB_SHEET_MASTER .................................................................................. 39 检验单项目定义 LAB_SHEET_ITEMS .............................................................................. 40 检查报告模板 EXAM_RPT_PATTERN ............................................................................... 40 治疗结果字典 TREATING_RESULT_DICT ........................................................................ 41 切口愈合情况字典 HEAL_DICT .......................................................................................... 41 诊断符合情况字典 DIAG_CORR_DICT .............................................................................. 41 时间单位字典 TIME_UNITS_DICT ..................................................................................... 42 计量单位字典 MEASURES_DICT ....................................................................................... 42 星期字典 DAY_OF_WEEK_DICT........................................................................................ 42 诊疗项目分类字典 CLINIC_ITEM_CLASS_DICT ............................................................. 42 标本字典 SPECIMAN_DICT................................................................................................. 43 检验报告项目字典 LAB_REPORT_ITEM_DICT .............................................................. 43 检验结果模板字典 LAB_LIST_RESULT_DICT ................................................................ 43 检验申请项目与报告项目对照 LAB_ORDER_VS_REPORT ........................................... 44 切口等级字典 WOUND_GRADE_DICT ............................................................................ 44 检验项目与分类对照 LAB_ITEM_VS_CLASS ................................................................. 44 检验项目类别字典 LAB_ITEM_CLASS_DICT ................................................................. 44 检验报告项目与申请项目对照 LAB_REPORT_VS_ORDER ........................................... 44 药物过敏严重程度字典 DRUG_ALERGY_SEVERITY_DICT(不使用) .......................... 45 合理用药相关表MDC_DRUG_MATCH_RESULT(不使用) .............................................. 45 合理用药相关表MDC_ROUTE_MATCH_RESULT(不使用) ............................................ 45 MEDCARD_PRIVILEGE_DICT(不使用) ............................................................................. 46 QUALITY_GRAND_DICT(不使用) ...................................................................................... 46

5. 药品物资 .......................................................................................................................................... 47 5.1 5.2 5.3 5.4

药品字典 DRUG_DICT ......................................................................................................... 47 药品名称字典 DRUG_NAME_DICT .................................................................................... 47 药品价格 DRUG_PRICE_LIST ............................................................................................. 48 公费用药目录 OFFICIAL_DRUG_CATALOG .................................................................... 48

5.5 5.6 5.7 5.8 5.9 5.10 5.11 5.12 5.13 5.14 5.15 5.16 5.17 5.18 5.19 5.20 5.21 5.22 5.23 5.24 5.25 5.26 5.27 5.28 5.29 5.30 5.31 5.32 5.33

药品入库分类字典 DRUG_IMPORT_CLASS_DICT .......................................................... 49 药品出库分类字典 DRUG_EXPORT_CLASS_DICT .......................................................... 49 药品处方属性字典 DRUG_PRESC_ATTR_DICT ............................................................... 49 药品摆药类别字典 DRUG_DISP_PROPERTY_DICT ......................................................... 49 药品供应商目录 DRUG_SUPPLIER_CATALOG .............................................................. 50 药品毒理分类字典 DRUG_TOXI_PROPERTY_DICT ........................................................ 50 药品剂型字典 DRUG_FORM_DICT .................................................................................... 50 药品类别字典 DRUG_CLASS_DICT ................................................................................... 50 药品编码描述 DRUG_CODING_RULE ............................................................................... 51 药品信息 DRUG_INFO ......................................................................................................... 51 药品相互作用 DRUG_INCOMPATIBILITY ........................................................................ 51 药品用量信息COMM.DRUG_RATIONAL_DOSAGE(新增) ...................................................... 51 中标价格类别TENDER_PRICE_CLASS(新增) ................................................................... 52 中标药品字典TENDER_DRUG_DICT(新增) ...................................................................... 52 货位名称LOCATION(新增) .................................................................................................. 52 设备字典EQUIP_DICT ......................................................................................................... 53 设备制造商字典EQUIP_MANUFACTURE_DICT ............................................................. 53 设备名称字典EQUIP_NAME_DICT .................................................................................... 53 EQUIP_VS_FEE_DICT .......................................................................................................... 53 消耗品编码规则EXP_CODING_RULE ............................................................................... 54 消耗品字典EXP_DICT .......................................................................................................... 54 消耗品币值字典EXP_FUND_ITEM_DICT ......................................................................... 54 消耗品名称字典EXP_NAME_DICT .................................................................................... 54 消耗品价表EXP_PRICE_LIST ............................................................................................. 54 供应商字典EXP_SUPPLIER_CATALOG ............................................................................ 55 经费来源字典FUND_SOURCE_DICT ................................................................................. 55 公费用药目录OFFICIAL_DRUG_CATALOG(新增) .......................................................... 55 公费用药目录限制级别字典OFFICIAL_DRUG_CATALOG_CLASS(新增) .................... 56 质控反馈信息字典QC_MSG_DICT ..................................................................................... 56

6. 费用 .................................................................................................................................................. 57 6.1 6.2 6.3 6.4 6.5 6.6 6.7 6.8 6.9 6.10 6.11 6.12 6.13

价表 PRICE_LIST .................................................................................................................. 57 当前价表 CURRENT_PRICE_LIST ...................................................................................... 58 价表项目分类与其他分类对照表 ITEM_CLASS_VS_OTHER_CLASS ........................... 59 价表项目名称字典 PRICE_ITEM_NAME_DICT............................................................... 59 计价单位字典 BILL_UNITS_DICT ...................................................................................... 59 收费系数字典 CHARGE_PRICE_SCHEDULE .................................................................... 59 价表项目执行科室 PERFORM_DEPT.................................................................................. 60 临床诊疗项目与价表项目对照表 CLINIC_VS_CHARGE .................................................. 60 医嘱附加计价项目字典 EXTRA_COSTS_DICT ................................................................. 61 价表项目分类字典 BILL_ITEM_CLASS_DICT .................................................................. 61 病案首页费用分类字典 MR_FEE_CLASS_DICT ............................................................... 61 门诊收据费用分类字典 OUTP_RCPT_FEE_DICT ............................................................. 61 住院收据费用分类字典 INP_RCPT_FEE_DICT ................................................................. 62

6.14 6.15 6.16 6.17 6.18 6.19 6.20 6.21 6.22 6.23 6.24 6.25 6.26 6.27 6.28 6.29 6.30 6.31 6.32

核算项目分类字典 RECK_ITEM_CLASS_DICT ................................................................ 62 会计科目字典 TALLY_SUBJECT_DICT ............................................................................. 62 支付方式字典 PAY_WAY_DICT ......................................................................................... 62 预交金操作类型字典 PREPAY_TRANS_TYPE_DICT ....................................................... 63 结算操作类型字典 SETTLE_TRANS_TYPE_DICT ........................................................... 63 支票标识字典 CHECK_LABEL_DICT ................................................................................ 63 收费特殊项目字典 CHARGE_SPECIAL_ITEM_DICT ....................................................... 63 收费特殊项目排斥字典 CHARGE_SPECIAL_EXCEPT_DICT ......................................... 64 收费部门分组字典 BILLING_GROUP_DICT ..................................................................... 64 费用模板主记录 BILL_PATTERN_MASTER ..................................................................... 65 费用模板明细记录 BILL_PATTERN_DETAIL ................................................................... 65 特殊号别价格字典SPECIAL_CLINIC_PRICE(不使用) ..................................................... 65 号类收费设置表 CLINIC_TYPE_CHARGE_DICT(新增) ................................................... 65 挂号支付方式字典REGIST_PAY_DICT ............................................................................. 66 治疗类别字典CURE_CLASS_DICT(不使用) ...................................................................... 66 币种字典MONEY_DICT ....................................................................................................... 66 OUTP_RCPT_FEE_FACTDICT ............................................................................................. 66 OUTP_RCPT_FEE_VS_FACTCODE .................................................................................... 67 PAY_STYLE_DICT ................................................................................................................ 67

7. 系统维护 .......................................................................................................................................... 68 7.1 7.2 7.3 7.4 7.5 7.6 7.7 7.8 7.9 7.10 7.11 7.12 7.13 7.14 7.15 7.16 7.17 7.18 7.19 7.20

病人标识号引用表 PATIENT_ID_REF .............................................................................. 68 应用程序记录 APPLICATIONS ............................................................................................ 68 应用程序权限记录 APP_GRANTS ....................................................................................... 68 联机帮助信息 HELP_MSG ................................................................................................... 68 字典信息 METADICT ........................................................................................................... 69 计算机站点 CLIENT_INSTALLATION ............................................................................... 69 SECURITY_GROUPINGS ..................................................................................................... 69 SECURITY_INFO ................................................................................................................... 69 SECURITY_USERS................................................................................................................ 69 SECURITY_APPS .................................................................................................................. 70 SECURITY_TEMPLATE ....................................................................................................... 70 应用角色APP_ROLES ........................................................................................................... 70 应用参数表信息APP_CONFIGER_BASEINFO(新增) ....................................................... 70 应用参数设置表APP_CONFIGER_PARAMETER(新增) ................................................... 70 AUTO_SETTING(不使用) ..................................................................................................... 70 自动生成ID表AUTO_SETTING_ID ................................................................................... 71 密码字典KEY_DICT ............................................................................................................. 71 表字段解释说明TABLE_COLUMNS_SET ......................................................................... 71 表角色解释说明TABLE_ROLE_SET .................................................................................. 72 表同义词解释说明TABLE_SYNONYM_SET ..................................................................... 72

8. 输入法 .............................................................................................................................................. 72 8.1 8.2

输入法配置表 OUTER_CODING_CONFIG ........................................................................ 72 输入码表 OUTER_CODE_DICT ........................................................................................... 73

8.3 8.4 8.5 8.6 8.7

层次输入法定义 CLASS_CODING_CONFIG ..................................................................... 73 分层编码描述 CLASS_CODING_RULE .............................................................................. 74 词库生成规则表OUTER_GENERATION ............................................................................ 74 模块与词库对照表OUTER_APP_USE ................................................................................. 74 MESSAGES ............................................................................................................................. 75

9. 病案 .................................................................................................................................................. 76 9.1 9.2 9.3 9.4 9.5 9.6 9.7 9.8 9.9 9.10 9.11 9.12 9.13 9.14 9.15 9.16 9.17 9.18 9.19 9.20 9.21 9.22 9.23 9.24 9.25 9.26 9.27 9.28 9.29 9.30 9.31 9.32 10. 10.1 10.2 10.3 10.4

病人主索引 PAT_MASTER_INDEX .................................................................................. 76 病人住院主记录 PAT_VISIT ............................................................................................... 77 病人在科记录 TRANSFER .................................................................................................. 82 诊断记录 DIAGNOSIS ......................................................................................................... 82 门诊诊断记录 CLINIC_DIAGNOSIS .................................................................................. 83 主要诊断 FINAL_CHIEF_DIAGNOSIS .............................................................................. 83 诊断分类记录 DIAGNOSTIC_CATEGORY ...................................................................... 83 手术记录 OPERATION ........................................................................................................ 84 诊断对照记录 DIAG_COMPARING .................................................................................... 84 住院病人费用记录 MEDICAL_COSTS................................................................................ 85 病人输血记录 BLOOD_TRANSFUSION ........................................................................... 85 病人过敏药物记录 ALERGY_DRUGS(不使用) ................................................................ 85 主索引合并记录 PMI_MERGED_LOG .............................................................................. 86 病案记录 MR_REC .............................................................................................................. 86 病案追踪日志 MR_TRACE_LOG ......................................................................................... 86 病案索引 MR_INDEX ........................................................................................................... 87 病历文件索引 MR_FILE_INDEX ......................................................................................... 87 联机病历描述MR_ON_LINE ................................................................................................ 88 病历模板索引 MR_TEMPLET_INDEX................................................................................ 88 病历模板选择MR_TEMPLET_SELECTION ....................................................................... 89 当前病历路径描述MR_WORK_PATH ................................................................................ 89 病案纸张描述MR_PAPER_DESC ........................................................................................ 89 医疗质量问题分类字典QA_EVENT_TYPE_DICT ............................................................. 90 修改姓名记录表PAT_MASTER_RENAME_LOG (新增) ................................................... 90 卡地址描述表MEDCARD_ADDRESS_REC(新增) ............................................................ 90 医疗卡门诊就医系统运行配置表MEDCARD_CONFIG(新增) .......................................... 91 医疗卡类型字典MEDICAL_CARD_TYPE_DICT(新增) .................................................... 91 医疗卡说明MEDICAL_CARD_MEMO(新增) .................................................................... 91 医疗卡变更日志MEDICAL_CARD_LOG(新增) ................................................................. 92 新生儿记录表NEWBORN_REC(新增) ................................................................................ 92 OPER_SETTLE_CARD .......................................................................................................... 93 PATIENT_CARD_INFO ........................................................................................................ 93 门诊病人管理 ......................................................................................................................... 94 门诊号别定义CLINIC_INDEX ............................................................................................. 94 门诊安排记录 CLINIC_SCHEDULE .................................................................................... 94 门诊号表 CLINIC_FOR_REGIST ......................................................................................... 95 门诊预约记录 CLINIC_APPOINTS ...................................................................................... 95