Fleet Services - Preventative Maintenance

citydata.mesaaz.gov | Last Updated 1 Oct 2019

Information about preventative maintenance performed by Fleet Services

This dataset has the following 7 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Month Datemonth_datecalendar_dateFull date format for the time period reporting
MonthmonthtextMonth of the time period reporting
Calendar Yearcalendar_yeartextYear of the time period reporting
Fiscal Yearfiscal_yeartextFiscal year associated with the time period reporting
LocationlocationtextLocation where preventative maintenance occurred. EM = East Mesa shop, FS = West Mesa shop, Both = EM and FS locations combined
Base percentage of PMs completed from original listbase_percentage_of_pmsnumber# of vehicles from original list not in new list/# of total projected vehicles due for PM from original run
Adjusted Total Percentage of PMs completed for monthadjusted_total_percentagenumberTotal Projected Vehicles/Total No. of PM Work Orders Generated * 100