TMS Fleet Maintenance Hub: Automated Preventative Service (PM) Scheduling Solvers

Technical Implementation Details

Telematics Data Ingestion

The foundation is a robust integration with Electronic Logging Devices (ELDs) and telematics platforms. Using the practices outlined in our ELD and EDI Integration methodology, the TMS establishes real-time or near-real-time event streams. Key data points include:

• Vehicle chassis number (VIN)
• Current odometer reading (miles)
• Cumulative engine hours
• Idle hours versus driving hours
• Diagnostic trouble codes (DTCs)

These events are persisted in a normalized time-series table that supports both incremental updates and historical reconstruction for audit purposes.

PM Scheduling Algorithm

The scheduling solver operates on a set of configurable business rules stored in a flexible rules table. A simplified schema representation includes:

CREATE TABLE pm_service_templates (
    template_id INT PRIMARY KEY,
    service_code VARCHAR(10), -- A, B, C, D
    description TEXT,
    interval_miles INT,
    interval_engine_hours INT,
    interval_days INT,
    warning_lead_days INT,
    requires_annual_inspection BOOLEAN
);

CREATE TABLE vehicle_pm_status (
    vehicle_id INT,
    template_id INT,
    last_completed_miles INT,
    last_completed_engine_hours INT,
    last_completed_date DATE,
    next_due_miles INT GENERATED ALWAYS AS (last_completed_miles + interval_miles) STORED,
    next_due_engine_hours INT GENERATED ALWAYS AS (last_completed_engine_hours + interval_engine_hours) STORED,
    status VARCHAR(20) -- CURRENT, DUE_SOON, OVERDUE
);

The solver runs on a scheduled basis (typically nightly) and also triggers on significant telematics events. When a vehicle's projected next_due_miles falls within the warning_lead_days window, the system automatically creates a draft maintenance work order.

Automated Work Order Generation and Parts Reservation

Upon threshold breach, the TMS generates a work order linked to the specific vehicle and service template. The bill of materials (BOM) for that service code is used to create inventory reservations against the shop's parts warehouse. This prevents mechanics from beginning work only to discover a required filter or belt is out of stock.

Integration with the transportation accounting system (see our Transportation Accounting Integration practice) ensures labor and parts costs flow correctly into asset maintenance ledgers and equipment depreciation schedules.