Equipment master, allocation to projects, fuel tracking, maintenance scheduling, breakdown management, and utilization reporting.
Equipment Management tracks heavy machinery and construction equipment across projects. Equipment is registered in a master list with specifications, allocated to projects, and monitored for fuel consumption, maintenance schedules, and breakdowns. Utilization hours are captured from DPR and equipment logs. Cost per hour is calculated for project cost allocation.
| Status | Description | Allowed Actions | Next States |
|---|---|---|---|
| Available | Equipment idle, ready for allocation | Allocate, Transfer, Dispose | Allocated |
| Allocated | Assigned to a project | Log Hours, Fuel, Maintain | Available, Under Maintenance |
| Under Maintenance | Scheduled or breakdown maintenance | Complete Repair, Update Status | Available, Allocated |
| Breakdown | Unplanned failure, needs repair | Create Maintenance Request | Under Maintenance |
| Disposed | Equipment decommissioned/sold | View History | — |
equipment_id — PK, unique equipment recordtenant_id — FK → organization.tenantequipment_code, equipment_name — Asset identificationcategory, make, model, year — Classification detailscapacity, fuel_type — Operational specificationsownership_type — owned | hired | leasedhourly_rate, status — Cost and availability stateallocation_id — PKequipment_id — FK → equipment.equipment_masterproject_id — FK → project.projectallocated_from, allocated_to — Date range of deploymentdaily_rate, shift_hours — Cost and usage parametersfuel_id — PKequipment_id — FK → equipment.equipment_masterlog_date, fuel_qty, fuel_cost — Daily fuel consumptionodometer_reading, hour_meter — Usage measurementfilled_by — FK → admin.usermaintenance_id — PKequipment_id — FK → equipment.equipment_mastermaintenance_type — preventive | corrective | overhaulscheduled_date, actual_date — Planning vs executioncost, downtime_hours — Financial and availability impactperformed_by — Internal or vendor referencebreakdown_id — PKequipment_id — FK → equipment.equipment_masterreported_date, resolved_date — Breakdown durationfailure_type, root_cause — Analysis fieldsproduction_loss_hours — Impact on project scheduleRegister equipment with make, model, capacity, ownership type, and hourly rate. Owned equipment linked to fixed assets. Hired equipment linked to rental agreement.
Allocate equipment to project with date range and shift details. System checks availability to prevent double-booking. Allocation triggers cost accrual in project.
Operators log daily hours and fuel consumption via DPR equipment section. Hour meter readings validated against previous entry (cannot decrease).
Preventive maintenance scheduled based on hour meter thresholds (e.g., every 250 hours). Breakdown reported by operator → maintenance team dispatched. Downtime tracked.
Monthly utilization = actual hours / available hours × 100. Cost per hour includes fuel, maintenance, depreciation, and operator cost. Idle equipment flagged for redeployment.
-- Monthly utilization and cost per equipment SELECT em.equipment_code, em.equipment_name, SUM(el.working_hours) AS total_hours, SUM(fl.fuel_qty) AS total_fuel, SUM(fl.fuel_cost) AS fuel_cost, ROUND(SUM(el.working_hours) / (26.0 * 8) * 100, 1) AS utilization_pct FROM equipment.equipment_master em LEFT JOIN equipment.equipment_log el ON el.equipment_id = em.equipment_id LEFT JOIN equipment.fuel_log fl ON fl.equipment_id = em.equipment_id WHERE el.log_date BETWEEN :start_date AND :end_date GROUP BY em.equipment_id;