PES_WorkItemTaskDimension

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

Column Data Type Description
obj_UID int A unique identifier that specifies the ID of the task. This value appears in the PES_WorkItemTask table.
dim_UID int Specifies the ID of the dimension. This value appears in the PES_Dimension table.
tsd_Duration float The duration of a 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 work item.
tsd_Cost float The cost for a particular work item.

With work items, 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_TASK. Use an "@" symbol to specify the dimension from which you want to display work item task data. For example:
SELECT * FROM PES_MACRO_WORK_ITEM_TASK(work, obj_ProjectUID = 281, Description, tsk_Completed, tsk_PMCompleted, tsk_RemainingWork, tsk_PercentWorkComplete, tsk_CapEx, 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)