DIM_SDW_TSDMD_OF_COST_CENTRE_COMBINED_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..DIM_SDW_TSDMD_OF_COST_CENTRE_COMBINED

Synonyms

INSNZP01_BANK..SYN_DIM_SDW_TSDMD_OF_COST_CENTRE_COMBINED_INSIGHT

Columns
# Name Data Type Length
1 COST_CENTRE_SID BIGINT 8
2 COST_CENTRE_DIM_ID CHARACTER VARYING(150) 150
3 COST_CENTRE_CODE CHARACTER VARYING(150) 150
4 COST_CENTRE_NAME CHARACTER VARYING(240) 240
5 COST_CENTRE_CREATED_DATE TIMESTAMP 8
6 COST_CENTRE_CHANGED_DATE TIMESTAMP 8
7 COST_CENTRE_LEVEL_01_CODE CHARACTER VARYING(60) 60
8 COST_CENTRE_HIER_HISTORY_SID BIGINT 8
9 COST_CENTRE_HIERARCHY_DIM_ID CHARACTER VARYING(150) 150
10 COST_CENTRE_NAME_HIST CHARACTER VARYING(240) 240
11 COST_CENTRE_NAME_CF CHARACTER(1) 1
12 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
13 COST_CENTRE_LEVEL_01_NAME_CF CHARACTER(1) 1
14 COST_CENTRE_LEVEL_02_CODE CHARACTER VARYING(150) 150
15 COST_CENTRE_LEVEL_02_CODE_CF CHARACTER(1) 1
16 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
17 COST_CENTRE_LEVEL_02_NAME_CF CHARACTER(1) 1
18 COST_CENTRE_LEVEL_03_CODE CHARACTER VARYING(150) 150
19 COST_CENTRE_LEVEL_03_CODE_CF CHARACTER(1) 1
20 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
21 COST_CENTRE_LEVEL_03_NAME_CF CHARACTER(1) 1
22 COST_CENTRE_LEVEL_04_CODE CHARACTER VARYING(150) 150
23 COST_CENTRE_LEVEL_04_CODE_CF CHARACTER(1) 1
24 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
25 COST_CENTRE_LEVEL_04_NAME_CF CHARACTER(1) 1
26 COST_CENTRE_LEVEL_05_CODE CHARACTER VARYING(150) 150
27 COST_CENTRE_LEVEL_05_CODE_CF CHARACTER(1) 1
28 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
29 COST_CENTRE_LEVEL_05_NAME_CF CHARACTER(1) 1
30 COST_CENTRE_LEVEL_06_CODE CHARACTER VARYING(150) 150
31 COST_CENTRE_LEVEL_06_CODE_CF CHARACTER(1) 1
32 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
33 COST_CENTRE_LEVEL_06_NAME_CF CHARACTER(1) 1
34 COST_CENTRE_LEVEL_07_CODE CHARACTER VARYING(150) 150
35 COST_CENTRE_LEVEL_07_CODE_CF CHARACTER(1) 1
36 COST_CENTRE_LEVEL_07_NAME CHARACTER VARYING(240) 240
37 COST_CENTRE_LEVEL_07_NAME_CF CHARACTER(1) 1
38 COST_CENTRE_LEVEL_08_CODE CHARACTER VARYING(150) 150
39 COST_CENTRE_LEVEL_08_CODE_CF CHARACTER(1) 1
40 COST_CENTRE_LEVEL_08_NAME CHARACTER VARYING(240) 240
41 COST_CENTRE_LEVEL_08_NAME_CF CHARACTER(1) 1
42 COST_CENTRE_LEVEL_09_CODE CHARACTER VARYING(150) 150
43 COST_CENTRE_LEVEL_09_CODE_CF CHARACTER(1) 1
44 COST_CENTRE_LEVEL_09_NAME CHARACTER VARYING(240) 240
45 COST_CENTRE_LEVEL_09_NAME_CF CHARACTER(1) 1
46 COST_CENTRE_LEVEL_10_CODE CHARACTER VARYING(150) 150
47 COST_CENTRE_LEVEL_10_CODE_CF CHARACTER(1) 1
48 COST_CENTRE_LEVEL_10_NAME CHARACTER VARYING(240) 240
49 COST_CENTRE_LEVEL_10_NAME_CF CHARACTER(1) 1
50 COST_CENTRE_LEVEL_11_CODE CHARACTER VARYING(150) 150
51 COST_CENTRE_LEVEL_11_CODE_CF CHARACTER(1) 1
52 COST_CENTRE_LEVEL_11_NAME CHARACTER VARYING(240) 240
53 COST_CENTRE_LEVEL_11_NAME_CF CHARACTER(1) 1
54 COST_CENTRE_LEVEL_12_CODE CHARACTER VARYING(150) 150
55 COST_CENTRE_LEVEL_12_CODE_CF CHARACTER(1) 1
56 COST_CENTRE_LEVEL_12_NAME CHARACTER VARYING(240) 240
57 COST_CENTRE_LEVEL_12_NAME_CF CHARACTER(1) 1
58 COST_CENTRE_LEVEL_13_CODE CHARACTER VARYING(150) 150
59 COST_CENTRE_LEVEL_13_CODE_CF CHARACTER(1) 1
60 COST_CENTRE_LEVEL_13_NAME CHARACTER VARYING(240) 240
61 COST_CENTRE_LEVEL_13_NAME_CF CHARACTER(1) 1
62 COST_CENTRE_LEVEL_14_CODE CHARACTER VARYING(150) 150
63 COST_CENTRE_LEVEL_14_CODE_CF CHARACTER(1) 1
64 COST_CENTRE_LEVEL_14_NAME CHARACTER VARYING(240) 240
65 COST_CENTRE_LEVEL_14_NAME_CF CHARACTER(1) 1
66 COST_CENTRE_LEVEL_15_CODE CHARACTER VARYING(150) 150
67 COST_CENTRE_LEVEL_15_CODE_CF CHARACTER(1) 1
68 COST_CENTRE_LEVEL_15_NAME CHARACTER VARYING(240) 240
69 COST_CENTRE_LEVEL_15_NAME_CF CHARACTER(1) 1
70 EFFECTIVE_DATE TIMESTAMP 8
71 VALID_TO_DATE TIMESTAMP 8
72 COST_CENTRE_HIST_CREATED_DATE TIMESTAMP 8
73 COST_CENTRE_HIST_CHANGED_DATE TIMESTAMP 8
74 COST_CENTRE_HIERARCHY_SID BIGINT 8
75 BUSINESS_LOAD_DATE TIMESTAMP 8
76 CDC_COMMIT_TIMESTAMP_COST_CENTRE TIMESTAMP 8
77 CDC_COMMIT_TIMESTAMP_COST_CENTRE_HIER TIMESTAMP 8
78 CDC_COMMIT_TIMESTAMP_COST_CENTRE_HIST TIMESTAMP 8