INT_ATOCRS_KYC_INDICIA_ADDRESS

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUSTOMER_ID BIGINT 8
2 CIS_PROFILE_ID BIGINT 8
3 ADDR_TYP_CODE CHARACTER VARYING(5) 5
4 ADDR_LNE_1 CHARACTER VARYING(50) 50
5 ADDR_LNE_2 CHARACTER VARYING(50) 50
6 ADDR_LNE_3 CHARACTER VARYING(50) 50
7 ADDR_LNE_4 CHARACTER VARYING(1) 1
8 ADDR_LNE_5 CHARACTER VARYING(1) 1
9 SBRB_CODE CHARACTER VARYING(50) 50
10 PCODE CHARACTER VARYING(10) 10
11 STATE_DESC CHARACTER VARYING(30) 30
12 CNTRY_CODE CHARACTER VARYING(2) 2
13 FOREIGN_INDICIA_FLAG CHARACTER VARYING(7) 7
14 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(10) 10
15 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
16 FOREIGN_INDICIA_PATTERN CHARACTER VARYING(100) 100
17 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(7) 7
18 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(8) 8
19 SOURCE_SYSTEM CHARACTER VARYING(3) 3
20 DATA_SOURCE_APPLICATION CHARACTER VARYING(3) 3
21 FOREIGN_INDICIA_DATA_SOURCE CHARACTER VARYING(35) 35
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8