Mi-TRAC Next Phase - Project Overview
Executive Summary
Project: Extend Mi-TRAC to support multiple departments, role-based access control, resident self-service, and ILP generation.
Current State: Mi-TRAC supports Emergency Medicine only, with program director access via hardcoded email whitelist. Data comes from MedHub API.
Target State: Multi-department platform (OB-GYN, EM, future: IM/Med-Peds) with proper RBAC, resident self-service dashboards, and automated ILP document generation.
Project Phases
| Phase | Name | Duration | Key Deliverable |
|---|---|---|---|
| 1 | OB-GYN Data Foundation | ~1.5 weeks | OB-GYN data imported, admin can verify |
| 2 | Multi-Dept + RBAC + Resident Access | ~3.5 weeks | PDs and residents can login with proper access |
| 3 | ILP Generator | ~2 weeks | Residents can download pre-populated ILP Word doc |
Total Estimated Duration: 7 weeks (full-time development)
Timeline Overview
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7
├────────────┼────────────┼────────────┼────────────┼────────────┼────────────┼────────────┤
│▓▓▓▓▓▓▓▓▓▓▓▓│▓▓▓▓▓▓▓│ │ │ │ │ │ │
│ PHASE 1: Data Import │ │ │ │ │ │
│ │ ▼ │ │ │ │ │ │
│ │ Demo 1 │ │ │ │ │ │
│ │ │░░░░│░░░░░░░░░░░░│░░░░░░░░░░░░│░░░░░░░░░░░░│ │ │
│ │ │ PHASE 2: RBAC + Multi-Dept │ │ │
│ │ │ │ │ │ ▼ │ │
│ │ │ │ │ │ Demo 2 │ │
│ │ │ │ │ │ │████████│████████████│
│ │ │ │ │ │ │ PHASE 3: ILP │
│ │ │ │ │ │ │ │ ▼ │
│ │ │ │ │ │ │ │ Demo 3 │
└────────────┴────────────┴────────────┴────────────┴────────────┴────────────┴────────────┘Key Milestones & Demos
| Milestone | Target | What Can Be Demonstrated |
|---|---|---|
| Demo 1 | Week 2 Day 3 | Admin uploads OB-GYN Excel, data appears in database, basic verification view |
| Demo 2 | End of Week 5 | PD logs in and sees OB-GYN dashboard with Milestones/Procedures toggle; Resident logs in and sees only their own data |
| Demo 3 | End of Week 7 | Resident views trajectory charts, comment summaries, downloads pre-populated ILP Word doc |
Scope by Phase
Phase 1: OB-GYN Data Foundation (~1.5 weeks)
- Unified database schema (supports competencies, milestones, procedures)
- Excel import pipeline for OB-GYN data (Milestones + Procedures)
- Admin verification endpoints
Phase 2: Multi-Dept + RBAC + Resident Access (~3.5 weeks)
- Users table and learner-to-email mappings
- CSV upload for learner mappings
- Role-based access control (super_admin, dept_admin, program_director, resident)
- Auth middleware refactor (database lookup vs hardcoded list)
- Dynamic UI for different form types
- Form type selector (Milestones vs Procedures dropdown)
- Resident personal dashboard (view own data only)
- EM data migration to unified schema
Phase 3: ILP Generator (~2 weeks)
- Competency/milestone trajectory visualization
- AI comment summaries adapted for OB-GYN
- ILP template with reflection prompts (PGY-level appropriate)
- Word document generation with pre-populated data
- One-click ILP download for residents
Dependencies & Critical Path
Phase 1 (Data Foundation)
│
▼
Phase 2.0 (Users + Mappings) ─────┐
│ │
▼ ▼
Phase 2.1-2.2 (RBAC) Phase 2.3 (Dynamic UI)
│ │
▼ │
Phase 2.4 (Resident Dashboard) ◄──┘
│
▼
Phase 3 (ILP Generator)Critical Path: Schema → Import → Users/Mappings → RBAC → Resident Dashboard → ILP Generator
Resource Requirements
- Development: 1 full-time developer for 7 weeks
- Research Team Input: Reflection prompts for ILP (needed by Phase 3)
- OB-GYN Team Input: Learner-to-email mapping CSV, validation of imported data
- Stakeholder Reviews: Demo at end of each phase
Risk & Mitigation
| Risk | Impact | Mitigation |
|---|---|---|
| OB-GYN data format changes | Medium | Build flexible parser, document assumptions |
| AI comment system adaptation takes longer | Medium | Can launch Phase 3 without AI summaries, add later |
| EM migration breaks existing functionality | High | Keep old tables, run parallel until verified |
| Reflection prompts not ready | Low | Use placeholder prompts, update when ready |
| Learner mapping CSV delayed | Medium | Can demo Phase 2 RBAC with test data |
Out of Scope (Future Work)
- IM/Med-Peds department support (TBD data source)
- Configurable cohort comparison for residents
- TRUE SCORE calculation for dynamic forms
- ILP versioning/history
Dedicated admin UI section(done —/admin/obgyn)- Additional OB-GYN forms beyond Milestones + Procedures (Phase 2 stretch goal)
- Individual learner mapping editor UI
Documents
Approval & Sign-off
| Role | Name | Date | Signature |
|---|---|---|---|
| Project Sponsor | |||
| Technical Lead | |||
| Product Manager | |||
| OB-GYN Stakeholder |