INT_ATOCRS_KYC_LEGACY_INDICIA_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CIS_PROFILE_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
4 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(22) 22
5 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(20) 20
6 FOREIGN_INDICIA_FLAG CHARACTER VARYING(1) 1
7 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(2) 2
8 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(13) 13
9 FOREIGN_INDICIA_PATTERN CHARACTER VARYING(3) 3
10 INDICIA_COUNTRY_CHANGE_INDICATOR CHARACTER VARYING(6) 6
11 SOURCE_SYSTEM CHARACTER VARYING(3) 3
12 DATA_SOURCE_APPLICATION CHARACTER VARYING(3) 3
13 FOREIGN_INDICIA_DATA_SOURCE CHARACTER VARYING(49) 49
14 US_TAX_LIABLE_STATUS CHARACTER VARYING(1) 1
15 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
16 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8