dim_sdw_crai_hogan_migrated_accounts_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_dim_id bigint 64
2 account_number character varying 63
3 sdw_account_number character varying 60
4 migrated_date timestamp without time zone
5 ar_id bigint 64
6 origination_channel character varying 90
7 application_dim_id bigint 64
8 sln_arrangement_id character varying 60
9 orig_lvr numeric 8
10 orig_term bigint 64
11 add_loan_flag character varying 3
12 add_loan_type character varying 300
13 add_loan_date timestamp without time zone
14 cdtl_approval_date timestamp without time zone
15 uncdtl_approval_date timestamp without time zone
16 data_entry_branch character varying 15
17 application_branch character varying 15
18 orig_app_capture_user_dt timestamp without time zone
19 sales_officer_id character varying 36
20 sales_officer_name character varying 240
21 mortgage_insurance_flag character varying 3
22 mortgage_insurance_provider character varying 240
23 date_open timestamp without time zone
24 date_closed timestamp without time zone
25 first_home_owner_grant_flag character varying 3
26 electronic_lodgement_no character varying 90
27 broker_code character varying 15
28 accredited_broker_code character varying 21
29 lender_id character varying 300
30 cdtl_approval_officer character varying 36
31 uncdtl_approval_officer character varying 36
32 verified_by character varying 300
33 support_officer_id character varying 300
34 orig_sales_officer_id character varying 36
35 orig_sales_officer_name character varying 240
36 month_opening_balance numeric 14
37 month_opening_undrawn_amount numeric 14
38 month_opening_available_redraw_balance numeric 14
39 month_opening_offset_facility_balance numeric 14
40 month_opening_principle_limit numeric 15
41 balance_sheet_indicator character varying 60
42 week_start_id numeric 29
43 week_end_id numeric 29
44 month_start_id numeric 29
45 month_end_id numeric 29
46 week_start_date timestamp without time zone
47 week_end_date timestamp without time zone
48 month_start_date timestamp without time zone
49 month_end_date timestamp without time zone
50 migrated_date_minus_1 timestamp without time zone
51 migrated_period_dim_id integer 32
52 migrated_period_dim_id_minus_1 integer 32
53 prior_month_end_id integer 32
54 end_of_prior_week_id integer 32
55 end_of_prior_month_id integer 32
56 end_of_prior_quarter_id integer 32
57 end_of_prior_financial_year_id integer 32
58 prev_principle_limit numeric 15
59 offset_status character varying 72
60 bill_src_strt_dt timestamp without time zone
61 curr_due_date timestamp without time zone
62 latest_schdule_creation_date timestamp without time zone