Module

Equipment & Assets

A deep asset model with criticality, warranty, manufacturer, condition and full maintenance history per item. Every event that touches the asset is logged, making it the highest-signal source for predictive maintenance models.

equipmentequipment_surveyequipment_logequipment_type
47
Tables
5,000+
Asset classes
1,800+
Fields
Capabilities

Functional areas this module covers.

Asset registry

Hierarchical equipment with parent-child relationships, location and ownership.

equipmentequipment_type

Condition surveys

Periodic surveys with scoring against standardised criteria.

equipment_surveyequipment_survey_item

Maintenance history

Every task, part, technician and outcome that touched the asset.

equipment_logtask

Warranty & lifecycle

Install/commission dates, warranty windows, expected and projected end of life.

equipment_warrantyequipment_lifecycle
Core tables

1 core table documented in detail.

AI use cases

Unlocked by the depth of this module's schema.

Predictive failure

Model failure probability per asset class using meter, log and event data.

Replace vs. repair

Score each asset on remaining useful life vs. cost-to-keep.

Criticality-aware prioritisation

Weight maintenance backlog by asset criticality, not raw count.

Ask it in natural language

Sample queries an AI agent can resolve against this module.

1

List equipment with three or more corrective tasks in the last 90 days.

2

Which critical assets are within six months of warranty expiry?

3

Show MTBF trend for chillers across the portfolio.

Reporting & KPIs

Pre-built summary views and the metrics teams track.

Summary views

  • Monthly
    monthly_equipment_summary
    Failures, downtime and cost per equipment class.
  • Quarterly
    quarterly_equipment_condition_summary
    Condition score distribution.

Key KPIs

  • MTBF
    Mean time between failures per asset class.
  • Downtime hours
    Total unavailable hours per critical asset.
  • Warranty leakage
    Cost of work done on assets still under warranty.
Related modules

Where this module connects across the platform.

Browse all modules
Back to Schema Explorer