PowerExchange for PeopleSoft supports trees with strictly enforced levels. In a strict-level tree, each branch of the tree progresses logically through the hierarchy of levels from the root node to the final branch node of a winter tree or the detail range of a detail tree. PeopleSoft assigns a level to each node based on its position in the tree.

Strict-level trees can contain branches with skipped or missing nodes. Skipped or missing nodes result in different sets of data but do not affect the structure of the tree or the imported source definition.

For example, PeopleSoft Trees has no skipped or missing nodes. The following figure is a strict-level tree with missing nodes:

The tree contains defined levels, and all branches progress logically through the hierarchy of levels. The top level, or root node level, is the country US. Level 2 is a branch node level with the East and West regions. Level 3 is another branch node level consisting of states in each region.

The US-DC branch skips the region node level. The tree also contains a branch, US-W, with a missing state node level. In this strict-level tree, branches cannot be configured to alter or reverse the hierarchy of levels. For example, you cannot have the state node above the country node, such as DC-US.

The PowerCenter Integration Service denormalizes strict-level trees using either vertical or horizontal flattening.