DIM_ATOCRS_GCM_CUSTOMER_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 EXTRACT_DATE DATE 4
2 GCIS_CUSTOMER_NUMBER INTEGER 4
3 CUSTOMER_TYPE CHARACTER VARYING(12) 12
4 PROFILE_STATUS CHARACTER VARYING(1) 1
5 NEW_GCIS_CUSTOMER_NUMBER_1 INTEGER 4
6 NEW_GCIS_CUSTOMER_NUMBER_2 INTEGER 4
7 ORGANISATION_NAME CHARACTER VARYING(120) 120
8 PERSONAL_TITLE CHARACTER VARYING(30) 30
9 FIRST_NAME CHARACTER VARYING(30) 30
10 MIDDLE_NAME CHARACTER VARYING(60) 60
11 LAST_NAME CHARACTER VARYING(40) 40
12 NAME_SUFFIX CHARACTER VARYING(30) 30
13 PREF_NAME CHARACTER VARYING(30) 30
14 UNSCRUB_NAME CHARACTER VARYING(1014) 1014
15 DATE_OF_BIRTH DATE 4
16 GENDER CHARACTER VARYING(1) 1
17 DRIVERS_LICENCE CHARACTER VARYING(10) 10
18 RESIDENTIAL_ADDRESS_LINE_1 CHARACTER VARYING(50) 50
19 RESIDENTIAL_ADDRESS_LINE_2 CHARACTER VARYING(50) 50
20 RESIDENTIAL_ADDRESS_LINE_3 CHARACTER VARYING(50) 50
21 RESIDENTIAL_CITY_TWN_SUBURB CHARACTER VARYING(40) 40
22 RESIDENTIAL_POST_CODE CHARACTER VARYING(10) 10
23 RESIDENTIAL_STATE CHARACTER VARYING(30) 30
24 RESIDENTIAL_COUNTRY CHARACTER VARYING(2) 2
25 MAIL_ADDRESS_LINE_1 CHARACTER VARYING(50) 50
26 MAIL_ADDRESS_LINE_2 CHARACTER VARYING(50) 50
27 MAIL_ADDRESS_LINE_3 CHARACTER VARYING(50) 50
28 MAIL_CITY_TWN_SUBURB CHARACTER VARYING(40) 40
29 MAIL_POST_CODE CHARACTER VARYING(10) 10
30 MAIL_STATE CHARACTER VARYING(30) 30
31 MAIL_COUNTRY CHARACTER VARYING(2) 2
32 DECEASED_IND CHARACTER VARYING(1) 1
33 ABN CHARACTER VARYING(11) 11
34 ACN CHARACTER VARYING(9) 9
35 ARBN CHARACTER VARYING(9) 9
36 SRC_SYS_WRITTEN CHARACTER VARYING(3) 3
37 CUSTOMER_TYPE_CODE INTEGER 4
38 COMPANY_TYPE INTEGER 4
39 OCCUPATION_CODE INTEGER 4
40 CUSTOMER_PACKAGE INTEGER 4
41 WEBSITE CHARACTER VARYING(254) 254