PES_Object

PES_Object stores information about specific investments.

Columns

Name Type Length Description
obj_UID int 4 Primary key for the investment ID.
obj_ParentUID int 4 Parent object ID.
cls_UID smallint 2 Foreign key to PES_Class.
obj_HasChildren bit 1 Field for optimization.
obj_Name nvarchar 200 Investment name.
obj_LastChange datetime 8 Date and time for the last modification to the investment.
obj_EditMapping ntext 16 Editability of attributes associated with the investment.
obj_BinData image 16 Attribute values stored as binary data.
obj_TransitionUID int 4 Investment transition ID.
obj_RootFolderID uniqueidentifier 16 ID of the root folder.
obj_MSPDocumentID uniqueidentifier 16 Not relevant for Agile Planner.
obj_Description nvarchar -1 Investment description.
obj_CreatedBy int 4 ID of the user that created the investment.
obj_CreatedDate datetime 8 Date and time when the investment was created.
obj_LastChangeBy int 4 ID of the user that last updated the investment.
obj_CanSelfAllocate bit 1 Not relevant for Agile Planner.
obj_CanSelfAssign bit 1 Not relevant for Agile Planner.
obj_LockAssignmentWhenComplete bit 1 Whether assignment should be locked when completed.
obj_LastUserChangeDate datetime 8 Ignore this column.
obj_LastUserChangeBy int 4 Ignore this column.
obj_HideOnTimesheet bit 1 Not relevant for Agile Planner.
obj_RequestorEmail nvarchar 200 Not relevant for Agile Planner.
obj_ResourceCompleteAffectsPlan bit 1 Not relevant for Agile Planner.

Agile Planner Representation

Investments data stored in PES_Object is represented in the investment hierarchy in Agile, for example under the Projects view.

image