ADW_CHANNEL_HIERARCHY_HISTORY

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CHANNEL_HIERARCH_HISTORY_SID BIGINT 8
2 CHANNEL_HIERARCHY_DIM_ID CHARACTER VARYING(150) 150
3 CHANNEL_NAME CHARACTER VARYING(240) 240
4 CHANNEL_NAME_CF CHARACTER(1) 1
5 CHANNEL_LEVEL_01_NAME CHARACTER VARYING(240) 240
6 CHANNEL_LEVEL_01_NAME_CF CHARACTER(1) 1
7 CHANNEL_LEVEL_02_CODE CHARACTER VARYING(150) 150
8 CHANNEL_LEVEL_02_CODE_CF CHARACTER(1) 1
9 CHANNEL_LEVEL_02_NAME CHARACTER VARYING(240) 240
10 CHANNEL_LEVEL_02_NAME_CF CHARACTER(1) 1
11 CHANNEL_LEVEL_03_CODE CHARACTER VARYING(150) 150
12 CHANNEL_LEVEL_03_CODE_CF CHARACTER(1) 1
13 CHANNEL_LEVEL_03_NAME CHARACTER VARYING(240) 240
14 CHANNEL_LEVEL_03_NAME_CF CHARACTER(1) 1
15 CHANNEL_LEVEL_04_CODE CHARACTER VARYING(150) 150
16 CHANNEL_LEVEL_04_CODE_CF CHARACTER(1) 1
17 CHANNEL_LEVEL_04_NAME CHARACTER VARYING(240) 240
18 CHANNEL_LEVEL_04_NAME_CF CHARACTER(1) 1
19 CHANNEL_LEVEL_05_CODE CHARACTER VARYING(150) 150
20 CHANNEL_LEVEL_05_CODE_CF CHARACTER(1) 1
21 CHANNEL_LEVEL_05_NAME CHARACTER VARYING(240) 240
22 CHANNEL_LEVEL_05_NAME_CF CHARACTER(1) 1
23 CHANNEL_LEVEL_06_CODE CHARACTER VARYING(150) 150
24 CHANNEL_LEVEL_06_CODE_CF CHARACTER(1) 1
25 CHANNEL_LEVEL_06_NAME CHARACTER VARYING(240) 240
26 CHANNEL_LEVEL_06_NAME_CF CHARACTER(1) 1
27 CHANNEL_LEVEL_07_CODE CHARACTER VARYING(150) 150
28 CHANNEL_LEVEL_07_CODE_CF CHARACTER(1) 1
29 CHANNEL_LEVEL_07_NAME CHARACTER VARYING(240) 240
30 CHANNEL_LEVEL_07_NAME_CF CHARACTER(1) 1
31 CHANNEL_LEVEL_08_CODE CHARACTER VARYING(150) 150
32 CHANNEL_LEVEL_08_CODE_CF CHARACTER(1) 1
33 CHANNEL_LEVEL_08_NAME CHARACTER VARYING(240) 240
34 CHANNEL_LEVEL_08_NAME_CF CHARACTER(1) 1
35 CHANNEL_LEVEL_09_CODE CHARACTER VARYING(150) 150
36 CHANNEL_LEVEL_09_CODE_CF CHARACTER(1) 1
37 CHANNEL_LEVEL_09_NAME CHARACTER VARYING(240) 240
38 CHANNEL_LEVEL_09_NAME_CF CHARACTER(1) 1
39 CHANNEL_LEVEL_10_CODE CHARACTER VARYING(150) 150
40 CHANNEL_LEVEL_10_CODE_CF CHARACTER(1) 1
41 CHANNEL_LEVEL_10_NAME CHARACTER VARYING(240) 240
42 CHANNEL_LEVEL_10_NAME_CF CHARACTER(1) 1
43 CHANNEL_LEVEL_11_CODE CHARACTER VARYING(150) 150
44 CHANNEL_LEVEL_11_CODE_CF CHARACTER(1) 1
45 CHANNEL_LEVEL_11_NAME CHARACTER VARYING(240) 240
46 CHANNEL_LEVEL_11_NAME_CF CHARACTER(1) 1
47 CHANNEL_LEVEL_12_CODE CHARACTER VARYING(150) 150
48 CHANNEL_LEVEL_12_CODE_CF CHARACTER(1) 1
49 CHANNEL_LEVEL_12_NAME CHARACTER VARYING(240) 240
50 CHANNEL_LEVEL_12_NAME_CF CHARACTER(1) 1
51 CHANNEL_LEVEL_13_CODE CHARACTER VARYING(150) 150
52 CHANNEL_LEVEL_13_CODE_CF CHARACTER(1) 1
53 CHANNEL_LEVEL_13_NAME CHARACTER VARYING(240) 240
54 CHANNEL_LEVEL_13_NAME_CF CHARACTER(1) 1
55 CHANNEL_LEVEL_14_CODE CHARACTER VARYING(150) 150
56 CHANNEL_LEVEL_14_CODE_CF CHARACTER(1) 1
57 CHANNEL_LEVEL_14_NAME CHARACTER VARYING(240) 240
58 CHANNEL_LEVEL_14_NAME_CF CHARACTER(1) 1
59 CHANNEL_LEVEL_15_CODE CHARACTER VARYING(150) 150
60 CHANNEL_LEVEL_15_CODE_CF CHARACTER(1) 1
61 CHANNEL_LEVEL_15_NAME CHARACTER VARYING(240) 240
62 CHANNEL_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 CHANNEL_HIERARCHY_SID BIGINT 8