DIM_OBP_OF_COST_CENTRE_FLAT_V

Database

SDSNZP05_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 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8