Resource Aggregates Monthly: Why are Person Days different for different users in the same month?

ctr-vbasani
Tera Contributor

3 weeks ago

Hi Community,

I'm investigating the Resource Aggregates Monthly [resource_aggregate_monthly] table and noticed that for the same month, different users have different Person Days values.

For example, for the month starting 2026-07-01, some users have 22 Person Days while others have 23 Person Days, even though they appear to be active resources during the same period.

I'm trying to understand:

  1. How is the Person Days value calculated in the Resource Aggregates Monthly table?
  2. Is it derived from:
    • User schedules?
    • Resource plans/allocations?
    • Holidays or schedule exceptions?
    • User availability/FTE?
  3. Which scheduled job or process populates the resource_aggregate_monthly records?
  4. What should I compare between two users (one showing 22 days and another showing 23 days) to determine the reason for the difference?
  5. Are there specific tables or calculations involved that can explain why one user has fewer Person Days than another for the same month?

Any insights into the calculation logic, related tables, or debugging steps would be greatly appreciated.

Thank you!

0 Helpfuls
  • 353 Views
1 REPLY 1

Vikram Reddy
Tera Guru

3 weeks ago

Hello @ctr-vbasani,

 

Person Days on resource_aggregate_monthly isn't a fixed number for a calendar month, it's derived per resource, so a 1-day gap between two users for the same month is expected once their inputs differ. The relationship is the same one used for planned hours: hours equal Person Days times Average Daily FTE Hours divided by Hours Per Person Day, so the Person Days figure is really just that user's working days for the month (per their schedule) converted through their own FTE Hours setting.

For the two users showing 22 vs 23, compare these:

  • the schedule assigned to each resource (sys_user.schedule or the group/role schedule they inherit), since different schedules carry different holiday calendars
  • whether one schedule has a Schedule Entry of type Excluded for a holiday in July that the other schedule doesn't include
  • the Average Daily FTE Hours field on each user record, which falls back to the com.snc.resource_management.average_daily_fte property when blank
  • whether either resource's plan or allocation only covers part of the month (start/end dates mid-month)

If none of that explains it, run Resource Diagnostics (needs the pps_admin role) to check for a corrupted aggregate record, and if the numbers still look wrong after a schedule or FTE hours change, the "Update FTE and Person Days in Resource Aggregates" scheduled job is what refreshes those existing aggregate rows.

References

 

Thank you,
Vikram Karety
Octigo Solutions INC