DIM_OEB_PSTREE_HIERARCHY_CFDM_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LEAF_NAME CHARACTER VARYING(240) 240
2 SM_LEAF_DESCR CHARACTER VARYING(240) 240
3 SM_LEAF_STATUS CHARACTER VARYING(1) 1
4 SM_TREE_SETID CHARACTER VARYING(2) 2
5 TREE_NAME CHARACTER VARYING(16) 16
6 TREE_EFFDT TIMESTAMP 8
7 LEVEL1_NAME CHARACTER VARYING(150) 150
8 SM_NODE_DECR1 CHARACTER VARYING(240) 240
9 SM_TREE_NODE_NUM1 INTEGER 4
10 LEVEL2_NAME CHARACTER VARYING(150) 150
11 SM_NODE_DECR2 CHARACTER VARYING(240) 240
12 SM_TREE_NODE_NUM2 INTEGER 4
13 LEVEL3_NAME CHARACTER VARYING(150) 150
14 SM_NODE_DECR3 CHARACTER VARYING(240) 240
15 SM_TREE_NODE_NUM3 INTEGER 4
16 LEVEL4_NAME CHARACTER VARYING(150) 150
17 SM_NODE_DECR4 CHARACTER VARYING(240) 240
18 SM_TREE_NODE_NUM4 INTEGER 4
19 LEVEL5_NAME CHARACTER VARYING(150) 150
20 SM_NODE_DECR5 CHARACTER VARYING(240) 240
21 SM_TREE_NODE_NUM5 INTEGER 4
22 LEVEL6_NAME CHARACTER VARYING(150) 150
23 SM_NODE_DECR6 CHARACTER VARYING(240) 240
24 SM_TREE_NODE_NUM6 INTEGER 4
25 LEVEL7_NAME CHARACTER VARYING(150) 150
26 SM_NODE_DECR7 CHARACTER VARYING(240) 240
27 SM_TREE_NODE_NUM7 INTEGER 4
28 LEVEL8_NAME CHARACTER VARYING(150) 150
29 SM_NODE_DECR8 CHARACTER VARYING(240) 240
30 SM_TREE_NODE_NUM8 INTEGER 4
31 LEVEL9_NAME CHARACTER VARYING(150) 150
32 SM_NODE_DECR9 CHARACTER VARYING(240) 240
33 SM_TREE_NODE_NUM9 INTEGER 4
34 LEVEL10_NAME CHARACTER VARYING(150) 150
35 SM_NODE_DECR10 CHARACTER VARYING(240) 240
36 SM_TREE_NODE_NUM10 INTEGER 4
37 LEVEL11_NAME CHARACTER VARYING(150) 150
38 SM_NODE_DECR11 CHARACTER VARYING(240) 240
39 SM_TREE_NODE_NUM11 INTEGER 4
40 LEVEL12_NAME CHARACTER VARYING(150) 150
41 SM_NODE_DECR12 CHARACTER VARYING(240) 240
42 SM_TREE_NODE_NUM12 INTEGER 4
43 LEVEL13_NAME CHARACTER VARYING(150) 150
44 SM_NODE_DECR13 CHARACTER VARYING(240) 240
45 SM_TREE_NODE_NUM13 INTEGER 4
46 LEVEL14_NAME CHARACTER VARYING(150) 150
47 SM_NODE_DECR14 CHARACTER VARYING(240) 240
48 SM_TREE_NODE_NUM14 INTEGER 4
49 LEVEL15_NAME CHARACTER VARYING(150) 150
50 SM_NODE_DECR15 CHARACTER VARYING(240) 240
51 SM_TREE_NODE_NUM15 INTEGER 4
52 TREE_LEVEL_NUM INTEGER 4
53 LEVEL_COUNT INTEGER 4
54 SM_TREE_STATUS CHARACTER VARYING(1) 1
55 TREE_STRCT_ID CHARACTER VARYING(11) 11