1、精選優(yōu)質(zhì)文檔-傾情為你奉上1DatabaseDatabases 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 m

2、isused.1、Strategic usesDatabases 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 call

3、ed 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, finan

4、cial 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 comp

5、anies, 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

6、earlier, web search sites like Yahoo! Maintain extensive databases of available web sites.2、SecurityPrecisely 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 priv

7、ate information about people stored in databases may be used for the wrong purposes. For instance, a persons 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 numerou

8、s 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 organi

9、zations 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.2Database Management SystemA DataBase Management System (

10、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, w

11、ith 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 r

12、estriction allows quick indexing, sorting, and other data processing. Contrast this with .3 Hospital Management SystemMedinous 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 impor

13、tantly it is backed by reliable and dependable Medinous support.1、RegistrationThe 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 c

14、are 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

15、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

16、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、BillingThe Patient Billing module handles all types of billing for long-term care. This module facilitates cashier and billing

17、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 provide

18、s 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 ancillar

19、y 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· S

20、ponsorship 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 Char

21、ges· Recurring Ancillary Charge Capability· Auto-generated Codes and Billing Criteria· Provision for Pre-billing· Extensive Third-party BillingThe system supports multiple reports utilizing various print options with user-defined parameters3、Financial AccountingThe Financial Acco

22、unting 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

23、 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 co

24、mpanies, Insurance Agencies, Family Accounts, Individual Accounts, sponsorship details of the patient, Health Card Insurance are recorded in the system4、Fixed AssetsThe Fixed Assetss Module deals with all the activities that are related to the Fixed Assets Part of Financial Accounting. This describe

25、 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、PayrollThe Payroll & Personnel module deals with Pay (and deduction) calculation, printing of salary slip, sala

26、ry 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 Act

27、ivities 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 ManagementThe Outp

28、atient 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 informa

29、tion. 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 "Call on". Some patients may avail only the hospital facilities like Lab, Radio

30、logy, Nuclear Medicine, and Physiotherapy and so on.Medical Alerts Details Consultation Duty Roster Diagnosis Details Triage Parameters Patients Appointments Daily / Weekly Schedule Summary Appointment Scheduling / Rescheduling Facility Outpatient Medical Observation Details Investigation / Treatmen

31、t History Clinical Service Details Group / Package Registration Facility Common Billing Clinical Services Doctors Diagnosis Statistics Further more, Confidentiality of Doctors Observation, Previous History of Patients Visit, Online Prescription, Online Request for Investigations and so on, are the s

32、pecial 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 process7、Inpatient ManagementThe inpatient module is designed to take care of all the activities and fu

33、nctions 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,

34、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 Co

35、st 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

36、 visits of patients, along with multiple appointments.8、PharmacyPharmacy 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 e

37、fficient. This module deals with the activities such as:Enquiry Quotation Purchase order Online approval, Pharmacy drug configuration Pharmacy stores configuration Drug issue to patients and billing Unit dosage facility Supplier information Maintenance of drug inventory Automatic reorder level setti

38、ng Purchase Requisitions Purchase Order Online request for stock from various sub-stores Online stock transfer Maintenance of stock at different sub-stores Return of items nearing expiry Destruction of expired items Physical stock verification and adjustment Goods receipt Stock Transfer (inter store

39、 stock transfer) Stock Adjustment Stock in Hand reports In addition the Online prescription facility assists and facilitates the physicians to track the patient's prescription details and as well reflects the medication billing details in the Billing module.9、RadiologyRadiology module caters to services such as X-ray, Scanning, Ultra sound etc. Scheduling of Radiology resources is poss