- Before
- Checks values retyped from field notes, with no way to see the plate or show where a number came from.
- Now
- Works a queue sorted by decision, sees the plate beside each value with its region and confidence, picks dual ratings, resolves duplicates, approves each record by name and builds the loader file.
Asset data collection for one pump motor, from photo to loader file
A water utility, seven weeks after go-live. A utility technician walks a booster pump station with a managed iPad, and a Master Data reviewer has eight open records in the queue. Here is what happens to one pump motor, screen by screen, in the working solution.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 01In the station, no signal
Glare is caught before the photo is kept
Utility technicianThe technician scans the asset tag and photographs the 75 HP motor. The capture coach flags glare on the first photo, so the technician takes a second angle and an overall shot. There is no signal in the station, so the photos wait on the iPad and upload once it returns. On the next pump motor, the same check asks for a tilt of about 10° or shade over the plate.
Safety first: no one opens a guard or climbs for a photo.
- 02From a desk
A whole walk-down uploaded at once
Maintenance plannerThe planner drops 22 photos from a raw water pump station. The agents fingerprint each photo, group them into 7 assets by tag and time, flag glare on one photo and low light on another, and skip one photo as identical to an earlier upload. Nobody sorts photos by hand.
1 photo skipped as identical to an earlier upload
- 03Once the photos land
Each value with its confidence and its region
Plate readerThe plate reader reads 3 identity values and 10 characteristic pairs, plus 6 more plate values that are kept but not exported. The serial reads at 98%. When the reviewer clicks the serial number, the exact region of the photo it was read from is outlined and zoomed. Approve stays locked: 3 items to resolve.
Click any value to see the part of the plate it was read from.
- 04Photo 2
Service factor, read from the second photo
Master Data reviewerThe service factor sits under glare from the work light in photo 1, where it read at 62%. Photo 2, taken at a second angle, reads 1.15 at 93%. Both readings are kept, and the reviewer confirms 1.15 against photo 2.
Both readings are kept; the reviewer confirms the value against the photo it came from.
- 05One pick
Two voltages on the plate, and no guess
Master Data reviewerThe plate lists 230/460 volts and the EAM characteristic takes one value, so the normalizer leaves it blank under the dual-rating rule. The reviewer picks 460 V, the voltage the motor is connected for, and full-load current follows that choice from 172/86.0 to 86.0 A under the next rule in the set. Both values carry the reviewer's initials as human-verified.
A dual rating is not averaged or guessed: the reviewer picks one.
- 06Already in the register
The pump drive is caught before it is loaded twice
Duplicate checkerThe motor's serial has no match in the latest monthly register extract. The pump's drive does: its serial is already EAM equipment, with the same horsepower, voltage, current, phase and enclosure. The submission and the existing equipment sit side by side, and the reviewer marks it as the existing asset, so it is not exported and its photo is kept as evidence.
The duplicate checker does not merge or reject; a reviewer decides.
- 07A worn plate
Rusted characters stay blank
Plate readerOn an aeration blower at the water reclamation facility, four characters of the serial are rusted through. Brake horsepower is washed out by glare from the skylight. Both are left blank and flagged, the duplicate check falls back to model and tag, and the reviewer requests a recapture, which lands on the planner's capture list with the guidance.
Four characters are rusted through: left blank and flagged, with none guessed.
- 08Approved
Approved by name, version 1
Master Data reviewerThe approval shows exactly what the reviewer signs: 3 identity values, 10 characteristic pairs, 3 values the reviewer verified and 19 customer-owned columns left blank. The reviewer's name, the time and version 1 are recorded. Any later change to the record needs a new approval.
A reviewer approves each record; confidence does not replace sign-off.
- 09Before the file is built
The exact layout of the asset loader template
Loader builderThe preview shows all 62 columns, A to BJ, of the SAP-style example template: manufacturer, model and serial in N, O and P, ten characteristic pairs in AB to AU, and the customer-owned columns blank. Each cell opens to its source, rule and approver. Column P for one transformer holds its serial, read from photo 1, within 18 characters, with the reviewer's name and the time of approval.
Empty characteristic slots stay empty, not filled to reach ten pairs.
- 10The file goes out
Eight records, nine checks, zero errors
Reviewer and EAM data ownerOnly approved records go in. Nine validation checks pass, from 62 columns in template order to codes from the Characteristics sheet and nothing already in the EAM. The Excel file is written with its validation report: 8 records, 0 errors. The EAM data owner loads it into the EAM and records 8 accepted and 0 rejected, so the load reconciles.
The EAM data owner loads the file without reworking a column.