Hi Anthony,

Not being a DSE expert, I discussed this with someone who is based on your questions.  This is their response:

Basically, every agent is having BWORK address as a default.

User can set start shift and/ or end shift addresses in addition for this address.

DSE will calculate the travel from/ to those addresses as long as they are valid addresses and having effective start and end dates.

Each and every route that the DSE is calculating, is taking those address into consideration and the schedule will be affected by it..

How it will affect? It’s really depend on the DSE setup (travel cost, maximum travel limitation, etc. ).

For example, If the agent is having one call on his route, DSE will calculate the travel from the start shift address for the service order’s address and from that address for the end shift address.

That is of  course a basic example. There can be a lot of combinations, depending on the amount of agents and customer’s addresses.

If they are working with GIS, all this data is saving on constant_routes_no_traffic table based on the Longitude and Latitude data.

Hopefully this response addresses the questions you raised.

HI @Phil Seifert 

Please
Could you ask to the R&D team if we can have a key between the table Demand_schedule and the Constant_routes_no traffic in order to have the last travel between the order and the endshift.
In the DSE allocation report, we use this Data of the last travel, so this data may be in a table ?
 

Thanks and Regards

anthony

Hi Anthony,

That is a difficult question and do not think there is a direct key between the tables.  As the subject matter expert indicated in his response:

If they are working with GIS, all this data is saving on constant_routes_no_traffic table based on the Longitude and Latitude data.

I have asked the question and will relay their response once provided.

In the meantime, just looking at the tables generally what I suspect is the demand_labor has an address stored in the to_address_id which should be where the agent is going for the work order.  From this ID, you would have the GIS coordinates to search the constant_routes_no_traffic table based on those GIS values in the from_latitude, from_longitude and I would think you would have to also use the to_latitude, to_longitude to find the GIS coordinates for the home address IF that is populated into this table.

Again, not being an expert this is what I see and looks fairly complex.  I think at this point, once we have received the response, you may be better served to work with Services to develop a solution for what you want to do instead of building your own due to this complexity.