An Asset Register for Hydroponic Equipment

An Asset Register for Hydroponic Equipment

An asset register template farm teams can maintain is the input a maintenance system needs, and most farms buy the software first. A CMMS fed a thin register produces work orders nobody trusts: half the pumps missing, no nameplate data, intervals copied from a brochure. This article sets out the fields each record needs, how to tag equipment so the tag survives a wet house, how to set A/B/C criticality tiers and intervals, when a spreadsheet stops being enough, and what the register has to answer on audit day.

Start With the Register, Not the Software

Software schedules work against records that already exist. Build the list first on site, one line per physical item, and the import into any system becomes a formatting job instead of a data recovery exercise. A register built from memory in an office always misses the items installed during a retrofit, which is where the first year of failures usually comes from.

One rule prevents most of the pain later: one line per maintainable item, not per system. A dosing unit is one asset; the pump head, the injector and the controller probe are three more, because they fail at different intervals and are held as different spares.

Fields an Asset Register Template Farm Teams Need

A record that cannot support a work order, a spare part lookup and a warranty claim is not finished. The field set below is the minimum that does all three.

Two fields cause the most rework when omitted: nameplate data and commissioned date. Without them, a replacement has to be specified on site under time pressure, and age-based decisions turn into guesswork.

ID Tags That Survive Wet Zones

A wet, fertilised, UV-exposed house destroys paper labels and most adhesive ones within a season. Tag choice is a physical problem before it is a data problem.

• Material: engraved or laser-marked stainless or anodised aluminium for wet zones; laminated printed tags only inside dry control panels.
• Fixing: stainless screws or cable ties rated for UV, never adhesive alone on a tank or pipe that sweats.
• Size: characters legible at arm’s length, typically 6 to 10 mm, since a tag read with a phone camera defeats the purpose.
• Encoding: the human-readable ID plus a QR or barcode, so scanning and reading both work when one fails.
• Placement: on the asset, not on the frame beside it, and on the side a technician reaches first.

Photograph every tag during the build and store the photograph against the record. When a tag is lost, the photograph plus the location field identifies the asset without a shutdown.

Criticality Tiers and Intervals

Criticality is set by consequence, not by cost: what happens to the crop when this item stops. Three tiers are enough, and each carries its own interval, response target and spares policy.

Tier A on a lettuce house normally covers the circulation pumps, the dosing unit and its controller, the climate controller and the vent motors. Everything else falls to B or C, and the split should be reviewed after the first year of real failure data, not argued in a meeting.

Intervals should be written as both a calendar period and a running-hours figure where the item has a counter, whichever comes first. Equipment that runs continuously ages on hours; equipment that runs seasonally ages on calendar time. The maintenance schedule is where those intervals get turned into a calendar, and the difference between long-life and short-life parts sets which items get replaced on age rather than repaired.

From Spreadsheet to CMMS: When It Pays

A spreadsheet handles up to roughly 200 to 300 assets with one or two people maintaining it. Past that, or once more than one person closes work orders, the failure mode is predictable: two copies of the file, intervals updated in one and not the other, and no record of what was actually done.

Move to a CMMS when one of three things is true: the same question about service history is asked more than once a month; downtime has to be reported by asset to justify a capital request; or the farm is preparing for certification and needs an auditable closed-work-order trail. Before migrating, export the register as a flat table with one header row, one asset per line, and no merged cells, since that is the format every system imports.

A row without a physical tag on the asset is not finished.

Tag the asset before the register row is considered complete. A record without a physical tag cannot be verified during a walk-round, and an unverified record drifts: the pump gets swapped, the row keeps the old serial, and the next spare ordered from that row is the wrong one. Tags first, photographs second, spreadsheet third.

Photos, Manuals and Warranty Links in One Place

A register row that points at a folder beats a row that repeats information. Keep one folder per asset ID containing the nameplate photograph, the installation photograph, the manual PDF, and the purchase record with the warranty end date.

Purchase records matter more than they appear to. The order number, supplier, warranty end date and the spares clause from the supply contract are what turn a failed unit into a claim rather than a purchase. A manufacturer shipping hydroponic equipment since 1996 can usually identify a part from a plate photograph alone, which shortens the outage.

Link the register to the stock list on the spares side so a work order names the part number, and to the annual maintenance plan so reordering follows the interval rather than a memory of what ran out. Where sensor data is already logged remotely, the asset ID is the join key that puts a temperature trend next to a service history.

Audit Day: What the Register Answers

An auditor or an insurance assessor asks a short set of questions, and a maintained register answers them from a screen rather than from a walk-round with a clipboard.

• What equipment exists and where: filtered by house and zone.
• When was it last serviced: closed work orders with dates and the person who signed.
• What is overdue: a filtered list, which is the one that gets checked first.
• Who is responsible: in-house or contracted, which maps onto maintenance contract scope.
• What a failure cost: downtime by asset, which supports the capital case for replacement.

Energy questions get answered from the same asset register template farm teams keep for the auditor. Where submetering is installed per zone, pump and lighting assets can be matched to consumption, and a rising trend on one asset becomes evidence for overhaul rather than an opinion.

Frequently Asked Questions

What fields does an asset register need?
A: Asset ID, location, category, make, model, serial, nameplate ratings, commissioning date, criticality tier, service interval, linked spare part and document links.

How many assets justify a CMMS instead of a spreadsheet?
A: Around 200 to 300 assets, or as soon as more than one person closes work orders and service history has to be auditable.

What tag material survives a wet greenhouse?
A: Laser-marked or engraved stainless steel or anodised aluminium fixed with stainless screws or UV-rated ties. Adhesive labels fail within a season.

How should criticality be set?
A: By consequence of failure. Tier A stops production within hours, tier B degrades control over days, tier C can wait for a scheduled visit.

Should intervals be calendar or running hours?
A: Both, whichever comes first. Continuously running equipment ages on hours; seasonal equipment ages on calendar time.

Get the Asset Register Starter Sheet

Build the register on site, tag every item before the row is closed, and set intervals from criticality rather than from a brochure. An asset register template farm crews keep current is worth more than any software licence bought before the list exists. To ask for our asset register starter sheet with criticality presets for hydroponic farms, send the house count and the pump, dosing and controller inventory.

• Hydroponic system maintenance schedule
• Spares inventory and the annual maintenance plan
• Service life of long-life and short-life parts