PES_AttributeType

PES_AttributeType stores the data type for specific attribute types, such as integer, text, etc.

Columns

Name Type Length Description
atyp_UID smallint 2 Attribute type ID.
atyp_Name nvarchar 400 Attribute type name.
atyp_Name sysname 400 Attribute type system name.
atyp_NativeType nvarchar 400 Attribute type.
atyp_NativeType sysname 400 System name of attribute type.
atyp_UIType nvarchar 400  
atyp_UIType sysname 400  
ru_UID tinyint 1  
nsp_UID int 4  

Agile Planner Representation

The data type for attributes is represented in the Configuration | Attributes Setup view, under the Attributes tab.

image

SQL Example

SELECT*
FROM PES_AttributeType
atyp_UID atyp_Name                    atyp_NativeType                                          atyp_UIType                                              ru_UID nsp_UID
-------- ---------------------------- -------------------------------------------------------- -------------------------------------------------------- ------ --------
1        date                         System.DateTime                                          System.DateTime                                          2      1
2        integer                      System.Int32                                             System.Int32                                             1      1
3        flag                         System.Boolean                                           System.Boolean                                           0      1
4        text                         System.String                                            System.String                                            0      1
5        float                        System.Double                                            System.Double                                            1      1
6        money                        System.Double                                            System.Double                                            1      1
10       startmilestone               System.String                                            System.DateTime                                          2      1
11       milestone                    System.String                                            System.DateTime                                          0      1
12       ranged calculation           System.Double                                            System.Double                                            0      1
13       percent                      System.Double                                            System.Double                                            0      1
14       Timephased - FTE             System.Double                                            System.Double                                            0      1
15       Timephased - UNITS           System.Double                                            System.Double                                            0      1
16       Timephased - CURRENCY        System.Double                                            System.Double                                            0      1
17       Timephased Calc - FTE        System.Double                                            System.Double                                            0      1
18       Timephased Calc - UNITS      System.Double                                            System.Double                                            0      1
19       Timephased Calc - CURRENCY   System.Double                                            System.Double                                            0      1
20       Timephased Calc - HOURS      System.Double                                            System.Double                                            0      1
21       constant                     System.Double                                            System.Double                                            0      1
22       investment                   PacificEdgeSoftware.Common.ObjectServices.PESObject      PacificEdgeSoftware.Common.ObjectServices.PESObject      0      1
23       Large Text                   System.String                                            System.String                                            0      1
24       Scorecard                    System.Double                                            System.Double                                            0      1
25       Notes Grid                   System.String                                            System.String                                            0      1
26       time                         System.DateTime                                          System.DateTime                                          0      1
27       url link                     PacificEdgeSoftware.Common.ObjectServices.LinkContainer  PacificEdgeSoftware.Common.ObjectServices.LinkContainer  0      1
28       resource                     System.Int32                                             System.Int32                                             0      1
29       Timephased - NonLabor        System.Double                                            System.Double                                            0      1