PES_WBSHierarchy defines containment rules for work items, including valid parent and children work item types.
Columns
| Name | Type | Length | Description |
| wbs_UID | int | 4 | This table describes the containment hierarchy for agile work items, (for example, Epics contain Stories, Stories contain Tasks and Defects, etc.) |
| cls_ParentUID | smallint | 2 | Foreign key to the PES_Class table. |
| cls_ChildUID | smallint | 2 | Foreign key to the PES_Class table. |
Example
The work breakdown structure hierarchy is represented in Agile Planner in the Configuration | Types Setup view, under the Work Hierarchy tab.
SQL Example
SELECT* FROM PES_WBSHierarchy wbs_UID cls_ParentUID cls_ChildUID ----------- ------------- ------------ 1 0 18 1 0 21 1 0 23 1 0 24 1 0 30 1 18 21 1 18 24 1 23 18 1 23 24 1 30 18 1 30 23 1 30 24