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.

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)

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