PES_RollupType stores the rollup type for a specific attribute.


Name Type Length Description
ru_UID tinyint 1 Key for the rollup type.
ru_Name nvarchar 200 Rollup type name.
ru_Description nvarchar 200 Rollup type description.

Agile Planner Representation

Rollup type data is represented in Agile Planner in the Configuration | Attributes Setup view, under the Attributes tab.


SQL Example

FROM PES_RollupType
ru_UID ru_Name         ru_Description
------ --------------- --------------
0      none            none
1      sum             sum
2      min             min
3      max             max
4      average         average
5      boolean AND     boolean AND