Case Questions

1. Case Questions • Mountain View Community Hospital • P.33-35

2. Q1. Mission: High-quality, cost-effective health care services • Tracking operating costs, • Providing an electronic medical record for each patient, • Developing historical records of various treatment programs, • Tracking important measures, e.g., average length of patient stay, cost per day for a patient, and so on.

3. Q2: To Comply with HIPAA standards

4. Q3: Costs and Risks of Using Database • New, specialized personnel. • Installation and management cost and complexity. • Conversion costs. • Need for explicit backup and recovery. • Organizational conflict.

5. Q4: How critical are data quality requirements at the hospital? • Patient care administration • Clinical services • Financial management and admin. services

6. Q5: Examples of Unstructured Data at Hospital • Medical scans (MRI, X-ray, etc.) • Clinical test data (blood test, etc.) • Documents (admission forms, physician referrals, etc.) • Unstructured text (doctors’ orders, doctors’ notes, etc.) • Test results (electrocardiograms, ultrasound, etc.)

7. Q6: Linkage between Patient and Patient Charge table

8. Q7: Example of different types of databases • Personal databases • that reside on PDAs for physician. • Workgroup databases • contain information specific to one ward, by one group of researchers. • Departmental databases • store records that are only pertinent to that department • radiology might store all images from a patient x-ray or MRI,. • An enterprise database • store all information about a patient, such as the medical record, billing, etc.

9. Q8: Web-based Applications at the Hospital? • Intranet for access to databases by internal hospital personnel. • Extranet application to do third-party billing directly with insurance companies. • Benefit: streamlining such processes as third-party billing. • One major risk: Security.

10. Project assignment 1: • PRESCRIPTION . • INSURANCE_CARRIER • ITEM • LABORATORY

11. Project assignment 2: • Treatment View • Physician View • Laboratory View • Pharmacy View • Nurse_Supervisor View • Care Center View • Lab Supervisor View

12. Project assignment 3: Your Turn • Exercise Due next Wednesday • Also, identify the entities needed for each view from project assignment 2.