hdda_master

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 integer 32
4 key_prod character varying 9
5 key_acct bigint 64
6 accred_brkr_cde character varying 21
7 acct_status character varying 6
8 approval_off_cd character varying 15
9 branch_no integer 32
10 broker_cd character varying 15
11 closing_reason character varying 6
12 cost_center integer 32
13 date_last_maint character varying 30
14 dt_closed character varying 30
15 dt_opened character varying 30
16 ins_amount numeric 16
17 ins_company_code character varying 9
18 ins_effective_dte character varying 30
19 ins_expiry_dte character varying 30
20 ins_policy_num character varying 60
21 ins_type_cde character varying 6
22 od_coll_tolerance numeric 16
23 od_appl_branch integer 32
24 od_db_int_cycle_cd character varying 6
25 od_db_int_type_cd character varying 6
26 od_doc_type character varying 15
27 od_insured_ind character varying 3
28 od_last_review_dt character varying 30
29 od_ldgr_tolerance numeric 16
30 od_limit numeric 16
31 od_lvr numeric 7
32 od_review_date character varying 30
33 od_sec_type_code character varying 9
34 od_secured_flag character varying 3
35 od_start_date character varying 30
36 od_term_code character varying 9
37 od_term_date character varying 30
38 officer character varying 15
39 original_branch integer 32
40 sale_off_cd character varying 21
41 secondary_officer character varying 15
42 short_name character varying 75
43 sic_occupation_cd character varying 12
44 sub_prdct_cd character varying 6
45 svc_type_cd character varying 6
46 temp_od_expiry_date character varying 30
47 temp_od_limit numeric 16
48 write_off_code character varying 6
49 write_off_date character varying 30
50 balance_before_closing numeric 16
51 smile_eln_number character varying 36
52 sunloans_number integer 32
53 svc_chg_waive_cde character varying 6
54 securitisation_status_code character varying 3
55 securitisation_pool_id character varying 9
56 securitisation_start_date character varying 30
57 repurchase_reason_code character varying 3
58 repurchase_date character varying 30
59 db_int_pay_cycle_cd character varying 6
60 int_pay_cycle_cd character varying 6
61 package_cd character varying 12
62 stmt_cycle character varying 6
63 int_cd character varying 6
64 bus_moff_flag character varying 3
65 cond_cyc_code character varying 6
66 cond_int_code character varying 6
67 cur_cr_int_var numeric 7
68 db_int_cd character varying 6
69 dte_sub_prdct_tfr character varying 30
70 funds_owner_cd character varying 6
71 funds_sub_owner_cd character varying 6
72 int_pay_method character varying 6
73 line_amt numeric 16
74 mtge_removed_dte character varying 30
75 offset_assoc_acct bigint 64
76 opening_dep numeric 16
77 package_role character varying 3
78 pbi_balance_step numeric 17
79 pbi_end_date character varying 30
80 pbi_old_int_code character varying 6
81 pbi_start_date character varying 30
82 pend_moff_flag character varying 3
83 pending_offset_dte character varying 30
84 pending_package_cd character varying 12
85 promo_code character varying 30
86 svc_cycle_cd character varying 6
87 write_off_amt numeric 16
88 wve_cde_expr_dte character varying 30
89 icc_int_base character varying 3
90 icc_int_method character varying 3
91 icc_int_rate double precision 53
92 icc_key_int_type character varying 3
93 mof_date_linked character varying 30
94 mof_loan_acct bigint 64
95 mof_orig_int_code character varying 6
96 mof_status character varying 3
97 mof_type character varying 9
98 od_act_status character varying 6
99 od_anzsic_cde character varying 12
100 od_date_last_cycle character varying 30
101 od_date_od character varying 30
102 od_neg_basis_point double precision 53
103 od_regulated_flag character varying 3
104 od_type character varying 3
105 ins_company_cde character varying 9
106 ins_financed_ind character varying 3
107 ins_premium numeric 19
108 ins_term_mths integer 32
109 ins_unpaid_ind character varying 3
110 prc_code character varying 12
111 prc_margin character varying 6
112 prc_margin_rate double precision 53
113 prc_start_date character varying 30
114 customer_rate numeric 9
115 dr_int_rate double precision 53
116 pkg_mand_acct_prod character varying 9
117 pkg_mand_acct bigint 64
118 pkg_start_dte character varying 30
119 pkg_end_dte character varying 30
120 clms_borr_id character varying 150
121 clms_grp_id character varying 150
122 acct_cqr_cd character varying 6
123 acct_sr_cd character varying 3
124 borr_cqr_cd character varying 6
125 borr_sr_cd character varying 3
126 grp_cqr_cd character varying 6
127 grp_sr_cd character varying 3
128 risk_model_cd character varying 6
129 dt_of_chg character varying 30
130 anzsic_cd character varying 12
131 review_dt character varying 30
132 net_sales numeric 18
133 q_19 character varying 3
134 q_20 character varying 3
135 q_21 character varying 3
136 q_22 character varying 3
137 crit_tot_score numeric 24
138 crit_tot_overall character varying 30
139 override_flag character varying 6
140 override_rsn character varying 300
141 override_srce character varying 300
142 calc_score character varying 6
143 actual_score numeric 24
144 sicr character varying 9
145 sys_code character varying 12
146 prev_cr_act_desc character varying 120
147 prev_cr_act_cdr_ldr character varying 30
148 q_24 character varying 30
149 q_25 character varying 30
150 q_26 character varying 6
151 q_27 character varying 6
152 q_28 character varying 6
153 delta_type character varying 3
154 effective_strt_dt timestamp without time zone
155 effective_end_dt timestamp without time zone