Provides a view with fields primarily oriented to where the railcar was reported. The dataset is based mostly on the Sighting records in RMS.
List of fields
City
Station city where the railcar was reported (i.e. the location of bad order). Source: Sighting or if a match is made on a Station Alias, Station. Format: Mycity.
CityState
Station city and state where the railcar was reported (i.e. the location of bad order). Source: Sighting or if a match is made on a Station Alias, Station. Format: Mycity, NA.
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: Sighting or if a match is made on a Station Alias, Station.
Destination
City and state / station where the shipment is to terminate. Source: 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: Sighting or if a match is made on a Station Alias, Station.
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
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
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
SightingID
Unique identifier of sighting record. Used mostly by RMS. Source: Sighting (RMS). Format: 00
Source
Three character abbreviation indicating the source of the sighting record. Source: Sighting (RMS).
State
Two character state abbreviation where the railcar was reported. 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.