Skip to main content

Multi-CMMS Consolidation

Many building, campus, and facility portfolios already use several CMMS or EAM providers. Different buildings, systems, contractors, and service lines may keep their own work-order platforms. FactVerse can provide a common operations layer across those providers, while each downstream CMMS continues to own the records and execution processes that the customer needs to keep.

Use this guide when a customer wants a centralized maintenance operations view across multiple CMMS providers, especially when the downstream systems mainly handle work-order management.

Target Architecture

The design has four practical goals:

  • Give operators one place to see work-order status across buildings, systems, and service providers.
  • Keep source-system ownership clear so teams know where execution decisions are made.
  • Normalize asset, location, status, priority, SLA, attachment, and closeout data for reporting and AI workflows.
  • Support controlled handoff or write-back after the customer approves the integration model.

Prerequisites

RequirementWhy it matters
Provider inventoryThe program needs a list of CMMS, EAM, contractor, and building systems by site or service line
Source ownershipEach downstream system needs a named owner for access, field meaning, status mapping, and exception review
Asset identity baselineWork orders need to map to stable buildings, systems, spaces, equipment, and MDM identities
Status and SLA taxonomyProvider states, priorities, and SLA rules need a shared interpretation for unified operations
Integration accessAPIs, exports, middleware, service accounts, network paths, and rate limits need to be confirmed
Write-back decisionThe customer needs to decide which providers are read-only, handoff-based, synchronized, or provider-owned
Security and audit modelService identities, scopes, evidence retention, and sync logs need customer approval before rollout

Operating Model

LayerResponsibility
Downstream CMMS and EAMMaintain native work-order records, provider-specific workflows, technician dispatch, and local execution rules
DFSConnect to provider APIs, scheduled exports, files, or middleware; validate and normalize records
MDMAlign provider asset IDs, building systems, locations, equipment names, and duplicate references
FactVerse CMMS OperationsProvide the common work-order view, status mapping, assignment context, SLA review, and cross-provider history
Facility OperationsAdd site, space, equipment, inspection, and operations context around each work item
Predictive MaintenanceGenerate condition-based maintenance recommendations that can be reviewed before work-order handoff
ECMManage attachments, service reports, SOPs, photos, and closeout evidence across providers
FactVerse AI AgentSummarize, compare, draft, and explain maintenance context under explicit permissions and review gates

Source Data Inputs

InputUse
Provider work-order exports or APIsBring work-order ID, status, priority, owner, timestamps, service type, and closeout fields into the common model
Asset and location referencesAlign provider records with buildings, systems, spaces, equipment, and MDM identities
Provider status taxonomyMaps native provider states to the shared lifecycle used by operators
Attachment metadata and filesConnect service reports, photos, permits, checklists, and closeout evidence to unified records
User and provider ownership dataSeparates source-system ownership, execution ownership, and customer review responsibility
SLA and priority rulesSupports portfolio-wide backlog, response-time, and exception review
Sync historyShows import time, freshness, retry state, write-back result, and exception detail
Handoff or write-back policyDefines which fields can be created or updated from FactVerse and which remain provider-owned

Integration Patterns

PatternWhen to use itNotes
Read-only aggregationThe customer needs a common view without changing provider workflowsLowest operational risk and a good first rollout pattern
Controlled handoffFactVerse creates a reviewed request or draft for a downstream providerUseful when inspections, alarms, or predictive-maintenance findings need dispatch
Two-way status synchronizationOperators need current provider status and selected status updates from FactVerseRequires clear conflict rules, retry handling, and synchronization logs
Attachment and evidence synchronizationPhotos, reports, checklists, and closeout files need to follow the work orderRequires retention, file-size, access, and audit policy alignment
Provider-specific write-backFactVerse updates assigned fields in a provider CMMSUse only after field ownership, permissions, and rollback behavior are agreed

Common Work-Order Model

