Incorrect entries in "Resource Aggregates Monthly" table?

oleg7
Tera Contributor

We run reports on Resource Aggregates Monthly table and I noticed that some of "non-project time"-entries don't have any task specified.

How is that possible and what can those be? Task-field is always mandatory when creating new resource plans:

 

find_real_file.png

 

Having those "empty" entries we can't perform proper planning as resource allocation does not reflect real situation.

5 REPLIES 5

Noah Drew
ServiceNow Employee
ServiceNow Employee

Hi @oleg !

This is indeed possible. When you Allocate users for Operational Resource Plans (Meeting, Admin, etc...) then no specific task is associated but they still have hours for the type.

You can verify this by:

1. Go to Resource > Resource Plans > Create New Operational Plan

2. Pick a single user, specify dates, set Operational Work Type to "Admin"

3. Allocate the Resource Plan

4. Check the resource_aggregate_daily table for the non-project time days.

Hope that helps!

If it did please mark as Helpful and consider setting the reply as the Correct Answer to the question, thanks!