Provides a view with fields primarily oriented to where the railcar was last reported. The dataset is based mostly on the Sighting records in RMS, but also contains a lot of information from the Shipping Instruction.
List of fields
Comments
Up to 4 characters that may be entered by the user when inserting or updating a sighting record. Source: Sighting
DestCity
City / station where the shipment is to terminate. Source: Shipping Instruction or if a match is made on a Station Alias, Station; if there is no shipping instruction available, then it is from the Sighting or if a match is made on a Station Alias, Station.
Destination
City and state / station where the shipment is to terminate. Source: Shipping Instruction or if a match is made on a Station Alias, Station; if there is no shipping instruction available, then it is from the Sighting or if a match is made on a Station Alias, Station. Format: Mycity, NA
DestState
Two character state abbreviation where the shipment is to terminate. Source: Shipping Instruction or if a match is made on a Station Alias, Station; if there is no shipping instruction available, then it is from the Sighting or if a match is made on a Station Alias, Station.
ElapsedTime
The number of days between EventDttm (event date and time) and the date and time the report was run. Source: Calculated by RMS. Format: 00.0
ETARRDttm
Date and time that the railcar is estimated to arrive at the final destination according to the railroad. Source: Sighting (Note: CLM Format H is the sighting format that will provide this). Format: mm/dd/yyyy hh:mm
Event
One character code identifying the event last performed on the railcar. Source: Sighting. Format: See Event Codes in the Glossary
EventDate
When the event last performed on the railcar happened. Source: Sighting. Format: mm/dd/yyyy
EventDesc
Phrase describing the event last performed on the railcar. Source: Event Descriptions. Format: See Event Codes in the Glossary
EventDttm
When the event last performed on the railcar happened. Source: Sighting. Format: mm/dd/yyyy hh:mm
EventTime
When the event last performed on the railcar happened. Source: Sighting. Format: hh:mm:ss am/pm
IsCarTemp
Indicates whether the railcar is a Temporary fleet assignment. Source: Railcar. Format: True or False
LastCity
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. Format: Mycity
LastCityState
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.
LastState
Station 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: NA.
LE
Indicates whether the shipment is for a railcar that is empty (E) or loaded (L). Source: Shipping Instruction
LEDesc
Indicates whether the shipment is for a railcar that is empty (EMPTY) or loaded (LOAD). Source: Shipping Instruction
NoSighting
Indicates if there is no sighting information for a particular railcar. Source: RMS. Format: 1 for yes, 0 for no. 1 and 0 were used so that by summarizing the field with the Sum function, a count of railcars without sightings could be displayed.
Pool
Railcar sub-fleet / pool to which the railcar belongs. 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: 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
Railroad
SCAC railroad abbreviation for the railroad which last reported the location of the railcar. Source: Sighting
TimeToDest
Number of days before arriving at destination. Source: calculated by RMS. Format: 00.0
TrainID
Identifier of train in which the railcar is included. Source: Sighting.