PSTREENODE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
6	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
7	TREE_BRANCH	Character(20)	VARCHAR2(20) NOT NULL	Tree Branch Name
8	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
9	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
10	TREE_NODE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether node represents a Group (G) or a Record (R) in a Query Access Group Tree,
11	PARENT_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Parent Node Number
12	PARENT_NODE_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name of parent node
13	OLD_TREE_NODE_NUM	Character(1)	VARCHAR2(1) NOT NULL	Old Tree Node
14	NODECOL_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Collapsed Node Image Field
15	NODEEXP_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Expanded Node Image Field