FieldPurpose
provider_idIdentifies the source CMMS, EAM, contractor system, or managed service provider
source_work_order_idPreserves the native work-order identifier from the downstream system
common_work_order_idProvides a stable FactVerse reference for unified views, dashboards, and AI workflows
asset_refLinks the work order to the MDM asset, equipment, system, or location identity
source_statusKeeps the original provider status visible for audit and provider communication
common_statusMaps provider states to the shared lifecycle used by operators
priority and slaSupports cross-provider urgency and service-level review
requested_at, assigned_at, started_at, completed_at, closed_atEnables lifecycle, backlog, and response-time analysis
owner and assigneeSeparates provider ownership from local execution responsibility
attachmentsLinks reports, photos, SOP references, permits, and closeout evidence
sync_stateShows freshness, last synchronization result, and exception status

Status Mapping

Common statusExample provider statesReview point
RequestedNew, Open, Submitted, CreatedConfirm source, asset, duplicate risk, and service category
TriagedReviewed, Validated, AcceptedConfirm priority, SLA, and ownership
AssignedDispatched, Assigned, ScheduledConfirm provider, crew, technician, and planned window
In progressStarted, On Site, Work In ProgressTrack field execution and evidence
BlockedOn Hold, Waiting Parts, Pending ApprovalCapture blocker reason and expected next action
CompletedResolved, Work Complete, Ready to CloseReview outcome, evidence, and follow-up actions
ClosedClosed, Archived, VerifiedLock closeout record and preserve audit trace
CanceledRejected, Void, CanceledKeep cancellation reason and source decision visible

Source Ownership Rules

Use explicit ownership rules before enabling synchronization:

  • Define which system can create a work order for each building, service line, and provider.
  • Define which fields FactVerse can update and which fields remain provider-owned.
  • Preserve the native provider ID and source status in every unified view.
  • Keep a synchronization log for imports, handoff, write-back, attachment sync, retries, and failures.
  • Show stale data and sync exceptions in the operator view rather than hiding them in background jobs.
  • Prevent duplicate work orders when inspections, alarms, AI recommendations, and provider imports describe the same issue.

Discovery Checklist

TopicQuestions to answer
Provider landscapeWhich CMMS, EAM, contractor, or building systems are in scope for each site
Integration accessWhich providers offer REST APIs, webhooks, database views, exports, SFTP, or middleware
AuthenticationWhich service accounts, API keys, OAuth flows, IP restrictions, and approval processes are required
Work-order fieldsWhich fields are required, optional, read-only, provider-specific, or customer-specific
Status taxonomyHow provider statuses map to the common lifecycle and where exceptions occur
Asset identityHow provider asset IDs map to building, floor, room, equipment, system, and MDM identities
AttachmentsWhich photos, reports, checklists, permits, and closeout documents need to synchronize
Write-back policyWhich fields can be written back, who approves writes, and how failures are retried
Data freshnessWhether the customer needs near-real-time sync, scheduled sync, or manual refresh
Audit and retentionHow long records and attachments are retained and who can access them

Rollout Sequence

  1. Inventory provider systems, work-order fields, status values, asset references, and integration access.
  2. Build the common work-order model and status mapping with real examples from each provider.
  3. Connect the first provider in read-only mode and validate unified views with operators.
  4. Add MDM matching for assets, locations, equipment, and service categories.
  5. Add attachment and evidence workflows after access and retention policy are confirmed.
  6. Enable controlled handoff or write-back for one provider and one service line before expanding.
  7. Add AI Agent summaries and recommendations after the data model and permissions are stable.
  8. Review exception handling, duplicate detection, and sync logs during pilot operations.

Governance

Multi-provider CMMS programs affect operational ownership. Treat the integration as an operating model with connector, data, permission, and exception-management workstreams.

  • Give each provider a clear ownership boundary.
  • Separate read permissions from draft, handoff, write-back, and closeout permissions.
  • Use service accounts with scoped access and rotation policy.
  • Review synchronization failures and stale records as operational exceptions.
  • Store customer-specific provider mappings, API credentials, and field rules in the approved project repository and secret-management process.