int_bnk_crai_origination_sunloans

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_number character varying 40
2 scope_account_id_number character varying 72
3 submission_id character varying 60
4 migrated_date timestamp without time zone
5 first_home_owner_grant_flag character varying 3
6 orig_lvr numeric 8
7 orig_app_capture_user_dt timestamp without time zone
8 cdtl_approval_date timestamp without time zone
9 uncdtl_approval_date timestamp without time zone
10 date_open timestamp without time zone
11 account_opening_date timestamp without time zone
12 obp_facility_id character varying 60
13 obp_account_id_number character varying 72
14 migration_status character varying 24
15 obp_effective_start_date timestamp without time zone
16 obp_effective_end_date timestamp without time zone
17 sln_appln_id character varying 60
18 sln_loan_acct character varying 60
19 sln_facility_id character varying 60
20 add_loan_fl character varying 3
21 add_loan_date timestamp without time zone
22 is_split character varying 3
23 product_code character varying 60
24 loan_purpose_code character varying 180
25 loan_sub_purpose_code character varying 180
26 payment_type character varying 72
27 loan_use character varying 180
28 loan_amt numeric 13
29 sln_settlement_date timestamp without time zone
30 sln_effective_start_date timestamp without time zone
31 sln_effective_end_date timestamp without time zone
32 monthend_date timestamp without time zone