Reference → Data Dictionary → Instance Data Table Summary → PES_ResourceAllocation
This table contains data for all the resource allocations in the system. Each resource allocation maps a resource to an item. An allocated resource can then be assigned to tasks or work items. In addition, resource allocations have other properties associated with them such as resource roles and contours.
|obj_UID||int||A unique identifier. Every record in the table has a unique ID.|
|obj_ResourceUID||int||The ID of the resource. This value appears in PES_Resource table.|
|obj_ProjectUID||nvarchar(100)||The ID of the item to which the resource is allocated.|
|sks_SkillSetUID||int||The ID of Resource Role that corresponds to this resource or allocation. This value appears in the PES_SkillSet table.|
|obj_BinData||image||Contains all the custom attribute data for an allocation. This data is stored in binary and requires a macro to extract it.|
SELECT * FROM PES_MACRO_RESOURCE_ALLOCATION(alloc, ,Name)or
SELECT inv.obj_Name as Investment, res.obj_Name as Resource FROM PES_ResourceAllocation alloc JOIN PES_Resource res on alloc.obj_ResourceUID = res.obj_UID JOIN PES_Object inv on alloc.obj_ProjectUID = inv.obj_UID
Copyright © 2003–2010 Serena Software, Inc. All rights reserved.