Monthly Allocation Tables
Article ID: 189945
Updated On:
Products
Clarity PPM SaaS
Issue/Introduction
Which tables can provide the mapping of resource to project/idea allocation month-wise?
Environment
Release : 15.6.1
Component : CA PPM SAAS APPLICATION
Resolution
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.
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.
Feedback
Yes
No
Powered by
