Route Fields

This section provides a list of route fields.

Field	Label	Data Type	Mandatory	Description
Resource External ID	provider.external_id	VARCHAR2	True	External system identifier for the resource for which the user is assigned to.
Resource TIme Zone	time_zone.name	VARCHAR2		Standard Oracle Time zone name
Route Activation Time	queue.activated	DATE		Date and time of route activation for resource for whom the activity is provided.
Route Date	queue.date	DATE	True	Date of the route the activity is assigned to.
Route Deactivation Time	queue.deactivated	DATE		Date and time of route deactivation (for already activated route) for resource for whom the activity is provided.
Route Reactivation Time	queue.reactivated	DATE		Date and time of route reactivation (for already deactivated route) for resource for whom the activity is provided.
Traveling Time (final location)	queue.final_travel	INTEGER		Travel to the final location of resource for whom the activity is provided.
Working Day End	queue.calendar_time_to	DATE		End of working day (Date and time) for the resource for whom the activity is provided.
Working Day Start	queue.calendar_time_from	DATE		Start of working day (Date and time) for the resource for whom the activity is provided.