INT_ATOCRS_SOURCE_INDICIA_PHONE_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CUST_NUM NUMERIC(19,0) 19
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
4 PHONE_TYPE CHARACTER VARYING(4) 4
5 PHONE_NUMBER CHARACTER VARYING(20) 20
6 FOREIGN_INDICIA_FLAG CHARACTER VARYING(7) 7
7 COUNTRY_ISD_CODE CHARACTER VARYING(100) 100
8 COUNTRY_SPECIFIC_AREA_CODE CHARACTER VARYING(255) 255
9 FOREIGN_INDICIA_PATTERN CHARACTER VARYING(355) 355
10 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(10) 10
11 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
12 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(5) 5
13 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(20) 20
14 SOURCE_SYSTEM CHARACTER VARYING(11) 11
15 DATA_SOURCE_APPLICATION CHARACTER VARYING(14) 14
16 FOREIGN_INDICIA_DATA_SOURCE CHARACTER VARYING(41) 41
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
18 EFF_STRT_DATE TIMESTAMP 8
19 EFF_END_DATE TIMESTAMP 8