When the Wrong Substation Gets Prioritized
Maintenance scheduling by priority is only as reliable as the data feeding it. A distribution substation flagged PRIORITAS: Normal that has been offline intermittently for three months — but has no reliable update record because the field team's last visit produced handwritten notes that never made it to the asset register — will sit at the bottom of the work queue while a newer installation with clean digital records gets resources first. The consequence is a distribution fault that was predictable, logged in anecdote, and invisible to anyone making scheduling decisions from the database.
The failure isn't in the substation hardware. It's in the record integrity.
The Asset Profile That Supports the Full Maintenance Cycle
ASSETNUM and CLASSIFICATION are the primary identifiers that link this record to everything else in the utility's asset management ecosystem: SCADA tags, maintenance work orders, inspection schedules, regulatory filings. A gardu that has a documented ASSETNUM is a gardu that can be found in every system simultaneously. One without it — or with a transcription variant — creates a split identity that disconnects its field history from its maintenance record.
INSTALLDATE sits as a text field to accommodate the range of source formats arriving from commissioning documents, contractor handovers, and historical records. However it's entered, that date determines the unit's expected service life, its warranty status, and its depreciation schedule. A substation that was commissioned 22 years ago is approaching end-of-life assessment territory; one commissioned last year is in its early monitoring phase. Without the install date, age-based risk profiling is impossible.
MANUFACTURER and VENDOR1 together track original equipment supply and the current maintenance contractor. These are not the same relationship. The manufacturer determines technical documentation, spare parts sourcing, and recall exposure. VENDOR1 determines who owns the next maintenance window, who holds the SLA, and who gets called at 03:00 when a fault occurs on this feeder. Conflating them, or failing to update VENDOR1 when the maintenance contract changes, creates a critical dispatch error: the wrong crew gets the callout.
PRIORITAS is the scheduling lever. High-priority installations get shorter inspection intervals and faster fault response. The field that populates it needs to be current — updated when a unit's condition assessment changes, not set at commissioning and left static. A gardu that accumulated fault history over the last two years but still carries its initial Normal priority rating is a risk management failure in the database, not just in the field.
The Quad-View Photo Standard
Front, internal, transformer, and full-view photographs — four images per substation — is the audit baseline that makes condition change visible over time. The photo taken during today's inspection is compared against the photo from the previous inspection. Hot spots, corrosion progression, unauthorized cable additions, flood damage, vegetation encroachment into the exclusion zone: these are discovered in photographs before they're discovered in failure events, but only if the photographs exist and are tied to the correct asset record.
TGLGAMBAR (photo date) and USERGAMBAR (photographer/officer) create the accountability chain. An undated photograph from an unknown officer has no evidentiary value. A photograph timestamped to a specific inspection date with an officer name attached is part of the asset's documented condition history.
TGLUPDATE and USERUPDATE track the last record modification — not the last site visit, but the last time someone changed the database entry. If the last update was 14 months ago, the current condition assessment in the record is 14 months stale, and decisions being made from it carry that age as a hidden risk factor.
Online/offline connectivity status and the geospatial LOCATION field close the situational awareness loop. A dispatcher managing a widespread outage event needs to know which substations are online, where they are on the network map, and what their service type is — all from a single record query, without calling the field team for basic locational data.