Examples of Loading Department Tree Nodes

You can load any organization that has the Department classification as a tree node to a department tree version. This topic shows how to load Department Tree Node objects using HCM Data Loader.

Creating Department Tree Nodes

This example DepartmentTreeNode.dat file loads department tree nodes to an existing department tree version.

METADATA|DepartmentTreeNode|TreeStructureCode|TreeCode|TreeVersionName|DepartmentName|ParentDepartmentName
MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|Department Tree Code|Tree Version Jan|Vision University|
MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|Department Tree Code|Tree Version Jan|School of Arts and Science|Vision University
MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|Department Tree Code|Tree Version Jan|Drama|School of Arts and Science
MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|Department Tree Code|Tree Version Jan|Languages|Vision University
MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|Department Tree Code|Tree Version Jan|French|Languages
MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|Department Tree Code|Tree Version Jan|German|Languages

Vision University is at the top of the hierarchy. It inherits the School of Arts and Science and the Languages departments. The School of Arts and Science inherits the Drama department. The Languages department inherits the French and German departments. — This figure shows the hierarchy nodes that this DepartmentTreeNode.dat file creates.

Deleting Department Tree Nodes

You can delete Department Tree Node objects using HCM Data Loader. The departments are removed from the tree version, but the department objects themselves continue to exist. To delete a department tree node and all nodes below it in the department tree hierarchy, set the DeleteChildNodesFlag attribute to Y. This example DepartmentTreeNode.dat file deletes a node and its child nodes.

METADATA|DepartmentTreeNode|TreeStructureCode|TreeCode|TreeVersionName|DepartmentName|DeleteChildNodesFlag
DELETE|DepartmentTreeVersion|PER_DEPT_TREE_STRUCTURE|Department Tree Code|Tree Version Jan|Languages|Y

Vision University is at the top of the hierarchy. It inherits the School of Arts and Science department. The School of Arts and Science department inherits the Drama department. — This figure shows the hierarchy after deleting the Languages node and its child nodes.

To delete a department tree node and promote its child nodes, set the DeleteChildNodesFlag attribute to N. This example DepartmentTreeNode.dat file deletes a node and promotes its child nodes.

METADATA|DepartmentTreeNode|TreeStructureCode|TreeCode|TreeVersionName|DepartmentName|DeleteChildNodesFlag
DELETE|DepartmentTreeVersion|PER_DEPT_TREE_STRUCTURE|Department Tree Code|Tree Version Jan|Languages|N

Vision University is at the top of the hierarchy. It inherits the Schools of Arts and Science, French, and German departments. The School of Arts and Science inherits the Drama department. — This figure shows the hierarchy after deleting the Languages node and promoting its child nodes.