APSACS IEC Outreach - Mobile Reporting & Analytics Platform

Triyog partnered with Andhra Pradesh State AIDS Control Society (APSACS) to build a production-grade backend that digitizes field outreach reporting across districts, mandals, and villages. The solution provides OTP-based mobile authentication, role & facility mapping, and tightly validated geo metadata aligned to LGD codes. Field teams submit activity reports with auto-captured location, attach photos/videos, and log IEC utilization—while administrators access clean, analytics-ready data through purpose-built APIs for dashboards.

Designed for reliability at scale, the platform enforces strict referential integrity (State → District → Sub-district → Village), supports both rural and urban contexts, and stores media in a web-accessible structure for quick previewing. Fine-grained endpoints power operational dashboards: activity trends, geo coverage, user productivity, and facility performance.

Highlights

• OTP-based mobile login (passwordless) + ASP.NET Identity roles

• PostgreSQL with schema-level constraints; LGD master data alignment

• Progress report model covering meetings, folk events, school/college sessions, rallies, camps, hospitals & IEC breakdown

• Rural/Urban handling via village AreaType; mandal validation by LGD codes

• Media uploads (10 images / 3 videos per report), static delivery URLs

• Facility mapping (user ↔ facility), role assignment & audit trails

• Clean, cycle-free JSON responses for dashboards

• Bulk user provisioning via secure admin upload

• Swagger-first developer experience; environment-ready for cloud or on-prem

Impact

• Faster, higher-fidelity field reporting

• Reduced data errors via LGD validation

• Analytics-ready data for district & state dashboards