DIM_MASTER_HIERARCHY

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 FLEX_VALUE_SET_ID BIGINT 8
2 LOB CHARACTER VARYING(16) 16
3 LEVEL_01_CODE CHARACTER VARYING(150) 150
4 LEVEL_01_NAME CHARACTER VARYING(240) 240
5 LEVEL_01_TYPE CHARACTER VARYING(1) 1
6 LEVEL_02_CODE CHARACTER VARYING(150) 150
7 LEVEL_02_NAME CHARACTER VARYING(240) 240
8 LEVEL_02_TYPE CHARACTER VARYING(1) 1
9 LEVEL_03_CODE CHARACTER VARYING(150) 150
10 LEVEL_03_NAME CHARACTER VARYING(240) 240
11 LEVEL_03_TYPE CHARACTER VARYING(1) 1
12 LEVEL_04_CODE CHARACTER VARYING(150) 150
13 LEVEL_04_NAME CHARACTER VARYING(240) 240
14 LEVEL_04_TYPE CHARACTER VARYING(1) 1
15 LEVEL_05_CODE CHARACTER VARYING(150) 150
16 LEVEL_05_NAME CHARACTER VARYING(240) 240
17 LEVEL_05_TYPE CHARACTER VARYING(1) 1
18 LEVEL_06_CODE CHARACTER VARYING(150) 150
19 LEVEL_06_NAME CHARACTER VARYING(240) 240
20 LEVEL_06_TYPE CHARACTER VARYING(1) 1
21 LEVEL_07_CODE CHARACTER VARYING(150) 150
22 LEVEL_07_NAME CHARACTER VARYING(240) 240
23 LEVEL_07_TYPE CHARACTER VARYING(1) 1
24 LEVEL_08_CODE CHARACTER VARYING(150) 150
25 LEVEL_08_NAME CHARACTER VARYING(240) 240
26 LEVEL_08_TYPE CHARACTER VARYING(1) 1
27 LEVEL_09_CODE CHARACTER VARYING(150) 150
28 LEVEL_09_NAME CHARACTER VARYING(240) 240
29 LEVEL_09_TYPE CHARACTER VARYING(1) 1
30 LEVEL_10_CODE CHARACTER VARYING(150) 150
31 LEVEL_10_NAME CHARACTER VARYING(240) 240
32 LEVEL_10_TYPE CHARACTER VARYING(1) 1
33 LEVEL_11_CODE CHARACTER VARYING(150) 150
34 LEVEL_11_NAME CHARACTER VARYING(240) 240
35 LEVEL_11_TYPE CHARACTER VARYING(1) 1
36 LEVEL_12_CODE CHARACTER VARYING(150) 150
37 LEVEL_12_NAME CHARACTER VARYING(240) 240
38 LEVEL_12_TYPE CHARACTER VARYING(1) 1
39 LEVEL_13_CODE CHARACTER VARYING(150) 150
40 LEVEL_13_NAME CHARACTER VARYING(240) 240
41 LEVEL_13_TYPE CHARACTER VARYING(1) 1
42 LEVEL_14_CODE CHARACTER VARYING(150) 150
43 LEVEL_14_NAME CHARACTER VARYING(240) 240
44 LEVEL_14_TYPE CHARACTER VARYING(1) 1
45 LEVEL_15_CODE CHARACTER VARYING(150) 150
46 LEVEL_15_NAME CHARACTER VARYING(240) 240
47 LEVEL_15_TYPE CHARACTER VARYING(1) 1
48 LEVEL_16_CODE CHARACTER VARYING(150) 150
49 LEVEL_16_NAME CHARACTER VARYING(240) 240
50 LEVEL_16_TYPE CHARACTER VARYING(1) 1
51 LEVEL_17_CODE CHARACTER VARYING(150) 150
52 LEVEL_17_NAME CHARACTER VARYING(240) 240
53 LEVEL_17_TYPE CHARACTER VARYING(1) 1
54 LEVEL_18_CODE CHARACTER VARYING(150) 150
55 LEVEL_18_NAME CHARACTER VARYING(240) 240
56 LEVEL_18_TYPE CHARACTER VARYING(1) 1
57 LEVEL_19_CODE CHARACTER VARYING(150) 150
58 LEVEL_19_NAME CHARACTER VARYING(240) 240
59 LEVEL_19_TYPE CHARACTER VARYING(1) 1
60 LEVEL_20_CODE CHARACTER VARYING(150) 150
61 LEVEL_20_NAME CHARACTER VARYING(240) 240
62 LEVEL_20_TYPE CHARACTER VARYING(1) 1