Fleet Services - Repair

citydata.mesaaz.gov | Last Updated 11 Jul 2019

This dataset describes the repair work done by Fleet Services

This dataset has the following 28 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Work Order IDwork_order_idtextIncludes location, FS (West Fleet location) or EM (East Mesa location)-year-system generated work order number
Work Location Abbreviationwork_location_abbreviationtextEM (East Mesa) or FS (West Fleet) service locations
Work Location Namework_location_nametextEM-East Mesa FS-Fleet Services
Work Order Numberwork_order_numbernumberSystem generated work order number
Job Typejob_typetextType of work or job performed, preventative maintenance (PM) or repair
Work Order Statuswork_order_statustextStatus the work order is in (examples: closed, open, work finished, etc.)
Task PM Service Codetask_pm_service_codetextSingle letter Task Code representing a group of common preventative maintenance (PM) tasks to be performed based on class of vehicle (cross references class_task_pmlist table)
Equipment Numberequipment_numbertext4-digit vehicle or equipment (trailer) number
Repair Start Yearrepair_start_yeartext4-digit year which repairs were started
Repair Start Monthrepair_start_monthtext2-digit month which repairs were started
Repair Start Month Daterepair_start_month_datecalendar_dateMonth/day repairs started
Repair Start Timerepair_start_timecalendar_dateTime of day repairs were started
Repair End Yearrepair_end_yeartextYear repairs were completed
Repair End Monthrepair_end_monthtextMonth repairs were completed
Repair End Month Daterepair_end_month_datecalendar_dateMonth/day repairs were completed
Repair End Timerepair_end_timecalendar_dateTime of day repairs were completed
Repair Duration Daysrepair_duration_daysnumberTotal number of days to repair vehicle
Repair Duration Days Rounded Uprepair_duration_days_roundednumberNot used
Is Finishedis_finishedcheckboxIndicator that work is completed
Is Completed in One Dayis_completed_in_one_daycheckboxIndicator that repairs were completed within 24 hours of work order open date/time
Is Completed in Two Daysis_completed_in_two_dayscheckboxIndicator that repairs were completed within 48 hours of work order open date/time
Is Completed in More than Two Daysis_completed_in_more_thancheckboxIndicator that repairs were completed over 48 hours after repair order date/time
Has Delayhas_delaycheckboxIndicator that the work order has an assigned delay (parts ordered useable, waiting labor-mechanic, etc.)
Has Commercial Delayhas_commercial_delaycheckboxIndicator that the work order has an assigned delay due to vehicle at vendor
Delay in Hoursdelay_in_hoursnumberTotal number of hours vehicle/work order was in delay for that particular delay
Commercial Delay in Hourscommercial_delay_in_hoursnumberTotal number of hours vehicle/work order was in delay while at vendor
Meter 1 Readingmeter_1_readingnumberCurrent meter reading on equipment at that point in time
Reason for Repairreason_for_repairtextDesignated reason why work order was created (accident, wear/tear, repairs found during preventative maintenance, etc.)