GL_IA_TREE_AET

(SQL Table)
Index Back

GL IA - tree state record

# 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