Provides a view with fields primarily oriented to how railcars were utilized over a period of time. The dataset is based mostly on the Sighting records in RMS, but also gets shipment counts from Shipping Instructions or Cycles.
Note: If you make a custom report based on this dataset, when you click on the Save / Preview 1st 100 only button, it will not display any records. This is due to the long time it would take to do this for larger fleets. We understand that this makes it more difficult to perfect the layout and this behavior may be improved in future versions. In the mean time, it is recommended to copy the existing Railcar Utilization reports from the Management Reports, then modify the filter and add output options in the Custom Report Creator and Editor. For larger fleets (500 +) this report may take several minutes and may be better run via the Scheduler during non-working hours and exported to a file or emailed as an attachment. See Setting Up Automatic Delivery of Custom Reports for instructions on how to do this.
List of fields
AnalysisDate
Date of railcar fleet "snapshot". Source: RMS. Format: mm/dd/yyyy
Note: By default, RMS takes a snapshot of your fleet every 7 days. This is done so that the report will complete in a reasonable time and will not negatively impact other applications on the network. If you wish, you may change this number by clicking on the Reports | Properties menu; click on he Railcar Utilization tab; change the entry in the Analysis Interval (Days) text box. Click the Ok button to save changes.
DailyRailcars
Number of railcars, on average, that are active during the particular period. Source: Calculated by RMS. Format: 00.0
DailyRailcarsPercentage
Percentage of the total fleet or group of railcars that are active during the particular period. Source: Calculated by RMS. Format 00.00%
DailyShellCapacity
Average shell capacity for all of the active railcars for the particular period. Source: Railcar, Calculated by RMS. Format: 00
ExtLEStatus
Extended load/empty status. Source: Calculated by RMS. Format: There are three categories:
Empty at Plant/Loading
Empty in Transit
Load
LEStatus
Load/emtpy status. Source: Sighting. Format: L = load E = empty
Pool
Railcar pool that the railcar belonged to during each "snapshot". Source: RMS Event Log (keeps track of when railcars are added/removed from a pool)
Railcar
Initial and Number of the equipment used for the shipment (XXXX 123456); there is always one space between the initials and number with no trailing or leading spaces or zeros. Note: This is not a good field to use for sorting. If you wish to sort by the railcar initial and number, it is recommended to use the fields RailcarInitial and RailcarNumber. Source: Shipping Instruction
RailcarInitial
Initial of the equipment used for the shipment. Source: Shipping Instruction
RailcarNumber
Number of the equipment used for the shipment. Source: Shipping Instruction
RecordCount
Number of records returned
ShellCapacity
Shell capacity for each particular railcar. Source: Railcar Format: 00
ShipmentCount
Count of shipments for the period. Source: Shipping Instructions. Format: 00
Note: The default behavior is that RMS counts the number of shipments for a period based on the bill of lading date. In other words, this would be summarizing the number of shipments that started during a given period. You may also have RMS count the number of shipments by when the shipment ended (the release event date/time that ends the cycle) by clicking on the Reports | Properties menu; click on the Railcar Utilization tab and select the Based on Cycle Completion Date option button. Click the Ok button to save the changes.
ShipmentsPerRailcar
ShipmentCount divided by DailyRailcars. Source: Calculated by RMS. Format. 00.0
ShipmentsPerRecord
ShipmentCount divided by RecordCount. Source: Calculated by RMS. Format: 00.0