PES_WorkItemAssignmentDimension

This table contains data for dimensioned attributes of a work item.

Column	Data Type	Description
obj_UID	int	A unique identifier. Every record in the table has a unique ID.
dim_UID	int	The ID of a dimension. This value appears in the PES_Dimension table.
tsd_Duration	float	The duration of a particular work item.
tsd_Start	datetime	The start date of a work item.
tsd_Finish	datetime	The finish date of a work item.
tsd_Work	float	The amount of work for a particular item.
tsd_Cost	float	The cost for a particular item.

With work item assignments, you can select directly off the tables when looking for the system attributes specified above. If you have custom attributes, you will need to use the macro. If you are selecting both dimensioned and non-dimensioned attributes, you may find it easier to use a macro rather then joining the tables together.

MACRO: PES_MACRO_WORK_ITEM_ASSIGNMENT. Use an "@" symbol to specify the dimension from which you want to display assignment data. For example:

SELECT * FROM PES_MACRO_WORK_ITEM_ASSIGNMENT(work,
obj_ProjectUID = 281, Description, tsk_Completed, tsk_PMCompleted,
tsk_RemainingWork, tsk_PercentWorkComplete, tsd_Duration@Plan,
tsd_Start@Plan, tsd_Finish@Plan, tsd_Work@Plan, tsd_Cost@Plan,
tsd_Duration@Actual, tsd_Start@Actual, tsd_Finish@Actual,
tsd_Work@Actual, tsd_Cost@Actual)