sdw_tsdmd_of_costctr_hier_hst

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 cost_centre_hier_history_sid numeric 19
2 cost_centre_hierarchy_dim_id character varying 450
3 cost_centre_name character varying 720
4 cost_centre_name_cf character varying 3
5 cost_centre_level_01_name character varying 720
6 cost_centre_level_01_name_cf character varying 3
7 cost_centre_level_02_code character varying 450
8 cost_centre_level_02_code_cf character varying 3
9 cost_centre_level_02_name character varying 720
10 cost_centre_level_02_name_cf character varying 3
11 cost_centre_level_03_code character varying 450
12 cost_centre_level_03_code_cf character varying 3
13 cost_centre_level_03_name character varying 720
14 cost_centre_level_03_name_cf character varying 3
15 cost_centre_level_04_code character varying 450
16 cost_centre_level_04_code_cf character varying 3
17 cost_centre_level_04_name character varying 720
18 cost_centre_level_04_name_cf character varying 3
19 cost_centre_level_05_code character varying 450
20 cost_centre_level_05_code_cf character varying 3
21 cost_centre_level_05_name character varying 720
22 cost_centre_level_05_name_cf character varying 3
23 cost_centre_level_06_code character varying 450
24 cost_centre_level_06_code_cf character varying 3
25 cost_centre_level_06_name character varying 720
26 cost_centre_level_06_name_cf character varying 3
27 cost_centre_level_07_code character varying 450
28 cost_centre_level_07_code_cf character varying 3
29 cost_centre_level_07_name character varying 720
30 cost_centre_level_07_name_cf character varying 3
31 cost_centre_level_08_code character varying 450
32 cost_centre_level_08_code_cf character varying 3
33 cost_centre_level_08_name character varying 720
34 cost_centre_level_08_name_cf character varying 3
35 cost_centre_level_09_code character varying 450
36 cost_centre_level_09_code_cf character varying 3
37 cost_centre_level_09_name character varying 720
38 cost_centre_level_09_name_cf character varying 3
39 cost_centre_level_10_code character varying 450
40 cost_centre_level_10_code_cf character varying 3
41 cost_centre_level_10_name character varying 720
42 cost_centre_level_10_name_cf character varying 3
43 cost_centre_level_11_code character varying 450
44 cost_centre_level_11_code_cf character varying 3
45 cost_centre_level_11_name character varying 720
46 cost_centre_level_11_name_cf character varying 3
47 cost_centre_level_12_code character varying 450
48 cost_centre_level_12_code_cf character varying 3
49 cost_centre_level_12_name character varying 720
50 cost_centre_level_12_name_cf character varying 3
51 cost_centre_level_13_code character varying 450
52 cost_centre_level_13_code_cf character varying 3
53 cost_centre_level_13_name character varying 720
54 cost_centre_level_13_name_cf character varying 3
55 cost_centre_level_14_code character varying 450
56 cost_centre_level_14_code_cf character varying 3
57 cost_centre_level_14_name character varying 720
58 cost_centre_level_14_name_cf character varying 3
59 cost_centre_level_15_code character varying 450
60 cost_centre_level_15_code_cf character varying 3
61 cost_centre_level_15_name character varying 720
62 cost_centre_level_15_name_cf character varying 3
63 effective_date timestamp without time zone
64 valid_to_date timestamp without time zone
65 created_date timestamp without time zone
66 changed_date timestamp without time zone
67 cost_centre_hierarchy_sid numeric 19
68 business_load_date timestamp without time zone
69 cdc_source_system_code character varying 12
70 cdc_record_type character varying 48
71 cdc_commit_timestamp timestamp without time zone
72 cdc_extract_timestamp timestamp without time zone