PSTREEBRANCH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SETID_NOMETA_VW
2	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: PSTREEDEFN
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	TREE_BRANCH	Character(20)	VARCHAR2(20) NOT NULL	Tree Branch Name
6	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
7	PARENT_BRANCH	Character(20)	VARCHAR2(20) NOT NULL	Parent Branch Name
8	BRANCH_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Branch Level Number
9	PARENT_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Parent Node Number
10	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
11	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
12	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
13	NODE_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Tree Definition Node Count
14	LEAF_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Leaf Count
15	BRANCH_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Branched Tree Image Name