# Statement of Requirements (SoR)
## Kampong Speu Provincial Demographic Management System (KSP-DMS)

**Document Identifier:** KSP-DMS-DOC-SOR-01  
**Project:** Kampong Speu Provincial Demographic Management System  
**Version:** 1.0 (Draft Proposal)  
**Date:** November 2026  

---

## 1. Purpose of this Document
This Statement of Requirements (SoR) articulates the high-level business, functional, and governance demands established by the Kampong Speu Provincial Administration for procuring, designing, engineering, and verifying the KSP-DMS software platform.

---

## 2. General Administrative Requirements

1. **Hierarchy Compliance:** The system must strictly model the administrative levels of the Kingdom of Cambodia:
   - Level 1: Province (ខេត្ត) - Kampong Speu
   - Level 2: District / Municipality (ស្រុក / ក្រុង) - 8 operational divisions
   - Level 3: Commune / Sangkat (ឃុំ / សង្កាត់)
   - Level 4: Village (ភូមិ)
2. **Sovereignty & Localization:**
   - 100% of data must be hosted on local provincial servers with zero unapproved transmission to overseas third-party cloud infrastructure.
   - All user interfaces, forms, validation messages, and reports must support both official Khmer (ភាសាខ្មែរ) and English interchangeably.
3. **Multi-Tiered Workflow Control:**
   - No direct updates to active population registers are permitted by field enumerators.
   - All household modifications and vital events must progress through formal submission batches (`draft` -> `submitted` -> `reviewed` -> `approved`).

---

## 3. Operational Requirements Matrix

| Req ID | Requirement Statement | Priority | Administrative Beneficiary |
| :--- | :--- | :--- | :--- |
| **SOR-GEN-01** | The platform must provide bilingual localization (Khmer/English) switchable in one click. | Critical | All Administrative Users |
| **SOR-GEN-02** | Access control must restrict data visibility based on the user's assigned administrative jurisdiction. | Critical | Provincial Governance |
| **SOR-HH-01** | Support digital household registration with unique national/provincial code identifiers. | High | Village & Commune Administrators |
| **SOR-HH-02** | Maintain strict one-to-many relationship between a Household and its resident Persons. | High | Statistics Planning |
| **SOR-EVT-01** | Provide structured event recording for Births, Deaths, In-Migration, and Out-Migration. | Critical | Civil & Demographic Registry |
| **SOR-WF-01** | Provide a four-eye approval workflow for demographic changes before baseline commit. | Critical | Commune & District Reviewers |
| **SOR-GIS-01** | Display aggregated spatial demographic heatmaps at the commune and district levels. | Medium | Provincial Leadership |
| **SOR-API-01** | Provide secured REST API v1 for future Flutter mobile offline data synchronization. | High | Field Data Collectors |
| **SOR-SEC-01** | Complete immutable audit trail recording every write, update, and delete action. | Critical | Legal & Compliance Officers |
| **SOR-ENV-01** | Operate reliably on Windows 11 / XAMPP (Apache, PHP 8.2, MariaDB 10.4). | Critical | Provincial IT Department |

---

## 4. Verification and Acceptance Criteria
Every requirement in this SoR must be proven through automated testing, demonstrable user flows, or formal inspection logs before the system is certified as acceptance-complete.
