WorkList

WorkList stores information about work items in a backlog.

Columns

Name	Type	Length	Description
obj_OwningInvestment	int	4	Product, release, team or sprint backlog. Foreign key to PES_Object obj_UID.
obj_WorkItem	int	4	The foreign key to the PES_AgileWI table.
wkl_Rank	float	8	Rank of the item in the backlog. When you add or re-rank an item, this number is halfway between the previous two neighbors.

Agile Planner Representation

SQL Example

SELECT*
FROM PES_WorkList 
obj_OwningInvestment obj_WorkItem wkl_Rank
-------------------- ------------ ----------------------
922                  923          1
922                  924          101
922                  928          201
922                  929          301
927                  928          200
927                  929          300