obp24_hst_ci_acct_extn

Database

prod_bank_wealth

Schema

sor_obp

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 acct_id character varying 30
2 facility_id character varying 120
3 liability_id character varying 120
4 host_accnt_nbr character varying 120
5 business_unit character varying 120
6 market_entity character varying 120
7 host_prod_class_cd character varying 30
8 host_prod_grp_cd character varying 60
9 host_prd_cd character varying 30
10 host_sys_acct_stat_flg character varying 150
11 acct_type_cd character varying 24
12 source_host_id character varying 30
13 bus_obj_cd character varying 90
14 bo_status_cd character varying 36
15 bo_data_area character varying 2048
16 version integer 32
17 status_upd_dttm timestamp without time zone
18 dr_int_accrd_amt double precision 53
19 accrl_stat_flg character varying 3
20 acct_purps_cd character varying 60
21 last_acct_restr_dt timestamp without time zone
22 appl_scr numeric 5
23 behavior_score numeric 5
24 repaymnt_freq character varying 90
25 redraw_avl_sw character varying 3
26 redraw_cnt smallint 16
27 write_off_dt timestamp without time zone
28 write_off_amt double precision 53
29 last_prncpl_write_off_dt timestamp without time zone
30 last_provsn_dt timestamp without time zone
31 maturity_dt timestamp without time zone
32 unclr_paymnt_amt double precision 53
33 last_prncpl_write_off_bal double precision 53
34 last_provsn_bal double precision 53
35 acct_purps_type character varying 60
36 usr_def_acct_stat_flg character varying 360
37 asst_class_cd character varying 120
38 joint_applicant_sw character varying 3
39 last_payment_dt timestamp without time zone
40 last_payment_amt double precision 53
41 acct_addr_type character varying 60
42 employee_acct_sw character varying 3
43 minor_account_status_type character varying 120
44 offer_id character varying 90
45 offer_name character varying 180
46 guarantor_sw character varying 3
47 secured_sw character varying 3
48 ppi_insured_sw character varying 3
49 lmi_insured_sw character varying 3
50 probability_of_deflt_val character varying 180
51 per_addr_id character varying 42
52 udf1 character varying 180
53 udf2 character varying 180
54 udf3 character varying 180
55 udf4 character varying 180
56 udf5 character varying 180
57 udf6 character varying 180
58 udf7 character varying 180
59 udf8 character varying 180
60 udf9 character varying 180
61 udf10 character varying 180
62 udf11 character varying 180
63 udf12 character varying 180
64 udf13 character varying 180
65 udf14 character varying 180
66 udf15 character varying 180
67 udf16 character varying 180
68 udf17 character varying 180
69 udf18 character varying 180
70 udf19 character varying 180
71 udf20 character varying 180
72 non_starter_sw character varying 3
73 write_off_request_dt timestamp without time zone
74 branch_cd character varying 60
75 in_collections_sw character varying 3
76 last_setoff_dt timestamp without time zone
77 last_setoff_amt double precision 53
78 legal_case_exists_sw character varying 3
79 repo_case_exists_sw character varying 3
80 debt_sold_sw character varying 3
81 acct_in_dispute_sw character varying 3
82 outstanding_amt double precision 53
83 overlimit_amt double precision 53
84 overdue_amt double precision 53
85 disbrs_amt double precision 53
86 total_avl_disbrs_amt double precision 53
87 ltv_val numeric 5
88 lvr_val numeric 5
89 joint_nomination_sw character varying 3
90 sticky_notes character varying 12000
91 setoff_excld_dt timestamp without time zone
92 regulated_account_sw character varying 3
93 acct_title character varying 1500
94 usr_def_inst_sw character varying 3
95 ioa_balance_amt double precision 53
96 cdc_source_system_code character varying 12
97 cdc_record_type character varying 48
98 cdc_commit_timestamp timestamp without time zone
99 cdc_extract_timestamp timestamp without time zone