I have a need to report about the demand by role on Ideas and projects. In the case of the Ideas its Team tab is for the most part populated with roles within our organization. While running a SQL query against the PRJ_BLB_Slices for Daily allocations, I noticed that it holds the daily allocations just for named resources and not for roles..
- So is there there is a specific time slice for roles or is it in the same slice as that of named resources. The PRID column of the PRTeam table is what I used to query the PRJ_BLB_Slices and got only the rows for named resources on the team.
- If the allocation of Roles are kept in a different slice then what is the name of the Slice Request and what ID does one use to query this slice
Roles and Resource allocation information stores on same time slice. You can check either slice table or insta Slice table
Slice Table:
PRJ_BLB_SLICES
Insta Slices:
PRJ_BLB_SLICES_M_ALC OR PRJ_BLB_SLICES_W_ALC
Thanks
Senthil