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
BOLDate
Date the bill of lading was created (format: mm/dd/yyyy). Source: Shipping Instruction
BOLNum
Bill of lading number assigned to the shipment by the shipper. Source: Shipping Instruction
CareOf
Company name listed as the care of party by the shipper. Source: Shipping Instruction or if a match is made on a Party Alias, Party
Comments
Up to 4 characters that may be entered by the user when inserting or updating a sighting record. Source: Sighting
Commodity
Description of the commodity carried in the railcar. Source: Shipping Instruction unless it matches an alias of a proprietary Commodity - in that case, it will display the proprietary Commodity Name.
Consignee
Company name listed as the consignee party by the shipper. Source: Shipping Instruction or if a match is made on a Party Alias, Party
ContractNum
Number identifying the contract between the freight payor and the rail carrier. Source: Shipping Instruction
DaysFromDest
Number of days until the railcar is estimated to arrive at the final destination: Source: Trip Plan. Format: 00.0
DestBill
City and state / station where the shipment is to terminate. Source: Shipping Instruction or if a match is made on a Station Alias, Station. Format: Mycity, NA
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.
DestCityCLM
City / station where the shipment is to terminate. Source: Sighting or if a match is made on a Station Alias, Station.
DestCLM
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
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.
DestStateCLM
Two character state abbreviation where the shipment is to terminate. Source: 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
ElapsedTimeSinceRlse
The number of days between RlseDttm (Release date and time that begins the currrent Cycle that the railcar is in) and the date and time the report was run. Source: Calculated by RMS. Format: 00.0
ETADttm
Date and time that the railcar is estimated to arrive at the final destination. EventDttm plus DaysFromDest or if DaysFromDest from the Trip Plan is not available, the ETA provided by the railroad is used (ETARRDttm). Source: Calculated by RMS. Format: mm/dd/yyyy hh:mm
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
ETASource
Identifies the ETA source. Source: RMS. Format: RMS - if the ETA was calculated using Trip Plans and RMS' Enhanced ETA feature; RR - if the ETA was provided by the railroad via the Sighting record.
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: Sighting
LeaseNum
Railcar lease contract number. Source: Railcar Lease.
LEDesc
Indicates whether the shipment is for a railcar that is empty (EMPTY) or loaded (LOAD). Source: Shipping Instruction
NetWeight
Weight of the lading. 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.
Origin
City / station where the shipment originated. Source: Shipping Instruction or if a match is made on a Station Alias, Station
Origin Cycle
City / station where the cycle originated. Source: Cycle or if a match is made on a Station Alias, Station
PONUm
Displays the purchase order number that was entered on the bill of lading. 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
RlseDate
Date the railcar was released to start the cycle. Source: Cycle. Format: mm/dd/yyyy
RlseDttm
Date and time the railcar was released to start the cycle. Source: Cycle Format: mm/dd/yyyy hh:mm.
RlseTime
Time the railcar was released to start the cycle. Source: Cycle. Format: hh:mm:ss am/pm
Route
Includes SCAC abbreviations of railroads that are involved in the shipment and Rule 260 junction abbreviations indicating interchange points. Source: Shipping Instruction
RTADttm
Requested date and time of arrival. Source: Shipping Instruction. Format: mm/dd/yyyy hh:mm
ShellCapacity
Capacity of the tank car shell. Source: Railcar. Format: 0
ShipmentDesc
User maintained field of up to 30 alpha numeric characters. May also be imported automatically using the ISG System. Source: Shipping Instruction.
ShipmentID
User maintained field of up to 6 alpha numeric characters. May also be imported automatically using the ISG System. Source: Shipping Instruction.
Shipper
Company name listed as the Shipper party by the shipper. Source: Shipping Instruction or if a match is made on a Party Alias, Party
SIUserField1
User maintained field of up to 50 alpha numeric characters. Source: Shipping Instruction.
SIUserField2
User maintained field of up to 50 alpha numeric characters. Source: Shipping Instruction.
SIUserField3
User maintained field of up to 4000 alpha numeric characters. Source: Shipping Instruction.
STCC
A seven digit numeric code representing 38 commodity groupings. Source: Shipping Instruction
STCCDesc
A description related to the seven digit numeric code representing 38 commodity groupings. Source: RMS Commodities
TrainID
Identifier of the train that the railcar is in. Source: Sighting.
TransitStatus
If the EventDesc is Placement Constructive, Placement Actual, Arrival at Final Destination or the LastCityState = Destination, then it will display "At Destination", otherwise, "In Transit". Source: RMS.
TransitStatus2
If the EventDesc is Placement Constructive, Placement Actual or the LastCityState = Destination, then it will display "At Destination", otherwise, "In Transit". Source: RMS.
WaybillDate
Date the waybill was created. Source: Shipping Instruction
WaybillNum
Waybill number assigned to the shipment by the rail carrier. Source: Shipping Instruction