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:
prj_blb_slices_m_alc 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.
prj_blb_slices 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.