Data Base view creation on WOT on FSE available hours

[prosenjitsarkar]

Hello All,

I want to create a data base view for all FSE who are assigned to WOTs and how many hours they are available when I filter on particular day.

Usually we consider 8 hours as fixed hours for each FSE and then minus the (total time travel + Work duration) on planned hours.

What is the best suggestion to do this, so that any  given point Resource Allocation team can easily pull up those FSE who has hours available of that day ? Will a data base view be good option ?

[Francisco javi2]

Hi.

As I understand it, you can't perform arithmetic operations in the definition of a database view. I understand that you want to subtract from the working hours the time they've spent attending the WOTs, right? The only way I see is by adding a function field to the table and then using it in the database view.

Display function results in a database view

Best regards,

[prosenjitsarkar]

Thats a good suggestion, let me try that, will keep posted.

[Joshua Chen FX]

another option, have you explored the possibility of using capacity management ?  
-as of yokohoma, there is a territory planning console for your resource allocation team
-you have ootb tables added such as:

Capacity Usage [wm_capacity_usage]

Stores the capacity used by an internal field service agent or a group within a specific time period.

Field Service Capacity and Reservations Management components