1 Database
Databases offer great opportunities for productivity. In fact, in corporate libraries, electronic databases are now considered more valuable than books and journals. However, maintaining databases means users must make constant efforts to keep them from being tampered with or misused. 1、Strategic uses
Databases help users to keep up to date and to plan for the future. To support the needs of managers and other business professionals, many organizations collect data from a variety of internal and external databases. This data is then stored in a special type of database called a data warehouse. A technique called data mining is often used to search these databases to look for related information and patterns.
There are hundreds of databases available to help users with both general and specific business purposes, including:
Business directories providing addresses, financial and marketing information, products, and trade and brand names.
Demographic data, such as county and city statistics, current estimates on population and income, employment statistics, census data , and so on.
Business statistical information, such as financial information on publicly traded companies, market potential of certain retail stores, and other business data and information.
Text databases providing articles from business publications, press releases, reviews on companies and products, and so on.
Web databases covering a wide range of topics including all of the above. As mentioned earlier, web search sites like Yahoo! Maintain extensive databases of available web sites. 2、Security
Precisely because databases are so valuable, their security has become a vital issue. As we discussed in chapter 10, there are several database security concerns. One concern is that personal and private information about people stored in databases may be used for the wrong purposes. For instance, a person’s credit history or medical records might be used to make hiring or promotion decisions. Another concern is unauthorized users gaining access to a database. For example, there have been numerous instances in which a computer virus has been launched into a database or network.
Security may require putting guards in company computer rooms and checking the identification of everyone admitted. Some security systems electronically check fingerprints. Security is particularly important to organizations using WANs. Violations can occur without actually entering secured areas. As mentioned in previous chapters, most major corporations
today use special hardware and software called firewalls to control access to their internal networks.
2 Database Management System
A DataBase Management System (DBMS) is a software application which allows the storage, retrieval, and manipulation of information in a prescribed format. One common form of organization is the table, which is formatted by row (record) and column (field). For example, a table storing data on animals might have a row for a cat, with fields for legs (4), whiskers (yes), type (mammal), and so on. Another row, for a snake, would contain 0, no, and reptile. The creator of the table must therefore anticipate any characteristics which will need to be recorded. In its purest form, a DBMS does not allow for unformatted data. This restriction allows quick indexing, sorting, and other data processing. Contrast this with .
3 Hospital Management System
Medinous Hospital Management System is powerful, flexible and easy to use and has designed and developed to deliver real conceivable benefits to hospitals and clinics. And more importantly it is backed by reliable and dependable Medinous support. 1、Registration
The Registration module is an integrated patient management system, which captures complete and relevant patient information. The system automates the patient administration functions to have better and efficient patient care process.
? Patient Registration Details
? Inpatient and Outpatient Registration ? Medical Alerts Details
? Appointment Scheduling (Patient / Doctor wise) ? Doctor's Schedule Summary ? Doctors Daily Schedule List Patient Visit History
? Medical Record Movements
? Appointments for Radiology tests and Operation Theatre ? Patient Visit Slip ? Sponsorship Details
It provides for enquiries about the patient, the patient's location, admission, and appointment scheduling and discharge details. Furthermore, this system even takes care of package deals for
?
a patient for a fixed cost. Medical Record keeps an abstract of clinical data about patients. It allows easy retrieval of medical records on patients. 2、Billing
The Patient Billing module handles all types of billing for long-term care. This module facilitates cashier and billing operations for different categories of patients like Outpatient, Inpatient and Referral. It provides automatic posting of charges related to different services like bed charges, lab tests conducted, medicines issued, consultant's fee, food, beverage and telephone charges etc. This module provides for credit partly billing and can be seamlessly integrated with the Financial Accounting Module. The billing module is extensively flexible by which each of your billing plans can be configured to automatically accept or deny. The system is tuned to capture room and bed charges along with ancillary charges based on the sponsorship category. The Billing Screens is used for In-patient and Outpatient Billing and Invoicing. Further more the charges for various services rendered can be recorded through service module and this can be used for billing purposes.
? Payment Modes / Details
? Sponsorship Conditions Details ? Patient Billing Details ? Package Installment ? Approval from Sponsor
? Company Sponsorship Details ? Package Registration ? Sponsor Verification ? Retroactive Processing ? User-defined Billing Cycles
? Automatic Room and Board Charges ? Recurring Ancillary Charge Capability ? Auto-generated Codes and Billing Criteria ? Provision for Pre-billing ? Extensive Third-party Billing
The system supports multiple reports utilizing various print options with user-defined parameters
3、Financial Accounting
The Financial Accounting Module deals with Cash/Bank, Receipt/Payments, Journal Voucher and General Ledger etc. Books like Cashbook, Bankbook and Ledger book can be generated. This module generates reports like Trail Balance, Balance Sheet and Profit and Loss statement. The Financial Accounting Screens describe about the Account Payable, Account Receivable and General Ledger. Also describe the activities related to IP, OP, Bank related
activities and provision to clearing the Supplier Invoice and keep track of the Account Receivable and Revenue related activities. The services that are covered by the sponsor
companies, Insurance Agencies, Family Accounts, Individual Accounts, sponsorship details of the patient, Health Card Insurance are recorded in the system 4、Fixed Assets
The Fixed Assetss Module deals with all the activities that are related to the Fixed Assets Part of Financial Accounting. This describe included the activities that are related to identifying an item as a Fixed Assets and then allocating depreciation, managing its movement, Maintenance, Revaluation and Disposal etc., 5、Payroll
The Payroll & Personnel module deals with Pay (and deduction) calculation, printing of salary slip, salary certificates, and PF statements, Gratuity Statement and provides a monthly analysis. It deals with the maintenance of employee bio-data, Attendance / Overtime details. It also reports on absenteeism, leave encasements etc. The Personnel & Payroll department is responsible Employee Related Activities like appointing the staff, maintaining the employee database, Fixing allowances and deductions, Leave entitlements, Leave sanctions, Loan,
Termination Process, Maintenance of Hospital documents, Insurance details, Tenancy Contracts and Vehicle Registration etc. 6、Outpatient Management
The Outpatient module serves as an entry point to schedule an appointment with the Hospital Resident Doctor or Consultant Doctor for Medical Consultations and diagnosis. This module supports doctors to take better and timely consultation decisions by providing instant access to comprehensive patient information. Patient visits are divided into New, Follow-up and Review. This module also handles requests and results of laboratory tests and other
examinations. External Doctors visit to in patients can be defined as \may avail only the hospital facilities like Lab, Radiology, Nuclear Medicine, and Physiotherapy and so on.
Medical Alerts Details Consultation Duty Roster
Diagnosis Details Triage Parameters
Patient’s Appointments
Daily / Weekly Schedule Summary
Appointment Scheduling / Rescheduling Facility Outpatient Medical Observation Details Investigation / Treatment History Clinical Service Details
Group / Package Registration Facility Common Billing Clinical Services Doctor’s Diagnosis Statistics
Further more, Confidentiality of Doctors Observation, Previous History of Patients Visit, Online Prescription, Online Request for Investigations and so on, are the special features in Doctors Observation screen. This system calculates the cost for the services rendered to the patient and reflects in the billing module appropriately resulting in smooth billing process 7、Inpatient Management
The inpatient module is designed to take care of all the activities and functions pertaining to Inpatient Management. This module automates the day-to-day administrative actives and provides instant access to other modules, which leads to a better patient care. It provides
comprehensive data pertaining to Admission of Patients & Ward Management: Availability of beds, Estimation, Agreement preparation, Collection of advance, Planned admission,
Emergency admission and so on. The Inpatient module also deals with Ward Management: Shifting from one ward to the other, Bed availability, Surgery, Administration of drugs, nursing notes, charge slip and so on.
Admission Cost Estimation Admission Approval Admission Request Doctor Transfer Details Nursing Notes
IP Medical Observation Pending Drug Request Surgery Scheduling Details
Discharge Notification Summary Expected Date and Time of Discharge
The module tracks every visit made by the patient and caters to follow-up visits of patients, along with multiple appointments. 8、Pharmacy
Pharmacy module deals with the automation of general workflow and administration management process of a pharmacy. The pharmacy module is equipped with bar coding facility, which makes the delivery of medical items to the patient more efficient. This module deals with the activities such as:
Enquiry Quotation Purchase order Online approval,
外文文献--医院信息管理系统
