DIM_BNK_EFS_ACCOUNT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
3 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
4 DATE_CLOSED TIMESTAMP 8
5 DATE_OPEN TIMESTAMP 8
6 COMPANY_CODE CHARACTER VARYING(5) 5
7 BDM_CODE CHARACTER VARYING(254) 254
8 BDM_NAME CHARACTER VARYING(256) 256
9 DATE_CLOSED_FINAL TIMESTAMP 8
10 MIGRATED_STATUS CHARACTER VARYING(8) 8
11 MIGRATED_DATE TIMESTAMP 8
12 SOURCE_SYSTEM_GROUP CHARACTER VARYING(12) 12