FWGPSStatus

Attribute Name	Type	Field Size	Description	Required
GPSStatusID	int	4	Unique internal DB Identifier of the GPS status record.	Required
RouteID	int	4	Unique internal DB Identifier of the Route record. Must exist on the FWRoute table.
DateTime	datetime	8	Date/ time stamp reported in the GPS Message.
Latitude	float	8	In conjunction with Longitude attribute, provides geographic position of address. For use with non-geocodable addresses, or in longhaul situations where the map does not support geocoding.
Longitude	float	8	In conjunction with Latitude, provides geographic position of address. For use with non-geocodable addresses, or in longhaul situations where the map does not support geocoding.
ModifiedBy	int	4	See ModifiedBy.
ModifyDate	datetime	8	See ModifyDate.
ResourceKey	nvarchar	50	Business key to identify the Resource this GPS status refers to. Must exist on the FWResource table.
Ignition	bit	1	Indicates if this GPS reports Ignition on or off. · 0 - Off · 1 - On · Null – not reported
Odometer	float	8	Stores the odometer reading reported in the incoming gps status message
UnscheduledStop	bit	1	Indicates if this GPS reports a unscheduled stop on or off · 0 - Off · 1 - On · Null – not reported
Speed	float	8	Stores the speed reported in the GPS Status message
Direction	nvarchar	50	Stores the direction reported in the GPS Status message
DriverKey	nvarchar	50	Stores the DriverKey reported in the GPS Status message
TractorKey	nvarchar	50	Stores the TractorKey reported in the GPS Status message
TrailerKey	nvarchar	50	Stores the TrailerKey reported in the GPS Status message
Temperature	float	8	Stores the Temperature reported in the GPS Status message
StopID	int	4	StopID the gps message is related to
StartOdometer	int	4	Beginning odometer of the vehicle
EndOdometer	float	8	Ending odometer of the vehicle
LastReportedTimeZone	nvarchar	100	Time zone of last reported time
DateTimeUTC	datetime	8	Time stamp of the gps status in UTC
WirelessSource	nvarchar	20	Allows wGLN to detect whether the submitted status information was sent by driver, black box or ASU
AVLCounter	int	4	Stores the counter for AVL parameters