PES_ProjectTaskDimension

This table contains data for dimensioned attributes of a task, such as Start, Finish, and Work.

Column	Data Type	Description
obj_UID	int	A unique identifier that specifies the ID of the task. This value appears in the PES_ProjectTask 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 particular task.
tsd_Start	datetime	The start date of a task.
tsd_Finish	datetime	The finish date of a task.
tsd_Work	float	The amount of work (labor and non-labor) for a particular item.
tsd_Cost	float	The labor cost for a particular item.
tsd_NonLaborCost	float	The non-labor cost for a particular item.
tsd_TotalCost	float	The combined labor and non-labor cost for a particular item.

With tasks, 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.

The parent_UID for the root task is -6. This can be used to select the summary task. This is useful for reporting on a rolled up value such as total planned work, total actual work, duration, whether the entire task plan has been marked PM completed, and so on.

MACRO: PES_MACRO_PROJECT_TASK. Use the "@" symbol to specify the dimension from which you want to display task data. For example:

SELECT * FROM PES_MACRO_PROJECT_TASK(task, 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))