PES_RollupType

PES_RollupType stores the rollup type for a specific attribute.

Columns

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

SELECT*
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