Summarizing ChartFields Using Trees

This chapter provides an overview of Oracle's PeopleSoft Enterprise ChartField summarization with trees and discusses how to create and maintain trees.

Understanding ChartField Summarization with Trees

Use tree diagrams to organize and maintain the ChartFields. Trees add an intuitive, visual layer, where you can see how detail items in the chart of accounts fit into the big picture. Design tree structures, either detail or summary, from the top down by using the graphical PeopleTools Tree Manager. Next, add ChartField values as leaves to the branches of the tree. In the following example of a balance sheet detail tree structure, The BALSHEET tree node and level is a detail of the ALLACCOUNTS tree node and level, and the (000000) - All Accounts is a detail value reporting to the BALSHEET tree node and level. If you click the ASSETS -Asset Accounts, a range of detail asset accounts appears. This approach ensures definitive hierarchies for all the accounts, programs, and anything in the chart of accounts. To create financial reports or generate rules for summary ledgers, you specify the appropriate tree and indicate the level or branch from which you want to extract data.

Example: Balances Sheet Detail Tree Structure

You can also copy a tree to create another tree and maintain data in the existing trees. For example, you can modify ChartFields in PeopleSoft Tree Manager and the rest of the system automatically uses the updated tree.

Prerequisites

Before you use the PeopleTools Tree Manager to set up the trees, do the following:

Define all of the ChartFields.
Define the organizational structure.
Define ChartField summarization levels.
Define reporting relationships.

Creating and Maintaining Trees

This section discusses how to:

Use PeopleSoft Tree Manager.
Define tree structures.
Create a new tree.
Branch tree nodes.
Copy trees.
Maintain ChartFields in PeopleSoft Tree Manager.
Maintain trees.

Using PeopleSoft Tree Manager

The PeopleTools PeopleBook has a thorough description of how to use Tree Manager.

Defining Tree Structures

The PeopleTools PeopleBook has a thorough description of how to define tree structures.

Creating a New Tree

The PeopleTools PeopleBook has a thorough description of how to create a new tree.

Branching Tree Nodes

The PeopleTools PeopleBook has a thorough description of how to use tree nodes and branching.

Copying Trees

The PeopleTools PeopleBook has a thorough description of how to copy one tree to another.

Maintaining ChartFields in PeopleSoft Tree Manager

The PeopleTools PeopleBook and the “Defining and Using ChartFields” chapter in the PeopleSoft Enterprise Application Fundamentals 9.0 PeopleBook. have thorough descriptions as to how to create and maintain ChartFields in PeopleSoft trees.

Maintaining Trees

The PeopleTools PeopleBook has a thorough discussion of how to maintain existing trees.