Managing a regional power grid is fundamentally an exercise in knowing exactly where your failure points are. When a medium voltage (MV) line trips, dispatchers cannot afford to guess what type of switchgear is mounted on a specific utility pole ten miles away. If a field technician arrives equipped to repair an "LBS AIR" switch but the pole actually houses an "LBS SF6 REMOTE" unit, the resulting delay can cost thousands in downtime penalties. This Memento system acts as a rigid, geolocated ledger, forcing utility operators to map the exact technical specifications of every node in their network.
The Geospatial Grid
The core of utility management is physical location, but standard addresses are useless in rural or unmapped industrial zones. This database relies on absolute geospatial anchoring.
It forces the technician to log the "Switch Location" using precise GPS coordinates, paired with the regional "Zone Number" and the specific operational "Depot Name" (e.g., Ratmalana, Panadura). This creates a flawless digital map of the grid. To eliminate human data-entry errors when scanning hardware in the field, the system utilizes a "QR code" scanner. The technician simply scans the physical tag on the pole, instantly linking the physical hardware to its digital "SIN NUMBER" and the exact "Data captured on" timestamp.
Technical Hardware Classification
A switch is not just a switch; the mechanics dictate the operational hazard. The template forces a strict categorization of the hardware's internal logic.
Before a unit is logged, the technician must declare the "Voltage Level" (11kV or 33kV). They are then forced to select the precise "Switch Type" from a hard-coded radio list: "DDLO", "ABS", "LBS AIR", "LBS SF6 HANDLE", or "LBS SF6 REMOTE". This isn't just administrative data; it dictates the safety protocols required to service the unit. By locking this down alongside the "Switch Manufacturer" and the "Control Box Manufacturer", the central office has a complete bill of materials for every pole in the grid.
The Accountability Loop
High-voltage infrastructure requires an unbroken chain of custody. If a switch fails due to poor maintenance, the utility needs to know exactly who signed off on its condition.
The database enforces this by requiring the "Employee PF number", ensuring that every data point is tied to a specific technician. It closes the loop with dedicated "Images" and "Attachments" fields. Instead of trusting a written description of corrosion on a control box, the system demands photographic proof and allows for the attachment of PDF schematics or safety permits directly to the node's profile.