KYC_HST_TKYCR_RELATED_PARTY_TYPE_FATCA_CUTOFF

Database

SDSNZS01_KYC

Schema

CDCPADM_KYC

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RELATED_PARTY_TYPE_ID BIGINT 8
2 RELATED_PARTY_TYPE_DESC CHARACTER VARYING(30) 30
3 ADDRESS_REQUIRED CHARACTER VARYING(1) 1
4 VERIFICATION_REQUIRED CHARACTER VARYING(1) 1
5 HUB_SEARCH_ALLOWED_FLAG CHARACTER VARYING(1) 1
6 NAME_DISPLAY_KEY CHARACTER VARYING(30) 30
7 SHOW_NAME_REQUIRED CHARACTER VARYING(1) 1
8 ADDRESS_DISPLAY_KEY CHARACTER VARYING(30) 30
9 RELATED_PARTY_TYPE_CODE CHARACTER VARYING(10) 10
10 ALLOWED_CLASSIFICATIONS CHARACTER VARYING(40) 40
11 AML_STATUS_REQUIRED CHARACTER VARYING(1) 1
12 AML_METHOD_REQUIRED CHARACTER VARYING(1) 1
13 AML_DETAILS_REQUIRED CHARACTER VARYING(1) 1
14 DOB_REQUIRED CHARACTER VARYING(1) 1
15 FATCA_IND_REQUIRED CHARACTER VARYING(1) 1
16 FATCA_METHOD_REQUIRED CHARACTER VARYING(1) 1
17 FATCA_DETAILS_REQUIRED 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