DEVELOPMENT OF MEDICAL RECORD QUERY APPLICATION FOR HOSxP, HoMC and HOSPITAL OS FOR PHARMACEUTICAL CARE

Authors

  • Durongrit Tripak Pharmacy Department, Phrae Hospital, Phrae
  • Perayot Pamonsinlapatham Department of Health Informatics, Faculty of Pharmacy, Silpakorn University, Sanamchandra Palace Campus, Nakhon Pathom

Keywords:

pharmacy, application, hospital information system, application programming interface: API, pharmaceutical care

Abstract

Pharmacy service is an important process to access patient’s information especially drug use information. Up to date, electronic health data has been stored in the database of Hospital Information System (HIS). It can be accessed from the hospital information system programs such as HOSxP, HoMC and Hospital OS. However, the HIS program was not sufficient to support the routine work and could not facilitate the pharmacy services. The researcher developed a medical record query application in order to assist pharmacy services. The researcher developed a program using the Application Programming Interface (API) concept to connect the database of three hospital information systems, HOSxP, HoMC and Hospital OS, and also developed a medical record query program to connect the API. After the two parts were completely developed, the evaluation of the program in terms of accuracy, speed, and user’s satisfaction was conducted by using a questionnaire. The mean score of an accuracy of the program was at a high level (4.03, SD = 0.72). The mean score of the speed of the program efficiently fast (4.01, SD = 0.92), and the overall satisfaction score of the program was at a high level (4.22, SD = 0.91). When the programs connected to each hospital information system were compared, it was found that the mean scores of the accuracy and the speed of the Hospital OS were significantly different from those of HOSxP and HoMC. Moreover, the users’ satisfaction towards each HIS was different

References

1. Ismail NI, Abdullah NH, Shamsuddin A. Adoption of Hospital Information System (HIS) in Malaysian Public Hospitals. Procedia - Soc Behav Sci [Internet]. 2015 Jan 27 [cited 2018 Apr 17];172:336–43. Available from: https://www.sciencedirect.com/science/article/pii/S1877042815004103

2. Tsumoto S, Hirano S, Tsumoto Y. Information reuse in hospital information systems: A data mining approach. In: 2011 IEEE International Conference on Information Reuse & Integration [Internet]. IEEE; 2011 [cited 2018 Apr 23]. p. 172–6. Available from: http://ieeexplore.ieee.org/ document/6009541/

3. Tripak D, Pamonsinlapatham P. Development of application programming interface (API) with hospital information system (HIS) for medical record query in pharmacy service. In: The Fifth National Conference on Medical Informatics and The Annual Meeting of The Thai Medical Informatics Association. 2016. p. 53–8.

4. BMS-HOSxP [Internet]. [cited 2018 Apr 9]. Available from: http://hosxp.net/joomla25/index.php/product-menu/2012-06-06-06-08-32/bms-hosxp-menu

5. info-d software | Hospital System Program [Internet]. [cited 2018 Apr 9]. Available from: http://www.info-dsoftware.com/#product (in Thai)

6. Hospital OS Community - Open Source Technology Co., Ltd [Internet]. [cited 2018 Apr 9]. Available from: http://www.hospital-os.com/th/index.php/product-list/hospital-os-community.html (in Thai)

7. MySQL [Internet]. [cited 2018 Oct 22]. Available from: https://www.mysql.com/

8. Microsoft Data Platform | Microsoft [Internet]. [cited 2018 Oct 23]. Available from: https://www.microsoft.com/en-us/sql-server/

9. PostgreSQL: The world’s most advanced open source database [Internet]. [cited 2018 Oct 22]. Available from: https://www.postgresql.org/

10. API | Definition of API in English by Oxford Dictionaries [Internet]. [cited 2018 Oct 8]. Available from: https://en.oxforddictionaries.com/definition/api

11. API [Internet]. [cited 2018 Oct 8]. Available from: https://www.bot.or.th/Thai/Statistics/EconomicAndFinancial/Pages/API.aspx

12. Heiderich M, Nava EAV, Heyes G, Lindsay D, Heiderich M, Nava EAV, et al. PHP. In: Web Application Obfuscation [Internet]. Elsevier; 2011 [cited 2018 Apr 21]. p. 151–75. Available from: http://linkinghub.elsevier.com/retrieve/pii/ B9781597496049000066
13. Yuan T, Tang Y, Wu X, Zhang Y, Zhu H, Guo J, et al. Formalization and Verification of REST on HTTP Using CSP. Electron Notes Theor Comput Sci [Internet]. 2014 Dec 22 [cited 2018 Apr 22];309:75–93. Available from: https://www.sciencedirect.com/science/article/pii/S1571066114000917

14. JSON [Internet]. [cited 2018 Apr 23]. Available from: https://www.json.org/

15. Extensible Markup Language (XML) [Internet]. [cited 2018 Apr 23]. Available from: https://www.w3.org/XML/

16. Lin B, Chen Y, Chen X, Yu Y. Comparison between JSON and XML in Applications Based on AJAX. In: 2012 International Conference on Computer Science and Service System [Internet]. IEEE; 2012 [cited 2018 Apr 23]. p. 1174–7. Available from: http://ieeexplore.ieee.org/ document/6394535/

17. PSPP - GNU Project - Free Software Foundation [Internet]. [cited 2018 Apr 9]. Available from: https://www.gnu.org/ software/pspp/

18. Sratthaphut L. Freeware PSPP Statistic Software Manual for Beginners. 1st ed. Nakhon Pathom: Silpakorn University Printing House; 2012. (in Thai)

19. Sub-committee for Rational Use of Medicines. Rational Drug Use Hospital Manual. 1st ed. The Agricultural Co-operative Federation of Thailand Printing House; 2015. p. 56-141 (in Thai)

20. Prapanwattana M. Medication Reconciliation. In: Safety Medication System. 3rd ed. Phitsanulok: Rattanasuwan Printting 3; 2014. p. 261–306. (in Thai)

21. Theera-Ampornpunt N. Thai hospitals’ adoption of information technology: a theory development and nationwide survey. 2011 [cited 2018 Apr 22]; Available from: https://conservancy.umn.edu/handle/11299/162267

22. Allen IE, Seaman CA. Likert scales and data analyses. Qual Prog. 2007;40(7):64–5.

Downloads

Published

2019-03-25

Issue

Section

Original Research Articles