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))