DIM_ATOCRS_CUSTOMER_INDICIA_METADATA_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 REC_TYPE CHARACTER VARYING(6) 6
2 SOURCE_SYSTEM CHARACTER VARYING(13) 13
3 DATA_SOURCE_APPLICATION CHARACTER VARYING(23) 23
4 FOREIGN_INDICIA_RECORD_TYPE CHARACTER VARYING(22) 22
5 FOREIGN_INDICIA_RECORD_SUB_TYPE CHARACTER VARYING(23) 23
6 FOREIGN_INDICIA_DATA_SOURCE CHARACTER VARYING(11) 11
7 GCIS_CUSTOMER_NUMBER CHARACTER VARYING(20) 20
8 PRDT_SYS_CODE CHARACTER VARYING(13) 13
9 PRDT_SYS_CUST_NUM CHARACTER VARYING(17) 17
10 FOREIGN_INDICIA_COUNTRY_CODE CHARACTER VARYING(28) 28
11 FOREIGN_INDICIA_COUNTRY CHARACTER VARYING(23) 23
12 FOREIGN_INDICIA_START_TIMESTAMP CHARACTER VARYING(31) 31
13 FOREIGN_INDICIA_END_TIMESTAMP CHARACTER VARYING(29) 29
14 SRC_FIELD1 CHARACTER VARYING(20) 20
15 SRC_FIELD2 CHARACTER VARYING(21) 21
16 SRC_FIELD3 CHARACTER VARYING(22) 22
17 SRC_FIELD4 CHARACTER VARYING(25) 25
18 SRC_FIELD5 CHARACTER VARYING(23) 23
19 SRC_FIELD6 CHARACTER VARYING(24) 24
20 SRC_FIELD7 CHARACTER VARYING(25) 25
21 SRC_FIELD8 CHARACTER VARYING(27) 27
22 SRC_FIELD9 CHARACTER VARYING(15) 15
23 SRC_FIELD10 CHARACTER VARYING(16) 16
24 RECORD_START_TIMESTAMP CHARACTER VARYING(22) 22
25 RECORD_END_TIMESTAMP CHARACTER VARYING(20) 20