Provides a view with fields from the Problem Log records entered.
List of fields
ActionTaken
A short description of what was done by the person listed in the CompanyContact field. Source: Problem Log
CompanyContact
Person who created out the problem log. Source: Problem Log
Description
Long description of the problem. Source: Problem Log
Destination
The station where the railcar is to terminate for its trip when the problem occured. This entry will stay with the problem record and will not change. Source: Station Format: Mycity, NA.
LastCityState
Station city and state where the railcar was last reported. Source: Sighting or if a match is made on a Station Alias, Station. Format: Mycity, NA.
LastDestination
City / station where the shipment will terminate for its current trip. Source: Shipping Instruction of latest/current shipment or if a match is made on a Station Alias, Station.
LastEventDttm
When the event last performed on the railcar happened. Source: Sighting. Format: mm/dd/yyyy hh:mm
LastLE
Indicates whether the railcar is currently empty (E) or loaded (L). Source: Sighting
LastOrigin
City / station where the shipment originated for its current trip. Source: Shipping Instruction of latest/current shipment or if a match is made on a Station Alias, Station.
Location
Short description of the specific location of the problem. This could be a track number, station name and anything. Source: Problem Log
Origin
The station where the railcar originated. This entry will stay with the problem record and will not change. Source: Problem Log Format: Mycity, NA
Pool
Railcar sub-fleet / pool that the railcar belonged to at the time of this problem. Source: Railcar Pool
PoolCurrent
Railcar sub-fleet / pool that the railcar belongs to currently. Source: Railcar Pool
ProblemDate
Date that the problem occurred. Source: Problem Log Format: mm/dd/yyyy
ProblemDttm
Date and time that the problem occurred. Source: Problem Log Format: mm/dd/yyyy hh:mm
ProblemTime
Time that the problem occurred. Source: Problem Log Format: hh:mm
Railcar
Railcar initial, a space, railcar number with no leading zeros. Source: Problem Log / Railcar. Format: KEYX 23456
RailcarInitial
Source: Problem Log / Railcar. Format: KEYX
RailcarNumber
Source: Problem Log / Railcar. Format: 23456
Railroad
Rail carrier to which this problem is being addressed. Source: Problem Log / Railroad
RailroadContact
Rail carrier contact. Source: Problem Log
Resolution
Long description of the solution to the problem. Source: Problem Log
ResolutionDate
Date that the problem was solved. Source: Problem Log Format: mm/dd/yyyy
RRContactPhone
Telephone number of the railroad contact. Source: Problem Log