DIM_SDW_TSDMD_OF_PRODUCT_COMBINED_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..DIM_SDW_TSDMD_OF_PRODUCT_COMBINED

Synonyms

INSNZP01_BANK..SYN_DIM_SDW_TSDMD_OF_PRODUCT_COMBINED_INSIGHT

Columns
# Name Data Type Length
1 PRODUCT_SID BIGINT 8
2 PRODUCT_DIM_ID CHARACTER VARYING(150) 150
3 PRODUCT_CODE CHARACTER VARYING(150) 150
4 PRODUCT_NAME CHARACTER VARYING(240) 240
5 VALID_FROM_DATE TIMESTAMP 8
6 PRODUCT_VALID_TO_DATE TIMESTAMP 8
7 PRODUCT_CREATED_DATE TIMESTAMP 8
8 PRODUCT_CHANGED_DATE TIMESTAMP 8
9 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
10 PRODUCT_LEVEL_01_CODE CHARACTER VARYING(60) 60
11 PRODUCT_HIERARCH_HISTORY_SID BIGINT 8
12 PRODUCT_HIERARCHY_DIM_ID CHARACTER VARYING(150) 150
13 HIST_PRODUCT_NAME CHARACTER VARYING(240) 240
14 PRODUCT_NAME_CF CHARACTER(1) 1
15 PRODUCT_LEVEL_01_NAME CHARACTER VARYING(240) 240
16 PRODUCT_LEVEL_01_NAME_CF CHARACTER(1) 1
17 PRODUCT_LEVEL_02_CODE CHARACTER VARYING(150) 150
18 PRODUCT_LEVEL_02_CODE_CF CHARACTER(1) 1
19 PRODUCT_LEVEL_02_NAME CHARACTER VARYING(240) 240
20 PRODUCT_LEVEL_02_NAME_CF CHARACTER(1) 1
21 PRODUCT_LEVEL_03_CODE CHARACTER VARYING(150) 150
22 PRODUCT_LEVEL_03_CODE_CF CHARACTER(1) 1
23 PRODUCT_LEVEL_03_NAME CHARACTER VARYING(240) 240
24 PRODUCT_LEVEL_03_NAME_CF CHARACTER(1) 1
25 PRODUCT_LEVEL_04_CODE CHARACTER VARYING(150) 150
26 PRODUCT_LEVEL_04_CODE_CF CHARACTER(1) 1
27 PRODUCT_LEVEL_04_NAME CHARACTER VARYING(240) 240
28 PRODUCT_LEVEL_04_NAME_CF CHARACTER(1) 1
29 PRODUCT_LEVEL_05_CODE CHARACTER VARYING(150) 150
30 PRODUCT_LEVEL_05_CODE_CF CHARACTER(1) 1
31 PRODUCT_LEVEL_05_NAME CHARACTER VARYING(240) 240
32 PRODUCT_LEVEL_05_NAME_CF CHARACTER(1) 1
33 PRODUCT_LEVEL_06_CODE CHARACTER VARYING(150) 150
34 PRODUCT_LEVEL_06_CODE_CF CHARACTER(1) 1
35 PRODUCT_LEVEL_06_NAME CHARACTER VARYING(240) 240
36 PRODUCT_LEVEL_06_NAME_CF CHARACTER(1) 1
37 PRODUCT_LEVEL_07_CODE CHARACTER VARYING(150) 150
38 PRODUCT_LEVEL_07_CODE_CF CHARACTER(1) 1
39 PRODUCT_LEVEL_07_NAME CHARACTER VARYING(240) 240
40 PRODUCT_LEVEL_07_NAME_CF CHARACTER(1) 1
41 PRODUCT_LEVEL_08_CODE CHARACTER VARYING(150) 150
42 PRODUCT_LEVEL_08_CODE_CF CHARACTER(1) 1
43 PRODUCT_LEVEL_08_NAME CHARACTER VARYING(240) 240
44 PRODUCT_LEVEL_08_NAME_CF CHARACTER(1) 1
45 PRODUCT_LEVEL_09_CODE CHARACTER VARYING(150) 150
46 PRODUCT_LEVEL_09_CODE_CF CHARACTER(1) 1
47 PRODUCT_LEVEL_09_NAME CHARACTER VARYING(240) 240
48 PRODUCT_LEVEL_09_NAME_CF CHARACTER(1) 1
49 PRODUCT_LEVEL_10_CODE CHARACTER VARYING(150) 150
50 PRODUCT_LEVEL_10_CODE_CF CHARACTER(1) 1
51 PRODUCT_LEVEL_10_NAME CHARACTER VARYING(240) 240
52 PRODUCT_LEVEL_10_NAME_CF CHARACTER(1) 1
53 PRODUCT_LEVEL_11_CODE CHARACTER VARYING(150) 150
54 PRODUCT_LEVEL_11_CODE_CF CHARACTER(1) 1
55 PRODUCT_LEVEL_11_NAME CHARACTER VARYING(240) 240
56 PRODUCT_LEVEL_11_NAME_CF CHARACTER(1) 1
57 PRODUCT_LEVEL_12_CODE CHARACTER VARYING(150) 150
58 PRODUCT_LEVEL_12_CODE_CF CHARACTER(1) 1
59 PRODUCT_LEVEL_12_NAME CHARACTER VARYING(240) 240
60 PRODUCT_LEVEL_12_NAME_CF CHARACTER(1) 1
61 PRODUCT_LEVEL_13_CODE CHARACTER VARYING(150) 150
62 PRODUCT_LEVEL_13_CODE_CF CHARACTER(1) 1
63 PRODUCT_LEVEL_13_NAME CHARACTER VARYING(240) 240
64 PRODUCT_LEVEL_13_NAME_CF CHARACTER(1) 1
65 PRODUCT_LEVEL_14_CODE CHARACTER VARYING(150) 150
66 PRODUCT_LEVEL_14_CODE_CF CHARACTER(1) 1
67 PRODUCT_LEVEL_14_NAME CHARACTER VARYING(240) 240
68 PRODUCT_LEVEL_14_NAME_CF CHARACTER(1) 1
69 PRODUCT_LEVEL_15_CODE CHARACTER VARYING(150) 150
70 PRODUCT_LEVEL_15_CODE_CF CHARACTER(1) 1
71 PRODUCT_LEVEL_15_NAME CHARACTER VARYING(240) 240
72 PRODUCT_LEVEL_15_NAME_CF CHARACTER(1) 1
73 PRODUCT_EFFECTIVE_DATE TIMESTAMP 8
74 PRODUCT_HIST_VALID_TO_DATE TIMESTAMP 8
75 PRODUCT_HIST_CREATED_DATE TIMESTAMP 8
76 PRODUCT_HIST_CHANGED_DATE TIMESTAMP 8
77 PRODUCT_HIERARCHY_SID BIGINT 8
78 PRODUCT_COMMIT_TIMESTAMP TIMESTAMP 8
79 PRODUCT_HIER_COMMIT_TIMESTAMP TIMESTAMP 8
80 PRODUCT_HIST_COMMIT_TIMESTAMP TIMESTAMP 8