Summary/Use Case
Report Summary
The purpose of this report is to provide customers with a report that tracks the service due dates for equipment, as well as the VMRS code/description of the service due. The customer is given the option to only include overdue services prior to running the report, but in any case, overdue lines are highlighted in red. There is also a facility and report summary that gives customers the count of overdue services, average days overdue, total equipment listed, and mounted equipment.
Use Case
Send to customers for service scheduling
Use in conjunction with PM Due 30 Days report to align services with vehicles that the equipment are mounted to
Location: Where to Find it
Open RTA Web and Select Reports > RTA Standard Reports > Equipment > Equipment Service Reminders
...
Data Parameter / Filter Prompts
You will first be prompted on if you want to only include overdue services.
...
Data Parameter List
Parameter Name | Value (Options) | Value (Defaults) | Value (Notes) |
|---|---|---|---|
Only Include Overdue Services? | True False | False | The ‘False’ option will cause the report to give all services, whether they are overdue or not The ‘True’ option will cause the report to only include equipment that have services that are overdue |
Next, you will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options.
...
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Defaults)Value (Notes) | ||||||
|---|---|---|---|---|---|---|---|---|---|
Facility Equal To Not Equal To Less Than Less Than or Equal To Greater Than Greater Than or Equal To Starts With Not Starts With Ends With Does Not End With Contains Does Not Contain Is Between | Is Not Between Is One Of Is Not One Of | 1 - 99999 | Between 1 and 99999 | Based on what condition option you select you can Include individual Facility Number or Numbers, and Ranges. Or You can exclude individual Facility Number or Numbers, and Ranges. | Equipment Number | Equal To Not Equal To Less Than Less Than or Equal To Greater Than Greater Than or Equal To Starts With Not Starts With Ends With Does Not End With Contains Does Not Contain Is Between Is Not Between Is One Of Is Not One Of- 99999 | |||
Equipment Number | Is Between | 1 - zzzzzzzzzz | Between 1 and zzzzzzzzzz | Based on what condition option you select you can include Equipment Numbers or Ranges. Or You can exclude individual Equipment Number or Numbers, and Ranges. | Service Date | Is Between Greater Than or Equal To Less Than or Equal To | Any date range is acceptable | First Day of Last Month - First Day of Current Month Note: First Day of Current Month starts at 12:00am, so no current month transactions will be included | Based on the condition, you can select a range of dates- zzzzzzzzzz |
Report Output and Data Elements
When the report runs, you will see the report is grouped/sorted by Facility > Equipment Number. The primary function of this report is to provide a complete list of services completed for each piece of equipment during the specified date rangethe data related to the equipment services and their respective intervals.
Report Output:
...
Report Data Elements List
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Equipment # | This is the assigned equipment number |
2Service | DateAssignee Name | This is the date that the service was performedname of the individual assigned to this equipment |
3Service Type | Monted to Vehicle | This is the type of service that was performedvehicle that the equipment is mounted to, if mounted |
4Service | DescriptionVMRS Code | This is the description 9-digit VMRS code of the service that was performed |
5Qty | VMRS Desc | This is the quantity of the service type; this is used to indicate types that may be greater than one, such as labor hours or parts |
6 | Cost per Unit | This is the cost of each unit |
7 | Total Service Line Cost | This is the result of Qty * Cost per Unitdescription of the VMRS code |
6 | Service Interval (In Days) | This is the interval (in days) assigned to service |
7 | Last Service Date | This is the date that the service was last done |
8 | Next Service Date | This is a calculation of (Service Interval) + (Last Service Date) |
9 | Days Until Due | This is the number of days that the service is overdue or until due |