TVI-CAMS — TESDA compliance & attendance manager
A multi-tenant compliance and document tracker for TVIs running TESDA scholarship programmes. Each school’s batches move through the internal lifecycle — AOU, NTP, TIP, Training, Assessment, Billing — while a per-programme document checklist holds every required file at missing, pending, submitted or verified. Clerk handles sign-in for Admin, Coordinator, Trainer and Viewer roles, and Supabase row-level security scopes every query to the signed-in school. Billing documents generate only when the compound gate passes: training progress at or above 80% and every required document verified. It stays an internal working layer by design — official records remain in TESDA’s own SIS, T2MIS and BSRS.
Billing gated on verified documents rather than on a calendar date.
- Next.js 16
- Clerk
- Supabase RLS
- Drizzle ORM
- PostgreSQL