/soft/77257.htm
Community Hospital Management System 9.02
Keywords Community Health
With the rapid development of information technology, the development and application of hospital information systems (Hospital Information System) is also becoming more and more extensive, and is now commonplace [1, 2]. As early as the end of 2000, our hospital took the lead in the outpatient, inpatient computer network, to achieve a new leap in the hospital management model. The hospital's community health service center, under the 13 community health clinics, in order to strengthen management, based on the model of computerized management of hospitals, combined with the characteristics of community health service centers, design and development of a set of "community health service centers management system", and in the hospital under the community service clinics, other community service centers to be Widely used in the hospital community service clinics, other community service centers to achieve good results in the application of the design and introduction of the system is as follows, for peer reference.
1 system structure and development tools
1.1 system structure The system structure is simple, considering the importance of the system for patient information, money, things and other data management, the number of workstations is small, the system only runs in a single community within the hospital LAN. The network structure consists of a star and bus type LAN through gigabit switches and servers. Data contact with the hospital headquarters, at a fixed time, by the community's established workstations to run a backup program, back up the data in question, through the newsstand or broadband FTP back to the hospital.
1.2 Development tools Server, workstation operating system: Windows 2000, Windows 98, Windows XP. database: DBF, development tools using VFP 6.0
2 The system process, overview and functional modules
2.1 The flow of the system See Figure 1. Figure 1 System flow
2.3 The main modules of the management system
2.3.1 Patient basic information module (1) to establish the basic patient information base, such as name, age, gender, address, medical history, the time of this visit, ID card number and other information. (2) Establish the module of patient service card. When the patient visits the clinic for the first time, the service center writes the patient's basic information into the card and issues the card to the patient. When the patient returns to the clinic, he or she can present the service card to inquire about past relevant information and enjoy preferential medical treatment. (3) The establishment of the patient's medication details module, the patient swipes the card or enter the relevant information, you can access the details of their own medication records.
2.3.2 Drug Inventory Management Module In the community healthcare management system, there is no actual inventory in the pharmacy, and the drugs are managed in the same way as they come in, i.e., the inventory in the pharmacy is always absolutely zero. Therefore, the pharmacy management module is relatively simple only dictionary establishment, in and out of management, in and out of the quantity, amount of accounts.
2.3.2.1 Establish a dictionary of drugs such as drug name, specifications, role classification, restricted, unrestricted, medical insurance category (Class A, Class B, reimbursement rate), reimbursement signs and other related attributes.
2.3.2.2 Accounting for inventory The main purpose is to enter or automatically obtain the name of the drug, specifications, batch number, price, manufacturer, supplier, packaging unit, unit of issuance of drugs, etc., for inventory, the computer automatically access the previous historical prices, providing a scientific data basis for the procurement of drugs.
2.3.2.3 Incoming and outgoing management of medicines The incoming details, outgoing details, inventory details, transfer details, loss details, return details, and summary data of various medicines can be generated at any time. It can track the detailed running account of each drug, check the inventory change of any variety of incoming, outgoing and inventory details at any time, and support the management of drug batches. Special drugs such as poisonous and narcotic drugs, psychotropic drugs, etc. have specific judgment and identification processing. With automatic generation of procurement plans and purchase orders.
2.3.2.4 Price Management As the community medical management is a virtual pharmacy management, the price adjustment function of the drugs can only adjust the price of the pharmacy drugs, support for real-time price adjustment of a single species, the pharmacy unified price adjustment function.
2.3.2.5 Query statistics can statistically analyze the consumption of drugs inventory, provide the expiration date management of drugs, automatic alarm and statistics on the number of varieties of expired drugs and the amount of money, and inventory alert function, the provision of the accounting function, you can automatically query a certain period of time of the community drug sales, profits, the workload of the doctor and the individual generated profits, the profit of the patient's prescriptions, and other important information.
2.3.2.6 Prescription Dispensing Module The main functions include: prescription confirmation and dispensing, prescription query, prescription return, checking of the day's prescription, statistics, and workload statistics.
2.3.3 Charge Management Module
2.3.3.1 Write card, card issuance function First-time patients, where the relevant information is entered and deposited into the computer system, to complete the write card work.
2.3.3.2 Prescription entry module The main functions include: prescription entry, timely billing, and printing of bills.
2.3.3.3 Statistical Reports Sales revenue, profit, financial transfers for a certain period of time.
3 system design and application
3.1 The establishment of the database According to the requirements of the objectives that need to be achieved by the system, the establishment of the data structure of the corresponding database. Dictionary library: Drug Dictionary Library (YPZD), Project Charge Library (JCZL), Address Library (ADD), Card Number Library (BRKH), Supply Unit Library (JYADD), etc.; Business Flow Reservoir: Daily Operation Cash Library (YJDAY), Prescription Detail Library (CFDAY), Allergy History Library Table (GMSB), Quantity Account (YPSLZ), Summary Library (YJMON), etc.; Other library tables: drug inventory library (YPSTOCK), patient information library (BZXXK), etc. *** Counting 35 related library tables. In the design of the database, give full consideration to the community's preservation of patient information, timely statistics on drug profits, inventory consumption query, in the YJDAY library, increase GRJE, N, 8, 2 fields, so that in the prescription entry, the computer automatically writes the purchase of the unit price, to facilitate the real-time statistics of drug profits; BRKH only the patient's visit to the clinic number, the password for the two fields, the computer based on the read out of the card number, the BZXXK to carry out related operations; BZXXK increased allergy drug ID number, prompting doctors in a timely manner the relevant information on the patient's medication. These databases are stored separately in the ＼sqmz＼dbf＼ directory of the back-end server for access by each workstation.
3.2 Software design VFP 6.0 was chosen as the system software development tool because, in addition to its powerful development capabilities with nearly 500 commands and more than 200 functions, it is also very important that it is compatible with programs developed using FOXPROX. In the design of the system, fully inherited the advantages of the original drug management, prescription pricing stand-alone version, transplantation of some software modules, variables and functions. The whole system is divided into a number of subsystems, grouped design, debugging module by module. Then according to the functional requirements of the workstation, and finally form a complete networked system.
3.3 Difficulties in software design analysis and solution ideas
3.3.1 Real-time reduction of drug inventory Given the current network, database structure mode, in the prescription dispensing completed, invoice printing is completed, the computer writes the prescription, charge information in addition to the drugs in force according to dispensing the drug to reduce the inventory of the drug, the computer processing of the burden of the overload is very likely to cause Data between databases do not synergize. The idea of the solution, through the end of the day transfer program, the drugs in effect (CFDAY) to recalibrate the inventory, to ensure the accuracy and consistency of the number of inventory.
3.3.2 The problem of drug prices Due to the increase in the computer automatic settlement of sales profits, the purchase unit price into the entire software process, and the purchase unit price is a parameter that can not be changed, aggravated by the computer needs to judge the conditions of the program's judgment using the ID of the drug, the purchase price, the retail price of the three for the same drug judgment conditions, resulting in an increase in the amount of data in the database of the drug. Affect the running speed of the network system. The idea of the solution: where the inventory of drugs in the computer is greater than zero, can participate in the prescription entry, through the transfer program to organize the inventory, the inventory is equal to zero for the transfer of data processing, the inventory is negative, by responding to the workstation function to adjust, to ensure that at any time to read, write the database of the dynamic consistency.
4 system application experience
In the community health care services using computer management has very significant advantages: (1) the use of community patient information management module, the issuance of community visit card, the patient visits the card, both to display the patient's visit time here, the details of the previous medication, drugs, allergy history and other relevant information, which brings breakthroughs to the community health care This is a breakthrough for community healthcare. (2) in the management of drugs: although the community does not set up an actual drugstore, the system is still designed to use the virtual drugstore management, drug purchases can be received by the hospital headquarters, can also be purchased by the manufacturers themselves, in the virtual drugstore for the inventory, you can always access a unified variety of uniform batch number of the historical price of medicines, to facilitate a dynamic understanding of the price of the drugs purchased to avoid fraudulent behavior of the merchants. (3) Purchase price into the network workflow: the pharmacy allocated to the pharmacy drugs in the computer will be purchased unit price tracking pharmacy, in the prescription entry, the retail unit price, the purchase price of a piece of writing sales flow statement, statement statistics at any time to print the community sales, profit statement. Break the original financial statements, sales, inventory financial accounting methods. Pharmacy inventory can be queried at any time the retail amount, the purchase amount. Purchase price into the purchase, sale, inventory management process, and retail price synchronization tracking, so that community managers timely and dynamic understanding of the actual situation of the operation, to grasp the profitability of drug management, saving manpower, material resources, the issue of medicine community management in the charge, the issue of medicine can be completed by a workstation **** with the same. (4) Simplify the process of medical treatment: the whole process of patient care between the exchange of information in the network to complete, no longer need to rely on patients to go back and forth to pass the information, reducing the link between the patient to see a doctor, convenient for the patient. The whole management is more standardized and scientific, improving work efficiency and thus overall improving the service quality of community health services. (5) the establishment of the initial patient's health electronic file: the issuance of community service cards, card-carrying clinic, can be accessed at any time in this community each visit to the cost, medication, etc., convenient for the patient.
This community medical management software is based on the hospital's community outpatient management needs to write. Currently in the community outpatient clinic normal operation for more than a year, the community services department of the praise. Due to the development of this software system's structure system is not ideal, the data collected by the system can not do a deep analysis, the establishment of basic patient information is still to be based on the requirements of community health services, classification and establishment of the patient's profile information. With the development of information technology and the improvement of management requirements, the structural system of the network and software development tools need to be improved. So that community information can be passed to each other within the higher authorities, community centers, the program design should continue to sum up the experience and continue to improve the system's various service functions.
References
1 Wu Guangtong, Zhang Xiahua. The application of drug management system of "Military and Health Project No.1". Chinese Journal of Modern Clinical Medicine,2004,2(8A):1370.
2 Wang Tianbo. Investigation and reflection on community health service in urban area of Jiangyan City. Chinese Journal of Modern Hospital Management,2005,3(8):740.
Authors' affiliation: Tai'an Hospital of Traditional Chinese Medicine, Tai'an City, Shandong Province, 271000, P.R. China
(Edited by Lin Jianlei)