search cancel

Monthly Allocation Tables

book

Article ID: 189945

calendar_today

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.