DIM_SDW_TSDMD_OF_ENTITY_COMBINED

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

INSNZP02_BANK..DIM_SDW_TSDMD_OF_ENTITY_COMBINED_INSIGHT

Columns
# Name Data Type Length
1 ENTITY_SID BIGINT 8
2 ENTITY_DIM_ID CHARACTER VARYING(150) 150
3 ENTITY_CODE CHARACTER VARYING(150) 150
4 ENTITY_NAME CHARACTER VARYING(240) 240
5 VALID_FROM_DATE TIMESTAMP 8
6 ENTITY_VALID_TO_DATE TIMESTAMP 8
7 ENTITY_CREATED_DATE TIMESTAMP 8
8 ENTITY_CHANGED_DATE TIMESTAMP 8
9 ENTITY_LEVEL_01_CODE CHARACTER VARYING(60) 60
10 ENTITY_HIERARCHY_HISTORY_SID BIGINT 8
11 ENTITY_HIERARCHY_DIM_ID CHARACTER VARYING(150) 150
12 HIST_ENTITY_NAME CHARACTER VARYING(240) 240
13 ENTITY_NAME_CF CHARACTER(1) 1
14 ENTITY_LEVEL_01_NAME CHARACTER VARYING(240) 240
15 ENTITY_LEVEL_01_NAME_CF CHARACTER(1) 1
16 ENTITY_LEVEL_02_CODE CHARACTER VARYING(150) 150
17 ENTITY_LEVEL_02_CODE_CF CHARACTER(1) 1
18 ENTITY_LEVEL_02_NAME CHARACTER VARYING(240) 240
19 ENTITY_LEVEL_02_NAME_CF CHARACTER(1) 1
20 ENTITY_LEVEL_03_CODE CHARACTER VARYING(150) 150
21 ENTITY_LEVEL_03_CODE_CF CHARACTER(1) 1
22 ENTITY_LEVEL_03_NAME CHARACTER VARYING(240) 240
23 ENTITY_LEVEL_03_NAME_CF CHARACTER(1) 1
24 ENTITY_LEVEL_04_CODE CHARACTER VARYING(150) 150
25 ENTITY_LEVEL_04_CODE_CF CHARACTER(1) 1
26 ENTITY_LEVEL_04_NAME CHARACTER VARYING(240) 240
27 ENTITY_LEVEL_04_NAME_CF CHARACTER(1) 1
28 ENTITY_LEVEL_05_CODE CHARACTER VARYING(150) 150
29 ENTITY_LEVEL_05_CODE_CF CHARACTER(1) 1
30 ENTITY_LEVEL_05_NAME CHARACTER VARYING(240) 240
31 ENTITY_LEVEL_05_NAME_CF CHARACTER(1) 1
32 ENTITY_LEVEL_06_CODE CHARACTER VARYING(150) 150
33 ENTITY_LEVEL_06_CODE_CF CHARACTER(1) 1
34 ENTITY_LEVEL_06_NAME CHARACTER VARYING(240) 240
35 ENTITY_LEVEL_06_NAME_CF CHARACTER(1) 1
36 ENTITY_LEVEL_07_CODE CHARACTER VARYING(150) 150
37 ENTITY_LEVEL_07_CODE_CF CHARACTER(1) 1
38 ENTITY_LEVEL_07_NAME CHARACTER VARYING(240) 240
39 ENTITY_LEVEL_07_NAME_CF CHARACTER(1) 1
40 ENTITY_LEVEL_08_CODE CHARACTER VARYING(150) 150
41 ENTITY_LEVEL_08_CODE_CF CHARACTER(1) 1
42 ENTITY_LEVEL_08_NAME CHARACTER VARYING(240) 240
43 ENTITY_LEVEL_08_NAME_CF CHARACTER(1) 1
44 ENTITY_LEVEL_09_CODE CHARACTER VARYING(150) 150
45 ENTITY_LEVEL_09_CODE_CF CHARACTER(1) 1
46 ENTITY_LEVEL_09_NAME CHARACTER VARYING(240) 240
47 ENTITY_LEVEL_09_NAME_CF CHARACTER(1) 1
48 ENTITY_LEVEL_10_CODE CHARACTER VARYING(150) 150
49 ENTITY_LEVEL_10_CODE_CF CHARACTER(1) 1
50 ENTITY_LEVEL_10_NAME CHARACTER VARYING(240) 240
51 ENTITY_LEVEL_10_NAME_CF CHARACTER(1) 1
52 ENTITY_LEVEL_11_CODE CHARACTER VARYING(150) 150
53 ENTITY_LEVEL_11_CODE_CF CHARACTER(1) 1
54 ENTITY_LEVEL_11_NAME CHARACTER VARYING(240) 240
55 ENTITY_LEVEL_11_NAME_CF CHARACTER(1) 1
56 ENTITY_LEVEL_12_CODE CHARACTER VARYING(150) 150
57 ENTITY_LEVEL_12_CODE_CF CHARACTER(1) 1
58 ENTITY_LEVEL_12_NAME CHARACTER VARYING(240) 240
59 ENTITY_LEVEL_12_NAME_CF CHARACTER(1) 1
60 ENTITY_LEVEL_13_CODE CHARACTER VARYING(150) 150
61 ENTITY_LEVEL_13_CODE_CF CHARACTER(1) 1
62 ENTITY_LEVEL_13_NAME CHARACTER VARYING(240) 240
63 ENTITY_LEVEL_13_NAME_CF CHARACTER(1) 1
64 ENTITY_LEVEL_14_CODE CHARACTER VARYING(150) 150
65 ENTITY_LEVEL_14_CODE_CF CHARACTER(1) 1
66 ENTITY_LEVEL_14_NAME CHARACTER VARYING(240) 240
67 ENTITY_LEVEL_14_NAME_CF CHARACTER(1) 1
68 ENTITY_LEVEL_15_CODE CHARACTER VARYING(150) 150
69 ENTITY_LEVEL_15_CODE_CF CHARACTER(1) 1
70 ENTITY_LEVEL_15_NAME CHARACTER VARYING(240) 240
71 ENTITY_LEVEL_15_NAME_CF CHARACTER(1) 1
72 EFFECTIVE_DATE TIMESTAMP 8
73 ENTITY_HIST_VALID_TO_DATE TIMESTAMP 8
74 ENTITY_HIST_CREATED_DATE TIMESTAMP 8
75 ENTITY_HIST_CHANGED_DATE TIMESTAMP 8
76 ENTITY_HIERARCHY_SID BIGINT 8
77 ENTITY_LEVEL_16_CODE CHARACTER VARYING(150) 150
78 ENTITY_LEVEL_16_CODE_CF CHARACTER(1) 1
79 ENTITY_LEVEL_16_NAME CHARACTER VARYING(240) 240
80 ENTITY_LEVEL_16_NAME_CF CHARACTER(1) 1
81 ENTITY_LEVEL_17_CODE CHARACTER VARYING(150) 150
82 ENTITY_LEVEL_17_CODE_CF CHARACTER(1) 1
83 ENTITY_LEVEL_17_NAME CHARACTER VARYING(240) 240
84 ENTITY_LEVEL_17_NAME_CF CHARACTER(1) 1
85 ENTITY_LEVEL_18_CODE CHARACTER VARYING(150) 150
86 ENTITY_LEVEL_18_CODE_CF CHARACTER(1) 1
87 ENTITY_LEVEL_18_NAME CHARACTER VARYING(240) 240
88 ENTITY_LEVEL_18_NAME_CF CHARACTER(1) 1
89 ENTITY_LEVEL_19_CODE CHARACTER VARYING(150) 150
90 ENTITY_LEVEL_19_CODE_CF CHARACTER(1) 1
91 ENTITY_LEVEL_19_NAME CHARACTER VARYING(240) 240
92 ENTITY_LEVEL_19_NAME_CF CHARACTER(1) 1
93 ENTITY_LEVEL_20_CODE CHARACTER VARYING(150) 150
94 ENTITY_LEVEL_20_CODE_CF CHARACTER(1) 1
95 ENTITY_LEVEL_20_NAME CHARACTER VARYING(240) 240
96 ENTITY_LEVEL_20_NAME_CF CHARACTER(1) 1
97 BUSINESS_LOAD_DATE TIMESTAMP 8
98 ENTITY_COMMIT_TIMESTAMP TIMESTAMP 8
99 ENTITY_HIER_COMMIT_TIMESTAMP TIMESTAMP 8
100 ENTITY_HIST_COMMIT_TIMESTAMP TIMESTAMP 8