och24_hst_s_contact

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 row_id character varying 45
2 created timestamp without time zone
3 created_by character varying 45
4 last_upd timestamp without time zone
5 last_upd_by character varying 45
6 dcking_num numeric 22
7 modification_num bigint 64
8 conflict_id character varying 45
9 par_row_id character varying 45
10 active_flg character varying 3
11 bu_id character varying 45
12 court_pay_flg character varying 3
13 disa_cleanse_flg character varying 3
14 disp_img_auth_flg character varying 3
15 email_sr_upd_flg character varying 3
16 emp_flg character varying 3
17 fst_name character varying 150
18 invstgtr_flg character varying 3
19 last_name character varying 150
20 ondemand_sync_flg character varying 3
21 person_uid character varying 300
22 po_pay_flg character varying 3
23 priv_flg character varying 3
24 prospect_flg character varying 3
25 ptshp_contact_flg character varying 3
26 ptshp_key_con_flg character varying 3
27 send_survey_flg character varying 3
28 speaker_flg character varying 3
29 suppress_email_flg character varying 3
30 suppress_fax_flg character varying 3
31 suspect_flg character varying 3
32 susp_wtch_flg character varying 3
33 veteran_flg character varying 3
34 agent_flg character varying 3
35 enterprise_flag character varying 3
36 member_flg character varying 3
37 ok_to_sample_flg character varying 3
38 provider_flg character varying 3
39 pr_rep_dnrm_flg character varying 3
40 pr_rep_manl_flg character varying 3
41 pr_rep_sys_flg character varying 3
42 send_fin_flg character varying 3
43 send_news_flg character varying 3
44 send_promotes_flg character varying 3
45 suppress_call_flg character varying 3
46 suppress_mail_flg character varying 3
47 age numeric 22
48 annl_incm_amt numeric 22
49 annl_incm_exch_dt timestamp without time zone
50 asgn_dt timestamp without time zone
51 asgn_excld_flg2 character varying 3
52 asgn_required_flg2 character varying 3
53 asgn_usr_excld_flg character varying 3
54 birth_dt timestamp without time zone
55 call_flg character varying 3
56 consumer_flg character varying 3
57 con_created_dt timestamp without time zone
58 credit_score numeric 22
59 cust_end_dt timestamp without time zone
60 cust_since_dt timestamp without time zone
61 db_last_upd timestamp without time zone
62 death_dt timestamp without time zone
63 dedup_dataclnsd_dt timestamp without time zone
64 dedup_key_upd_dt timestamp without time zone
65 dedup_last_mtch_dt timestamp without time zone
66 hard_to_reach character varying 3
67 inves_start_dt timestamp without time zone
68 inv_org_st_dt timestamp without time zone
69 last_credit_dt timestamp without time zone
70 latitude numeric 22
71 longitude numeric 22
72 lst_emladr_upd_ts timestamp without time zone
73 marital_stat_dt timestamp without time zone
74 mgmnt_flg character varying 3
75 num_hard_bnce bigint 64
76 num_soft_bnce bigint 64
77 seminar_invit_flg character varying 3
78 active_cti_cfg_id character varying 45
79 active_teleset_id character varying 45
80 aia_integ1_id character varying 1500
81 aia_integ_id character varying 450
82 alias_name character varying 150
83 alt_email_addr character varying 150
84 alt_email_loc_cd character varying 90
85 alt_ph_num character varying 120
86 annl_incm_curcy_cd character varying 60
87 approval_status_cd character varying 90
88 area_id character varying 45
89 asst_ph_num character varying 120
90 call_frequency character varying 90
91 cell_ph_num character varying 120
92 citizenship_cd character varying 90
93 comments character varying 765
94 complexion_cd character varying 90
95 consumer_ref_id character varying 45
96 con_asst_name character varying 150
97 con_asst_per_id character varying 45
98 con_cd character varying 90
99 con_exper_cd character varying 90
100 con_image_id character varying 45
101 con_influnc_id character varying 45
102 con_manager_name character varying 150
103 con_manager_per_id character varying 45
104 corp_ptrnl_lstname character varying 150
105 country_template character varying 45
106 creator_login character varying 150
107 credit_agency character varying 90
108 csn character varying 150
109 curr_pri_lst_id character varying 45
110 cust_stat_cd character varying 90
111 cust_value_cd character varying 90
112 db_last_upd_src character varying 150
113 death_cert_num character varying 90
114 decision_type_cd character varying 90
115 dedup_token character varying 300
116 degree character varying 90
117 dflt_order_proc_cd character varying 90
118 email_addr character varying 300
119 email_loc_cd character varying 90
120 email_status_cd character varying 90
121 emplmnt_stat_cd character varying 90
122 emp_id character varying 45
123 emp_num character varying 90
124 emp_work_loc_name character varying 150
125 ethnicity_cd character varying 90
126 eye_color character varying 90
127 fax_ph_num character varying 120
128 furi_ptrnl_lstname character varying 150
129 hair_color character varying 90
130 height character varying 60
131 height_uom_cd character varying 90
132 home_ph_num character varying 120
133 indust_id character varying 45
134 integration_id character varying 90
135 job_title character varying 225
136 left_eye_clr_cd character varying 90
137 login character varying 150
138 maiden_name character varying 150
139 marital_stat_cd character varying 90
140 med_spec_id character varying 45
141 mid_name character varying 150
142 mother_maiden_name character varying 150
143 mstr_case_id character varying 45
144 nationality character varying 90
145 new_user_resp_name character varying 150
146 nick_name character varying 150
147 occupation character varying 150
148 od_last_upd_by character varying 375
149 ou_id character varying 45
150 ou_mail_stop character varying 90
151 owner_login character varying 150
152 owner_per_id character varying 45
153 pager_company_id character varying 45
154 pager_num character varying 120
155 pager_ph_num character varying 120
156 pager_pin character varying 120
157 pager_type_cd character varying 90
158 password character varying 60
159 paternal_last_name character varying 150
160 per_title character varying 45
161 per_title_suffix character varying 45
162 place_of_birth character varying 300
163 place_of_death character varying 150
164 postn_cd character varying 90
165 practice_type character varying 90
166 pref_comm_media_cd character varying 90
167 pref_comm_meth_cd character varying 90
168 pref_lang_id character varying 45
169 pref_locale_id character varying 45
170 pref_sale_dlr_id character varying 45
171 presence_uri character varying 300
172 privacy_cd character varying 90
173 pr_act_id character varying 45
174 pr_affl_id character varying 45
175 pr_alt_ph_num_id character varying 45
176 pr_asset_id character varying 45
177 pr_bl_per_addr_id character varying 45
178 pr_client_ou_id character varying 45
179 pr_comm_lang_id character varying 45
180 pr_con_addr_id character varying 45
181 pr_cst_accnt_id character varying 45
182 pr_cti_cfg_id character varying 45
183 pr_dept_ou_id character varying 45
184 pr_drvr_license_id character varying 45
185 pr_email_addr_id character varying 45
186 pr_facility_id character varying 45
187 pr_grp_ou_id character varying 45
188 pr_held_postn_id character varying 45
189 pr_image_id character varying 45
190 pr_indust_id character varying 45
191 pr_mkt_seg_id character varying 45
192 pr_note_id character varying 45
193 pr_opty_id character varying 45
194 pr_ou_addr_id character varying 45
195 pr_per_addr_id character varying 45
196 pr_per_pay_prfl_id character varying 45
197 pr_phone_id character varying 45
198 pr_postn_id character varying 45
199 pr_prod_id character varying 45
200 pr_prod_ln_id character varying 45
201 pr_region_id character varying 45
202 pr_resp_id character varying 45
203 pr_security_id character varying 45
204 pr_sh_per_addr_id character varying 45
205 pr_specialty_id character varying 45
206 pr_state_lic_id character varying 45
207 pr_sync_user_id character varying 45
208 pr_terr_id character varying 45
209 pr_userrole_id character varying 45
210 race character varying 90
211 rating character varying 90
212 region_id character varying 45
213 regl_stat_cd character varying 90
214 reliability_cd character varying 90
215 resident_stat_cd character varying 90
216 right_eye_clr_cd character varying 90
217 route character varying 90
218 sec_answr character varying 150
219 sec_quest_cd character varying 90
220 sex_mf character varying 90
221 soc_security_num character varying 60
222 spouse_last_name character varying 150
223 src_id character varying 45
224 status_cd character varying 90
225 stat_reason_cd character varying 90
226 stock_portfolio character varying 1500
227 sub_spec_id character varying 45
228 svc_branch_id character varying 45
229 timezone_id character varying 45
230 tmzone_cd character varying 90
231 weathr_loc_pref character varying 225
232 web_region_id character varying 45
233 weight character varying 60
234 weight_uom_cd character varying 90
235 work_ph_num character varying 120
236 x_ccn character varying 90
237 x_consent_verified character varying 3
238 x_credit_score character varying 66
239 x_credit_score_dt timestamp without time zone
240 x_crs_modeltype character varying 120
241 x_crs_version character varying 30
242 x_degree character varying 90
243 x_dispute_denial character varying 3
244 x_domicile_branch character varying 30
245 x_exist_cust character varying 3
246 x_ext_created_dt timestamp without time zone
247 x_industry character varying 90
248 x_kyc_status_cd character varying 90
249 x_kyc_ts timestamp without time zone
250 x_kyc_ver_stage character varying 90
251 x_last_upd_dt timestamp without time zone
252 x_legacy_id character varying 90
253 x_link_error_msg character varying 1500
254 x_linked character varying 3
255 x_match_call character varying 3
256 x_message_id_pub character varying 300
257 x_message_id_sync character varying 300
258 x_nab_staff character varying 3
259 x_news_paper character varying 90
260 x_platform character varying 90
261 x_sec_ans character varying 300
262 x_sec_purpose character varying 3
263 x_sec_ques character varying 300
264 x_segment_cd character varying 150
265 x_shared_info character varying 3
266 x_src_code character varying 120
267 x_staff_partner_flag character varying 3
268 x_staff_user_id character varying 90
269 x_sys_of_origin character varying 150
270 x_tax_iden_num character varying 60
271 x_tfn_exempt_dt timestamp without time zone
272 x_use_count bigint 64
273 x_usr_def_ques character varying 300
274 x_value_group character varying 150
275 x_workplace character varying 150
276 cdc_source_system_code character varying 12
277 cdc_record_type character varying 48
278 cdc_commit_timestamp timestamp without time zone
279 cdc_extract_timestamp timestamp without time zone
280 x_deleted_child character varying 300
281 x_batch_publish character varying 3
282 x_last_upd_sys character varying 300
283 x_stff_partner_flg character varying 3
284 x_stff_user_id character varying 90
285 x_domicile_name character varying 300