INT_ATOCRS_HIST_SOURCE_INDICIA_PHONE_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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