Database Table Reference → PES_Object
PES_Object stores information about specific investments.
| 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. |