DIM_CUST_H_SOURCE_CUST

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_DIM_CUST_H_SOURCE_CUST

SDSNZP02_BANK..NROD_DIM_CUST_H_SOURCE_CUST

Columns
# Name Data Type Length
1 CUST_NUM NUMERIC(19,0) 19
2 CUST_ID BIGINT 8
3 PRDT_SYS_CODE CHARACTER VARYING(10) 10
4 PRDT_SYS_CODE_CDI CHARACTER VARYING(10) 10
5 PRDT_SYS_CUST_NUM CHARACTER VARYING(30) 30
6 PRDT_SYS_CUST_NUM_CDI CHARACTER VARYING(30) 30
7 BRND_CODE CHARACTER VARYING(10) 10
8 BRND_ID BIGINT 8
9 INTN_INITIATE_MBR_ID NUMERIC(22,0) 19
10 ENTITY_TYP_CODE CHARACTER VARYING(20) 20
11 ENTTYP_ID BIGINT 8
12 GNDR_IND CHARACTER VARYING(3) 3
13 DERIVED_GNDR_IND CHARACTER VARYING(3) 3
14 TITLE CHARACTER VARYING(20) 20
15 FRST_NAM CHARACTER VARYING(100) 100
16 MIDDLE_NAM CHARACTER VARYING(100) 100
17 LST_NAM CHARACTER VARYING(100) 100
18 NAM_SUFFIX CHARACTER VARYING(50) 50
19 ORG_NAM CHARACTER VARYING(150) 150
20 BRTH_DATE TIMESTAMP 8
21 DECEASED_IND CHARACTER VARYING(3) 3
22 DECEASED_DATE TIMESTAMP 8
23 OCCUP_CODE CHARACTER VARYING(50) 50
24 OCCUP_ID BIGINT 8
25 DRVR_LIC_NUM CHARACTER VARYING(20) 20
26 DRVR_LIC_STATE_DESC CHARACTER VARYING(50) 50
27 DRVR_LIC_CNTRY_CODE CHARACTER VARYING(20) 20
28 DRVR_LIC_CNTRY_ID BIGINT 8
29 ABN CHARACTER VARYING(20) 20
30 ACN_ARBN CHARACTER VARYING(10) 10
31 ANZSIC_TYP_CODE CHARACTER VARYING(20) 20
32 ANZSIC_TYP_ID BIGINT 8
33 EMP_NUM CHARACTER VARYING(20) 20
34 ORG_CNTCT_NAM CHARACTER VARYING(100) 100
35 ORG_CNTCT_POSN CHARACTER VARYING(50) 50
36 LIFECYCLE_STAT_CODE CHARACTER VARYING(50) 50
37 LIFECYCLE_STAT_ID BIGINT 8
38 SRC_SYS_ID CHARACTER VARYING(5) 5
39 DECEASED_FLAG_SUPPLIED CHARACTER VARYING(1) 1