PC_TRCHILD_TAO (SQL Table)	Index Back
Save the children table This is a temporary table used when updating an EPS tree structure. When the tree structure changes, we want to save all the children nodes so that they will not be lost.

PC_TRCHILD_TAO

(SQL Table)

Save the children table

This is a temporary table used when updating an EPS tree structure. When the tree structure changes, we want to save all the children nodes so that they will not be lost.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 TREE_NODE_CHILD Character(20) VARCHAR2(20) NOT NULL Tree Node Child

3 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node

4 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

5 PC_INDENT_LEVEL Number(3,0) SMALLINT NOT NULL Tree Indent Level

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TREE_NODE_CHILD	Character(20)	VARCHAR2(20) NOT NULL	Tree Node Child
3	PARENT_NODE	Character(20)	VARCHAR2(20) NOT NULL	Parent Tree Node
4	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
5	PC_INDENT_LEVEL	Number(3,0)	SMALLINT NOT NULL	Tree Indent Level