DIM_BNK_OF_ACCOUNT_HIER

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_SID BIGINT 8
2 ACCOUNT_HIERARCHY_SID BIGINT 8
3 ACCOUNT_HIERARCHY_DIM_ID CHARACTER VARYING(150) 150
4 ACCOUNT_CODE CHARACTER VARYING(150) 150
5 CREATED_DATE TIMESTAMP 8
6 CHANGED_DATE TIMESTAMP 8
7 ACCOUNT_LEVEL_01_CODE CHARACTER VARYING(60) 60
8 BUSINESS_LOAD_DATE TIMESTAMP 8
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8