HOG_CIS_HST_MASTER

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BTTPS_HOG_CIS_HST_MASTER

SDSNZP02_BANK..EFS_HOG_CIS_HST_MASTER

SDSNZP02_BANK..NROD_HOG_CIS_HST_MASTER

SDSNZP02_BANK..QRMCGN_HOG_CIS_HST_MASTER

SDSNZP02_BANK..UBAR_HOG_CIS_HST_MASTER

SDSNZP05_BANK..CBA_HOG_CIS_HST_MASTER

SDSNZP05_BANK..CBP_HOG_CIS_HST_MASTER

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 KEY_COID INTEGER 4
4 CUSTOMER_NO BIGINT 8
5 CUSTOMER_NAME CHARACTER VARYING(80) 80
6 CUSTOMER_TYPE_CODE CHARACTER VARYING(2) 2
7 BUSINESS_CUSTOMER_TYPE CHARACTER VARYING(1) 1
8 BIRTH_DATE CHARACTER VARYING(10) 10
9 DECEASED_DATE CHARACTER VARYING(10) 10
10 OCCUPATION_CODE CHARACTER VARYING(4) 4
11 ANZSIC_CODE CHARACTER VARYING(4) 4
12 MARITAL_STATUS_CODE CHARACTER VARYING(1) 1
13 GENDER_CODE CHARACTER VARYING(1) 1
14 BANKRUPT_DATE CHARACTER VARYING(10) 10
15 DT_OPENED CHARACTER VARYING(10) 10
16 CUSTOMER_100POINT_IND CHARACTER VARYING(1) 1
17 LAST_MAINT_DATE CHARACTER VARYING(10) 10
18 BRANCH_NO INTEGER 4
19 PERS_PHONE_NBR CHARACTER VARYING(16) 16
20 BUS_PHONE_NBR CHARACTER VARYING(16) 16
21 PERS_MOBILE_NBR CHARACTER VARYING(16) 16
22 ABN_NUMBER CHARACTER VARYING(11) 11
23 ACN_ARBN_NO CHARACTER VARYING(10) 10
24 BUS_ESTAB_DATE CHARACTER VARYING(10) 10
25 CLOSE_DATE CHARACTER VARYING(10) 10
26 CUST_ID CHARACTER VARYING(9) 9
27 CUST_TIE_BRKR INTEGER 4
28 CUST_TYPE_IND CHARACTER VARYING(1) 1
29 LST_CONTACT_DATE CHARACTER VARYING(10) 10
30 NATIONALITY_CD CHARACTER VARYING(2) 2
31 RES_STATUS CHARACTER VARYING(1) 1
32 STATUS_CD CHARACTER VARYING(3) 3
33 DELTA_TYPE CHARACTER VARYING(1) 1
34 EFFECTIVE_STRT_DT TIMESTAMP 8
35 EFFECTIVE_END_DT TIMESTAMP 8
36 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
37 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8