FWAVLParm

 

Attribute Name

Type

Field Size

Description

Required

AVLParmID

int

4

Unique internal DB identifier of the AVLParm record.

Required

ScheduleID

int

4

Unique internal DB identifier of the Schedule record. Must exist in the FWSchedule table.

Required

RouteThreshold

float

8

Distance for Route Geofence

 

RouteThresholdUnit

nvarchar

10

Distance units for Route Geofence Distance

 

StopThreshold

float

8

Distance for Stop Geofence

 

StopThresholdUnit

nvarchar

10

Distance units for Stop Geofence distance

 

DistanceAssessment

bit

1

Field to determine if along the road is used to calculate the geofence distance for both, route and stops.

·        0 – Do not use along the road

·        1 - use along the road

 

AVLStatusRefreshCycle

int

4

Number of GPS messages to recalculate the route

 

MobilityWindow

int

4

Time interval to check when a resource has not reported gps or status messages

 

MinAvgSpeed

float

8

Specifies the minimum speed allowed in a vehicle befre reporting a mobility alert (vehicle is not moving or moving very slow)

 

SpeedUnit

nvarchar

10

Speed units

 

MinTemperature

float

8

Specifies the minimum temperature that the temperature is allowed before an alert is triggered.

 

AutomaticEnrouteonGPS

bit

1

This field defines whether or not the application will set the status to Enroute automatically once the first GPS message is received

 

ServiceDurationTolerance

int

4

Specifies the maximum time a ServiceDuration can be exceeded before raising an alert. A value of 0 will turn off this notification.

 

DepartStopTolerance

int

4

Specifies the maximum time a route stays in a stop that has been completed. A value of 0 will turn off this notification.

 

StartTimeTolerance

int

4

Specifies the maximum exceeding time a route is allowed to delay its start before raising an alert. A value of 0 will turn off this notification.

 

AutoCorrectGeocodeInd

bit

8

This field will turn on or off Autocorrection on Geocoding information based on actual. Possible values:

0 – Off

1 – On

 

AutoCorrectGeocodeAfter

int

8

The field will define the number of successful GPS readings before doing the correction of the latitude/longitude.

 

AutoCorrectDistance

int

8

This field will define the distance threshold that will decide if a latitude/longitude reading is a candidate of autocorrection. If all the readings (defined by the AutoCorrectGeocodeAfter value) are within this distance from each other, then the latitude/longitude saved in the database will be corrected only for those locations where the LocLatLong field is off.

 

DepartDistanceThreshold

int

4

This field will specify the distance threshold to consider when a vehicle has left the stop

 

SpeedTolerance

int

4

This field will specify the speed tolerance allowed by a vehicle before a Speeding alert is created. Meters/Second

A value of 0 will turn off this notification

 

RemainingRoutingTime

int

 

This field defines the number of maximum number of seconds before a route ends. If the remaining time of the route is less than this number, then an alert will be raised.

 

RemainingRoutingDistance

float

 

This field will specify the distance threshold to consider when a vehicle has left the stop

 

RemainingStops

int

4

This field defines the number of maximum number of stops before a route ends. If the remaining stop of the route is less than this number, then an alert will be raised.

 

AlertNoStopsPending

int

 

This field defines the number (integer) of stops that are in pending before the route is completed. Pending equivalent status include:

• Pending

• Delayed

• Enroute

• Skipped

 

RemainingRoutingTime

int

 

This field defines the number of maximum number of seconds before a route ends. If the remaining time of the route is less than this number, then an alert will be raised.

 

RemainingRoutingDistance

int

 

This field defines the number of maximum number of meters before a route ends. If the remaining distance of the route is less than this number, then an alert will be raised.

 

MaxTemperature

float

8

Specifies the maximum temperature that the temperature is allowed before an alert is triggered.