fct_bnk_asic516_switched_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 20
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 origination_amount numeric 19
15 origination_interest numeric 15
16 origination_interest_amount numeric 35
17 channel character varying 256
18 refinancing_party character varying 256
19 payout_classification character varying 256
20 date_open timestamp without time zone
21 date_closed timestamp without time zone
22 payout_date timestamp without time zone
23 age_days bigint 64
24 switched_period text
25 payout double precision 53