KYC_TKYCT_EVIDENCE

Database

SDSNZS01_KYC

Schema

CDCPADM_KYC

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EVIDENCE_ID BIGINT 8
2 CUSTOMER_ID BIGINT 8
3 EVIDENCE_TYPE_ID BIGINT 8
4 EVIDENCE_GROUP_ID BIGINT 8
5 EVIDENCE_ISSUER_ID BIGINT 8
6 ISSUE_DATE TIMESTAMP 8
7 EXPIRY_DATE TIMESTAMP 8
8 COLLECTION_DATE TIMESTAMP 8
9 EVIDENCE_STANDARD_ID BIGINT 8
10 EVIDENCE_ISSUER_DESC CHARACTER VARYING(100) 100
11 ARCHIVE_REF_NUM CHARACTER VARYING(60) 60
12 ACCRED_TRANSLATOR_NAME CHARACTER VARYING(40) 40
13 SIGHTED_DOCUMENT_FLAG CHARACTER VARYING(1) 1
14 REASON CHARACTER VARYING(100) 100
15 CREATED_BY CHARACTER VARYING(10) 10
16 CREATED_DATETIME TIMESTAMP 8
17 UPDATED_BY CHARACTER VARYING(10) 10
18 UPDATED_DATETIME TIMESTAMP 8
19 VERSION BIGINT 8
20 VALIDATION_RESULT CHARACTER VARYING(10) 10
21 VALIDATED_BY CHARACTER VARYING(10) 10
22 VALIDATION_DATE TIMESTAMP 8
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8