fct_bnk_asic516_business_lending_v

Database

prod_bank_wealth

Schema

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