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