Skip to main content

Asset Identity for CMMS Integration

CMMS integration depends on stable asset identity. A work order has limited value when the asset reference cannot be matched to the building, floor, room, system, equipment, Inspector object, or digital twin context that operators use.

Use this guide to prepare MDM alignment before exposing CMMS records to operators or AI Agent workflows.

Identity Flow

Prerequisites

RequirementWhy it matters
Source asset inventoryEach CMMS provider must expose asset IDs, names, locations, and parent relationships
Location hierarchyBuildings, floors, rooms, zones, lines, or systems must be represented consistently
Alias strategySource IDs from CMMS, BMS, ERP, Inspector, and model assets need a shared matching plan
Steward ownerAmbiguous matches need review by a customer or project data owner
Retired asset policyHistorical work orders may reference retired, renamed, or replaced equipment
Confidence thresholdAutomated matching must route low-confidence results to review

Source Data Inputs

InputUse
CMMS asset tableSource asset ID, asset name, parent, location, equipment type, status
Work-order asset referenceConnects each work order to an asset, location, system, or functional location
BMS or historian tagsLinks operational signals to the same equipment or system
Inspector recordsLinks inspections, alerts, stations, QR codes, and work orders
Model asset referencesLinks digital twin objects, BIM/CAD model elements, and scene context
Alias tableStores cross-source identifiers for the same asset
Steward decisionsRecords manual match, split, merge, re-point, and rejection decisions

Identity Model

EntityExample use
SiteCampus, factory, plant, building group, or data center
BuildingBuilding-level operations and reporting
Floor or zoneSpace-level work routing and inspection planning
Room or areaLocal work-order location and evidence context
SystemHVAC, electrical, fire safety, water, compressed air, production support
EquipmentPump, AHU, chiller, UPS, conveyor, tool support asset
ComponentMotor, filter, valve, bearing, controller, sensor
Digital twin object3D, BIM, CAD, or scene object linked to operational identity

Matching Procedure

  1. Import CMMS asset and location records into DFS or MDM staging.
  2. Import related BMS, Inspector, ERP, and model-asset references when available.
  3. Normalize names, location fields, equipment types, and source-system codes.
  4. Create deterministic rules for exact IDs and agreed aliases.
  5. Use fuzzy or semantic matching for names and descriptions that need review.
  6. Route low-confidence matches to the steward queue.
  7. Approve, reject, merge, split, or re-point records.
  8. Publish the reviewed golden asset and alias set.
  9. Re-run work-order fusion after identity changes.

Steward Review

Review caseAction
One source asset maps to one golden assetApprove the match
Multiple source assets describe one physical assetMerge aliases into one golden asset after owner approval
One source asset represents several physical assetsSplit into separate golden assets and re-point work orders where needed
Work orders point to retired equipmentRe-point to the replacement asset when the customer approves the rule
Location differs across systemsReview site hierarchy and preserve the source location in audit fields
Low confidence matchHold for steward review before operational use

Expected Output

The identity package should include:

  • golden asset and location records;
  • CMMS alias mapping;
  • BMS and Inspector alias mapping where available;
  • model-asset or digital twin binding where spatial context is needed;
  • steward decision records;
  • rejected or unresolved match list;
  • refresh cadence for identity updates.

Validation Checklist

  • Open and closed work orders resolve to the intended asset or location.
  • Provider asset ID and common asset ID are both visible for audit.
  • Retired and renamed assets have clear handling rules.
  • Predictive Maintenance signals and CMMS work orders point to the same equipment identity.
  • Inspector alerts and work orders can be joined through the reviewed asset identity.
  • AI Agent answers cite the same asset identity used in operator views.

Troubleshooting

SymptomCheck
Work orders appear under the wrong equipmentAlias mapping, parent hierarchy, retired asset rules, and steward decisions
Many records stay unmatchedMissing source asset table, inconsistent naming, absent location codes, or low confidence threshold
Duplicate assets appearMerge rules, source-system aliases, equipment type normalization, and parent hierarchy
Digital twin view does not open from work orderModel asset binding, component geometry, tenant scope, and asset ID bridge
Predictive Maintenance cannot join work historyEquipment ID bridge, signal asset ID, work-order asset reference, and MDM publication state