Which table in the database corresponds to the 'Allocation' values on the Project Team Staff page?

Document ID : KB000022471
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Which table in the database corresponds to the 'Allocation' values on the Project: Team: Staff page? 

Answer:

Finding the corresponding tables that maps to various attributes and fields in the applicationis very useful when creating custom reports and portlets. Additional information on the database tables can be found in the Technical Reference Guide which is available in the DocOps Wiki product pages.

The Total Allocation for the Team Staff Member can be found on PRTEAM.PRALLOCSUM. This column is the total allocation of the resource to the project, in units of seconds for labor and equipment resources. This column is set by the time slicing background process which cracks the BLOB field into readable numbers.  

The time-varying segment data you see on the Team, Detail page uses an internal or 'insta-slice' time slice definition and it is limited in date range and if you query the data from this slice you may not get the full data you expect.

For using the slice data in reporting or queries, it is best to use visible, external Time Slice definitions.  Go to Administration, Time Slices page and sort the list by 'Item'.  The stock time slice used in the application for Resource Finder and Datamart allocations is Slice #10 - DAILYRESOURCEALLOCCURVE.

Additional Information:

The following articles relate to the use of the DAILYRESOURCEALLOCCURVE Time Slice data.

Reference TEC439131 : Where is the resource Default % Allocation field stored in the database

Reference TEC439075 : How do I read data from the Daily Time Slices?

Reference TEC435572 : How should I configure my Time Slices ?       

Reference TEC564415 : Match scores may be inaccurate if availability dates do not fall within the following range

Reference TEC440242 : Resource Finder is displaying a 100% availability match for resources already 100% allocated

Reference TEC438916 : The 'Include Soft-booked Resources' does not appear to function when using the resource requisition filter