HCIS_CUSTOMER_TB

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BTTPS_HCIS_CUSTOMER_TB

SDSNZP02_BANK..NROD_HCIS_CUSTOMER_TB

Columns
# Name Data Type Length
1 CUST_CO_NBR NUMERIC(5,0) 19
2 CUST_ID CHARACTER VARYING(9) 9
3 CUST_TIE_BRKR SMALLINT 2
4 CUST_TYPE_IND CHARACTER VARYING(1) 1
5 STATUS_CD CHARACTER VARYING(3) 3
6 OPEN_DATE DATE 4
7 CLOSE_DATE DATE 4
8 BANKRUPT_DATE DATE 4
9 LST_MAINT_DATE DATE 4
10 BRANCH_NBR NUMERIC(5,0) 19
11 SENSITIVITY_CD CHARACTER VARYING(1) 1
12 ADVERTISING_IND CHARACTER VARYING(1) 1
13 ALIAS_RECORD_IND CHARACTER VARYING(1) 1
14 EMPLOYEE_IND CHARACTER VARYING(1) 1
15 CUST_NBR NUMERIC(15,0) 19
16 CUST_TYPE_CD CHARACTER VARYING(2) 2
17 CUST_SOUNDX_KEY CHARACTER VARYING(4) 4
18 CUST_SECND_NAME_ID CHARACTER VARYING(9) 9
19 CUST_EXPAN_NAME_ID CHARACTER VARYING(19) 19
20 SSN_TAXID_SUFX_CD CHARACTER VARYING(1) 1
21 SSN_TAXID_IND CHARACTER VARYING(1) 1
22 SSN_TAXID_LM_DATE DATE 4
23 TFN_EXMPT_DGT_CNT NUMERIC(1,0) 19
24 LANGUAGE_CD CHARACTER VARYING(3) 3
25 CUST_NAME_LINE_1 CHARACTER VARYING(40) 40
26 CUST_NAME_LINE_2 CHARACTER VARYING(40) 40
27 INDV_DATA_PRES_IND CHARACTER VARYING(1) 1
28 BIRTH_DATE DATE 4
29 DECEASED_DATE DATE 4
30 SEX_CD CHARACTER VARYING(1) 1
31 MARITAL_STATUS_CD CHARACTER VARYING(1) 1
32 OCCUPATION_CD CHARACTER VARYING(4) 4
33 PERS_PHONE_NBR CHARACTER VARYING(16) 16
34 BUS_PHONE_NBR CHARACTER VARYING(16) 16
35 EMPLOYER_NAME CHARACTER VARYING(40) 40
36 COML_DATA_PRES_IND CHARACTER VARYING(1) 1
37 BUS_ESTAB_DATE DATE 4
38 SIC_CD CHARACTER VARYING(4) 4
39 TELEX_NBR CHARACTER VARYING(16) 16
40 DEMG_DATA_PRES_IND CHARACTER VARYING(1) 1
41 PRIM_OFFICER_CD CHARACTER VARYING(5) 5
42 SEC_OFFICER_CD CHARACTER VARYING(5) 5
43 COST_CENTER_NBR NUMERIC(15,0) 19
44 NATIONALITY_CD CHARACTER VARYING(2) 2
45 SEGMENT_ID CHARACTER VARYING(8) 8
46 CS_INFO_PRES_IND CHARACTER VARYING(1) 1
47 CS_INFO_VALID_DATE DATE 4
48 CS_WITH_RPT_SCORE SMALLINT 2
49 CS_WITH_RPT_DATE DATE 4
50 CS_W_O_RPT_SCORE SMALLINT 2
51 CS_W_O_RPT_DATE DATE 4
52 CUST_RISK_CATG_CD CHARACTER VARYING(3) 3
53 BANK_REL_USED_CNT SMALLINT 2
54 BANK_REL_CD_01 CHARACTER VARYING(3) 3
55 BANK_REL_CD_02 CHARACTER VARYING(3) 3
56 BANK_REL_CD_03 CHARACTER VARYING(3) 3
57 BANK_REL_CD_04 CHARACTER VARYING(3) 3
58 BANK_REL_CD_05 CHARACTER VARYING(3) 3
59 BANK_REL_CD_06 CHARACTER VARYING(3) 3
60 BANK_REL_CD_07 CHARACTER VARYING(3) 3
61 BANK_REL_CD_08 CHARACTER VARYING(3) 3
62 BANK_REL_CD_09 CHARACTER VARYING(3) 3
63 BANK_REL_CD_10 CHARACTER VARYING(3) 3
64 BANK_REL_CD_11 CHARACTER VARYING(3) 3
65 BANK_REL_CD_12 CHARACTER VARYING(3) 3
66 BANK_REL_CD_13 CHARACTER VARYING(3) 3
67 BANK_REL_CD_14 CHARACTER VARYING(3) 3
68 BANK_REL_CD_15 CHARACTER VARYING(3) 3
69 BANK_REL_CD_16 CHARACTER VARYING(3) 3
70 BANK_REL_CD_17 CHARACTER VARYING(3) 3
71 BANK_REL_CD_18 CHARACTER VARYING(3) 3
72 BANK_REL_CD_19 CHARACTER VARYING(3) 3
73 BANK_REL_CD_20 CHARACTER VARYING(3) 3
74 BANK_SVC_USED_CNT SMALLINT 2
75 BANK_SVC_CD_01 CHARACTER VARYING(3) 3
76 BANK_SVC_CD_02 CHARACTER VARYING(3) 3
77 BANK_SVC_CD_03 CHARACTER VARYING(3) 3
78 BANK_SVC_CD_04 CHARACTER VARYING(3) 3
79 BANK_SVC_CD_05 CHARACTER VARYING(3) 3
80 BANK_SVC_CD_06 CHARACTER VARYING(3) 3
81 BANK_SVC_CD_07 CHARACTER VARYING(3) 3
82 BANK_SVC_CD_08 CHARACTER VARYING(3) 3
83 BANK_SVC_CD_09 CHARACTER VARYING(3) 3
84 BANK_SVC_CD_10 CHARACTER VARYING(3) 3
85 BANK_SVC_CD_11 CHARACTER VARYING(3) 3
86 BANK_SVC_CD_12 CHARACTER VARYING(3) 3
87 BANK_SVC_CD_13 CHARACTER VARYING(3) 3
88 BANK_SVC_CD_14 CHARACTER VARYING(3) 3
89 BANK_SVC_CD_15 CHARACTER VARYING(3) 3
90 RPM_DATA_PRES_IND CHARACTER VARYING(1) 1
91 RPM_ACTY_CHRG_CLAS CHARACTER VARYING(2) 2
92 RPM_ACTY_COST_CLAS CHARACTER VARYING(2) 2
93 RPM_ACCTS_ANLY_CNT NUMERIC(5,0) 19
94 RPM_ACCTS_PRIC_CNT NUMERIC(5,0) 19
95 RPM_ACCTS_STMT_CNT NUMERIC(5,0) 19
96 RPM_CONS_CUST_CNT NUMERIC(5,0) 19
97 RPM_SRCE_POOL_NBR NUMERIC(2,0) 19
98 RPM_USE_POOL_NBR NUMERIC(2,0) 19
99 RPM_BASE_CR_RATEID CHARACTER VARYING(2) 2
100 RPM_BASE_CR_ADJ NUMERIC(7,5) 19
101 RPM_OVRDRFT_RATEID CHARACTER VARYING(2) 2
102 RPM_OVRDRFT_ADJ NUMERIC(7,5) 19
103 RPM_UNC_FND_RATEID CHARACTER VARYING(2) 2
104 RPM_UNC_FND_ADJ NUMERIC(7,5) 19
105 RPM_FISC_YR_END_MO NUMERIC(2,0) 19
106 RPM_CURRENCY_CD CHARACTER VARYING(3) 3
107 RPM_EXCEPT_SET_CD CHARACTER VARYING(8) 8
108 RPM_LVL_CD CHARACTER VARYING(1) 1
109 RPM_AUTH_CD CHARACTER VARYING(1) 1
110 RPM_SVC_CHRG_LVL CHARACTER VARYING(1) 1
111 RPM_SVC_CHRG_CD CHARACTER VARYING(1) 1
112 RPM_SVC_SCHED_CD CHARACTER VARYING(2) 2
113 RPM_ADDR_USE_1_CD CHARACTER VARYING(2) 2
114 RPM_ADDR_USE_2_CD CHARACTER VARYING(2) 2
115 RPM_ADDR_USE_3_CD CHARACTER VARYING(2) 2
116 RPM_ADDR_USE_4_CD CHARACTER VARYING(2) 2
117 RPM_ADDR_USE_5_CD CHARACTER VARYING(2) 2
118 PCS_DATA_PRES_IND CHARACTER VARYING(1) 1
119 PCS_LVL_CD CHARACTER VARYING(1) 1
120 PCS_CUSTM_PLAN_IND CHARACTER VARYING(1) 1
121 PCS_CURRENCY_CD CHARACTER VARYING(3) 3
122 PCS_SECURITY_CD CHARACTER VARYING(4) 4
123 PCS_MRGN_TAX_RATE NUMERIC(2,0) 19
124 PCS_ADDR_USE_1_CD CHARACTER VARYING(2) 2
125 PCS_ADDR_USE_2_CD CHARACTER VARYING(2) 2
126 PCS_ADDR_USE_3_CD CHARACTER VARYING(2) 2
127 PCS_ADDR_USE_4_CD CHARACTER VARYING(2) 2
128 PCS_ADDR_USE_5_CD CHARACTER VARYING(2) 2
129 USER_DATA_PRES_IND CHARACTER VARYING(1) 1
130 LST_CONTACT_DATE DATE 4
131 SPEC_OPEN_AUTH CHARACTER VARYING(1) 1
132 NO_TO_SIGN CHARACTER VARYING(2) 2
133 BUS_CUST_TYPE CHARACTER VARYING(1) 1
134 TERM_DEP_AUTH CHARACTER VARYING(1) 1
135 ACN_ARBN_NO CHARACTER VARYING(10) 10
136 RES_STATUS CHARACTER VARYING(1) 1
137 CONSENT_HELD_IND CHARACTER VARYING(1) 1
138 ABN_NUMBER CHARACTER VARYING(11) 11
139 PERS_FAX_NBR CHARACTER VARYING(16) 16
140 PERS_MOBILE_NBR CHARACTER VARYING(16) 16
141 CUST_100POINT_IND CHARACTER VARYING(1) 1
142 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
143 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
144 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
145 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8