摘要：In psychiatric hospitals, the ratios between patients versus physician and patients versus nurse are low as compared to those in general hospitals. Furthermore, usages of electronic medical records are also low so that nurse administrators are limited in their ability to compile, analyze, and generate patient care staffing information for their administrative use. Psychiatric nurse administrators anticipate the development of a nursing administration analysis system that could perform personnel data simulation, manage information on nursing staff, and manage ward/ practice operations. Responding to this situation, the authors developed a nursing administration analysis system utilizing formulae from the Psychiatric Outcome Management System, PSYCHOMS® to aid nurse administrators. Such formulae are awaiting patent approval. The purpose of this study was to examine the validity of the formulae and the Structured Query Language (SQL) statement, and its practical effectiveness of analyzing data. The study findings showed that two kinds of computation expressions—a classification and extraction were able to display required information desired by nurse administrators. Moreover, significant information critical to assigning staff was validated to ensure high quality of nursing care according to the function and characteristic of the hospital ward.
