Injury & First-aid Case Tracker

The problem this kills

The incident gets reported, the form gets filed, and then the case goes quiet. The follow-up appointment slips. Nobody notices the light-duty restriction expired three weeks ago. The "days away / days restricted" count that you'll need for your OSHA log is reconstructed from memory at year-end. And the medical details that should only be seen by occupational-health staff are sitting in a shared spreadsheet that half the company can open.

Open injury cases don't fail because people don't care. They fail because there's no single place that nags you about what's due, keeps the medical detail locked down, and won't let a case quietly disappear until someone with authority actually closes it.

What you'll build

A small, private web app — just for your team — that manages each injury and first-aid case from "reported" all the way to "closed":

• Log or import cases (employee/job, injury type, date, work restrictions, treating provider) from a spreadsheet or CSV.
• Track follow-ups over time — appointment dates, provider notes, restriction changes, return-to-work milestones.
• Auto-count days away and days restricted so your downstream OSHA recordkeeping has clean numbers, not guesses.
• Get email reminders before upcoming appointments and before restrictions hit their review/expiry date.
• Approve before closing — the case owner reviews status changes and signs off on closure (with required closure notes) before the case is finalized.
• Export a case-log CSV in the exact column names your existing process expects.

What's inside the Implementation Plan

A complete, paste-and-go runbook for an AI coding agent (Claude Code). You don't write code — you paste, answer questions, and approve.

The plan opens by interviewing you about your business — your current case-tracking process, the systems and spreadsheets you use, the exact fields and naming you use for cases, your typical and peak case volumes, and your real approval rules and messy edge cases (recordable vs. first-aid only, restriction extensions, transfers, cases that reopen). It reflects a short tailored spec back to you and waits for your thumbs-up, so the tool fits your safety program — not a generic template.

Then it walks the agent, step by step, through building the database, the screens, the reminders, the approval gate, and the export — each step ending in a ready-to-copy prompt.

The governance it includes (this is the point)

This isn't a toy spreadsheet replacement — it's built like a real internal system from the first prompt:

• Login so only your team can open it.
• Row-level security so people only ever see their own organization's cases — and medical detail is restricted to the occupational-health role, not everyone with an account.
• A full audit trail — who changed what, and when, on every case.
• A human-in-the-loop approval gate — the AI and the workflow draft status changes and closures; the case owner reviews and approves, and only then are counts finalized and the case marked closed.
• Duplicate guards keyed on case-id so the same case can't be imported or logged twice.

Who it's for

EHS coordinators, occupational-health staff, and HR safety partners who manage open injury and first-aid cases and are tired of chasing follow-ups by memory and email. If you can use a spreadsheet, you can build this.

You've got this — paste the first prompt and let the plan interview you.