Pamsimas Attendance & Monitoring System
A geofenced, offline-first attendance and field-monitoring system for Pamsimas community facilitators, with EVM/SPI performance analytics for admins and regional coordinators.
Built for the government Pamsimas program (community-based drinking water) under the Ministry of Public Works, this system replaces manual, unverifiable attendance with geofenced photo check-ins and gives program managers a live picture of work in the field. It pairs an installable field app, delivered as both a PWA and an Android APK, with a web dashboard for admins and regional coordinators.
In the field, community facilitators (FM) and assistant coordinators (AAK) record photo attendance watermarked on-device with GMT+7 time and GPS coordinates, log daily timesheets, request leave, and trigger an SOS button, all fully offline. Everything is stored on the device and syncs automatically, without duplicates, the moment a signal returns.
On the dashboard, admins and regional coordinators see a live map of every facilitator’s last-known position, planned-versus-actual S-Curves, and a Schedule Performance Index recomputed on each new record, alongside approvals, sanctions, and Excel and PDF exports, all under fine-grained role-based access with a complete audit trail. Engineered with React, TypeScript, Express, Prisma and PostgreSQL, with Leaflet maps and an offline-first PWA core.
Key Features
Geofenced photo attendance
Check-ins carry GMT+7 time, GPS coordinates and accuracy, with the photo watermarked on-device before it ever leaves the phone.
Offline-first by design
Attendance, timesheets, leave and SOS all work with no signal and sync automatically once connectivity returns.
Duplicate-proof sync
Every sync endpoint is idempotent, so retries over a flaky network can never create double records.
SOS emergency channel
A panic button takes a separate priority path and surfaces as a blinking marker on the coordinator map.
Timesheets locked by leave
Daily timesheets are enforced against approved leave on the server, keeping field records consistent.
Live map & tracking
See each facilitator last-known position, chosen intelligently between tracking pings and attendance.
EVM / SPI performance engine
Planned Value, Earned Value and Schedule Performance Index recomputed on every new record, with planned-vs-actual S-Curves.
Approvals, sanctions & exports
Leave approval, points and sanctions, plus one-click Excel and PDF reports for attendance, timesheets and SPI.
Role-based access & tunable rules
Roles with a per-role permission matrix and scopes; SPI thresholds, timesheet cut-off and geofence radius are adjustable without a redeploy.
