Equipment Service Reminders

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

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

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.

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 the 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
2	Assignee Name	This is the name of the individual assigned to this equipment
3	Monted to Vehicle	This is the vehicle that the equipment is mounted to, if mounted
4	VMRS Code	This is the 9-digit VMRS code of the service
5	VMRS Desc	This is the description 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