Database Table Reference → PES_AttributeType
PES_AttributeType stores the data type for specific attribute types, such as integer, text, etc.
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 |
The data type for attributes is represented in the Configuration | Attributes Setup view, under the Attributes tab.
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