Provides a view with fields primarily oriented to the measurement of the time between when a railcar is reported in Bad Order status and when it is released from bad order status. The dataset is based mostly on the Sighting records in RMS.
List of fields
BadOrderDate
Date that the railcar was placed in bad order status. Source: Sighting. Format: mm/dd/yyyy
BadOrderDttm
Date and time that the railcar was reported as in bad order status. Source: Sighting. Format: mm/dd/yyyy hh:mm
BadOrderRlseDate
Date that the railcar was released from bad order status. Source: Sighting. Format: mm/dd/yyyy
BadOrderRlseDttm
Date and time that the railcar was released from bad order status. Source: Sighting. Format: mm/dd/yyyy
BadOrderRlseTime
Time that the railcar was released from bad order status. Source: Sighting. Format: hh:mm:ss am/pm
BadOrderTime
Time that the railcar was reported as in bad order status. Source: Sighting. Format: hh:mm:ss am/pm
City
Station city where the railcar was last reported (i.e. the location of bad order). Source: Sighting or if a match is made on a Station Alias, Station
CityState
Station city and state where the railcar was last reported (i.e. the location of bad order). Source: Sighting or if a match is made on a Station Alias, Station. Format: Mycity, NA.
DestCity
Station city where the railcar is destined. Source: Sighting or if a match is made on a Station Alias, Station.
Destination
Station city and state where the railcar is destined. Source: Sighting or if a match is made on a Station Alias, Station. Format: Mycity, NA.
DestState
Two character state abbreviation where the railcar is destined. Source: Sighting or if a match is made on a Station Alias, Station.
ElapsedTime
Bad order release date and time minus the bad order date and time. Source: Calculated by RMS. Format: 00.0
IsCarTemp
Indicates whether the railcar is a Temporary fleet assignment. Source: Railcar. Format: True or False
LE
Indicates whether this is a load cycle or an empty cycle. Source: Cycle. Format: L for load and E for empty.
LEDesc
Indicates whether this is a load cycle or an empty cycle. Source: Cycle. Format: LOAD for load and EMPTY for empty.
Pool
Railcar sub-fleet / pool that the railcar belonged to at the time of this cycle. Source: Railcar Pool
PoolCurrent
Railcar sub-fleet / pool that the railcar belongs to currently (Provided for backward compatibility). Source: Railcar 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: Cycle
RailcarInitial
Initial of the equipment used for the shipment. Source: Cycle
RailcarNumber
Number of the equipment used for the shipment. Source: Cycle
Railroad
SCAC railroad abbreviation for the railroad which last reported the location of the railcar. Source: Sighting
State
Two character state abbreviation where the railcar was last reported (i.e. the location of bad order). Source: Sighting or if a match is made on a Station Alias, Station
TrainID
Identifier of the train that the railcar is in. Source: Sighting.