sdw_htcs_master_hst

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 id bigint 64
2 action_code character varying 3
3 key_coid numeric 5
4 key_prod character varying 9
5 sub_prdct_cd character varying 15
6 cntl_acct_num character varying 48
7 dt_opened character varying 30
8 xfr_rsn_cd character varying 15
9 od_limit numeric 15
10 transferred_to_acct_nbr character varying 48
11 transferred_from_acct_nbr character varying 48
12 smile_eln character varying 36
13 facility_id character varying 36
14 close_dt character varying 30
15 reopen_dt character varying 30
16 score numeric 3
17 cci_product character varying 6
18 cci_open_dt character varying 30
19 cci_chg_dt character varying 30
20 cci_close_dt character varying 30
21 cci_claim_dt character varying 30
22 cc_claim_amt_paid numeric 15
23 effective_strt_dt timestamp without time zone
24 effective_end_dt timestamp without time zone