【摘要】 目的探讨基于数据透视表的病案首页数据查询技术。方法通过定点医院从病案首页数据提取医疗保险测算病种的案例,划分数据透视表使用应用步骤。结果基于数据透视表的病案首页数据查询技术可以病案首页字段的灵活设置,转换分析角度,改变统计汇总方式,快捷、高效地分析病案数据资源。结论基于数据透视表的病案首页数据查询技术是一种低成本、高效率的技术,值得推广。更多还原

【Abstract】 Objective Discuss the technique of the data query in the first page of medical records based on pivot table.Methods To make the application step by the example of draw the disease type for the health insurance calcultation from the first page of medical records in specific hospital.Results The data query in the first page of medical records based on pivot table can make the field setting of first page of medical records smoothly,and transform the standpoint of analysis、and change the way of summarizing statistics,and make the analysis of medical records data resource more quickly and high efficiently.Conclusion The technique of the data query in the first page of medical records based on pivot table is low cost and high efficiency technique.It is worthy of spreading.更多还原