Reference → Data Dictionary → Instance Data Table Summary → PES_ProjectAssignment
This table contains information about the assignments that are associated with an item.
|obj_UID||int||A unique identifier. Every record in the table has a unique ID.|
|obj_Name||nvarchar(100)||The name of a particular assignment.|
|obj_ProjectUID||int||The ID of the item to which this assignment belongs.|
|obj_TaskUID||int||The ID of the task to which an assignment belongs.|
|obj_AllocationUID||int||The ID of the allocation that an assignment is part of. This can be used in a join to find out the allocation and resource.|
|prv_Published||bit||A value of "1" means this particular assignment 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 assignment. This data is stored in binary and requires a macro to extract it.|
|obj_Description||ntext||The description of a particular assignment.|
|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). May be the same value as obj_LastChangeBy.|
|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_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 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.
SELECT * FROM PES_MACRO_PROJECT_ASSIGNMENT(assn, obj_ProjectUID = 281, Description, tsk_Completed, tsk_PMCompleted, tsk_RemainingWork, tsk_PercentWorkComplete)
Copyright © 2003–2011 Serena Software, Inc. All rights reserved.