DIM_CUST_H_GCIS_CUST

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_DIM_CUST_H_GCIS_CUST

SDSNZP02_BANK..DIM_CUST_H_GCIS_CUST

SDSNZP02_BANK..NROD_DIM_CUST_H_GCIS_CUST

Columns
# Name Data Type Length
1 CIS_PROFILE_ID INTEGER 4
2 BRND_CODE CHARACTER VARYING(10) 10
3 BRND_ID BIGINT 8
4 ENTITY_TYP_CODE CHARACTER VARYING(1) 1
5 ENTTYP_ID BIGINT 8
6 GNDR_IND CHARACTER VARYING(1) 1
8 FRST_NAM CHARACTER VARYING(30) 30
9 MIDDLE_NAM CHARACTER VARYING(60) 60
10 LST_NAM CHARACTER VARYING(40) 40
11 NAM_SUFFIX CHARACTER VARYING(30) 30
12 ORG_NAM CHARACTER VARYING(120) 120
13 COMPANY_TYPE INTEGER 4
14 BRTH_DATE DATE 4
15 DECEASED_IND CHARACTER VARYING(1) 1
16 OCCUPATION_CODE INTEGER 4
17 OCCUPATION_ID BIGINT 8
18 DRVR_LIC_NUM CHARACTER VARYING(10) 10
19 ABN CHARACTER VARYING(11) 11
20 ACN_ARBN CHARACTER VARYING(9) 9
22 ANZSIC_TYPE_ID BIGINT 8
23 ANZSIC_TYPE_DESC CHARACTER VARYING(100) 100
24 CUSTOMER_PACKAGE INTEGER 4
25 WEBSITE CHARACTER VARYING(254) 254
26 CUSTOMER_TYPE INTEGER 4
27 SRC_SYS_ID CHARACTER VARYING(5) 5
29 EFF_STRT_DATE TIMESTAMP 8
30 EFF_END_DATE TIMESTAMP 8
31 IS_RECORD_CURRENT CHARACTER VARYING(3) 3
32 IS_RECORD_DELETED CHARACTER VARYING(3) 3
33 SNPSHT_DATE DATE 4