KYC_TKYCR_AUSTRAC_EVIDENCE_TYPE

Database

SDSNZS01_KYC

Schema

CDCPADM_KYC

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AUSTRAC_EVIDENCE_TYPE_ID BIGINT 8
2 CLASSIFICATION_ID BIGINT 8
3 EVIDENCE_GROUP_ID BIGINT 8
4 EVIDENCE_TYPE_ID BIGINT 8
5 EVIDENCE_ISSUER_ID BIGINT 8
6 AUSPOST_EVIDENCE_TYPE_ID BIGINT 8
7 AUSTRAC_TYPE CHARACTER VARYING(4) 4
8 REPORTABLE_FLAG CHARACTER VARYING(1) 1
9 OTHER_TYPE_PROPERTY CHARACTER VARYING(50) 50
10 OTHER_TYPE_DEFAULT CHARACTER VARYING(50) 50
11 DOCUMENT_NUMBER_PROPERTY CHARACTER VARYING(50) 50
12 DOCUMENT_NUMBER_DEFAULT CHARACTER VARYING(50) 50
13 ISSUER_PROPERTY CHARACTER VARYING(50) 50
14 ISSUER_DEFAULT CHARACTER VARYING(50) 50
15 COUNTRY_CODE_PROPERTY CHARACTER VARYING(50) 50
16 COUNTRY_CODE_DEFAULT CHARACTER VARYING(50) 50
17 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
19 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
20 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8