https://doi.org/10.14400/jdc.2017.15.10.377 최준영청암대학교병원의료정보과 Development of educational programs for managing medical information utilizing medical data generation and analysis techniques Joonyoung Choi Dept. of Hospital Medical Information, Cheongam College 요약본연구에서는의무기록사의의료정보관리능력을향상시킬수있는교육용의료정보관리프로그램을개발하였다. 교육용의료정보관리프로그램은 8 개월동안 vb.net 으로개발하였다. 데이터베이스는학습자가데이터의구조를쉽게이 해하고파악할수있는 ACCESS 의 Database 를이용하였다. 학습자는의무기록을분석하여퇴원분석및암등록프로그램 그리고미비기록프로그램을이용하여데이터를입력한다. 데이터를입력하고저장한후에의료정보관리프로그램을이용 하여데이터베이스의구조를이해하고분석하여의료정보를생성할수있다. 교육용프로그램은데이터베이스에서필요한 데이터를 SQL 을통하여직접추출하고, 다양한의료정보를생성해봄으로써학습자의의료정보관리능력을향상시킬수 있다. 하지만교육용프로그램이면서학습자의프로그램운영에대한평가체계가마련되지않았다. 이에따라서다음연구 에서는학습자평가를위한의료정보관리프로그램의평가시스템을개발해야할것이다. 주제어 : 의료정보관리, 의료정보분석, 의료정보교육, 의무기록분석, 의무기록교육 Abstract This study has developed a medical information management educational program that can improve the management ability of medical information. The educational medical information management program was developed for 8mnths uing VB. The database utilized the ACCESS Database, which allows learners to easily understand and understand the structure of the data. The learners enter data in the discharge analysis and the cancer registration program and the incomplete program after analyze the medical records. After entering and saving data, medical information management programs can be used to understand and analyze the structure of the database to generate medical information. The educational programs can improve the ability of learners to manage medical information by extracting the necessary data from the database directly through SQL and creating various medical information. However, although the medical information management program is an educational program, there is no evaluation system for the learners program operation. Accordingly, the next studies should develop the assessment system of the medical information management program for learners evaluation. Key Words : Medical Information Management, Medical Information Analysis, Medical Information Education, Medical Record Analysis, Medical Record Education Journal of Digital Convergence 377
1. 서론 2. 연구방법 378 Journal of Digital Convergence 2017 Oct; 15(10): 377-386
Development of educational programs for managing medical information utilizing medical data generation and analysis techniques [Fig. 2] Data Analysis Program for Medical Information Management [Fig. 1] Program algorithm 3. 연구결과 [Fig. 3] Entity-Relationship Diagram of Discharge Tables Journal of Digital Convergence 379
[Fig. 6] Table configuration fields [Fig. 4] Flowchart of Medical Information Management Program [Fig. 5] Data Analysis Program for Medical Information Management [Fig. 7] SQL for Data analysis [Fig. 8] Data query using SQL 380 Journal of Digital Convergence 2017 Oct; 15(10): 377-386
Development of educational programs for managing medical information utilizing medical data generation and analysis techniques 3.1 퇴원분석프로그램 [Fig. 11] Operation status, Transfer department status, Consulting diagnosis status [Fig. 12] Diagnosis code information, Operation code information [Fig. 9] Discharge base information [Fig. 10] Obstetric information and infection information <Table 1> Data table details of discharge analysis programs Journal of Digital Convergence 381
[Fig. 13] Discharge analysis table data relation ship <Table 2> Data table details of Cancer registration programs [Fig. 14] Discharge data analysis through medical information analysis program 3.2 암등록프로그램 [Fig. 15] Cancer Registration Program for Medical Information Management 382 Journal of Digital Convergence 2017 Oct; 15(10): 377-386
Development of educational programs for managing medical information utilizing medical data generation and analysis techniques 3.3 미비기록관리프로그램 [Fig. 18] Incomplement record management program for Medical Information Management [Fig. 16] Cancer registration table data relation ship <Table 3> Data table details of incomplement medical record programs [Fig. 17] Cancer registration data analysis through medical information analysis program Journal of Digital Convergence 383
[Fig. 19] Incomplement record management table data relation ship [Fig. 21] Procedures of Discharge analysis program for Medical Information Management [Fig. 20] Inadequate record data analysis through medical information analysis program 384 Journal of Digital Convergence 2017 Oct; 15(10): 377-386
Development of educational programs for managing medical information utilizing medical data generation and analysis techniques 4. 결론 REFERENCES Journal of Digital Convergence 385
최준영 (Choi, Joon Young) 386 Journal of Digital Convergence 2017 Oct; 15(10): 377-386