Patient Care Online
A New Approach to
Quality Patient Care
Prepared by Hani Bismar
ISAM 5338 Spring 2007 – System Architecture – Prepared by Hani Bismar
Patient Care Online
• System Requirements
– Hardware:
• Power Computers: Web Server and Database Server
• Network: Media, Router and Switch
• Firewall
• High Speed Internet Access
• PCs and Tablet PCs
– Software:
• Web Server: IIS / Apache
• Database Server: SQL Server / MS Access / MySQL / Oracle
• Development Software: ASP.NET, JavaScript, XHTML
• System Requirements on the Patient’s Side
– PC
– Web Browser
ISAM 5338 Spring 2007 – System Architecture – Prepared by Hani Bismar
Patient Care Online
• Architecture Design: Three-Tier Architecture
Patient / Physician
Internet
`
Web Server Database Server
Ethernet
Clients
Clients / Admin (Healthcare Provider Clinic)
`
ISAM 5338 Spring 2007 – System Architecture – Prepared by Hani Bismar
• Web Page Hierarchy
Home Page
Patient Staff Physician
Sign Up Sign-in Sign-in Sign-in
Healthcare Insurance History &
Demographics
Questionnaire Billing Info Present Illness
Prescriptions
Insurance Info Refill Treatment Plan
Prescriptions &
Lab Orders
ISAM 5338 Spring 2007 – System Architecture – Prepared by Hani Bismar
Health-Info Insurance
• Database PK Social Security No PK Social Security No
Demographics Chief Complaint Insured
Carrier 1
Tobacco
Alcohol FK Plan ID 1
PK Social Security No
Drug Allergies Co-Pay 1
Cardio – Chest Pain Deductible 1
First Name
Cardio – Short Breath Carrier 2
Middle Initial
Eyes – Double Vision FK Plan ID 2
FK Last Name
Eyes – Blurred Vision Co-Pay 2
FK Date of Birth
ENT – Sinus Deductible 2
Address 1
ENT – Ear Pain Notes
Address 2
Resp – Cough
City
Resp – Wheezing
State
Mus - Joint Swelling
Zip Code
Mus – Stiffness
HandP
Phone Home
Neuro – Headache PK Social Security No
Phone Work
Neuro – Dizziness
Phone Mobile
Skin – Rash History of Present
Phone Emergency
Skin – Itching Illness
Allergies Assessment
Reaction Treatment Plan
Medications Current Medication 1 Patient Discussion
Dosage 1 Notes
Current Medication 2
PK Social Security No
Dosage 2
Current Medication 3
FK
Drug Type
Commercial Name
Dosage 3 Logins
Anesthesia Problems
Dosage
Heart Disease PK Social Security No
Date Started
Diabetes
Duration
Notes User Type
Warning
FK User ID
Notes
User Password
ISAM 5338 Spring 2007 – System Architecture – Prepared by Hani Bismar
Patient Care Online
• Forms: Physician
Physician: User ID Password
Patient Social Sec #: Date
History & Present Illness:
Assessment:
Treatment Plan:
Patient Discussion:
ISAM 5338 Spring 2007 – System Architecture – Prepared by Hani Bismar
Patient Care Online
• Conclusion
• Questions ???
ISAM 5338 Spring 2007 – System Architecture – Prepared by Hani Bismar