Joho Village Digital Service Portal
System Overview & Objective
The Pelayanan Desa Joho system is a grassroots-level public administration digitalization platform. This system solves manual bureaucratic bottlenecks by transitioning the process of requesting cover letters, managing population data, and other village services into an asynchronous electronic workflow. The primary objective is to engineer a highly stable, accessible core system (accounting for varying levels of digital literacy among citizens) while measurably reducing the administrative load on village officials.
Core Logic & Architecture
Citizen Data Relational Mapping: The system's core logic heavily relies on relational database integrity. Citizen data (based on National ID/NIK and Family Card numbers) is encapsulated as Primary Keys mapped directly to their document request history. This schema enforces strict data normalization, preventing duplication and accelerating query execution during cross-verification by village staff.
Document Workflow Automation: The letter request pipeline is designed using a finite state machine model (Draft → Submitted → Verified → Ready for Pickup). The system automates the population of official document templates using data extracted directly from the database, eliminating human error-prone manual data entry.
Lightweight Role-Based Access Control (RBAC): The architecture strictly separates the citizen portal (for submitting requests) and the official dashboard (for processing approvals). This isolation is enforced at the routing and controller levels to guarantee that citizens cannot access or manipulate the state of other users' documents.