Database

Description

SDS2 Bank Redshift Cluster

Tables
Schema Name Type
insrsp01_bank dim_bank_period_insight VIEW
insrsp01_bank dim_bnk_crai_account_id_number_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_accredited_broker_code_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_aggregator_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_case_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_collateral_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_company_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_complaint_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_elula_account_sticky_outbound_exception_insight VIEW
insrsp01_bank dim_bnk_crai_elula_account_sticky_outbound_insight VIEW
insrsp01_bank dim_bnk_crai_facility_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_gcis_party_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_lead_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_lender_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_crai_submission_id_hash_overall_insight VIEW
insrsp01_bank dim_bnk_period_insight VIEW
insrsp01_bank ext_bnk_crai_broker_hash_insight VIEW
insrsp01_bank ext_bnk_crai_clms_loan_account_hash_insight VIEW
insrsp01_bank ext_bnk_crai_clms_transaction_hash_insight VIEW
insrsp01_bank ext_bnk_crai_collection_hash_insight VIEW
insrsp01_bank ext_bnk_crai_complaint_hash_insight VIEW
insrsp01_bank ext_bnk_crai_credit_card_account_hash_insight VIEW
insrsp01_bank ext_bnk_crai_credit_card_transaction_hash_insight VIEW
insrsp01_bank ext_bnk_crai_customer_account_linkage_hash_insight VIEW
insrsp01_bank ext_bnk_crai_customer_feedback_hash_insight VIEW
insrsp01_bank ext_bnk_crai_customer_hash_insight VIEW
insrsp01_bank ext_bnk_crai_customer_origination_linkage_hash_insight VIEW
insrsp01_bank ext_bnk_crai_customer_origination_linkage_sunloans_hash_insight VIEW
insrsp01_bank ext_bnk_crai_facility_collateral_linkage_hash_insight VIEW
insrsp01_bank ext_bnk_crai_fms_hl_refinance_hash_insight VIEW
insrsp01_bank ext_bnk_crai_hogan_casa_account_hash_insight VIEW
insrsp01_bank ext_bnk_crai_hogan_casa_transaction_hash_insight VIEW
insrsp01_bank ext_bnk_crai_hogan_ilp_account_hash_insight VIEW
insrsp01_bank ext_bnk_crai_hogan_ilp_transaction_hash_insight VIEW
insrsp01_bank ext_bnk_crai_obp_loan_account_hash_insight VIEW
insrsp01_bank ext_bnk_crai_obp_loan_transaction_hash_insight VIEW
insrsp01_bank ext_bnk_crai_origination_application_facility_hash_insight VIEW
insrsp01_bank ext_bnk_crai_origination_application_facility_sunloans_hash_insight VIEW
insrsp01_bank ext_bnk_crai_term_deposit_account_hash_insight VIEW
insrsp01_bank ext_bnk_crai_term_deposit_transaction_hash_insight VIEW
insrsp01_bank fct_bnk_asic516_bln_arrears_summary_insight VIEW
insrsp01_bank fct_bnk_asic516_bln_loan_pricing_summary_insight VIEW
insrsp01_bank fct_bnk_asic516_bln_orig_risk_grade_summary_insight VIEW
insrsp01_bank fct_bnk_asic516_bln_review_overdue_summary_insight VIEW
insrsp01_bank fct_bnk_asic516_bln_risk_grade_monthly_summary_insight VIEW
insrsp01_bank fct_bnk_asic516_bln_risk_grade_yearly_summary_insight VIEW
insrsp01_bank fct_bnk_asic516_bln_switched_summary_insight VIEW
insrsp01_bank fct_bnk_asic516_bln_trail_commission_summary_insight VIEW
insrsp01_bank fct_bnk_asic516_business_lending_insight VIEW
insrsp01_bank fct_bnk_asic516_switched_business_lending_insight VIEW
insrsp01_bank fct_bnk_npp_customer_payid_recon_insight VIEW
insrsp01_bank fct_bnk_npp_payid_events_insight VIEW
insrsp01_bank fct_bnk_npp_payid_master_insight VIEW
insrsp01_bank fct_bnk_npp_transactions_insight VIEW
insrsp01_bank fct_bnk_npp_transactions_summary_insight VIEW
insrsp01_bank fct_fms_refinance_data_insight VIEW
insrsp01_bank fct_qrm_cm_master_mr_insight VIEW
insrsp01_bank sds2_fct_bnk_npp_payid_master_insight VIEW
sdsrsp01_bank as516_clms_arlhead VIEW
sdsrsp01_bank as516_clms_opreffl VIEW
sdsrsp01_bank as516_fct_bnk_asic516_bln_transaction_summary_insight VIEW
sdsrsp01_bank as516_fms_refinance_data VIEW
sdsrsp01_bank as516_hilp_custom_margin VIEW
sdsrsp01_bank as516_hilp_master VIEW
sdsrsp01_bank as516_tbist_windividual VIEW
sdsrsp01_bank cfg_batch_control_npp BASE TABLE
sdsrsp01_bank cfg_batch_control_npp_v VIEW
sdsrsp01_bank cfg_batch_override_npp BASE TABLE
sdsrsp01_bank crai_bpay_billerdetails_v VIEW
sdsrsp01_bank crai_clms_arlbals_v VIEW
sdsrsp01_bank crai_clms_artrans_v VIEW
sdsrsp01_bank crai_crm_address_v VIEW
sdsrsp01_bank crai_crm_contact_v VIEW
sdsrsp01_bank crai_crm_country_code_v VIEW
sdsrsp01_bank crai_crm_customer_v VIEW
sdsrsp01_bank crai_crm_product_system_link_v VIEW
sdsrsp01_bank crai_crmd_campaign_details_v VIEW
sdsrsp01_bank crai_crmd_leads_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_account_customer_insight_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_account_id_number_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_account_insight_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_accredited_broker_code_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_aggregator_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_bill_type_insight_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_case_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_collateral_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_company_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_complaint_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_customer_role_insight_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_facility_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_gcis_party_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_lead_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_lender_id_hashed_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_source_product_insight_v VIEW
sdsrsp01_bank crai_dim_bnk_crai_submission_id_hashed_v VIEW
sdsrsp01_bank crai_dim_obp_crai_loan_account_guarantor_insight_v VIEW
sdsrsp01_bank crai_dim_sdw_crai_hogan_migrated_accounts_insight_v VIEW
sdsrsp01_bank crai_elula_full_sticky_list_v VIEW
sdsrsp01_bank crai_elula_outbound_sticky_list_v VIEW
sdsrsp01_bank crai_fct_bnk_crai_account_eod_td_insight_v VIEW
sdsrsp01_bank crai_fct_bnk_crai_collateral_suncorp_value_insight_v VIEW
sdsrsp01_bank crai_fct_bnk_crai_complaints_insight_v VIEW
sdsrsp01_bank crai_fct_clm_crai_account_eod_ln_insight_v VIEW
sdsrsp01_bank crai_fct_clm_crai_repayment_schedule_insight_v VIEW
sdsrsp01_bank crai_fct_hog_crai_account_eod_cs_insight_v VIEW
sdsrsp01_bank crai_fct_hog_crai_account_eod_ln_insight_v VIEW
sdsrsp01_bank crai_fct_hog_crai_repayment_schedule_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_account_eod_ln_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_application_facility_eod_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_collateral_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_ctr_income_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_loan_account_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_party_address_eod_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_party_eod_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_party_name_eod_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_repayment_schedule_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_transactions_insight_v VIEW
sdsrsp01_bank crai_fct_obp_crai_transactions_td_insight_v VIEW
sdsrsp01_bank crai_fct_sln_crai_application_facility_eod_insight_v VIEW
sdsrsp01_bank crai_fms_refinance_data_v VIEW
sdsrsp01_bank crai_gcis_hst_tcist_consent_detailt_v VIEW
sdsrsp01_bank crai_gcis_hst_tcist_consent_v VIEW
sdsrsp01_bank crai_gcis_tcist_consent_detail_hist_v VIEW
sdsrsp01_bank crai_gcis_tcist_consent_hist_v VIEW
sdsrsp01_bank crai_hdda_master_v VIEW
sdsrsp01_bank crai_hdda_transaction_daily_v VIEW
sdsrsp01_bank crai_hilp_bill_v VIEW
sdsrsp01_bank crai_hilp_borrpoint_v VIEW
sdsrsp01_bank crai_hilp_custom_margin_v VIEW
sdsrsp01_bank crai_hilp_interest_rate_v VIEW
sdsrsp01_bank crai_hilp_master_v VIEW
sdsrsp01_bank crai_hilp_pcd_1699_v VIEW
sdsrsp01_bank crai_hilp_transaction_daily_v VIEW
sdsrsp01_bank crai_hods_transaction_v VIEW
sdsrsp01_bank crai_hog_cis_hst_cust_x_acct_v VIEW
sdsrsp01_bank crai_hog_tcs_hst_daily_v VIEW
sdsrsp01_bank crai_hog_tcs_hst_master_v VIEW
sdsrsp01_bank crai_hog_tcs_hst_txndaily_v VIEW
sdsrsp01_bank crai_htda_transaction_daily_v VIEW
sdsrsp01_bank crai_obp24_ci_case_status_l_v VIEW
sdsrsp01_bank crai_obp24_ci_case_type_l_v VIEW
sdsrsp01_bank crai_obp24_flx_or_cd_reason_codes_b_v VIEW
sdsrsp01_bank crai_obp24_hst_ci_acct_extn_v VIEW
sdsrsp01_bank crai_obp24_hst_ci_case_extn_v VIEW
sdsrsp01_bank crai_obp24_hst_ci_case_v VIEW
sdsrsp01_bank crai_obp24_hst_cz_sc_or_expr_req_applicant_v VIEW
sdsrsp01_bank crai_obp24_hst_cz_sc_or_expr_resp_facility_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_ac_acct_sched_linkage_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_lm_cr_collateral_link_b_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_lm_realestate_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_or_applicants_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_or_cd_rej_rsn_xref_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_or_cd_rsn_xref_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_or_cd_submissions_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_or_lndg_prd_grp_xref_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_or_submissions_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_pi_emp_profile_v VIEW
sdsrsp01_bank crai_obp24_hst_flx_sh_schedule_period_v VIEW
sdsrsp01_bank crai_obp_ref_enumeration_list_v VIEW
sdsrsp01_bank crai_obp_ref_transaction_code_v VIEW
sdsrsp01_bank crai_sdw_crm_product_system_link_history_v VIEW
sdsrsp01_bank crai_sdw_hog_cis_hst_cust_x_acct_history_v VIEW
sdsrsp01_bank crai_sdw_htcs_eom_balance_hst_v VIEW
sdsrsp01_bank crai_sdw_htcs_master_hst_v VIEW
sdsrsp01_bank crai_sdw_htcs_transaction_hst_v VIEW
sdsrsp01_bank crai_sdw_tsdmd_source_product_v VIEW
sdsrsp01_bank crai_sdw_tsdmd_transactions_v VIEW
sdsrsp01_bank crai_sdw_tslnd_loan_purpose_v VIEW
sdsrsp01_bank crai_sdw_tslnd_loan_sub_purpose_v VIEW
sdsrsp01_bank crai_sln_application_master_v VIEW
sdsrsp01_bank crai_sln_facility_bsc_v VIEW
sdsrsp01_bank crai_sln_facility_parties_v VIEW
sdsrsp01_bank crai_sln_facility_v VIEW
sdsrsp01_bank crai_tbisr_segments_v VIEW
sdsrsp01_bank crai_tbist_wbook_v VIEW
sdsrsp01_bank crai_tbist_wgroup_v VIEW
sdsrsp01_bank crai_tbist_windividual_v VIEW
sdsrsp01_bank crm_contact VIEW
sdsrsp01_bank crm_customer VIEW
sdsrsp01_bank crm_product_system_link VIEW
sdsrsp01_bank dim_asic516_period_month BASE TABLE
sdsrsp01_bank dim_asic516_period_month_v VIEW
sdsrsp01_bank dim_bank_period BASE TABLE
sdsrsp01_bank dim_bnk_asic516_bln_aggregator BASE TABLE
sdsrsp01_bank dim_bnk_asic516_bln_aggregator_v VIEW
sdsrsp01_bank dim_bnk_asic516_bln_broker BASE TABLE
sdsrsp01_bank dim_bnk_asic516_bln_broker_v VIEW
sdsrsp01_bank dim_bnk_crai_account_id_number_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_accredited_broker_code_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_aggregator_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_case_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_collateral_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_company_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_complaint_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_customer_account BASE TABLE
sdsrsp01_bank dim_bnk_crai_customer_account_v VIEW
sdsrsp01_bank dim_bnk_crai_elula_account_sticky_outbound_exception_v VIEW
sdsrsp01_bank dim_bnk_crai_elula_account_sticky_outbound_v VIEW
sdsrsp01_bank dim_bnk_crai_facility_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_gcis_party_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_lead_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_lender_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_crai_run_date BASE TABLE
sdsrsp01_bank dim_bnk_crai_submission_id_hash_overall_v VIEW
sdsrsp01_bank dim_bnk_period BASE TABLE
sdsrsp01_bank dim_crai_period BASE TABLE
sdsrsp01_bank ext_bnk_crai_broker BASE TABLE
sdsrsp01_bank ext_bnk_crai_broker_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_broker_v VIEW
sdsrsp01_bank ext_bnk_crai_clms_loan_account BASE TABLE
sdsrsp01_bank ext_bnk_crai_clms_loan_account_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_clms_loan_account_v VIEW
sdsrsp01_bank ext_bnk_crai_clms_transaction BASE TABLE
sdsrsp01_bank ext_bnk_crai_clms_transaction_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_clms_transaction_v VIEW
sdsrsp01_bank ext_bnk_crai_collection BASE TABLE
sdsrsp01_bank ext_bnk_crai_collection_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_collection_v VIEW
sdsrsp01_bank ext_bnk_crai_complaint BASE TABLE
sdsrsp01_bank ext_bnk_crai_complaint_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_complaint_v VIEW
sdsrsp01_bank ext_bnk_crai_credit_card_account BASE TABLE
sdsrsp01_bank ext_bnk_crai_credit_card_account_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_credit_card_account_v VIEW
sdsrsp01_bank ext_bnk_crai_credit_card_transaction BASE TABLE
sdsrsp01_bank ext_bnk_crai_credit_card_transaction_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_credit_card_transaction_v VIEW
sdsrsp01_bank ext_bnk_crai_customer BASE TABLE
sdsrsp01_bank ext_bnk_crai_customer_account_linkage BASE TABLE
sdsrsp01_bank ext_bnk_crai_customer_account_linkage_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_account_linkage_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_feedback BASE TABLE
sdsrsp01_bank ext_bnk_crai_customer_feedback_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_feedback_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_origination_linkage BASE TABLE
sdsrsp01_bank ext_bnk_crai_customer_origination_linkage_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_origination_linkage_sunloans BASE TABLE
sdsrsp01_bank ext_bnk_crai_customer_origination_linkage_sunloans_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_origination_linkage_sunloans_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_origination_linkage_v VIEW
sdsrsp01_bank ext_bnk_crai_customer_v VIEW
sdsrsp01_bank ext_bnk_crai_facility_collateral_linkage BASE TABLE
sdsrsp01_bank ext_bnk_crai_facility_collateral_linkage_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_facility_collateral_linkage_v VIEW
sdsrsp01_bank ext_bnk_crai_fms_hl_refinance BASE TABLE
sdsrsp01_bank ext_bnk_crai_fms_hl_refinance_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_fms_hl_refinance_v VIEW
sdsrsp01_bank ext_bnk_crai_hogan_casa_account BASE TABLE
sdsrsp01_bank ext_bnk_crai_hogan_casa_account_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_hogan_casa_account_v VIEW
sdsrsp01_bank ext_bnk_crai_hogan_casa_transaction BASE TABLE
sdsrsp01_bank ext_bnk_crai_hogan_casa_transaction_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_hogan_casa_transaction_v VIEW
sdsrsp01_bank ext_bnk_crai_hogan_ilp_account BASE TABLE
sdsrsp01_bank ext_bnk_crai_hogan_ilp_account_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_hogan_ilp_account_v VIEW
sdsrsp01_bank ext_bnk_crai_hogan_ilp_transaction BASE TABLE
sdsrsp01_bank ext_bnk_crai_hogan_ilp_transaction_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_hogan_ilp_transaction_v VIEW
sdsrsp01_bank ext_bnk_crai_obp_loan_account BASE TABLE
sdsrsp01_bank ext_bnk_crai_obp_loan_account_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_obp_loan_account_v VIEW
sdsrsp01_bank ext_bnk_crai_obp_loan_transaction BASE TABLE
sdsrsp01_bank ext_bnk_crai_obp_loan_transaction_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_obp_loan_transaction_v VIEW
sdsrsp01_bank ext_bnk_crai_origination_application_facility BASE TABLE
sdsrsp01_bank ext_bnk_crai_origination_application_facility_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_origination_application_facility_sunloans BASE TABLE
sdsrsp01_bank ext_bnk_crai_origination_application_facility_sunloans_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_origination_application_facility_sunloans_v VIEW
sdsrsp01_bank ext_bnk_crai_origination_application_facility_v VIEW
sdsrsp01_bank ext_bnk_crai_term_deposit_account BASE TABLE
sdsrsp01_bank ext_bnk_crai_term_deposit_account_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_term_deposit_account_v VIEW
sdsrsp01_bank ext_bnk_crai_term_deposit_transaction BASE TABLE
sdsrsp01_bank ext_bnk_crai_term_deposit_transaction_hash_v VIEW
sdsrsp01_bank ext_bnk_crai_term_deposit_transaction_v VIEW
sdsrsp01_bank fct_bnk_asic516_bln_arrears_summary BASE TABLE
sdsrsp01_bank fct_bnk_asic516_bln_arrears_summary_v VIEW
sdsrsp01_bank fct_bnk_asic516_bln_loan_pricing_summary BASE TABLE
sdsrsp01_bank fct_bnk_asic516_bln_loan_pricing_summary_v VIEW
sdsrsp01_bank fct_bnk_asic516_bln_orig_risk_grade_summary BASE TABLE
sdsrsp01_bank fct_bnk_asic516_bln_orig_risk_grade_summary_v VIEW
sdsrsp01_bank fct_bnk_asic516_bln_review_overdue_summary BASE TABLE
sdsrsp01_bank fct_bnk_asic516_bln_review_overdue_summary_v VIEW
sdsrsp01_bank fct_bnk_asic516_bln_risk_grade_monthly_summary BASE TABLE
sdsrsp01_bank fct_bnk_asic516_bln_risk_grade_monthly_summary_v VIEW
sdsrsp01_bank fct_bnk_asic516_bln_risk_grade_yearly_summary BASE TABLE
sdsrsp01_bank fct_bnk_asic516_bln_risk_grade_yearly_summary_v VIEW
sdsrsp01_bank fct_bnk_asic516_bln_switched_summary BASE TABLE
sdsrsp01_bank fct_bnk_asic516_bln_switched_summary_v VIEW
sdsrsp01_bank fct_bnk_asic516_bln_trail_commission_summary BASE TABLE
sdsrsp01_bank fct_bnk_asic516_bln_trail_commission_summary_v VIEW
sdsrsp01_bank fct_bnk_asic516_business_lending BASE TABLE
sdsrsp01_bank fct_bnk_asic516_business_lending_v VIEW
sdsrsp01_bank fct_bnk_asic516_switched_business_lending BASE TABLE
sdsrsp01_bank fct_bnk_asic516_switched_business_lending_v VIEW
sdsrsp01_bank fct_bnk_npp_customer_payid_recon BASE TABLE
sdsrsp01_bank fct_bnk_npp_customer_payid_recon_v VIEW
sdsrsp01_bank fct_bnk_npp_payid_events BASE TABLE
sdsrsp01_bank fct_bnk_npp_payid_events_v VIEW
sdsrsp01_bank fct_bnk_npp_payid_master BASE TABLE
sdsrsp01_bank fct_bnk_npp_payid_master_v VIEW
sdsrsp01_bank fct_bnk_npp_transactions BASE TABLE
sdsrsp01_bank fct_bnk_npp_transactions_summary BASE TABLE
sdsrsp01_bank fct_bnk_npp_transactions_summary_v VIEW
sdsrsp01_bank fct_bnk_npp_transactions_v VIEW
sdsrsp01_bank fct_crai_fms_refinance_data_v VIEW
sdsrsp01_bank fct_fms_refinance_data BASE TABLE
sdsrsp01_bank fct_fms_refinance_data_v VIEW
sdsrsp01_bank fct_qrm_cm_master_mr BASE TABLE
sdsrsp01_bank fct_qrm_cm_master_mr_v VIEW
sdsrsp01_bank hdda_master VIEW
sdsrsp01_bank hdda_transaction_daily VIEW
sdsrsp01_bank int_bnk_crai_account_id_number_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_account_id_number_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_accredited_broker_code_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_accredited_broker_code_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_aggregator_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_aggregator_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_case_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_case_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_collateral_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_collateral_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_company_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_company_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_complaint_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_complaint_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_facility_collateral BASE TABLE
sdsrsp01_bank int_bnk_crai_facility_collateral_v VIEW
sdsrsp01_bank int_bnk_crai_facility_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_facility_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_gcis_party_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_gcis_party_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_lead_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_lead_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_lender_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_lender_id_hashing_v VIEW
sdsrsp01_bank int_bnk_crai_origination_sunloans BASE TABLE
sdsrsp01_bank int_bnk_crai_origination_sunloans_v VIEW
sdsrsp01_bank int_bnk_crai_submission_id_hashing BASE TABLE
sdsrsp01_bank int_bnk_crai_submission_id_hashing_v VIEW
sdsrsp01_bank int_bnk_npp_transactions_v VIEW
sdsrsp01_bank int_crai_customer_crm BASE TABLE
sdsrsp01_bank int_crai_customer_crm_missing BASE TABLE
sdsrsp01_bank int_crai_customer_crm_missing_v VIEW
sdsrsp01_bank int_crai_customer_crm_v VIEW
sdsrsp01_bank int_crai_obp_loan_account_schedule_period BASE TABLE
sdsrsp01_bank int_crai_obp_loan_account_schedule_period_v VIEW
sdsrsp01_bank int_hog_crai_customer_account_ongoing BASE TABLE
sdsrsp01_bank int_hog_crai_customer_account_ongoing_cc BASE TABLE
sdsrsp01_bank int_hog_crai_customer_account_ongoing_cc_v VIEW
sdsrsp01_bank int_hog_crai_customer_account_ongoing_v VIEW
sdsrsp01_bank int_hog_npp_transactions BASE TABLE
sdsrsp01_bank int_hog_npp_transactions_v VIEW
sdsrsp01_bank int_mr_asic516_accounts_in_scope_bln BASE TABLE
sdsrsp01_bank int_mr_asic516_accounts_in_scope_bln_v VIEW
sdsrsp01_bank int_obp_crai_account_in_scope_hl BASE TABLE
sdsrsp01_bank int_obp_crai_account_in_scope_hl_v VIEW
sdsrsp01_bank int_obp_crai_customer_in_scope_hl BASE TABLE
sdsrsp01_bank int_obp_crai_customer_in_scope_hl_v VIEW
sdsrsp01_bank int_qrm_cm_master_mr_v VIEW
sdsrsp01_bank int_qrm_cm_master_v VIEW
sdsrsp01_bank int_sdw_crai_customer_account_history BASE TABLE
sdsrsp01_bank int_sdw_crai_customer_account_history_v VIEW
sdsrsp01_bank npp_payid_events VIEW
sdsrsp01_bank npp_payid_master VIEW
sdsrsp01_bank npp_payment_master VIEW
sdsrsp01_bank qrm_cm_master VIEW
sdsrsp01_bank qrm_cm_master_mr VIEW
sdsrsp01_bank rdm_bank_asic516_aggregator_groups_hist_v VIEW
sdsrsp01_bank rdm_bank_asic516_aggregator_groups_v VIEW
sdsrsp01_bank rdm_bank_efs_loan_purpose_phase2_hist_v VIEW
sdsrsp01_bank rdm_bank_efs_loan_purpose_phase2_v VIEW
sdsrsp01_bank rdm_bank_npp_channels_hist_v VIEW
sdsrsp01_bank rdm_bank_npp_channels_v VIEW
sdsrsp01_bank rdm_bank_npp_payid_trans_status_hist_v VIEW
sdsrsp01_bank rdm_bank_npp_payid_trans_status_v VIEW
sdsrsp01_bank rdm_bank_npp_payid_type_hist_v VIEW
sdsrsp01_bank rdm_bank_npp_payid_type_v VIEW
sdsrsp01_bank rdm_bank_npp_product_code_hist_v VIEW
sdsrsp01_bank rdm_bank_npp_product_code_v VIEW
sdsrsp01_bank rdm_bank_npp_transaction_type_hist_v VIEW
sdsrsp01_bank rdm_bank_npp_transaction_type_v VIEW
sdsrsp01_bank sds2_fct_bnk_npp_payid_master BASE TABLE
sdsrsp01_bank sds2_fct_bnk_npp_payid_master_v VIEW
sdsrsp01_bank sdw_tsdmd_source_product VIEW
sor_bdw bpay_billerdetails BASE TABLE
sor_bdw clms_arlbals BASE TABLE
sor_bdw clms_arlhead BASE TABLE
sor_bdw clms_artrans BASE TABLE
sor_bdw clms_cntl BASE TABLE
sor_bdw clms_opreffl BASE TABLE
sor_bdw crai_elula_full_sticky_list BASE TABLE
sor_bdw crai_elula_outbound_sticky_list BASE TABLE
sor_bdw crm_address BASE TABLE
sor_bdw crm_contact BASE TABLE
sor_bdw crm_country_code BASE TABLE
sor_bdw crm_customer BASE TABLE
sor_bdw crm_occupation_code BASE TABLE
sor_bdw crm_product_system_link BASE TABLE
sor_bdw dim_bnk_crai_account_customer_insight BASE TABLE
sor_bdw dim_bnk_crai_account_id_number_hashed BASE TABLE
sor_bdw dim_bnk_crai_account_insight BASE TABLE
sor_bdw dim_bnk_crai_accredited_broker_code_hashed BASE TABLE
sor_bdw dim_bnk_crai_aggregator_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_bill_type_insight BASE TABLE
sor_bdw dim_bnk_crai_case_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_collateral_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_company_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_complaint_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_customer_role_insight BASE TABLE
sor_bdw dim_bnk_crai_facility_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_gcis_party_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_lead_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_lender_id_hashed BASE TABLE
sor_bdw dim_bnk_crai_source_product_insight BASE TABLE
sor_bdw dim_bnk_crai_submission_id_hashed BASE TABLE
sor_bdw dim_obp_crai_h_customer_gcis_link_insight BASE TABLE
sor_bdw dim_obp_crai_loan_account_guarantor_insight BASE TABLE
sor_bdw dim_sdw_crai_hogan_migrated_accounts_insight BASE TABLE
sor_bdw fct_bnk_asic516_bln_transaction_summary_insight BASE TABLE
sor_bdw fct_bnk_crai_account_eod_td_insight BASE TABLE
sor_bdw fct_bnk_crai_collateral_suncorp_value_insight BASE TABLE
sor_bdw fct_bnk_crai_complaints_insight BASE TABLE
sor_bdw fct_clm_crai_account_eod_ln_insight BASE TABLE
sor_bdw fct_clm_crai_repayment_schedule_insight BASE TABLE
sor_bdw fct_hog_crai_account_eod_cs_insight BASE TABLE
sor_bdw fct_hog_crai_account_eod_ln_insight BASE TABLE
sor_bdw fct_hog_crai_repayment_schedule_insight BASE TABLE
sor_bdw fct_obp_crai_account_balance_pit_td_insight BASE TABLE
sor_bdw fct_obp_crai_account_eod_ln_insight BASE TABLE
sor_bdw fct_obp_crai_application_facility_collateral_insight BASE TABLE
sor_bdw fct_obp_crai_application_facility_eod_insight BASE TABLE
sor_bdw fct_obp_crai_collateral_insight BASE TABLE
sor_bdw fct_obp_crai_collection_case_insight BASE TABLE
sor_bdw fct_obp_crai_ctr_income_insight BASE TABLE
sor_bdw fct_obp_crai_loan_account_insight BASE TABLE
sor_bdw fct_obp_crai_party_address_eod_insight BASE TABLE
sor_bdw fct_obp_crai_party_eod_insight BASE TABLE
sor_bdw fct_obp_crai_party_name_eod_insight BASE TABLE
sor_bdw fct_obp_crai_repayment_schedule_insight BASE TABLE
sor_bdw fct_obp_crai_transactions_insight BASE TABLE
sor_bdw fct_obp_crai_transactions_td_insight BASE TABLE
sor_bdw fct_sln_crai_application_facility_eod_insight BASE TABLE
sor_bdw fct_sln_crai_party_address_eod_insight BASE TABLE
sor_bdw fms_refinance_data BASE TABLE
sor_bdw hdda_master BASE TABLE
sor_bdw hdda_transaction_daily BASE TABLE
sor_bdw hilp_bill BASE TABLE
sor_bdw hilp_borrpoint BASE TABLE
sor_bdw hilp_custom_margin BASE TABLE
sor_bdw hilp_interest_rate BASE TABLE
sor_bdw hilp_master BASE TABLE
sor_bdw hilp_pcd_1699 BASE TABLE
sor_bdw hilp_transaction_daily BASE TABLE
sor_bdw hilp_trial_balance BASE TABLE
sor_bdw hods_transaction BASE TABLE
sor_bdw hog_cis_hst_cust_x_acct BASE TABLE
sor_bdw hog_cis_hst_master BASE TABLE
sor_bdw hog_tcs_hst_consign BASE TABLE
sor_bdw hog_tcs_hst_daily BASE TABLE
sor_bdw hog_tcs_hst_master BASE TABLE
sor_bdw hog_tcs_hst_product BASE TABLE
sor_bdw hog_tcs_hst_txndaily BASE TABLE
sor_bdw htda_transaction_daily BASE TABLE
sor_bdw npp_payid_events BASE TABLE
sor_bdw npp_payid_master BASE TABLE
sor_bdw npp_payment_master BASE TABLE
sor_bdw npp_payment_master_202105 BASE TABLE
sor_bdw obp_ref_enumeration_list BASE TABLE
sor_bdw obp_ref_stage BASE TABLE
sor_bdw obp_ref_transaction_code BASE TABLE
sor_bdw qrm_cm_master BASE TABLE
sor_bdw qrm_cm_master_mr BASE TABLE
sor_bdw sdw_crm_product_system_link_history BASE TABLE
sor_bdw sdw_hog_cis_hst_cust_x_acct_history BASE TABLE
sor_bdw sdw_htcs_eom_balance_hst BASE TABLE
sor_bdw sdw_htcs_master_hst BASE TABLE
sor_bdw sdw_htcs_transaction_hst BASE TABLE
sor_bdw sdw_tsdmd_of_cost_centre BASE TABLE
sor_bdw sdw_tsdmd_of_costctr_hier BASE TABLE
sor_bdw sdw_tsdmd_of_costctr_hier_hst BASE TABLE
sor_bdw sdw_tsdmd_source_product BASE TABLE
sor_bdw sdw_tsdmd_transactions BASE TABLE
sor_bdw sdw_tslnd_loan_purpose BASE TABLE
sor_bdw sdw_tslnd_loan_sub_purpose BASE TABLE
sor_bdw sln_application_master BASE TABLE
sor_bdw sln_facility BASE TABLE
sor_bdw sln_facility_bsc BASE TABLE
sor_bdw sln_facility_parties BASE TABLE
sor_bdw tbisr_district BASE TABLE
sor_bdw tbisr_resourcetype BASE TABLE
sor_bdw tbisr_segments BASE TABLE
sor_bdw tbist_intuser BASE TABLE
sor_bdw tbist_wbook BASE TABLE
sor_bdw tbist_wgroup BASE TABLE
sor_bdw tbist_windividual BASE TABLE
sor_crmd crmd_campaign_details BASE TABLE
sor_crmd crmd_leads BASE TABLE
sor_crmd crmd_opportunities BASE TABLE
sor_crmd crmd_service_requests BASE TABLE
sor_gcis gcis_hst_tcist_consent BASE TABLE
sor_gcis gcis_hst_tcist_consent_detail BASE TABLE
sor_gcis gcis_tcist_consent_detail_hist BASE TABLE
sor_gcis gcis_tcist_consent_hist BASE TABLE
sor_obp obp24_ci_case_status_l BASE TABLE
sor_obp obp24_ci_case_type_l BASE TABLE
sor_obp obp24_flx_cs_reasoncodes_mas_b BASE TABLE
sor_obp obp24_flx_or_cd_reason_codes_b BASE TABLE
sor_obp obp24_hst_ci_acct_extn BASE TABLE
sor_obp obp24_hst_ci_case BASE TABLE
sor_obp obp24_hst_ci_case_extn BASE TABLE
sor_obp obp24_hst_cz_sc_or_expr_req_applicant BASE TABLE
sor_obp obp24_hst_cz_sc_or_expr_resp_applicant BASE TABLE
sor_obp obp24_hst_cz_sc_or_expr_resp_facility BASE TABLE
sor_obp obp24_hst_flx_ac_acct_sched_linkage BASE TABLE
sor_obp obp24_hst_flx_lm_collateral_all_b BASE TABLE
sor_obp obp24_hst_flx_lm_cr_collateral_link_b BASE TABLE
sor_obp obp24_hst_flx_lm_guarantors BASE TABLE
sor_obp obp24_hst_flx_lm_pr_collateral_link_b BASE TABLE
sor_obp obp24_hst_flx_lm_realestate BASE TABLE
sor_obp obp24_hst_flx_ln_acct_preferences_b BASE TABLE
sor_obp obp24_hst_flx_or_applicants BASE TABLE
sor_obp obp24_hst_flx_or_cd_rej_rsn_xref BASE TABLE
sor_obp obp24_hst_flx_or_cd_rsn_xref BASE TABLE
sor_obp obp24_hst_flx_or_cd_submissions BASE TABLE
sor_obp obp24_hst_flx_or_lndg_prd_grp_xref BASE TABLE
sor_obp obp24_hst_flx_or_submission_summary_b BASE TABLE
sor_obp obp24_hst_flx_or_submissions BASE TABLE
sor_obp obp24_hst_flx_pi_emp_profile BASE TABLE
sor_obp obp24_hst_flx_pi_parties_b BASE TABLE
sor_obp obp24_hst_flx_sh_schedule_period BASE TABLE
sor_obp och24_hst_s_cif_con_map BASE TABLE
sor_obp och24_hst_s_cif_ext_syst BASE TABLE
sor_obp och24_hst_s_cif_org_map BASE TABLE
sor_obp och24_hst_s_contact BASE TABLE
sor_obp och24_hst_s_org_ext BASE TABLE
sor_rdm bank_asic516_aggregator_groups_1 BASE TABLE
sor_rdm bank_efs_loan_purpose_phase2 BASE TABLE
sor_rdm bank_efs_loan_purpose_phase2_29 BASE TABLE
sor_rdm bank_npp_channels_1 BASE TABLE
sor_rdm bank_npp_payid_trans_status_1 BASE TABLE
sor_rdm bank_npp_payid_type_1 BASE TABLE
sor_rdm bank_npp_product_code_1 BASE TABLE
sor_rdm bank_npp_transaction_type_1 BASE TABLE
sor_rdm bank_npp_transaction_type_2 BASE TABLE
sor_rdm fincompare_7 BASE TABLE
sor_unic ua_contacthistory_v10 BASE TABLE
sor_unic ua_dtlcontacthist_v10 BASE TABLE