dbo.optimoRouteDriverDay

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.optimoRouteDriverDay.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Surrogate primary key of the driver-day record.
2	PlanDate	datetime	no		Date of the route plan this driver-day summary covers.
3	EstimatorID	uniqueidentifier	yes		Prime Ecosystem user ID of the estimator/driver assigned to this route day.
4	DistanceKms	decimal(12,4)	yes		Total driving distance in kilometres for the route as planned by OptimoRoute.
5	DurationMins	int	yes		Total driving duration in minutes for the route as planned by OptimoRoute.
6	Stops	int	yes		Number of stops (job appointments) scheduled on this route day.
7	WorkFromTime	time(7)	yes		Start of the driver's working window for the day.
8	WorkToTime	time(7)	yes		End of the driver's working window for the day.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_optimoRouteDriverDay	CLUSTERED	yes	yes	ID

Relationships (inferred)

From	To	Confidence
dbo.optimoRouteDriverDay.EstimatorID	dbo.primeUsers.id	high
dbo.optimoRouteDriverDay.EstimatorID	dbo.ethBookingEstimatorSkill.primeEstimatorID	high
dbo.optimoRouteDriverDay.PlanDate	dbo.ethBookingDaySlot.Date	high

Referenced by

Procedures: dbo.spEthBookingGetAvailability, dbo.spEthBookingGetAvailabilityByEstimator, dbo.spEthBookingGetAvailabilityDetails, dbo.spEthBookingGetAvailabilityGeo, dbo.spOptimoRouteDriverDayClear, dbo.spOptimoRouteDriverDayGetWorkTime, dbo.spOptimoRouteDriverDayUpsert, dbo.spOptimoRouteDriverDayUpsertDurationMins, dbo.spOptimoRouteDriverDayUpsertWorkTime, dbo.spOptimoRouteGetAllowSpecificTimeBookings