HOGR_BANK

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 BANK_NUMBER CHARACTER VARYING(3) 3
3 EFFECTIVE_DATE CHARACTER VARYING(10) 10
4 EXPIRY_DATE CHARACTER VARYING(10) 10
5 LAST_MAINTENANCE_DATE CHARACTER VARYING(10) 10
6 CCID CHARACTER VARYING(10) 10
7 OPERATOR_ID CHARACTER VARYING(8) 8
8 BANK_NAME CHARACTER VARYING(60) 60
9 BANK_NAME_ABBREVIATION CHARACTER VARYING(3) 3
10 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
11 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
12 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
13 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8