Which tables can provide the mapping of resource to project/idea allocation month-wise?
Release : 15.6.1
Component : CA PPM SAAS APPLICATION
The monthly allocations can be found in either of these two tables:
This first table is used by the out of the box portlets and views in the system. This contains the monthly allocation slices that you see in the monthly time scales. This is using an internal slice that is not available under the Administration - Time Slices page.
This second table is used by the out of the box reports. This table contains more than just the monthly allocation slices, so we would have to look at the rows where the slice_request_id = 6. The 6 being the slice ID of the MONTHLYRESOURCEALLOCCURVE slice. If needed, the range of this slice can be modified in the UI under the Administration - Time Slices page. In this table, the PRJ_OBJECT_ID column contains the internal team id of the resource.