EMERGENCY ROOM PATIENT TRACKING SYSTEM AN ORACLE WEB APPLICATION

1
EMERGENCY ROOM PATIENT TRACKING SYSTEM AN ORACLE
WEB APPLICATION

• August 12, 2004
• MINGYIN YANG

2
INTRODUCTION

• Objective
• To develop a web application using the latest
  application development engine of Oracle Oracle
  HTML DB for emergency department in order to help
  reduce patient waiting time, share patient
  information efficiently and improve
  communications within emergency department
• Problem Motivation
• My sons experiences in the emergency room

3
SOFTWARE / TECHNOLOGY

• Three Tier Web Application Architecture
• RDBMS Oracle9i R2 Database Server
• App Development Engine Oracle HTML DB
• Web Server Oracle HTTP Server 10g
• Database OS MS Windows 2003 Server E.
• Web Server OS MS Windows XP Pro.
• Programming Languages SQL, PL/SQL, JavaScript
  and HTML

4
THREE TIER WEB APPLICATION ARCHITECTURE

• Presentation Tier Web browser
• Application Tier Oracle HTTP Server HTML DB
  Application Executive
• Data Tier Tables DB Triggers Procedures
  Functions Indexes Sequences

5
INTRODUCTION TO ORACLE HTML DB

• The latest web application development technology
• Used to build database driven centric web
  applications
• Shares data between departments
• Supports hosted development and deployment
  environment.
• Supported with Oracle9i R2 (9.2.0.3) and 10g
• Connects to database using Net8 (connection diver)

6
PROJECT DESIGN IMPLEMENTATION

• Plan web application architecture
• Installation and configuration
• Web Application design
• Data base Design
• Coding and testing
• Future enhancement

7
DATDBASE DESIGN

• Create schema in database
• Create workspace (container) in HTML DB
• Administer HTML DB
• Data normalization
• Create tables
• PATIENT, PRE_CHECK, TREATMENT, TEST, X_RAY,
  USERS and BED

8
DATDBASE DESIGN (cont.)
9
APPLICATION DESIGN

• ERPTS application is divided into seven
  modules during application design process. Seven
  modules are named by office name combining
  position duty
• Front Desk Registration, Triage Room
  Pre-check, ER Treatment, Lab Test, X-Ray
  Examination, Patient Release, Administrator

10
APPLICATION DESIGN (cont.)
11
APPLICATION DESIGN (cont.)

• Front Desk Registration Tasks
• To register patients
• To edit or update patient registration info
• To view and search patient info
• Triage Pre-check Tasks
• To insert (record) patient pre-check information
• To edit or update patient pre-check information
• To view and search patient pre-check information

12
APPLICATION DESIGN (cont.)

• ER Treatment Tracking Tasks
• To transfer a patient to emergency room
• To record patient diagnosis treatment
  information
• To edit or update patient diagnosis treatment
  information
• To view patient diagnosis and treatment
  information
• To order a lab test for a patient
• To order a X-Ray examination for a patient
• To view patient lab test and X-Ray examination
  results

13
APPLICATION DESIGN (cont.)

• Lab Test Tasks
• To submit lab test result
• To edit or update lab test result
• To view lab test result
• To track test status for a specific patient
• X-Ray Examination Tasks
• To submit X-Ray result
• To edit or update X-Ray result
• To view X-Ray result
• To track test status for a specific patient

14
APPLICATION DESIGN (cont.)

• Patient Release Tasks
• To Release patients
• To bring a released patient back released by
  accident
• Administrator Tasks
• To add a user
• To activate or inactivate a user
• To update a user

15
IMPLEMENTATION HIGHLIGHT

• Database Triggers
• Stored Procedures Functions
• Sequences Indexes
• Forms and Reports

16
PROJECT DEMO

• ERPTS Homepage URL
• http//math.indstate.edu/yang

17
CONCLUSION

• Oracle HTML DB is the latest technology. No books
  can be referred. Even the oracle online
  documentation is not fully documented.
• Store and obtain patient information quickly
• Reduce patient waiting time
• Improve communication within ED by sharing
  patient information through ERPTS easily
• Easy to use

18
(No Transcript)