PES_Attribute stores information about attributes, as defined from the Attributes Setup view. This includes the visible and system names, default value, and display value.
Columns
| Name | Type | Length | Description |
| att_UID | int | 4 | Primary key. |
| att_Name | nvarchar | 100 | Name of the attribute. |
| att_XMLName | nvarchar | 120 | unique name of the attribute. |
| atyp_UID | smallint | 2 | Foregin key to PES_AttributeType. |
| ru_UID | tinyint | 1 | Foreign key to PES_RollupType. |
| att_IsCalculated | bit | 1 | Whether the attribute is a calculated attribute. |
| att_IsDimensioned | bit | 1 | Whether the attribute is a dimensioned attribute. |
| att_Formula | ntext | 16 | MathML calculation definition. |
| lst_UID | int | 4 | Foreign key to PES_List. If this is a list attribute, this is the PES_List that it is based on. |
| att_DefaultValue | nvarchar | 2000 | Default value for the attribute. |
| att_IsGlobal | bit | 1 | Whether the attribute is global. Global is required for investments and optional for work items. |
| att_IsSystem | bit | 1 | Whether the attribute is a system attribute. System attributes can't be deleted. |
| att_IsActive | bit | 1 | Whether the attribute is active. |
| att_IsConnectorable | bit | 1 | Obsolete. |
| nsp_UID | int | 4 | Foreign key to PES_Namespace. |
| att_UserModified | bit | 1 | Whether the attribute is user-modifiable. |
| att_IsIndexed | bit | 1 | Whether the attribute is indexed. |
| stl_UID | int | 4 | Foreign key to PES_StorageLocation. |
| att_IsEditable | bit | 1 | Whether the attribute is editable. |
| att_Mapped | bit | 1 | Obsolete. |
Agile Planner Representation
The attribute information stored in PES_Attribute is represented in Agile Planner in the Configuration | Attributes Setup view, under the Attributes tab.
SQL Example
SELECT*
FROM PES_Attribute
att_UID att_Name att_XMLName atyp_UID ru_UID att_IsCalculated att_IsDimensioned att_Formula lst_UID att_DefaultValue att_IsGlobal att_IsSystem att_IsActive att_IsConnectorable nsp_UID att_UserModified att_IsIndexed stl_UID att_IsEditable att_Mapped
----------- --------------------------- ------------------------- -------- ------ ---------------- ----------------- ------------ ----------- ----------------- ------------ ------------ ------------ ------------------- ----------- ---------------- ------------- ----------- -------------- ----------
1 Name Name 4 0 0 0 NULL 1 1 1 1 1 NULL 1 1 1 0
2 Description Description 4 0 0 0 NULL 1 1 1 1 1 NULL 1 1 1 0
3 Created By CreateBy 4 0 0 0 NULL 1 1 1 1 1 NULL 0 1 0 0
4 Created Date CreationDate 1 0 0 0 NULL NULL NULL 1 1 1 0 1 NULL 0 1 0 0
5 Concurrency Modified By LastModifiedBy 4 0 0 0 NULL NULL NULL 1 1 1 0 1 NULL 0 1 0 0
6 Concurrency Timestamp Date LastModifiedDate 1 0 0 0 NULL NULL NULL 1 1 1 0 1 NULL 0 1 0 0
7 Start StartMS 10 2 0 1 NULL 1001 NULL 1 1 1 1 1 NULL 0 3 1 0
8 Investment ID id 2 0 0 0 NULL NULL NULL 1 1 1 0 1 NULL 0 1 0 0
9 Parent Parent 22 0 0 0 NULL NULL NULL 1 1 1 0 1 NULL 0 1 0 0
10 Transition State TransitionState 4 0 0 0 NULL NULL NULL 1 1 1 0 1 NULL 0 1 0 0
11 Investment Type PES-Investment-Type 4 0 0 0 NULL NULL NULL 1 1 1 0 1 NULL 0 1 0 0
12 Parent ID Parent-ID 2 0 0 0 NULL 1 1 1 1 1 NULL 0 1 0 0
13 Dependency Source ID PES-Dependency-Source-ID 2 0 0 0 NULL NULL NULL 0 1 1 0 1 NULL 0 1 0 0
14 Dependency Target ID PES-Dependency-Target-ID 2 0 0 0 NULL NULL NULL 0 1 1 0 1 NULL 0 1 0 0
15 Resource Type res_ResourceType 2 0 0 0 NULL 1002 NULL 0 1 1 1 1 NULL 0 2 1 0
16 Resource Last Name usr_LastName 4 0 0 0 NULL NULL NULL 0 1 1 1 1 NULL 0 2 1 0