fct_bnk_asic516_business_lending_insight

Database

prod_bank_wealth

Schema

insrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 portfolio_date timestamp without time zone
2 id_number character varying 50
3 account_number bigint 64
4 source_system character varying 4
5 broker_originated_flag character varying 1
6 qrm_account character varying 75
7 i_code character varying 20
8 aggregator_name character varying 250
9 a_code character varying 20
10 broker_name character varying 511
11 broker_state character varying 20
12 settlement_date timestamp without time zone
13 face_amt numeric 15
14 exposure numeric 15
15 impaired_flag character varying 1
16 days_in_arrears character varying 20
17 days_in_arrears_gte_30 character varying 20
18 composite_cdr character varying 10
19 outstanding_30_days_value numeric 15
20 outstanding_30_days_num integer 32
21 risk_group character varying 12
22 risk_score integer 32
23 time_period_from_orig_mon integer 32
24 time_period_from_orig_year character varying 10
25 cur_net_rate numeric 15
26 tp_base_rate numeric 15
27 tp_addon_rate numeric 15
28 tp_basis_cost numeric 15
29 curbal_x_cur_net_rate numeric 15
30 curbal_x_tp_base_rate numeric 15
31 curbal_x_tp_basis_cost numeric 15
32 curbal_x_tp_addon_rate numeric 15
33 balance_sheet_indicator character varying 10
34 curbal_spread numeric 15
35 composite_next_review_date timestamp without time zone
36 review_flag character varying 1
37 review_overdue_flag character varying 1
38 subsegment character varying 19
39 origination_amount numeric 15
40 origination_interest numeric 15
41 origination_interest_amount numeric 15
42 special_client_price numeric 15
43 origination_discount_amount numeric 15
44 product_sub_code character varying 3
45 trailing_commission_rate numeric 15
46 commission_amount numeric 15
47 kri_filter character varying 1