DIM_SDW_TSDMD_OF_INTERCOMPANY_COMBINED_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..DIM_SDW_TSDMD_OF_INTERCOMPANY_COMBINED

Synonyms

INSNZP01_BANK..SYN_DIM_SDW_TSDMD_OF_INTERCOMPANY_COMBINED_INSIGHT

Columns
# Name Data Type Length
1 INTERCOMPANY_SID BIGINT 8
2 INTERCOMPANY_DIM_ID CHARACTER VARYING(150) 150
3 INTERCOMPANY_CODE CHARACTER VARYING(150) 150
4 INTERCOMPANY_NAME CHARACTER VARYING(240) 240
5 VALID_FROM_DATE TIMESTAMP 8
6 INTERCOMPANY_VALID_TO_DATE TIMESTAMP 8
7 INTERCOMPANY_CREATED_DATE TIMESTAMP 8
8 INTERCOMPANY_CHANGED_DATE TIMESTAMP 8
9 INTERCOMPANY_LEVEL_01_CODE CHARACTER VARYING(60) 60
10 INTERCOMPANY_HIE_HISTORY_SID BIGINT 8
11 INTERCOMPANY_HIERARCH_DIM_ID CHARACTER VARYING(150) 150
12 HIST_INTERCOMPANY_NAME CHARACTER VARYING(240) 240
13 INTERCOMPANY_NAME_CF CHARACTER(1) 1
14 INTERCOMPANY_LEVEL_01_NAME CHARACTER VARYING(240) 240
15 INTERCOMPANY_LEVEL_01_NAM_CF CHARACTER(1) 1
16 INTERCOMPANY_LEVEL_02_CODE CHARACTER VARYING(150) 150
17 INTERCOMPANY_LEVEL_02_COD_CF CHARACTER(1) 1
18 INTERCOMPANY_LEVEL_02_NAME CHARACTER VARYING(240) 240
19 INTERCOMPANY_LEVEL_02_NAM_CF CHARACTER(1) 1
20 INTERCOMPANY_LEVEL_03_CODE CHARACTER VARYING(150) 150
21 INTERCOMPANY_LEVEL_03_COD_CF CHARACTER(1) 1
22 INTERCOMPANY_LEVEL_03_NAME CHARACTER VARYING(240) 240
23 INTERCOMPANY_LEVEL_03_NAM_CF CHARACTER(1) 1
24 INTERCOMPANY_LEVEL_04_CODE CHARACTER VARYING(150) 150
25 INTERCOMPANY_LEVEL_04_COD_CF CHARACTER(1) 1
26 INTERCOMPANY_LEVEL_04_NAME CHARACTER VARYING(240) 240
27 INTERCOMPANY_LEVEL_04_NAM_CF CHARACTER(1) 1
28 INTERCOMPANY_LEVEL_05_CODE CHARACTER VARYING(150) 150
29 INTERCOMPANY_LEVEL_05_COD_CF CHARACTER(1) 1
30 INTERCOMPANY_LEVEL_05_NAME CHARACTER VARYING(240) 240
31 INTERCOMPANY_LEVEL_05_NAM_CF CHARACTER(1) 1
32 INTERCOMPANY_LEVEL_06_CODE CHARACTER VARYING(150) 150
33 INTERCOMPANY_LEVEL_06_COD_CF CHARACTER(1) 1
34 INTERCOMPANY_LEVEL_06_NAME CHARACTER VARYING(240) 240
35 INTERCOMPANY_LEVEL_06_NAM_CF CHARACTER(1) 1
36 INTERCOMPANY_LEVEL_07_CODE CHARACTER VARYING(150) 150
37 INTERCOMPANY_LEVEL_07_COD_CF CHARACTER(1) 1
38 INTERCOMPANY_LEVEL_07_NAME CHARACTER VARYING(240) 240
39 INTERCOMPANY_LEVEL_07_NAM_CF CHARACTER(1) 1
40 INTERCOMPANY_LEVEL_08_CODE CHARACTER VARYING(150) 150
41 INTERCOMPANY_LEVEL_08_COD_CF CHARACTER(1) 1
42 INTERCOMPANY_LEVEL_08_NAME CHARACTER VARYING(240) 240
43 INTERCOMPANY_LEVEL_08_NAM_CF CHARACTER(1) 1
44 INTERCOMPANY_LEVEL_09_CODE CHARACTER VARYING(150) 150
45 INTERCOMPANY_LEVEL_09_COD_CF CHARACTER(1) 1
46 INTERCOMPANY_LEVEL_09_NAME CHARACTER VARYING(240) 240
47 INTERCOMPANY_LEVEL_09_NAM_CF CHARACTER(1) 1
48 INTERCOMPANY_LEVEL_10_CODE CHARACTER VARYING(150) 150
49 INTERCOMPANY_LEVEL_10_COD_CF CHARACTER(1) 1
50 INTERCOMPANY_LEVEL_10_NAME CHARACTER VARYING(240) 240
51 INTERCOMPANY_LEVEL_10_NAM_CF CHARACTER(1) 1
52 INTERCOMPANY_LEVEL_11_CODE CHARACTER VARYING(150) 150
53 INTERCOMPANY_LEVEL_11_COD_CF CHARACTER(1) 1
54 INTERCOMPANY_LEVEL_11_NAME CHARACTER VARYING(240) 240
55 INTERCOMPANY_LEVEL_11_NAM_CF CHARACTER(1) 1
56 INTERCOMPANY_LEVEL_12_CODE CHARACTER VARYING(150) 150
57 INTERCOMPANY_LEVEL_12_COD_CF CHARACTER(1) 1
58 INTERCOMPANY_LEVEL_12_NAME CHARACTER VARYING(240) 240
59 INTERCOMPANY_LEVEL_12_NAM_CF CHARACTER(1) 1
60 INTERCOMPANY_LEVEL_13_CODE CHARACTER VARYING(150) 150
61 INTERCOMPANY_LEVEL_13_COD_CF CHARACTER(1) 1
62 INTERCOMPANY_LEVEL_13_NAME CHARACTER VARYING(240) 240
63 INTERCOMPANY_LEVEL_13_NAM_CF CHARACTER(1) 1
64 INTERCOMPANY_LEVEL_14_CODE CHARACTER VARYING(150) 150
65 INTERCOMPANY_LEVEL_14_COD_CF CHARACTER(1) 1
66 INTERCOMPANY_LEVEL_14_NAME CHARACTER VARYING(240) 240
67 INTERCOMPANY_LEVEL_14_NAM_CF CHARACTER(1) 1
68 INTERCOMPANY_LEVEL_15_CODE CHARACTER VARYING(150) 150
69 INTERCOMPANY_LEVEL_15_COD_CF CHARACTER(1) 1
70 INTERCOMPANY_LEVEL_15_NAME CHARACTER VARYING(240) 240
71 INTERCOMPANY_LEVEL_15_NAM_CF CHARACTER(1) 1
72 EFFECTIVE_DATE TIMESTAMP 8
73 HIST_VALID_TO_DATE TIMESTAMP 8
74 HIST_CREATED_DATE TIMESTAMP 8
75 HIST_CHANGED_DATE TIMESTAMP 8
76 INTERCOMPANY_HIERARCHY_SID BIGINT 8
77 INTERCOMPANY_COMMIT_TIMESTAMP TIMESTAMP 8
78 INTERCOMPANY_HIER_COMMIT_TIMESTAMP TIMESTAMP 8
79 INTERCOMPANY_HIST_COMMIT_TIMESTAMP TIMESTAMP 8