INT_ATOCRS_GCIS_INDICIA_PHONE_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CIS_PROFILE_ID INTEGER 4
2 PHONE_TYPE CHARACTER VARYING(4) 4
3 PHONE_NUMBER CHARACTER VARYING(20) 20
4 FOREIGN_INDICIA_FLAG CHARACTER VARYING(7) 7
5 COUNTRY_ISD_CODE CHARACTER VARYING(100) 100
6 COUNTRY_SPECIFIC_AREA_CODE CHARACTER VARYING(255) 255
7 FOREIGN_INDICIA_PATTERN CHARACTER VARYING(355) 355
8 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(10) 10
9 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(255) 255
10 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(5) 5
11 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(20) 20
12 SOURCE_SYSTEM CHARACTER VARYING(4) 4
13 DATA_SOURCE_APPLICATION CHARACTER VARYING(14) 14
14 FOREIGN_INDICIA_DATA_SOURCE CHARACTER VARYING(39) 39
15 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
16 EFF_STRT_DATE TIMESTAMP 8
17 EFF_END_DATE TIMESTAMP 8