SDW_TSDMD_OF_ENTITY_HIER_HIST

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BNKNIC_SDW_TSDMD_OF_ENTITY_HIER_HIST

SDSNZP05_BANK..CBP_SDW_TSDMD_OF_ENTITY_HIER_HIST

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