FWDriver

Attribute Name	Type	Field Size	Description	Required
DriverID	int	4	Unique internal DB Identifier of the driver record.	Required
DriverKey	nvarchar	50	Business key to identify the activity this driver refers to.	Required
DriverFirstName	nvarchar	255	First name of the driver.	Required
DriverLastName	nvarchar	255	Last name of the driver.
ModifiedBy	int	4	See ModifiedBy under Generic Attributes.
ModifyDate	datetime	8	See ModifyDate under Generic Attributes.
DeviceKey	nvarchar	50	Unique Business Key that identifies the handheld device assigned to this driver. Used for wireless purposes.
LocationID	int	4	Unique internal DB Identifier. Sets the relationship between the FWLocation and the FWDriver tables. This field defines the driver’s address.
LicenseNumber	nvarchar	50	The license number of the driver.
LicenseIssueDate	datetime	8	The issue date of the license.
LicenseExpDate	datetime	8	The expiration date of the license.
EarliestStartTime	datetime	8	The earliest start time for the driver.
LatestStartTime	datetime	8	The latest start time for the driver.
EarliestEndTime	datetime	8	The earliest end time for the driver.
LatestEndTime	datetime	8	The latest end time for the driver.
Active	int	4	When this attribute is ’r;Active’ the driver is active or available. When it is ’r;Inactive’ the driver is inactive or not available.
CostProfileID	int	4	Identifies the cost profile of the driver
Email	nvarchar	50	The email address of the driver.
wGLNSyncInd	bit		Can be set to true or false depending on the response from wGLN. 0 &endash; Failure. wGLN does not have the latest changes. 1 &endash; wGLN is in sync with Route Planner.
wGLNResponse	nvarchar		This field holds the response from wGLN.
Comment	nvarchar	500	It is used to provide additional information about a specific record.
ExtDocControlID	nvarchar	250
Role	nvarchar	256	Stores the role of the driver in according to the crew assignment
ServiceSpeedFactor	float	8	Service Speed Factor is driver skill factor or efficiency. It works together with FwResource.ServiceSpeedFactor. If Driver factor is set up, it replaces Resource factor. Driver factor is used in current service duration formula as a divider. If it is less than 1, the resulting service duration is larger than the standard service duration. If greater than 1, the result is shorter (that is, more efficient).
Certificates	nvarchar	250	Certificates that this driver has to drive asset types.