ADW_CATEGORY_HIERARCHY_HISTORY

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CATEGORY_HIERARC_HISTORY_SID BIGINT 8
2 CATEGORY_HIERARCHY_DIM_ID CHARACTER VARYING(150) 150
3 CATEGORY_NAME CHARACTER VARYING(240) 240
4 CATEGORY_NAME_CF CHARACTER(1) 1
5 CATEGORY_LEVEL_01_NAME CHARACTER VARYING(240) 240
6 CATEGORY_LEVEL_01_NAME_CF CHARACTER(1) 1
7 CATEGORY_LEVEL_02_CODE CHARACTER VARYING(150) 150
8 CATEGORY_LEVEL_02_CODE_CF CHARACTER(1) 1
9 CATEGORY_LEVEL_02_NAME CHARACTER VARYING(240) 240
10 CATEGORY_LEVEL_02_NAME_CF CHARACTER(1) 1
11 CATEGORY_LEVEL_03_CODE CHARACTER VARYING(150) 150
12 CATEGORY_LEVEL_03_CODE_CF CHARACTER(1) 1
13 CATEGORY_LEVEL_03_NAME CHARACTER VARYING(240) 240
14 CATEGORY_LEVEL_03_NAME_CF CHARACTER(1) 1
15 CATEGORY_LEVEL_04_CODE CHARACTER VARYING(150) 150
16 CATEGORY_LEVEL_04_CODE_CF CHARACTER(1) 1
17 CATEGORY_LEVEL_04_NAME CHARACTER VARYING(240) 240
18 CATEGORY_LEVEL_04_NAME_CF CHARACTER(1) 1
19 CATEGORY_LEVEL_05_CODE CHARACTER VARYING(150) 150
20 CATEGORY_LEVEL_05_CODE_CF CHARACTER(1) 1
21 CATEGORY_LEVEL_05_NAME CHARACTER VARYING(240) 240
22 CATEGORY_LEVEL_05_NAME_CF CHARACTER(1) 1
23 CATEGORY_LEVEL_06_CODE CHARACTER VARYING(150) 150
24 CATEGORY_LEVEL_06_CODE_CF CHARACTER(1) 1
25 CATEGORY_LEVEL_06_NAME CHARACTER VARYING(240) 240
26 CATEGORY_LEVEL_06_NAME_CF CHARACTER(1) 1
27 CATEGORY_LEVEL_07_CODE CHARACTER VARYING(150) 150
28 CATEGORY_LEVEL_07_CODE_CF CHARACTER(1) 1
29 CATEGORY_LEVEL_07_NAME CHARACTER VARYING(240) 240
30 CATEGORY_LEVEL_07_NAME_CF CHARACTER(1) 1
31 CATEGORY_LEVEL_08_CODE CHARACTER VARYING(150) 150
32 CATEGORY_LEVEL_08_CODE_CF CHARACTER(1) 1
33 CATEGORY_LEVEL_08_NAME CHARACTER VARYING(240) 240
34 CATEGORY_LEVEL_08_NAME_CF CHARACTER(1) 1
35 CATEGORY_LEVEL_09_CODE CHARACTER VARYING(150) 150
36 CATEGORY_LEVEL_09_CODE_CF CHARACTER(1) 1
37 CATEGORY_LEVEL_09_NAME CHARACTER VARYING(240) 240
38 CATEGORY_LEVEL_09_NAME_CF CHARACTER(1) 1
39 CATEGORY_LEVEL_10_CODE CHARACTER VARYING(150) 150
40 CATEGORY_LEVEL_10_CODE_CF CHARACTER(1) 1
41 CATEGORY_LEVEL_10_NAME CHARACTER VARYING(240) 240
42 CATEGORY_LEVEL_10_NAME_CF CHARACTER(1) 1
43 CATEGORY_LEVEL_11_CODE CHARACTER VARYING(150) 150
44 CATEGORY_LEVEL_11_CODE_CF CHARACTER(1) 1
45 CATEGORY_LEVEL_11_NAME CHARACTER VARYING(240) 240
46 CATEGORY_LEVEL_11_NAME_CF CHARACTER(1) 1
47 CATEGORY_LEVEL_12_CODE CHARACTER VARYING(150) 150
48 CATEGORY_LEVEL_12_CODE_CF CHARACTER(1) 1
49 CATEGORY_LEVEL_12_NAME CHARACTER VARYING(240) 240
50 CATEGORY_LEVEL_12_NAME_CF CHARACTER(1) 1
51 CATEGORY_LEVEL_13_CODE CHARACTER VARYING(150) 150
52 CATEGORY_LEVEL_13_CODE_CF CHARACTER(1) 1
53 CATEGORY_LEVEL_13_NAME CHARACTER VARYING(240) 240
54 CATEGORY_LEVEL_13_NAME_CF CHARACTER(1) 1
55 CATEGORY_LEVEL_14_CODE CHARACTER VARYING(150) 150
56 CATEGORY_LEVEL_14_CODE_CF CHARACTER(1) 1
57 CATEGORY_LEVEL_14_NAME CHARACTER VARYING(240) 240
58 CATEGORY_LEVEL_14_NAME_CF CHARACTER(1) 1
59 CATEGORY_LEVEL_15_CODE CHARACTER VARYING(150) 150
60 CATEGORY_LEVEL_15_CODE_CF CHARACTER(1) 1
61 CATEGORY_LEVEL_15_NAME CHARACTER VARYING(240) 240
62 CATEGORY_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 CATEGORY_HIERARCHY_SID BIGINT 8