INT_ATOCRS_HIST_KYC_EVIDENCE_INDICIA

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..INT_ATOCRS_HIST_KYC_EVIDENCE_INDICIA_V

Columns
# Name Data Type Length
1 EVIDENCE_ID BIGINT 8
2 CUSTOMER_ID BIGINT 8
3 EVIDENCE_TYPE_ID BIGINT 8
4 EVIDENCE_ISSUER_ID BIGINT 8
5 ISSUER_EVIDENCE_ISSUER_ID BIGINT 8
6 EVIDENCE_ISSUER_DESC CHARACTER VARYING(100) 100
7 ISSUER_EVIDENCE_ISSUER_DESC CHARACTER VARYING(60) 60
8 EXPIRY_DATE TIMESTAMP 8
9 VALIDATION_RESULT CHARACTER VARYING(10) 10
10 VALIDATION_DATE TIMESTAMP 8
11 COLLECTION_DATE TIMESTAMP 8
12 FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
13 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(10) 10
14 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
15 FOREIGN_INDICIA_PATTERN CHARACTER VARYING(201) 201
16 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(12) 12
17 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(100) 100
18 SOURCE_SYSTEM CHARACTER VARYING(3) 3
19 DATA_SOURCE_APPLICATION CHARACTER VARYING(3) 3
20 FOREIGN_INDICIA_DATA_SOURCE CHARACTER VARYING(36) 36
21 UPDATED_DATETIME TIMESTAMP 8
22 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
23 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8