보건의료생명과학 논문지 (Journal of the Health Care and Life Science)

한국의료정보교육협회 (The Korean Society of Medical Informatics Education)
권호 표지
DOI QR코드

DOI QR Code

처방정보관리를 위한 EMR 인증기준의 실습 모델 연구 - SQL을 이용한 데이터 관리 중심 -

A Study on the Practice Model for Prescription Information Management of EMR Certification standard - Focus on Data management using SQL -

  • 최준영 (원광보건대학교 의무행정과)
  • Joon-Young Choi (Dept. of Medical Administration, Wonkwang Health Science University)
  • 투고 : 2022.07.03
  • 심사 : 2022.07.22
  • 발행 : 2022.07.31
PDF 다운로드
⟨ 이전 논문 다음 논문 ⟩

초록

본 연구에서는 보건의료정보관리사의 EMR 인증기준의 이해 및 데이터관리 실습을 위한 SQL 실습 모델을 제시하였다. 본 연구는 보건의료정보관리 실습 프로그램을 통하여 EMR인증기준의 기능성에 대한 처방정보관리를 실습하는 것이다. EMR 인증기준에 의한 실습내용은 약품마스터관리 및 약품명 조회, 투약처방 조회, 수진 정보 변환 후 이전 투약 처방 조회, 투약처방 시 검사 결과 조회, 검사처방기록 조회로 구성되었다. 추가적으로 식이처방기록 조회, 기타처방기록 조회, 마약류 투약 처방 중단 시 반납사유 조회가 포함된다. 이에 따라서 MS-ACCESS 기반의 보건의료정보관리 교육시스템의 처방관리 데이터베이스를 사용하여 처방정보관리 인증기준의 내용을 조회할 수 있는 SQL문장을 작성하였다. EMR 인증기준 실습은 SQL을 사용하여 인증기준에서 요구하는 조회항목을 직접 추출해봄으로써 인증기준을 좀 더 쉽게 이해할 수 있으며, 그리고 인증기준 외의 데이터를 추출할 수 있는 데이터 관리 및 정보 생성 능력을 향상시킬 수 있을 것이다.

In this study, a SQL practice model for understanding EMR certification standards and data management practice for healthcare information managers was presented. This study is to practice prescription information management for the functionality of EMR certification standards through the health and medical information management practice program. The data management practice according to the EMR certification criteria consists of medicaiton master management and medicaiton name inquiry, medicaiton prescription inquiry, previous medication prescription inquiry after converting medical care information, examintaion result inquiry when administering medicine, examination prescription records inquiry. Additionally, dietary prescription records, other prescription records, return reason inquiry when administering medicine is stopped are included. Accordingly, using the prescription management database of the MS-ACCESS-based health care information management education system, a SQL statement was written that can inquire the contents of the prescription information management certification standards. In the EMR certification practice, you can understand the certification standards more easily by directly extracting the query items required by the certification standards using SQL and it will be possible to improve the data management and information generation ability to extract data other than the certification standards.

키워드

과제정보

본 논문은 2022년도 원광보건대학교 교내연구비 지원에 의해서 수행되었음.

참고문헌

  1. Korea Health Information Management Association, 'Health Information Management Definition', Korea Health Information Management Association, khima.or.kr, 2020 
  2. Korea Ministry of Government Legislation, 'Medical Technician Law', Korea Ministry of Government Legislation, 2020. 
  3. S-H. Kang, S-J. Kim, Y-M. Kim, M-H. Park, S-W. Park, S-K. Baek, Y-K. Boo, J-Y. Seo, J-W. Lee, Y-H. Choi and J-Y. Choi, 'Health Care Information Management', Korea Health Information Management Association, 2020. 
  4. Y-T. Park, 'Current status and development direction of electronic medical record systems in domestic medical institutions', Health Insurance Review & Assessment Service, 2017 
  5. K-I. Lee, 'Establishment and activation of the basis for exchange of medical information for health and medical informatization', Korea Health Industry Development Institute, 2017. 
  6. Ministry of Health & Welfare, 'Establishment and activation of medical information exchange basis for health and medical informatization (Advanced EMR system product certification system)', Korea Health Industry Development Institute, 2016. 
  7. Korea Health Information Service, '2020 Electronic Medical Record System Certification System Certification Criteria', Korea Health Information Service, 2020. 
  8. Korea Health Information Service, 'Electronic Medical Record System Certification Standard 2020 Guide', Korea Health Information Service, 2020. 
  9. J-Y. Choi, S-H. K, B-C. Kim, B-I. Y, S-K. S, K-T. H and J-K. L, 'Medical Information Technology', Health Care Information Management Association, pp.11-120, 2020. 
  10. J-Y, Choi, 'A Study on Educational Contents of Software for the Management of Medical Information', The Korean Society of Health and Welfare, Vol.18, no.1, pp.113-126, 2016. 
  11. J-Y, Choi, 'A Study on Medical Data Management Training Plan for Improving Health Information Management Practice', The Korean Society of Health and Welfare, Vol.21, no.3, pp.131-149, 2019. 
  12. J-Y, Choi, 'A Study on the Health Information Management Practice Program Model for EMR Certification System Education - Focus on patient information management -, Journal of The Health Care and Life Science, vol.9, No.1, pp.1-9, 2021. 
  13. J-H, Lee, 'Health and Medical Informatization Survey Results Report', Korea Health Information Service, 2020.