A Web-Based Database for Nurse Led Outreach Teams (NLOT) in Toronto

Area of Science:

• Health Informatics
• Database Management Systems
• Mobile Health (mHealth)

Background:

• Healthcare systems are increasingly digitizing patient records for secure data exchange.
• Nurse Led Outreach Teams (NLOT) in Ontario provide mobile emergency nursing, aiming to reduce hospital transfers from long-term care.
• The current NLOT data management relies on a Microsoft Access database, which has significant limitations in scalability, portability, and interoperability.

Purpose of the Study:

• To develop a web-based database system for Nurse Led Outreach Teams (NLOT).
• To create a solution using Oracle Application Express (APEX) for improved data accessibility.
• To enable real-time data entry and retrieval for NLOT nurses via mobile devices.

Main Methods:

• Development of a web-based database utilizing Oracle Application Express (APEX).
• Focus on creating a user-friendly interface accessible from mobile devices.
• Implementation of features for anytime, anywhere data access and entry for resident information.

Main Results:

• A functional web-based database system was successfully developed.
• The system provides enhanced accessibility and portability of resident health information.
• The new system addresses the scalability and interoperability issues of the previous Access database.

Conclusions:

• The developed web-based database significantly improves data management for NLOT services.
• The Oracle APEX system offers a scalable and mobile-compatible solution for healthcare data.
• Enhanced data accessibility empowers NLOT nurses to provide more efficient and effective mobile care.