Mandatory Training Assignment & Completion Tracker

The problem this kills

Mandatory training is the kind of work that is invisible until it is on fire. Harassment-prevention, safety, security-awareness, and compliance courses have hard deadlines tied to law, insurance, or a customer contract - and the moment one person misses one, your "100% complete" number is a fiction you cannot defend in an audit.

So you keep a spreadsheet. It starts clean. Then you hire three people, two move locations, an annual course comes due again, someone emails you a certificate PDF that lives in your inbox forever, and three managers ask "wait, who still owes me what?" You spend the last week of every quarter color-coding cells and sending the same nagging email twenty-five times. The spreadsheet cannot compute a due date from a hire date, cannot tell you a 2024 certificate has expired, cannot prove who approved an assignment, and cannot stop you from assigning the same course to the same person twice.

This tool replaces that spreadsheet with a real system that does the counting, the date math, the chasing, and the proving - so the only thing left for you is the judgment calls.

What you'll build

A private, login-protected web app for HR and compliance that:

• Holds your course catalog with recurrence rules (one-time, annual, every two years) and grace periods for new hires.
• Lets you define assignment rules - "all warehouse staff get Forklift Safety," "everyone in CA gets Harassment Prevention within 6 months of hire" - and generates the right assignments automatically.
• Computes a due date for every assignment from the hire date or assignment date, and re-issues recurring courses when the period rolls over.
• Routes the generated assignments through an HR approval gate before anyone is notified - the tool drafts, you approve.
• Notifies, reminds, and escalates automatically over email as deadlines approach and pass.
• Collects completion evidence - a self-report attestation or an uploaded certificate file - and lets HR verify it before anyone is marked compliant.
• Flags expired and overdue training and escalates the stragglers with your approval.
• Exports a clean, audit-ready compliance CSV in exactly the columns your records or HRIS expect.

What's inside the Implementation Plan

The plan is a complete, paste-and-go runbook. Crucially, it opens by interviewing you about your business - your courses, your assignment rules, the real names and codes in your roster, your peak hiring months, your grace periods, and your messiest exceptions - and then tailors the data model, the due-date math, and every later build step to your answers. You are not getting a generic template; you are getting a tool shaped to how your organization actually runs training.

Inside you'll find:

• The discovery interview (8-12 targeted questions) and how the agent turns your answers into a spec you sign off on.
• The exact data model for employees, courses, rules, assignments, and evidence - including the duplicate-guard key so the same course/period can't be assigned twice.
• Step-by-step build prompts you copy into your AI agent, each one ready to paste.
• The due-date and recurrence engine, the approval gate, the reminder/escalation schedule, and the certificate-verification flow.
• A "No API yet?" fallback that imports your roster and past completions from a Google Sheet or CSV and exports a compliance CSV - so it is fully buildable today, even with zero integration to your HRIS.

The governance it includes (this is the point)

This is not a toy. The plan builds in the controls a compliance tool must have:

• Login so only your team can open it.
• Row-level security so a user only ever sees data for their own organization.
• A complete audit trail - who assigned what, who approved it, who verified each certificate, and exactly when.
• A hard human-in-the-loop approval gate: the AI drafts assignments and flags completions, but nothing is marked compliant or escalated until a person reviews and approves it.
• Duplicate guards so one employee can't be assigned the same course for the same period twice, and a re-uploaded certificate can't double-count.

Who it's for

HR and compliance professionals who are personally on the hook for getting required courses done before the deadline - and who are tracking it all in a spreadsheet today. If you have ever had to certify "everyone completed harassment training" and felt your stomach drop because you weren't fully sure, this is for you. No coding background needed.

You've got this - paste the first prompt and let the interview tailor the rest.