RF_IPRD_VH_NODE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
2	LEAF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Leaf Flag
3	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	RANGE_FROM	Character(30)	VARCHAR2(30) NOT NULL	Lower boundary for detail value that contains a range of values
6	RANGE_TO	Character(30)	VARCHAR2(30) NOT NULL	Upper boundary for detail value that contains a range of values
7	DYNAMIC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Dynamic Flag
8	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive
9	DISPLAY_OPTION	Character(1)	VARCHAR2(1) NOT NULL	UAD Display Options I=Image T=Text
10	STYLECLASSNAME	Character(30)	VARCHAR2(30) NOT NULL	Style Class Name
11	PARENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Parent Flag
12	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
13	LEVEL_OFFSET	Number(3,0)	SMALLINT NOT NULL	Level Offset
14	DESCR_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Description Image Name
15	EXPANDED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Expanded Flag
16	DISPLAYED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Displayed Flag
17	DESCR_MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
18	DESCR_MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
19	IMAGE_WIDTH	Number(2,0)	SMALLINT NOT NULL	Image Width
20	IMAGE_HEIGHT	Number(2,0)	SMALLINT NOT NULL	Image Height
21	COLLAPSED_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Collapsed Image Name
22	COLLAPSED_MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
23	COLLAPSED_MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
24	EXPANDED_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Expanded Image Name
25	EXPANDED_MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
26	EXPANDED_MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
27	END_NODE_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	End Node Image Name
28	END_NODE_MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
29	END_NODE_MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
30	LEAF_IMAGE	Character(30)	VARCHAR2(30) NOT NULL	Name of image that is used for leaf , i.e. detail values in tree
31	LEAF_MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
32	LEAF_MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
33	HTMLAREA	Long Character	CLOB	HTML Area
34	SORT_ORDER_NUM	Number(3,0)	SMALLINT NOT NULL	Field to capture the sort order number.
35	HIDDEN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hidden Flag field
36	NODE_VALUE	Character(60)	VARCHAR2(60) NOT NULL	Field used for storing node value information
37	LINE_NBR	Number(5,0)	INTEGER NOT NULL	This field represents the integer Order Line Number.
38	LINE_NBR_REL	Number(5,0)	INTEGER NOT NULL	Related Line
39	LINE_NBR_REL_1	Number(5,0)	INTEGER NOT NULL	Field used for storing related order line (line number) information
40	LINE_NBR_REL_2	Number(5,0)	INTEGER NOT NULL	Field used for storing related order line (line number) information
41	ROWSTYLECLASSNAME	Character(30)	VARCHAR2(30) NOT NULL	Fiels used by TREECTL_NDE_SBR to store name of style assigned to node of tree on line-details page
42	REL_INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	Field used for storing releated installed product information
43	CAPTURE_ID_REL	Character(20)	VARCHAR2(20) NOT NULL	This field stores relative capture IDs.