DIM_BNK_OF_COSTCTR_HIER_HST_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COST_CENTRE_HIER_HISTORY_SID BIGINT 8
2 COST_CENTRE_HIERARCHY_DIM_ID CHARACTER VARYING(150) 150
3 COST_CENTRE_NAME CHARACTER VARYING(240) 240
4 COST_CENTRE_NAME_CF CHARACTER(1) 1
5 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
6 COST_CENTRE_LEVEL_01_NAME_CF CHARACTER(1) 1
7 COST_CENTRE_LEVEL_02_CODE CHARACTER VARYING(150) 150
8 COST_CENTRE_LEVEL_02_CODE_CF CHARACTER(1) 1
9 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
10 COST_CENTRE_LEVEL_02_NAME_CF CHARACTER(1) 1
11 COST_CENTRE_LEVEL_03_CODE CHARACTER VARYING(150) 150
12 COST_CENTRE_LEVEL_03_CODE_CF CHARACTER(1) 1
13 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
14 COST_CENTRE_LEVEL_03_NAME_CF CHARACTER(1) 1
15 COST_CENTRE_LEVEL_04_CODE CHARACTER VARYING(150) 150
16 COST_CENTRE_LEVEL_04_CODE_CF CHARACTER(1) 1
17 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
18 COST_CENTRE_LEVEL_04_NAME_CF CHARACTER(1) 1
19 COST_CENTRE_LEVEL_05_CODE CHARACTER VARYING(150) 150
20 COST_CENTRE_LEVEL_05_CODE_CF CHARACTER(1) 1
21 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
22 COST_CENTRE_LEVEL_05_NAME_CF CHARACTER(1) 1
23 COST_CENTRE_LEVEL_06_CODE CHARACTER VARYING(150) 150
24 COST_CENTRE_LEVEL_06_CODE_CF CHARACTER(1) 1
25 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
26 COST_CENTRE_LEVEL_06_NAME_CF CHARACTER(1) 1
27 COST_CENTRE_LEVEL_07_CODE CHARACTER VARYING(150) 150
28 COST_CENTRE_LEVEL_07_CODE_CF CHARACTER(1) 1
29 COST_CENTRE_LEVEL_07_NAME CHARACTER VARYING(240) 240
30 COST_CENTRE_LEVEL_07_NAME_CF CHARACTER(1) 1
31 COST_CENTRE_LEVEL_08_CODE CHARACTER VARYING(150) 150
32 COST_CENTRE_LEVEL_08_CODE_CF CHARACTER(1) 1
33 COST_CENTRE_LEVEL_08_NAME CHARACTER VARYING(240) 240
34 COST_CENTRE_LEVEL_08_NAME_CF CHARACTER(1) 1
35 COST_CENTRE_LEVEL_09_CODE CHARACTER VARYING(150) 150
36 COST_CENTRE_LEVEL_09_CODE_CF CHARACTER(1) 1
37 COST_CENTRE_LEVEL_09_NAME CHARACTER VARYING(240) 240
38 COST_CENTRE_LEVEL_09_NAME_CF CHARACTER(1) 1
39 COST_CENTRE_LEVEL_10_CODE CHARACTER VARYING(150) 150
40 COST_CENTRE_LEVEL_10_CODE_CF CHARACTER(1) 1
41 COST_CENTRE_LEVEL_10_NAME CHARACTER VARYING(240) 240
42 COST_CENTRE_LEVEL_10_NAME_CF CHARACTER(1) 1
43 COST_CENTRE_LEVEL_11_CODE CHARACTER VARYING(150) 150
44 COST_CENTRE_LEVEL_11_CODE_CF CHARACTER(1) 1
45 COST_CENTRE_LEVEL_11_NAME CHARACTER VARYING(240) 240
46 COST_CENTRE_LEVEL_11_NAME_CF CHARACTER(1) 1
47 COST_CENTRE_LEVEL_12_CODE CHARACTER VARYING(150) 150
48 COST_CENTRE_LEVEL_12_CODE_CF CHARACTER(1) 1
49 COST_CENTRE_LEVEL_12_NAME CHARACTER VARYING(240) 240
50 COST_CENTRE_LEVEL_12_NAME_CF CHARACTER(1) 1
51 COST_CENTRE_LEVEL_13_CODE CHARACTER VARYING(150) 150
52 COST_CENTRE_LEVEL_13_CODE_CF CHARACTER(1) 1
53 COST_CENTRE_LEVEL_13_NAME CHARACTER VARYING(240) 240
54 COST_CENTRE_LEVEL_13_NAME_CF CHARACTER(1) 1
55 COST_CENTRE_LEVEL_14_CODE CHARACTER VARYING(150) 150
56 COST_CENTRE_LEVEL_14_CODE_CF CHARACTER(1) 1
57 COST_CENTRE_LEVEL_14_NAME CHARACTER VARYING(240) 240
58 COST_CENTRE_LEVEL_14_NAME_CF CHARACTER(1) 1
59 COST_CENTRE_LEVEL_15_CODE CHARACTER VARYING(150) 150
60 COST_CENTRE_LEVEL_15_CODE_CF CHARACTER(1) 1
61 COST_CENTRE_LEVEL_15_NAME CHARACTER VARYING(240) 240
62 COST_CENTRE_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 COST_CENTRE_HIERARCHY_SID BIGINT 8
68 BUSINESS_LOAD_DATE TIMESTAMP 8
69 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
70 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
71 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
72 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8