Back to work

ER Triage & Queue Manager

A workflow prototype for emergency-room queue visibility, patient-state tracking, and triage prioritization using structured forms, local data persistence, and dashboard views.

Role
System design, Python implementation, data model, workflow logic
Type
Workflow system
Status
Prototype
Year
2025
ER queue dashboard showing patients ranked by ESI acuity level
Live queue dashboard: patients ranked by ESI v4 acuity, color-coded, with room and status.

What this project solves

Emergency room workflows depend on clear shared visibility. Intake, vitals, priority, room assignment, and treatment progression can become fragmented if they are not represented in one system.

How I built it

The prototype centralizes patient intake, vitals entry, priority scoring, queue monitoring, patient insight pages, and status history.

System structure

  1. 01NiceGUI UI organizes the app around intake, nurse triage, queue monitoring, and admin views.
  2. 02SQLite persists patient records, vitals, priority, room assignment, and status history.
  3. 03Priority logic connects symptoms and vitals to a queue position.
  4. 04Dashboard views present patient state in a way that can be used during a live demo.

Stack: Python · NiceGUI · SQLite · Testing · Workflow Modeling

Tradeoffs I made

Workflow model before interface

Tradeoff

A hospital queue screen can look useful even if it does not reflect patient states, priority changes, or staff handoff.

Outcome

Modeled queue visibility, triage priority, patient status, and dashboard state before treating the UI as the final artifact.

Local persistence for prototype speed

Tradeoff

A cloud backend would be more realistic, but it would slow early iteration for a workflow prototype.

Outcome

Used local data persistence so the prototype could demonstrate patient state changes, queue behavior, and dashboard updates quickly.

Explainable priority over black-box scoring

Tradeoff

Automated priority scoring can become unsafe or untrusted if users cannot understand why a patient moved in the queue.

Outcome

Kept triage logic structured so future versions can show the reason behind priority changes and attention flags.

What it looks like

What came out of it

  • 01Turns a high-pressure operational process into a working prototype: structured intake, triage scoring, a live queue dashboard, and traceable patient state persisted in SQLite.
  • 02Python application structure
  • 03SQLite database model
  • 04Patient state and status history
  • 05Queue dashboard and role-based workflow screens

Next iteration

  • 01Add screen captures of each core workflow.
  • 02Document the scoring algorithm clearly.
  • 03Create a short demo video for the case study.

Open to internships, junior technical roles, and project collaborations.

jpss2004@icloud.com