RBF_TREECTL_NDE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREECTL_NAME	Character(15)	VARCHAR2(15) NOT NULL	Tree Name
2	TREE_NODE4	Character(4)	VARCHAR2(4) NOT NULL	Tree Node Name (ID)
3	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
5	NODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Tree node description.
6	DISPLAY_OPTION1	Character(1)	VARCHAR2(1) NOT NULL	Display Option B=Both D=Description N=Name Default Value: D
7	PARENT_NODE	Character(20)	VARCHAR2(20) NOT NULL	Parent Tree Node Prompt Table: RBF_TREECTL_NDE
8	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record Default Value: 1
9	TREE_TAG	Character(3)	VARCHAR2(3) NOT NULL	Tree Tag L_L=Leaf Under Leaf L_N=Leaf Under Node N_L=Node Under Leaf N_N=Node Under Node N_R=Node Under Root R=Root
10	CHILD_NODE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Folder LEA=Leaf NOD=Folder Default Value: NOD
11	CHILD_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Child Node Number Default Value: 999
12	VIEWNAME	Character(30)	VARCHAR2(30) NOT NULL	View Name
13	SETCNTRLFLD	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Node User Key Field Name
14	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
15	ID_NAME	Character(20)	VARCHAR2(20) NOT NULL	ID Fld in View
16	ID_TYPE	Character(3)	VARCHAR2(3) NOT NULL	ID Type CHA=Character NUM=Number Default Value: CHA
17	ID_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ID Value
18	NODE_DESCR_FLD	Character(20)	VARCHAR2(20) NOT NULL	Description Field
19	NODE_DESCR_FLD2	Character(20)	VARCHAR2(20) NOT NULL	Second Field
20	NODE_DESCR_FLD3	Character(20)	VARCHAR2(20) NOT NULL	Third Field
21	NODE_DESCR_FLD4	Character(20)	VARCHAR2(20) NOT NULL	Fourth Field
22	MENUNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Name (see PSMENUDEFN).
23	BARNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Bar Name
24	ITEMNAME	Character(30)	VARCHAR2(30) NOT NULL	Item Name
25	PAGENAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name
26	SRCH_RECORD	Character(15)	VARCHAR2(15) NOT NULL	Search Record
27	TRANSFER_MODE	Character(1)	VARCHAR2(1) NOT NULL	Transfer Mode A=Add C=Correction E=Data Entry L=Update/Display All U=Update/Display
28	MAX_ROWS_SCROLL	Number(5,0)	INTEGER NOT NULL	Max Number of Rows in Scrolls Default Value: 0
29	VISIBLE	Character(1)	VARCHAR2(1) NOT NULL	Show Sub Page Y/N Table Edit Default Value: Y
30	ORDER_BY_COLS	Character(50)	VARCHAR2(50) NOT NULL	Order by
31	TREECTL_NODE	Character(30)	VARCHAR2(30) NOT NULL	Node name