Reference → Data Dictionary → Instance Data Table Summary → PES_ProjectTask
This table contains information about the tasks that are part of an item’s task plan.
|obj_UID||int||A unique identifier. Every record in the table has a unique ID.|
|obj_Name||nvarchar(100)||The display name of a particular task.|
|obj_ParentUID||int||The ID of a task’s immediate parent.|
|obj_HasChildren||bit||Indicates whether the task has any children. A value of "1" indicated that it does.|
|obj_ProjectUID||int||The ID of the item to which the task belongs.|
|prv_Published||bit||Specifies the current state of the task plan wherein the task appears. A value of "1" indicates the task belongs to a checked in plan. A value of "0" means it belongs to a checked out plan.|
|obj_BinData||image||Contains all the custom attribute data for a task. This data is stored in binary and requires a macro to extract it.|
|obj_Description||ntext||The description of a particular task.|
|obj_LastChange||datetime||The last time the object was changed by a user or the system.|
|obj_LastChangeBy||int||The ID of the user who last changed the object (includes system).|
|obj_LastUserChangeDate||datetime||The last time the object was changed by a user (excludes system).|
|obj_LastUserChangeBy||int||The ID of the user who last changed the object (excludes system).|
|tsk_Completed||bit||Indicates whether or not a resource has marked the item as completed. A value of "1" indicates the item has been marked as completed.|
|tsk_PMCompleted||bit||Indicates whether or not a project manager has marked the item as completed. A value of "1" indicates the item has been marked as completed.|
|tsk_CapEx||bit||Indicates that the task is marked as a Capital expense. A value of "1" indicates that the item is a capital expense; a value of "0" means that it is not.|
|tsk_RemainingWork||float||Calculates the value of remaining work (Plan Work minus Actual Work).|
|tsk_PercentWorkComplete||float||Calculates the value of percent work complete (Actual Work v. Plan).|
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. 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.
SELECT * FROM PES_MACRO_PROJECT_TASK(task, obj_ProjectUID = 281, Description, tsk_Completed, tsk_PMCompleted, tsk_RemainingWork, tsk_PercentWorkComplete, tsk_CapEx)
Copyright © 2003–2010 Serena Software, Inc. All rights reserved.