PES_AttributeType

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