KYC_TKYCT_CUSTOMER_FATCA_CUTOFF

Database

SDSNZS01_KYC

Schema

CDCPADM_KYC

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUSTOMER_ID BIGINT 8
2 HUB_CUSTOMER_ID BIGINT 8
3 KYC_STATUS CHARACTER VARYING(1) 1
4 ACTIVE_STATUS CHARACTER VARYING(10) 10
5 CHANNEL_ID BIGINT 8
6 VERIFIED_BY CHARACTER VARYING(100) 100
7 VERIFYING_ENTITY CHARACTER VARYING(100) 100
8 VERIFIED_DATE TIMESTAMP 8
9 CREATED_BY CHARACTER VARYING(10) 10
10 CREATED_DATETIME TIMESTAMP 8
11 UPDATED_BY CHARACTER VARYING(10) 10
12 UPDATED_DATETIME TIMESTAMP 8
13 CLASSIFICATION_ID BIGINT 8
14 ID_PROCEDURE_TYPE_ID BIGINT 8
15 OVERRIDE_STATUS_REASON CHARACTER VARYING(400) 400
16 VERSION BIGINT 8
17 US_TAX_LIABLE_STATUS CHARACTER VARYING(1) 1
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8