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 items. In addition, resource allocations have other properties associated with them such as resource roles and contours.

Column Data Type Description
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.
MACRO: PES_MACRO_RESOURCE_ALLOCATION. For example:
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