DIM_BNK_OF_COST_CENTRE_FLAT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 OF_COST_CENTRE_SID BIGINT 8
2 OF_COST_CENTRE_CODE CHARACTER VARYING(150) 150
3 COST_CENTRE_NAME CHARACTER VARYING(240) 240
4 COST_CENTRE_CODE_NAME CHARACTER VARYING(393) 393
5 COST_CENTRE_NAME_CODE CHARACTER VARYING(393) 393
6 SUNCORP_BANKING_LEVEL_02_NAME CHARACTER VARYING(240) 240
7 SUNCORP_BANKING_LEVEL_03_NAME CHARACTER VARYING(240) 240
8 SUNCORP_BANKING_LEVEL_04_NAME CHARACTER VARYING(240) 240
9 SUNCORP_BANKING_LEVEL_05_NAME CHARACTER VARYING(240) 240
10 BANK_STATES_LEVEL_02_NAME CHARACTER VARYING(240) 240
11 BANK_STATES_LEVEL_03_NAME CHARACTER VARYING(240) 240
12 BANK_STATE CHARACTER VARYING(240) 240
13 BANK_STATE_NAME CHARACTER VARYING(240) 240
14 BANK_CHANNELS_LEVEL_02_NAME CHARACTER VARYING(240) 240
15 BANK_CHANNELS_LEVEL_03_NAME CHARACTER VARYING(240) 240
16 BUSINESS_LOAD_DATE TIMESTAMP 8
17 REGION CHARACTER VARYING(240) 240
18 REGIONAL_AREA CHARACTER VARYING(240) 240
19 BRANCH_NAME CHARACTER VARYING(105) 105
20 IN_TERM_DEPOSITS_SSM_YN CHARACTER VARYING(1) 1
21 IN_DEPOSITS_SSM_YN CHARACTER VARYING(1) 1
22 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
23 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
25 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8