Summary/Use Case
Report Summary
The intended use of this report is to give an overview of the equipment in the system. In addition to the equipment’s identifying information, the user can view purchase date, equipment age, purchase cost, total service costs, and % of purchase to total service costs.
Use Case
Provides a master list of all equipment in the system, including identification information, status, and vehicle mount
The report also gives totals for equipment valuation and service costs per facility
Information to perform lifecycle cost analysis is included
Location: Where to Find it
Open RTA Web and Select Reports > RTA Standard Reports > Equipment > Equipment Overview
...
Data Filter Prompts
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 | Any | 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. |
Status Code | Is One Of | In Inventory Mounted Repair Scrapped | In Inventory Mounted Repair ScrappedThese are the default equipment status options in the system. You can choose to include or exclude any of these options. | ||
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 a master list of equipment contained in the system and give identification and associated costs.
Report Output:
...
Report Data Elements List
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Equip # | This is the assigned equipment number |
2 | Type | This is the user assigned equipment type |
3 | Description | This is the user assigned description of the equipment |
4 | Serial | This is the serial number of the equipment |
5 | Status | This is the current status of the equipment |
6 | Vehicle (If Mounted) | This is the vehicle that the equipment is currently mounted to, if mounted |
7 | Purchase Date | This is the date the equipment was purchased |
8 | Age (In Months) | This is the vehicles age in months; this field is the date difference between today and the purchase date |
9 | Purchase Cost | This is the purchase cost of the equipment |
10 | Total Service Costs | This is the sum of all service costs over the life of the equipment |
11 | % Purchase to Service Costs | This is the percentage of total cost of service compared to the purchase cost; this field is helpful for determining the need for replacement |
...