GL_IA_TREE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TREE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tree SetID
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
4	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
5	EFFDT_TREE	Date(10)	DATE	Tree Effective Date
6	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
7	TREE_NODE_TO	Character(20)	VARCHAR2(20) NOT NULL	Tree Node
8	TREE_NODE_FROM	Character(20)	VARCHAR2(20) NOT NULL	Tree Node
9	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
10	GL_NEW_NODE_FLG	Character(1)	VARCHAR2(1) NOT NULL	New Tree Node
11	GL_NEW_NODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	New Node Description
12	GL_NODE_LEAF_FLAG	Character(4)	VARCHAR2(4) NOT NULL	As Node or Leaf LEAF=Leaf NODE=Node
13	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
14	DTL_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Tree Structure Detail Record name
15	NODE_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Tree Structure Node Record name
16	CONTN_NODE_LOOP	Character(1)	VARCHAR2(1) NOT NULL	Continue Tree Node Loop in Impact Analysis.
17	NEW_TREE_EFFDT	Character(1)	VARCHAR2(1) NOT NULL	New Tree Effective Date
18	MOVE_LEAF_OR_NODE	Character(1)	VARCHAR2(1) NOT NULL	Flag for Impact Analysis processing.
19	TREE_NODE_01	Character(20)	VARCHAR2(20) NOT NULL	Tree Node name
20	TREE_NODE_02	Character(20)	VARCHAR2(20) NOT NULL	Tree Node name
21	TREE_NODE_03	Character(20)	VARCHAR2(20) NOT NULL	Tree Node name