select bch_obj_id Batch_Object_Identifier, bus_cal_dt_dim_key_id Business_Calendar_Date_Dimension_Key_Identifier, fnm_ln_id Fannie_Mae_Loan_Identifier, ln_actg_upb_amt Loan_Accounting_UPB_Amount, ln_acvy_rptg_dt Loan_Activity_Reporting_Date, ln_age_eff_crxf_term_pct Loan_Age_Effective_Credit_Risk_Transfer_Term_Percent, ln_age_mlpr_fctr Loan_Age_Multiplier_Factor, ln_all_in_aqsn_cpl_bp_rt Loan_All_In_Acquisition_Capital_Basis_Point_Rate, ln_all_in_rocc_pct Loan_All_In_Return_On_Conservatorship_Capital_Percent, ln_all_in_rocc_upfnt_cb_pnt_rt Loan_All_In_Return_On_Conservatorship_Capital_Upfront_Calculation_Basis_Point_Rate, ln_all_in_rocc_wghtd_amt Loan_All_In_Return_On_Conservatorship_Capital_Weighted_Amount, ln_amterm_eff_crxf_term_pct Loan_Amortization_Term_Effective_Credit_Risk_Transfer_Term_Percent, ln_aqsn_dt Loan_Acquisition_Date, ln_aqsn_mtm_ltv_rt Loan_Acquisition_Mark_To_Market_LTV_Rate, ln_aqsn_net_crdt_rsk_cpl_amt Loan_Acquisition_Net_Credit_Risk_Capital_Amount, ln_aqsn_prd Loan_Acquisition_Period, ln_aqsn_seg_typ Loan_Acquisition_Segment_Type, ln_bcknd_crxf_fall_out_ind Loan_Backend_Credit_Risk_Transfer_Fall_Out_Indicator, ln_brnout_mlpr_fctr Loan_Burnout_Multiplier_Factor, ln_brwr_lndr_mi_hrct_pct Loan_Borrower_Lender_Mortgage_Insurance_Haircut_Percent, ln_brwr_lndr_mi_mlpr_fctr Loan_Borrower_Lender_Mortgage_Insurance_Multiplier_Factor, ln_brwr_mlpr_fctr Loan_Borrower_Multiplier_Factor, ln_bse_cpl_bp_rt Loan_Base_Capital_Basis_Point_Rate, ln_bse_expd_dflt_cost_rt Loan_Base_Expected_Default_Cost_Rate, ln_calc_actl_upb_amt Loan_Calculation_Actual_UPB_Amount, ln_calc_aqsn_upb_amt Loan_Calculation_Acquisition_UPB_Amount, ln_calc_mlpr_fctr Loan_Calculation_Multiplier_Factor, ln_calc_pre_mi_crcp_bp_rt Loan_Calculation_Pre_Mortgage_Insurance_Credit_Risk_Capital_Basis_Point_Rate, ln_calc_typ Loan_Calculation_Type, ln_calc_typ_dsrgt_key_id Loan_Calculation_Type_Dimension_Surrogate_Key_Identifier, ln_ce_edcst_loss_mlpr_fctr Loan_Credit_Enhancement_Expected_Default_Cost_Loss_Multiplier_Factor, ln_ce_expd_dflt_cost_hrct_pct Loan_Credit_Enhancement_Expected_Default_Cost_Haircut_Percent, ln_ce_mi_hrct_pct Loan_Credit_Enhancement_Mortgage_Insurance_Haircut_Percent, ln_ce_mi_mlpr_fctr Loan_Credit_Enhancement_Mortgage_Insurance_Multiplier_Factor, ln_clcd_prdc_catg_typ Loan_Calculated_Product_Category_Type, ln_colt_cvrg_amt Loan_Collateral_Coverage_Amount, ln_crcp_aft_mi_bef_mihct_amt Loan_Credit_Risk_Capital_After_Mortgage_Insurance_Before_Mortgage_Insurance_Haircut_Amount, ln_crcp_aft_mi_bef_mihct_bp_rt Loan_Credit_Risk_Capital_After_Mortgage_Insurance_Before_Mortgage_Insurance_Haircut_Basis_Point_Rate, ln_crdt_rsk_xfer_elig_chrt_typ Loan_Credit_Risk_Transfer_Eligibility_Cohort_Type, ln_ctc_adjd_aqsn_mtm_ltv_rt Loan_Counter_Cyclical_Adjusted_Acquisition_Mark_To_Market_Loan_To_Value_Rate, ln_ctc_adjd_orgnn_ltv_rt Loan_Counter_Cyclical_Adjusted_Origination_Loan_To_Value_Rate, ln_ctrt_yld_bp_rt Loan_Contract_Yield_Basis_Point_Rate, ln_dbt_to_incm_mlpr_fctr Loan_Debt_to_Income_Multiplier_Factor, ln_dim_srgt_key_id Loan_Dimension_Surrogate_Key_Identifier, ln_dlqy_svty_mlpr_fctr Loan_Delinquency_Severity_Multiplier_Factor, ln_dlry_fee_bp_rt Loan_Delivery_Fee_Basis_Point_Rate, ln_drvd_aft_non_mimlr_cpl_amt Loan_Derived_After_Non_Mortgage_Insurance_Multiplier_Capital_Amount, ln_drvd_amrt_term Loan_Derived_Amortization_Term, ln_drvd_brwr_cnt_typ Loan_Derived_Borrower_Count_Type, ln_drvd_bse_cpl_amt Loan_Derived_Base_Capital_Amount, ln_drvd_docm_typ Loan_Derived_Documentation_Type, ln_drvd_epmi_prdc_catg_typ Loan_Derived_Enterprise_Paid_Mortgage_Insurance_Product_Category_Type, coalesce(ln_drvd_int_only_typ, 'Yes IO') Loan_Derived_Interest_Only_Type, ln_drvd_mlpr_fctr Loan_Derived_Multiplier_Factor, coalesce(ln_drvd_orgr_typ, 'TPO') Loan_Derived_Originator_Type, ln_drvd_pr_max_dlqy_typ Loan_Derived_Prior_Max_Delinquency_Type, coalesce(ln_drvd_prdc_catg_typ,'ARM 1/1') Loan_Derived_Product_Category_Type, ln_drvd_pre_mi_crcp_bp_rt Loan_Derived_Pre_Mortgage_Insurance_Credit_Risk_Capital_Basis_Point_Rate, ln_drvd_prmi_crcp_amt Loan_Derived_Pre_Mortgage_Insurance_Credit_Risk_Capital_Amount, coalesce(ln_drvd_prop_typ, '2-4 Unit') Loan_Derived_Property_Type, ln_drvd_prop_usg_typ Loan_Derived_Property_Usage_Type, ln_drvd_purps_typ Loan_Derived_Purpose_Type, coalesce(ln_drvd_refi_plus_typ, 'No') Loan_Derived_Refinance_Plus_Type, ln_edcst_aft_mi_bef_hrct_bp_rt Loan_Expected_Default_Cost_After_Mortgage_Insurance_Before_Haircut_Basis_Point_Rate, ln_edcst_mi_loss_mlpr_fctr Loan_Expected_Default_Cost_Mortgage_Insurance_Loss_Multiplier_Factor, ln_el_bnft_to_el_rto_rt Loan_Expected_Loss_Benefit_To_Expected_Loss_Ratio_Rate, ln_entp_cpl_aqsn_mtm_ltv_rt Loan_Enterprise_Capital_Acquisition_Mark_To_Market_Loan_To_Value_Rate, ln_entp_cpl_aqsn_seg_typ Loan_Enterprise_Capital_Acquisition_Segment_Type, ln_entp_cpl_drvd_age_mths_cnt Loan_Enterprise_Capital_Derived_Age_Months_Count, ln_entp_cpl_orgnn_bm_catg_typ Loan_Enterprise_Capital_Origination_Burnout_Months_Category_Type, ln_entp_paid_mi_age_mlpr_pct Loan_Enterprise_Paid_Mortgage_Insurance_Age_Multiplier_Percent, ln_entp_paid_mi_bse_cpl_pct Loan_Enterprise_Paid_Mortgage_Insurance_Base_Capital_Percent, ln_entp_paid_mi_hrct_pct Loan_Enterprise_Paid_Mortgage_Insurance_Haircut_Percent, ln_entp_paid_mi_mlpr_fctr Loan_Enterprise_Paid_Mortgage_Insurance_Multiplier_Factor, ln_epmi_dlqy_svty_mlpr_pct Loan_Enterprise_Paid_Mortgage_Insurance_Delinquency_Severity_Multiplier_Percent, ln_epmi_eff_crxf_term_pct Loan_Enterprise_Paid_Mortgage_Insurance_Effective_Credit_Risk_Transfer_Term_Percent, ln_epmi_orig_mterm_mlpr_fctr Loan_Enterprise_Paid_Mortgage_Insurance_Original_Maturity_Term_Multiplier_Factor, ln_epmi_orig_sst_mth_cnt Loan_Enterprise_Paid_Mortgage_Insurance_Original_Sunset_Month_Count, ln_epmi_prop_typ_mlpr_fctr Loan_Enterprise_Paid_Mortgage_Insurance_Property_Type_Multiplier_Factor, ln_expd_dflt_cost_hrct_pct Loan_Expected_Default_Cost_Haircut_Percent, ln_fe_crxf_exp_amt Loan_Front_End_Credit_Risk_Transfer_Expense_Amount, ln_fhfa_edcst_with_fe_crxf_rt Loan_FHFA_Expected_Default_Cost_With_Front_End_Credit_Risk_Transfer_Rate, ln_fhfa_expd_dflt_cost_rt Loan_Federal_Housing_Finance_Agency_Expected_Default_Cost_Rate, ln_fncl_excn_ecd Loan_Financial_Execution_Enterprisecode, ln_gfee_byu_byd_bp_rt Loan_Guaranty_Fee_Buyup_Buydown_Basis_Point_Rate, ln_gfee_byu_byd_yld_bas_rt Loan_Guaranty_Fee_Buyup_Buydown_yield_Basis_Rate, ln_gnrl_admin_exp_bp_rt Loan_General_Admin_Expense_Basis_Point_Rate, ln_int_only_mlpr_fctr Loan_Interest_Only_Multiplier_Factor, ln_lndr_prfl_prcg_prdc_ecd Loan_Lender_Profile_Pricing_Product_Enterprisecode, ln_lndr_prfl_prcg_prdc_typ Loan_Lender_Profile_Pricing_Product_Type, ln_mi_hrct_pct Loan_Mortgage_Insurance_Haircut_Percent, ln_mi_mlpr_fctr Loan_Mortgage_Insurance_Multiplier_Factor, ln_mrkt_rsk_cpl_adjd_amt Loan_Market_Risk_Capital_Adjusted_Amount, ln_mrkt_rsk_cpl_bp_rt Loan_Market_Risk_Capital_Basis_Point_Rate, ln_net_crdt_rsk_cpl_amt Loan_Net_Credit_Risk_Capital_Amount, ln_npl_rfrhd_cs_mlpr_fctr Loan_Non_Performing_Loan__Refreshed_Credit_Score_Multiplier_Factor, ln_ocpy_typ_mlpr_fctr Loan_Occupancy_Type_Multiplier_Factor, ln_orgnn_brnout_mths_catg_typ Loan_Origination_Burnout_Months_Category_Type, ln_othr_gfee_exp_rt Loan_Other_Guaranty_Fee_Expense_Rate, ln_pmt_chg_from_mdfc_mlpr_fctr Loan_Payment_Change_from_Modification_Multiplier_Factor, ln_post_mi_crcp_with_bfr_bp_rt Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_With_Buffer_Basis_Point_Rate, ln_post_mi_crdt_rsk_cpl_amt Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_Amount, ln_post_mi_crsk_cpl_bp_rt Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_Basis_Point_Rate, ln_post_mi_expd_dflt_cost_rt Loan_Post_Mortgage_Insurance_Expected_Default_Cost_Rate, ln_prdc_typ_mlpr_fctr Loan_Product_Type_Multiplier_Factor, ln_pre_crxf_aqsn_cpl_bp_rt Loan_Pre_Credit_Risk_Transfer_Acquisition_Capital_Basis_Point_Rate, ln_pre_crxf_rocc_pct Loan_Pre_Credit_Risk_Transfer_Return_On_Conservatorship_Capital_Percent, ln_pre_crxf_upfnt_cb_pnt_rt Loan_Pre_Credit_Risk_Transfer_Upfront_Calculation_Basis_Point_Rate, ln_pre_mi_expd_dflt_cost_rt Loan_Pre_Mortgage_Insurance_Expected_Default_Cost_Rate, ln_prop_typ_mlpr_fctr Loan_Property_Type_Multiplier_Factor, ln_prv_max_dlqy_mlpr_fctr Loan_Previous_Maximum_Delinquency_Multiplier_Factor, ln_purps_typ_mlpr_fctr Loan_Purpose_Type_Multiplier_Factor, ln_pv_flt_incm_bp_rt Loan_Present_Value_Float_Income_Basis_Point_Rate, ln_pv_mthd_bse_mlpr_fctr Loan_Present_Value_Method_Base_Multiplier_Factor, ln_pv_mthd_ln_size_mlpr_fctr Loan_Present_Value_Method_Loan_Size_Multiplier_Factor, ln_pv_mthd_mlpr_fctr Loan_Present_Value_Method_Multiplier_Factor, ln_pv_mthd_prdc_typ_mlpr_fctr Loan_Present_Value_Method_Product_Type_Multiplier_Factor, ln_rdcd_docm_mlpr_fctr Loan_Reduced_Documentation_Multiplier_Factor, ln_refi_mlpr_fctr Loan_Refinance_Multiplier_Factor, ln_rpl_rfrhd_cs_mlpr_fctr Loan_Reperforming_Loan_Refreshed_Credit_Score_Multiplier_Factor, ln_rsk_fctr Loan_Risk_Factor, ln_sbon_mlpr_fctr Loan_Subordination_Multiplier_Factor, ln_size_mlpr_fctr Loan_Size_Multiplier_Factor, ln_src_of_orgnn_typ Loan_Source_Of_Origination_Type, ln_tot_rinsr_mi_hrct_rt Loan_Total_Reinsurer_Mortgage_Insurance_Haircut_Rate, ln_tpo_mlpr_fctr Loan_Third_Party_Origination_Multiplier_Factor, ln_whl_ln_cdt_hldg_days_cnt Loan_Whole_Loan_Conduit_Holding_Days_Count, ln_whl_ln_cdt_net_carryg_bp_rt Loan_Whole_Loan_Conduit_Net_Carrying_Basis_Point_Rate, ln_wlc_gos_gnls_bp_rt Loan_Whole_Loan_Conduit_Gain_On_Sale_Gain_Loss_Basis_Point_Rate, ln_wlc_gos_prtl_gnls_bp_rt Loan_Whole_Loan_Conduit_Gain_On_Sale_Partial__Gain_Loss_Basis_Point_Rate, ln_wlc_hdg_gl_ln_gnls_bp_rt Loan_Whole_Loan_Conduit_Hedge_General_Ledger_Loan_Gain_Loss_Basis_Point_Rate, ln_wlc_othr_iexp_bp_rt Loan_Whole_Loan_Conduit_Other_Income_Expense_Basis_Point_Rate, ln_wlc_trueup_gos_gnls_bp_rt Loan_Whole_Loan_Conduit_Trueup_Gain_On_Sale_Gain_Loss_Basis_Point_Rate, pgm_snro_run_id Program_Scenario_Run_Identifier, pgm_snro_run_typ Program_Scenario_Run_Type, port_ln_bfr_and_oprl_rsk_bp_rt Portfolio_Loan_Buffer_And_Operational_Risk_Basis_Point_Rate, port_ln_post_tx_rt_pct Portfolio_Loan_Post_Tax_Rate_Percent, port_ln_rinv_rt Portfolio_Loan_Reinvestment_Rate, port_ln_tx_cut_contn_act_bp_rt Portfolio_Loan_Tax_Cut_Continuation_Act_Basis_Point_Rate, port_mrkt_adjd_prc_disc_rt Portfolio_Market_Adjusted_Price_Discount_Rate, prcs_modl_typ Process_Module_Type, rec_cren_dttm Record_Creation_Datetime, rec_cren_usr_id Record_Creation_User_Identifier, rec_end_dttm Record_End_Datetime, rec_hash_key_id Record_Hash_Key_Identifier, ln_bse_rwt_aft_covid_hrct_pct Loan_Base_Risk_Weight_After_COVID_Haircut_Percent, ln_bse_rsk_wght_pct Loan_Base_Risk_Weight_Percent, ln_drvd_bse_rsk_wghtd_ast_amt Loan_Derived_Base_Risk_Weighted_Asset_Amount, ln_dbse_rwa_aft_covid_hrct_amt Loan_Derived_Base_Risk_Weighted_Asset_After_COVID_Haircut_Amount, ln_drvd_pre_mi_rsk_wght_pct Loan_Derived_Pre_Mortgage_Insurance_Risk_Weight_Percent, ln_drvd_prmi_rwa_amt Loan_Derived_Pre_Mortgage_Insurance_Risk_Weighted_Asset_Amount, ln_ptmi_crcp_aft_flr_bp_rt Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_After_Floor_Basis_Point_Rate, ln_post_mi_rsk_wght_pct Loan_Post_Mortgage_Insurance_Risk_Weight_Percent, ln_post_mi_rsk_wghtd_ast_amt Loan_Post_Mortgage_Insurance_Risk_Weighted_Asset_Amount, ln_aft_mi_bef_mihct_rwt_pct Loan_After_Mortgage_Insurance_Before_Mortgage_Insurance_Haircut_Risk_Weight_Percent, ln_aft_mi_bef_mihct_rwa_amt Loan_After_Mortgage_Insurance_Before_Mortgage_Insurance_Haircut_Risk_Weighted_Asset_Amount, ln_ptmi_aft_flr_crsk_wght_pct Loan_Post_Mortgage_Insurance_After_Floor_Credit_Risk_Weight_Percent, ln_ptmi_aft_flr_crdt_rwa_amt Loan_Post_Mortgage_Insurance_After_Floor_Credit_Risk_Weighted_Asset_Amount, ln_ptmi_crcp_aft_flr_amt Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_After_Floor_Amount, ln_adjd_tot_cpl_crdt_rsk_bp_rt Loan_Adjusted_Total_Capital_Credit_Risk_Basis_Point_Rate, ln_atcpl_orsk_mgmt_bp_rt Loan_Adjusted_Total_Capital_Operational_Risk_Management_Basis_Point_Rate, ln_tier_1_crdt_rsk_cpl_bp_rt Loan_Tier_1_Credit_Risk_Capital_Basis_Point_Rate, ln_tier_1_corr_bp_rt Loan_Tier_1_Capital_Operational_Risk_Regulatory_Basis_Point_Rate, ln_tier_1_cpl_orsk_mgmt_bp_rt Loan_Tier_1_Capital_Operational_Risk_Management_Basis_Point_Rate, ln_tier_1_lvrg_cpl_pbmgt_bp_rt Loan_Tier_1_Leverage_Capital_Prescribed_Buffer_Management_Basis_Point_Rate, ln_tier_1_lvrg_cpl_pbrty_bp_rt Loan_Tier_1_Leverage_Capital_Prescribed_Buffer_Regulatory_Basis_Point_Rate, ln_tier_1_ltcm_bp_rt Loan_Tier_1_Leverage_Target_Capital_Management_Basis_Point_Rate, ln_tot_tier_1_lvrg_mgmt_bp_rt Loan_Total_Tier_1_Leverage_Management_Basis_Point_Rate, ln_tot_tier_1_lrty_bp_rt Loan_Total_Tier_1_Leverage_Regulatory_Basis_Point_Rate, ln_tier_1_mrlvg_cpl_bp_rt Loan_Tier_1_Minimum_Required_Leverage_Capital_Basis_Point_Rate, ln_pscr_cpl_cbfr_mgmt_bp_rt Loan_Prescribed_Capital_Conservation_Buffer_Management_Basis_Point_Rate, ln_pscr_cpl_cbfr_rgultry_bp_rt Loan_Prescribed_Capital_Conservation_Buffer_Regulatory_Basis_Point_Rate, ln_atcpl_orsk_rptg_bp_rt Loan_Adjusted_Total_Capital_Operational_Risk_Reporting_Basis_Point_Rate, ln_pscr_lvrg_bfr_mgmt_pct Loan_Prescribed_Leverage_Buffer_Management_Percent, ln_pscr_lvrg_bfr_rgultry_pct Loan_Prescribed_Leverage_Buffer_Regulatory_Percent, ln_cet1_cpl_orsk_mgmt_bp_rt Loan_CET1_Capital_Operational_Risk_Management_Basis_Point_Rate, ln_cet1_cpl_orsk_rgultry_bp_rt Loan_CET1_Capital_Operational_Risk_Regulatory_Basis_Point_Rate, ln_cet1_crdt_rsk_cpl_bp_rt Loan_CET1_Credit_Risk_Capital_Basis_Point_Rate, ln_mrkt_rsk_wghtd_ast_amt Loan_Market_Risk_Weighted_Asset_Amount, ln_cet1_mrkt_rsk_cpl_amt Loan_CET1_Market_Risk_Capital_Amount, ln_cet1_mrkt_rsk_cpl_bp_rt Loan_CET1_Market_Risk_Capital_Basis_Point_Rate, ln_tier_1_mrkt_rsk_cpl_amt Loan_Tier_1_Market_Risk_Capital_Amount, ln_tier_1_mrkt_rsk_cpl_bp_rt Loan_Tier_1_Market_Risk_Capital_Basis_Point_Rate, ln_adjd_tot_cpl_mrkt_rsk_amt Loan_Adjusted_Total_Capital_Market_Risk_Amount, ln_adjd_tot_cpl_mrkt_rsk_bp_rt Loan_Adjusted_Total_Capital_Market_Risk_Basis_Point_Rate, ln_mrkt_rsk_wght_pct Loan_Market_Risk_Weight_Percent, ln_cet1_rbc_rgultry_bp_rt Loan_CET1_Risk_Based_Capital_Regulatory_Basis_Point_Rate, ln_cet1_rsk_bsd_cpl_mgmt_bp_rt Loan_CET1_Risk_Based_Capital_Management_Basis_Point_Rate, ln_cet1_rbc_pbrty_bp_rt Loan_CET1_Risk_Based_Capital_Prescribed_Buffer_Regulatory_Basis_Point_Rate, ln_cet1_rbc_pbmgt_bp_rt Loan_CET1_Risk_Based_Capital_Prescribed_Buffer_Management_Basis_Point_Rate, ln_cet1_trgt_cpl_rgultry_bp_rt Loan_CET1_Target_Capital_Regulatory_Basis_Point_Rate, ln_cet1_trgt_cpl_mgmt_bp_rt Loan_CET1_Target_Capital_Management_Basis_Point_Rate, ln_addl_tier_1_cocm_bp_rt Loan_Additional_Tier_1_Cost_of_Capital_Management_Basis_Point_Rate, ln_addl_tier_1_cpl_mgmt_bp_rt Loan_Additional_Tier_1_Capital_Management_Basis_Point_Rate, ln_addl_tier_1_lcocr_bp_rt Loan_Additional_Tier_1_Leverage_Cost_of_Capital_Regulatory_Basis_Point_Rate, ln_addl_tier_1_lcrty_bp_rt Loan_Additional_Tier_1_Leverage_Capital_Regulatory_Basis_Point_Rate, ln_addl_tier_1_rbc_bp_rt Loan_Additional_Tier_1_Risk_Based_Capital_Basis_Point_Rate, ln_addl_tier_1_rbcocr_bp_rt Loan_Additional_Tier_1_Risk_Based_Cost_of_Capital_Regulatory_Basis_Point_Rate, PSC_ERCF Preferred_Stock_Cost_ERCF, LN_FNL_ADDL_TIER_1_COST_OF_CPL_BP_RT Loan_Final_Additional_Tier_1_Cost_Of_Capital_Basis_Point_Rate, ln_adjd_tot_cpl_mgmt_bp_rt Loan_Adjusted_Total_Capital_Management_Basis_Point_Rate, ln_adjd_tot_cpl_rgultry_bp_rt Loan_Adjusted_Total_Capital_Regulatory_Basis_Point_Rate, ln_adjd_tot_cpl_tot_mgmt_amt Loan_Adjusted_Total_Capital_Total_Management_Amount, ln_atcpl_min_reqd_cpl_amt Loan_Adjusted_Total_Capital_Minimum_Required_Capital_Amount, ln_atcpl_pbrty_bp_rt Loan_Adjusted_Total_Capital_Prescribed_Buffer_Regulatory_Basis_Point_Rate, ln_atcpl_pscr_bfr_mgmt_bp_rt Loan_Adjusted_Total_Capital_Prescribed_Buffer_Management_Basis_Point_Rate, ln_atcpl_trgt_mgmt_bp_rt Loan_Adjusted_Total_Capital_Target_Management_Basis_Point_Rate, ln_atcpl_trgt_rgultry_bp_rt Loan_Adjusted_Total_Capital_Target_Regulatory_Basis_Point_Rate, ln_rocet1_cpl_atcpl_lbrty_pct Loan_Return_on_CET1_Capital_Adjusted_Total_Capital_Leverage_Binding_Regulatory_Percent, ln_rocet1_cpl_mgmt_pct Loan_Return_on_CET1_Capital_Management_Percent, ln_rocet1_cpl_rgultry_pct Loan_Return_on_CET1_Capital_Regulatory_Percent, ln_rocet1_cpl_rsk_bsd_brty_pct Loan_Return_on_CET1_Capital_Risk_Based_Binding_Regulatory_Percent, ln_rocet1_cpl_tier_1_lbrty_pct Loan_Return_on_CET1_Capital_Tier_1_Leverage_Binding_Regulatory_Percent, ln_tier_1_rbc_mgmt_bp_rt Loan_Tier_1_Risk_Based_Capital_Management_Basis_Point_Rate, ln_tier_1_rbc_pbmgt_bp_rt Loan_Tier_1_Risk_Based_Capital_Prescribed_Buffer_Management_Basis_Point_Rate, ln_tier_1_rbc_pbrty_bp_rt Loan_Tier_1_Risk_Based_Capital_Prescribed_Buffer_Regulatory_Basis_Point_Rate, ln_tier_1_rbc_rgultry_bp_rt Loan_Tier_1_Risk_Based_Capital_Regulatory_Basis_Point_Rate, ln_tier_1_rbtc_bp_rt Loan_Tier_1_Risk_Based_Target_Capital_Basis_Point_Rate, ln_tier_1_rbtcm_bp_rt Loan_Tier_1_Risk_Based_Target_Capital_Management_Basis_Point_Rate, ln_tier_2_cocm_bp_rt Loan_Tier_2_Cost_of_Capital_Management_Basis_Point_Rate, ln_tier_2_cost_of_cpl_atcpl_lbrty_bp_rt Loan_Tier_2_Cost_of_Capital_Adjusted_Total_Capital_Leverage_Binding_Regulatory_Basis_Point_Rate, ln_tier_2_cost_of_cpl_rsk_bsd_brty_bp_rt Loan_Tier_2_Cost_of_Capital_Risk_Based_Binding_Regulatory_Basis_Point_Rate, T2CC_ERCF Tier_2_Cost_Of_Capital_ERCF, LN_FNL_TIER_2_COST_OF_CPL_BP_RT Loan_Final_Tier_2_Cost_Of_Capital_Basis_Point_Rate, ln_tier_2_cost_of_cpl_tier_1_lbrty_bp_rt Loan_Tier_2_Cost_of_Capital_Tier_1_Leverage_Binding_Regulatory_Basis_Point_Rate, ln_tier_2_cpl_atcpl_lbrty_bp_rt Loan_Tier_2_Capital_Adjusted_Total_Capital_Leverage_Binding_Regulatory_Basis_Point_Rate, ln_tier_2_cpl_mgmt_bp_rt Loan_Tier_2_Capital_Management_Basis_Point_Rate, ln_tier_2_cpl_rsk_bsd_brty_bp_rt Loan_Tier_2_Capital_Risk_Based_Binding_Regulatory_Basis_Point_Rate, ln_tier_2_cpl_tier_1_lbrty_bp_rt Loan_Tier_2_Capital_Tier_1_Leverage_Binding_Regulatory_Basis_Point_Rate, ln_tot_rsk_wghtd_ast_amt Loan_Total_Risk_Weighted_Asset_Amount, ln_tot_tier_1_cpl_mgmt_bp_rt Loan_Total_Tier_1_Capital_Management_Basis_Point_Rate, LN_TIER_1_TRGT_CPL_BP_RT Loan_Tier_1_Target_Capital_Basis_Point_Rate, CASE when ln_entp_cpl_aqsn_seg_typ='New Origination' then CASE WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) >= 0 and (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 30 THEN 1 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 30 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 60 THEN 2 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 60 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 70 THEN 3 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 70 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 75 THEN 4 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 75 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) < 80 THEN 5 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) = 80 THEN 6 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 80 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 85 THEN 7 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 85 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 90 THEN 8 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 90 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 95 THEN 9 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 95 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 97 THEN 10 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 97 then 11 else 11 END when ln_entp_cpl_aqsn_seg_typ='Performing Seasoned' then CASE WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) >= 0 and (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 30 THEN 1 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 30 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 60 THEN 2 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 60 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 70 THEN 3 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 70 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 75 THEN 4 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 75 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) < 80 THEN 5 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) = 80 THEN 6 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 80 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 85 THEN 7 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 85 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 90 THEN 8 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 90 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 95 THEN 9 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 95 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 97 THEN 10 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 97 then 11 else 11 END END AS "LTV_GRP_ID", CASE when ln_entp_cpl_aqsn_seg_typ='New Origination' then CASE WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) >= 0 and (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 30 THEN 1 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 30 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 40 THEN 2 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 40 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 50 THEN 3 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 50 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 60 THEN 4 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 60 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 70 THEN 5 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 70 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 75 THEN 6 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 75 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 80 THEN 7 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 80 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 85 THEN 8 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 85 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 90 THEN 9 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 90 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 95 THEN 10 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 95 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 100 THEN 11 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 100 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 110 THEN 12 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 110 AND (ln_ctc_adjd_orgnn_ltv_rt*100 ) <= 120 THEN 13 WHEN (ln_ctc_adjd_orgnn_ltv_rt*100 ) > 120 then 14 else 14 END when ln_entp_cpl_aqsn_seg_typ='Performing Seasoned' then CASE WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) >= 0 and (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 30 THEN 1 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 30 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 40 THEN 2 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 40 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 50 THEN 3 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 50 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 60 THEN 4 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 60 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 70 THEN 5 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 70 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 75 THEN 6 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 75 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 80 THEN 7 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 80 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 85 THEN 8 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 85 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 90 THEN 9 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 90 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 95 THEN 10 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 95 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 100 THEN 11 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 100 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 110 THEN 12 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 110 AND (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) <= 120 THEN 13 WHEN (ln_ctc_adjd_aqsn_mtm_ltv_rt*100 ) > 120 then 14 else 14 END END AS "LTV_GRP_ID_2023", cast( substr(ln_acvy_rptg_dt, 1, 4) || case when substr(ln_acvy_rptg_dt, 6, 2) in ('01','02','03')then '1' when substr(ln_acvy_rptg_dt, 6, 2) in ('04','05','06')then '2' when substr(ln_acvy_rptg_dt, 6, 2) in ('07','08','09')then '3' when substr(ln_acvy_rptg_dt, 6, 2) in ('10','11','12')then '4' END as Int) as QUARTER_ID, coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) as Regulatory_Voluntary_Management_Buffer_ERCF, case when ( coalesce(cast(ln_cet1_crdt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mrkt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_cpl_orsk_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pscr_cpl_cbfr_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) - ( coalesce(cast(ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) else 0 END ) ) <> 0 then ( (1 - coalesce(cast(port_ln_post_tx_rt_pct as numeric (38,15)),0)) * ( coalesce(cast(ln_ctrt_yld_bp_rt as numeric (38,15)),0) + ( case when coalesce(cast(ln_pv_mthd_mlpr_fctr as numeric (38,15)),0) <> 0 then ( coalesce(cast(ln_dlry_fee_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_wlc_trueup_gos_gnls_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_wlc_hdg_gl_ln_gnls_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_whl_ln_cdt_net_carryg_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_wlc_othr_iexp_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pv_flt_incm_bp_rt as numeric (38,15)),0) - coalesce(cast(ln_fhfa_expd_dflt_cost_rt as numeric (38,15)),0) + coalesce(cast(ln_gfee_byu_byd_bp_rt as numeric (38,15)),0)+ ( coalesce(cast(ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) else 0 END ) ) / coalesce(cast(ln_pv_mthd_mlpr_fctr as numeric (38,15)),0) else 0 end ) + coalesce(cast(ln_gfee_byu_byd_yld_bas_rt as numeric (38,15)),0) - coalesce(cast(port_ln_tx_cut_contn_act_bp_rt as numeric (38,15)),0) - coalesce(cast(ln_gnrl_admin_exp_bp_rt as numeric (38,15)),0) - coalesce(cast(T2CC_ERCF as numeric (38,15)),0) ) - coalesce(cast(PSC_ERCF as numeric (38,15)),0) ) / (coalesce(cast(ln_cet1_crdt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mrkt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_cpl_orsk_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pscr_cpl_cbfr_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) - (coalesce(cast(ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) else 0 END ) ) END as All_In_ROCET_ERCF_Percent, (coalesce(cast(ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) END ) AS Front_End_Capital_Benefit_ERCF_Rate, (coalesce(cast(ln_cet1_trgt_cpl_rgultry_bp_rt as numeric (38,15)),0) - (coalesce(cast( ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) END ) ) All_In_Capital_ERCF_Rate, (coalesce(cast(ln_cet1_rbc_rgultry_bp_rt as numeric (38,15)),0) - (coalesce(cast( ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) END ) ) All_In_Capital_WOBuffer_ERCF_Rate, case when coalesce(ln_entp_cpl_orgnn_bm_catg_typ,'No Burnout') = 'No Burnout' then 1 when ln_entp_cpl_orgnn_bm_catg_typ = 'Low' then 2 when ln_entp_cpl_orgnn_bm_catg_typ = 'Med' then 3 when ln_entp_cpl_orgnn_bm_catg_typ = 'High' then 4 End as Burnout_ID, case when (coalesce(cast(ln_cet1_crdt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_cpl_orsk_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pscr_cpl_cbfr_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) - (coalesce(cast(ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) END ) ) <>0 then ( (1 - coalesce(cast(port_ln_post_tx_rt_pct as numeric (38,15)),0)) * (coalesce(cast(ln_ctrt_yld_bp_rt as numeric (38,15)),0) + case when coalesce(cast(ln_pv_mthd_mlpr_fctr as numeric (38,15)),0) <>0 then ( coalesce(cast(ln_dlry_fee_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pv_flt_incm_bp_rt as numeric (38,15)),0) - coalesce(cast(ln_fhfa_expd_dflt_cost_rt as numeric (38,15)),0) + coalesce(cast(ln_gfee_byu_byd_bp_rt as numeric (38,15)),0)+ (coalesce(cast(ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) END) ) / coalesce(cast(ln_pv_mthd_mlpr_fctr as numeric (38,15)),0) END + coalesce(cast(ln_gfee_byu_byd_yld_bas_rt as numeric (38,15)),0) - coalesce(cast(port_ln_tx_cut_contn_act_bp_rt as numeric (38,15)),0) - coalesce(cast(ln_gnrl_admin_exp_bp_rt as numeric (38,15)),0) - coalesce(cast(T2CC_ERCF as numeric (38,15)),0)) - coalesce(cast(PSC_ERCF as numeric (38,15)),0) ) / (coalesce(cast(ln_cet1_crdt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_cpl_orsk_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pscr_cpl_cbfr_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) - (coalesce(cast(ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) END ) ) END as All_In_ROCET_Without_WLC_ERCF_Percent, case when ( coalesce(cast(ln_cet1_crdt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mrkt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_cpl_orsk_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pscr_cpl_cbfr_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) ) <> 0 then ( (1- coalesce(cast(port_ln_post_tx_rt_pct as numeric (38,15)),0))* ( case when coalesce(cast(ln_pv_mthd_mlpr_fctr as numeric (38,15)),0) <> 0 then ( coalesce(cast(ln_dlry_fee_bp_rt as numeric (38,15)),0)+ (coalesce(cast(ln_wlc_trueup_gos_gnls_bp_rt as numeric (38,15)),0) +coalesce(cast(ln_wlc_hdg_gl_ln_gnls_bp_rt as numeric (38,15)),0) +coalesce(cast(ln_whl_ln_cdt_net_carryg_bp_rt as numeric (38,15)),0) +coalesce(cast(ln_wlc_othr_iexp_bp_rt as numeric (38,15)),0)) + coalesce(cast(ln_pv_flt_incm_bp_rt as numeric (38,15)),0) -coalesce(cast(ln_fhfa_expd_dflt_cost_rt as numeric (38,15)),0) +coalesce(cast(ln_gfee_byu_byd_bp_rt as numeric (38,15)),0) )/coalesce(cast(ln_pv_mthd_mlpr_fctr as numeric (38,15)),0) END +coalesce(cast(ln_ctrt_yld_bp_rt as numeric (38,15)),0) +coalesce(cast(ln_gfee_byu_byd_yld_bas_rt as numeric (38,15)),0) -coalesce(cast(port_ln_tx_cut_contn_act_bp_rt as numeric (38,15)),0) -coalesce(cast(ln_gnrl_admin_exp_bp_rt as numeric (38,15)),0) -coalesce(cast(T2CC_ERCF as numeric (38,15)),0)) -coalesce(cast(PSC_ERCF as numeric (38,15)),0) ) / ( coalesce(cast(ln_cet1_crdt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mrkt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_cpl_orsk_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pscr_cpl_cbfr_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) ) end as PRE_CRT_ROCET_ERCF_Percent, case when ( coalesce(cast(ln_cet1_crdt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_cpl_orsk_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pscr_cpl_cbfr_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) ) <> 0 then ( (1- coalesce(cast(port_ln_post_tx_rt_pct as numeric (38,15)),0))* ( case when coalesce(cast(ln_pv_mthd_mlpr_fctr as numeric (38,15)),0) <> 0 then ( coalesce(cast(ln_dlry_fee_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pv_flt_incm_bp_rt as numeric (38,15)),0) -coalesce(cast(ln_fhfa_expd_dflt_cost_rt as numeric (38,15)),0) +coalesce(cast(ln_gfee_byu_byd_bp_rt as numeric (38,15)),0) )/coalesce(cast(ln_pv_mthd_mlpr_fctr as numeric (38,15)),0) END +coalesce(cast(ln_ctrt_yld_bp_rt as numeric (38,15)),0) +coalesce(cast(ln_gfee_byu_byd_yld_bas_rt as numeric (38,15)),0) -coalesce(cast(port_ln_tx_cut_contn_act_bp_rt as numeric (38,15)),0) -coalesce(cast(ln_gnrl_admin_exp_bp_rt as numeric (38,15)),0) -coalesce(cast(T2CC_ERCF as numeric (38,15)),0)) -coalesce(cast(PSC_ERCF as numeric (38,15)),0) ) / ( coalesce(cast(ln_cet1_crdt_rsk_cpl_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_cpl_orsk_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_pscr_cpl_cbfr_rgultry_bp_rt as numeric (38,15)),0) + coalesce(cast(ln_cet1_mgmt_bfr_for_rgultry_bp_rt as numeric (38,15)),0) ) end AS PRE_CRT_ROCET_Without_WLC_ERCF_Percent, coalesce(cast(ln_cet1_rbc_rgultry_bp_rt as numeric (38,15)),0) - coalesce(cast(ln_cet1_mrkt_rsk_cpl_bp_rt as numeric (38,15)),0) as PRE_CRT_Capital_Without_MRC_ERCF_Rate, coalesce(cast(ln_cet1_rbc_rgultry_bp_rt as numeric (38,15)),0) + (coalesce(cast(ln_el_bnft_to_el_rto_rt as numeric (38,15)),0) - case when coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) <> 0 then coalesce(cast(ln_fe_crxf_exp_amt as numeric (38,15)),0) *10000 / coalesce(cast(ln_calc_actl_upb_amt as numeric (38,15)),0) END ) - coalesce(cast(ln_cet1_mrkt_rsk_cpl_bp_rt as numeric (38,15)),0) as All_In_Capital_Without_MRC_ERCF_Rate, ln_wlc_trup_nincm_gos_bp_rt Loan_Whole_Loan_Conduit_Trueup_Net_Income_Gain_On_Sale_Basis_Point_Rate, brwr_grp_smry_crdt_scr_rng_val Borrower_Group_Summary_Credit_Score_Range_Value, brwr_grp_npl_crdt_scr_rng_val Borrower_Group_Non_Performing_Loan_Credit_Score_Range_Value, ln_adjd_tot_cpl_crdt_rsk_amt Loan_Adjusted_Total_Capital_Credit_Risk_Amount, ln_atcpl_mgmt_bfr_mgmt_amt Loan_Adjusted_Total_Capital_Management_Buffer_Management_Amount, ln_atcpl_mgmt_bfr_rgultry_amt Loan_Adjusted_Total_Capital_Management_Buffer_Regulatory_Amount, ln_atcpl_orsk_rgultry_amt Loan_Adjusted_Total_Capital_Operational_Risk_Regulatory_Amount, ln_atcpl_pscr_bfr_mgmt_amt Loan_Adjusted_Total_Capital_Prescribed_Buffer_Management_Amount, ln_atcpl_pscr_bfr_rgultry_amt Loan_Adjusted_Total_Capital_Prescribed_Buffer_Regulatory_Amount, ln_atcpl_trgt_cpl_mgmt_amt Loan_Adjusted_Total_Capital_Target_Capital_Management_Amount, ln_atcpl_trgt_cpl_rgultry_amt Loan_Adjusted_Total_Capital_Target_Capital_Regulatory_Amount, ln_cet1_cpl_oprl_rsk_mgmt_amt Loan_CET1_Capital_Operational_Risk_Management_Amount, ln_cet1_cpl_orsk_rgultry_amt Loan_CET1_Capital_Operational_Risk_Regulatory_Amount, ln_cet1_crdt_rsk_cpl_amt Loan_CET1_Credit_Risk_Capital_Amount, ln_cet1_min_rcrty_amt Loan_CET1_Minimum_Required_Capital_Regulatory_Amount, ln_cet1_min_reqd_cpl_mgmt_amt Loan_CET1_Minimum_Required_Capital_Management_Amount, ln_cet1_rbc_pbrty_amt Loan_CET1_Risk_Based_Capital_Prescribed_Buffer_Regulatory_Amount, ln_cet1_rbc_pscr_bfr_mgmt_amt Loan_CET1_Risk_Based_Capital_Prescribed_Buffer_Management_Amount, ln_cet1_rbmbr_amt Loan_CET1_Risk_Based_Management_Buffer_Regulatory_Amount, ln_cet1_trgt_cpl_mgmt_amt Loan_CET1_Target_Capital_Management_Amount, ln_cet1_trgt_cpl_rgultry_amt Loan_CET1_Target_Capital_Regulatory_Amount, ln_crdt_rsk_wghtd_ast_amt Loan_Credit_Risk_Weighted_Asset_Amount, ln_ctc_cpl_bfr_amt Loan_Countercyclical_Capital_Buffer_Amount, ln_dl_catg_typ Loan_Deal_Category_Type, ln_mf_cet1_rbmb_mgmt_amt Loan_Multifamily_CET1_Risk_Based_Management_Buffer_Management_Amount, ln_mf_tier_1_lmbfr_mgmt_amt Loan_Multifamily_Tier_1_Leverage_Management_Buffer_Management_Amount, ln_mf_tier_1_rbmb_mgmt_amt Loan_Multifamily_Tier_1_Risk_Based_Management_Buffer_Management_Amount, ln_oprl_rsk_wghtd_ast_amt Loan_Operational_Risk_Weighted_Asset_Amount, ln_oprl_rsk_wght_pct Loan_Operational_Risk_Weight_Percent, ln_pscr_cpl_cbfr_rgultry_amt Loan_Prescribed_Capital_Conservation_Buffer_Regulatory_Amount, ln_pscr_cpl_cnvn_bfr_mgmt_amt Loan_Prescribed_Capital_Conservation_Buffer_Management_Amount, ln_pscr_lvrg_bfr_amt Loan_Prescribed_Leverage_Buffer_Amount, ln_sf_cet1_rbmb_mgmt_amt Loan_Single_Family_CET1_Risk_Based_Management_Buffer_Management_Amount, ln_sf_tier_1_lmbfr_mgmt_amt Loan_Single_Family_Tier_1_Leverage_Management_Buffer_Management_Amount, ln_sf_tier_1_rbmb_mgmt_amt Loan_Single_Family_Tier_1_Risk_Based_Management_Buffer_Management_Amount, ln_stbly_cpl_bfr_amt Loan_Stability_Capital_Buffer_Amount, ln_strs_cpl_bfr_amt Loan_Stress_Capital_Buffer_Amount, ln_tier_1_cpl_oprl_rsk_amt Loan_Tier_1_Capital_Operational_Risk_Amount, ln_tier_1_crdt_rsk_cpl_amt Loan_Tier_1_Credit_Risk_Capital_Amount, ln_tier_1_lmbfr_rgultry_amt Loan_Tier_1_Leverage_Management_Buffer_Regulatory_Amount, ln_tier_1_lvrg_trgt_cpl_amt Loan_Tier_1_Leverage_Target_Capital_Amount, ln_tier_1_min_reqd_rbc_amt Loan_Tier_1_Minimum_Required_Risk_Based_Capital_Amount, ln_tier_1_mrlvg_cpl_amt Loan_Tier_1_Minimum_Required_Leverage_Capital_Amount, ln_tier_1_rbc_pbrty_amt Loan_Tier_1_Risk_Based_Capital_Prescribed_Buffer_Regulatory_Amount, ln_tier_1_rbmbr_amt Loan_Tier_1_Risk_Based_Management_Buffer_Regulatory_Amount, ln_tier_1_rsk_bsd_trgt_cpl_amt Loan_Tier_1_Risk_Based_Target_Capital_Amount, ln_tier_1_trgt_cpl_amt Loan_Tier_1_Target_Capital_Amount, ln_tot_rsk_wght_pct Loan_Total_Risk_Weight_Percent, ln_whl_ln_cdt_net_carryg_amt Loan_Whole_Loan_Conduit_Net_Carrying_Amount, ln_whl_ln_cdt_net_incm_amt Loan_Whole_Loan_Conduit_Net_Income_Amount, ln_wlc_ancint_bp_rt Loan_Whole_Loan_Conduit_Annualized_Net_Carrying_Interest_Basis_Point_Rate, ln_wlc_anlzd_hdg_gos_bp_rt Loan_Whole_Loan_Conduit_Annualized_Hedge_Gain_On_Sale_Basis_Point_Rate, ln_wlc_anlzd_poe_gnls_bp_rt Loan_Whole_Loan_Conduit_Annualized_Pair_Offs_Over_Deliveries_Extensions_Gain_Loss_Basis_Point_Rate, ln_wlc_anlzd_prc_gos_bp_rt Loan_Whole_Loan_Conduit_Annualized_Price_Gain_On_Sale_Basis_Point_Rate, ln_wlc_apoclt_iegnls_bp_rt Loan_Whole_Loan_Conduit_Annualized_Payoff_Curtailment_Ineligible_Gain_Loss_Basis_Point_Rate, ln_wlc_atni_gos_bp_rt Loan_Whole_Loan_Conduit_Annualized_Trueup_Net_Income_Gain_On_Sale_Basis_Point_Rate, ln_wlc_atup_prc_gos_bp_rt Loan_Whole_Loan_Conduit_Annualized_Trueup_Price_Gain_On_Sale_Basis_Point_Rate, ln_wlc_gos_gl_amt Loan_Whole_Loan_Conduit_Gain_on_Sale_General_Ledger_Amount, ln_wlc_gos_gl_bp_rt Loan_Whole_Loan_Conduit_Gain_On_Sale_General_Ledger_Basis_Point_Rate, ln_wlc_hdg_gl_ln_gnls_amt Loan_Whole_Loan_Conduit_Hedge_General_Ledger_Loan_Gain_Loss_Amount, ln_wlc_nincm_anlzd_gos_bp_rt Loan_Whole_Loan_Conduit_Net_Income_Annualized_Gain_On_Sale_Basis_Point_Rate, ln_wlc_nincm_gos_bp_rt Loan_Whole_Loan_Conduit_Net_Income_Gain_On_Sale_Basis_Point_Rate, ln_wlc_poctlt_iegnls_amt Loan_Whole_Loan_Conduit_Payoff_Curtailment_Ineligible_Gain_Loss_Amount, ln_wlc_poctlt_iegnls_bp_rt Loan_Whole_Loan_Conduit_Payoff_Curtailment_Ineligible_Gain_Loss_Basis_Point_Rate, ln_wlc_poe_gnls_amt Loan_Whole_Loan_Conduit_Pair_Offs_Over_Deliveries_Extensions_Gain_Loss_Amount, ln_wlc_poe_gnls_bp_rt Loan_Whole_Loan_Conduit_Pair_Offs_Over_Deliveries_Extensions_Gain_Loss_Basis_Point_Rate, ln_wlc_trup_gos_gnls_amt Loan_Whole_Loan_Conduit_Trueup_Gain_On_Sale_Gain_Loss_Amount, ln_wlc_trup_nincm_amt Loan_Whole_Loan_Conduit_Trueup_Net_Income_Amount, ln_bse_rwt_aft_covid_hrct_wtho_ctc_adjm_pct Loan_Base_Risk_Weight_After_COVID_Haircut_Without_Countercyclical_Adjustment_Percent, ln_drvd_prmi_wtho_ctc_adjm_rwt_pct Loan_Derived_Pre_Mortgage_Insurance_Without_Countercyclical_Adjustment_Risk_Weight_Percent, ln_aft_mi_bef_mihct_wtho_ctc_adjm_rwt_pct Loan_After_Mortgage_Insurance_Before_Mortgage_Insurance_Haircut_Without_Countercyclical_Adjustment_Risk_Weight_Percent, ln_ptmi_wtho_ctc_adjm_rwt_pct Loan_Post_Mortgage_Insurance_Without_Countercyclical_Adjustment_Risk_Weight_Percent, ln_ptmi_aft_flr_wtho_ctc_adjm_crsk_wght_pct Loan_Post_Mortgage_Insurance_After_Floor_Without_Countercyclical_Adjustment_Credit_Risk_Weight_Percent, ln_pscr_cpl_wtho_ctc_adjm_rgultry_bp_rt Loan_Prescribed_Capital_Without_Countercyclical_Adjustment_Regulatory_Basis_Point_Rate, ln_cet1_mgmt_bfr_for_rgultry_bp_rt Loan_CET1_Management_Buffer_For_Regulatory_Basis_Point_Rate, ln_cet1_vlnty_mgmt_bfr_for_mgmt_bp_rt Loan_CET1_Voluntary_Management_Buffer_For_Management_Basis_Point_Rate, ln_rocet1_cpl_rsk_bsd_bwomrc_and_wlc_nincm_rgultry_pct Loan_Return_on_CET1_Capital_Risk_Based_Binding_Without_Market_Risk_Capital_And_Whole_Loan_Conduit_Net_Income_Regulatory_Percent, ln_rocet1_cpl_tier_1_lvrg_bwomrc_and_wlc_nincm_rgultry_pct Loan_Return_on_CET1_Capital_Tier_1_Leverage_Binding_Without_Market_Risk_Capital_And_Whole_Loan_Conduit_Net_Income_Regulatory_Percent, ln_rocet1_cpl_atcpl_lvrg_bwomrc_and_wlc_nincm_rgultry_pct Loan_Return_on_CET1_Capital_Adjusted_Total_Capital_Leverage_Binding_Without_Market_Risk_Capital_And_Whole_Loan_Conduit_Net_Income_Regulatory_Percent, ln_rocet1_cpl_wtho_mkrsk_cpl_and_wlc_nincm_rgultry_pct Loan_Return_on_CET1_Capital_Without_Market_Risk_Capital_And_Whole_Loan_Conduit_Net_Income_Regulatory_Percent, ln_rocet1_cpl_wtho_mkrsk_cpl_and_wlc_nincm_mgmt_pct Loan_Return_on_CET1_Capital_Without_Market_Risk_Capital_And_Whole_Loan_Conduit_Net_Income_Management_Percent, ln_cet1_rbc_wtho_mkrsk_cpl_rgultry_bp_rt Loan_CET1_Risk_Based_Capital_Without_Market_Risk_Capital_Regulatory_Basis_Point_Rate, ln_cet1_rbc_wtho_mkrsk_cpl_mgmt_bp_rt Loan_CET1_Risk_Based_Capital_Without_Market_Risk_Capital_Management_Basis_Point_Rate, ln_cet1_rbc_wtho_mkrsk_cpl_pbrty_bp_rt Loan_CET1_Risk_Based_Capital_Without_Market_Risk_Capital_Prescribed_Buffer_Regulatory_Basis_Point_Rate, ln_cet1_rbc_wtho_mkrsk_cpl_pbmgt_bp_rt Loan_CET1_Risk_Based_Capital_Without_Market_Risk_Capital_Prescribed_Buffer_Management_Basis_Point_Rate, ln_cet1_trgt_cpl_wtho_mkrsk_cpl_rgultry_bp_rt Loan_CET1_Target_Capital_Without_Market_Risk_Capital_Regulatory_Basis_Point_Rate, ln_cet1_trgt_cpl_wtho_mkrsk_cpl_mgmt_bp_rt Loan_CET1_Target_Capital_Without_Market_Risk_Capital_Management_Basis_Point_Rate, LN_STC_CTC_ADJM_MTM_LTV_RT Loan_Static_Countercyclical_Adjustment_Mark_To_Market_Loan_To_Value_Rate, LN_STC_CTC_ADJM_ORGNN_LTV_RT Loan_Static_Countercyclical_Adjustment_Origination_Loan_To_Value_Rate, LN_BSE_CPL_AFT_COVID_HRCT_WTHO_CTC_ADJM_BP_RT Loan_Base_Capital_After_COVID_Haircut_Without_Countercyclical_Adjustment_Basis_Point_Rate, LN_BSE_RWT_AFT_COVID_HRCT_WITH_STC_CTC_ADJM_PCT Loan_Base_Risk_Weight_After_COVID_Haircut_With_Static_Countercyclical_Adjustment_Percent, LN_BSE_CPL_AFT_COVID_HRCT_WITH_STC_CTC_ADJM_BP_RT Loan_Base_Capital_After_COVID_Haircut_With_Static_Countercyclical_Adjustment_Basis_Point_Rate, LN_DRVD_PRMI_CRCP_WTHO_CTC_ADJM_BP_RT Loan_Derived_Pre_Mortgage_Insurance_Credit_Risk_Capital_Without_Countercyclical_Adjustment_Basis_Point_Rate, LN_DRVD_PRMI_WITH_STC_CTC_ADJM_RWT_PCT Loan_Derived_Pre_Mortgage_Insurance_With_Static_Countercyclical_Adjustment_Risk_Weight_Percent, LN_DRVD_PRMI_CRCP_WITH_STC_CTC_ADJM_BP_RT Loan_Derived_Pre_Mortgage_Insurance_Credit_Risk_Capital_With_Static_Countercyclical_Adjustment_Basis_Point_Rate, LN_WTHO_CTC_ADJM_CRCP_AFT_MI_BEF_MIHCT_BP_RT Loan_Without_Countercyclical_Adjustment_Credit_Risk_Capital_After_Mortgage_Insurance_Before_Mortgage_Insurance_Haircut_Basis_Point_Rate, LN_AFT_MI_BEF_MIHCT_WITH_STC_CTC_ADJM_RWT_PCT Loan_After_Mortgage_Insurance_Before_Mortgage_Insurance_Haircut_With_Static_Countercyclical_Adjustment_Risk_Weight_Percent, LN_STC_CTC_ADJM_CRCP_AFT_MI_BEF_MIHCT_BP_RT Loan_Static_Countercyclical_Adjustment_Credit_Risk_Capital_After_Mortgage_Insurance_Before_Mortgage_Insurance_Haircut_Basis_Point_Rate, LN_PTMI_WTHO_CTC_ADJM_CRCP_BP_RT Loan_Post_Mortgage_Insurance_Without_Countercyclical_Adjustment_Credit_Risk_Capital_Basis_Point_Rate, LN_PTMI_WITH_STC_CTC_ADJM_RWT_PCT Loan_Post_Mortgage_Insurance_With_Static_Countercyclical_Adjustment_Risk_Weight_Percent, LN_PTMI_WITH_STC_CTC_ADJM_CRCP_BP_RT Loan_Post_Mortgage_Insurance_With_Static_Countercyclical_Adjustment_Credit_Risk_Capital_Basis_Point_Rate, LN_PTMI_CRCP_AFT_FLR_WTHO_CTC_ADJM_BP_RT Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_After_Floor_Without_Countercyclical_Adjustment_Basis_Point_Rate, LN_PTMI_AFT_FLR_WITH_STC_CTC_ADJM_CRSK_WGHT_PCT Loan_Post_Mortgage_Insurance_After_Floor_With_Static_Countercyclical_Adjustment_Credit_Risk_Weight_Percent, LN_PTMI_CRCP_AFT_FLR_WITH_STC_CTC_ADJM_BP_RT Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_After_Floor_With_Static_Countercyclical_Adjustment_Basis_Point_Rate, LN_PTMI_AFT_FLR_WTHO_CTC_ADJM_CRSK_WGHT_AMT Loan_Post_Mortgage_Insurance_After_Floor_Without_Countercyclical_Adjustment_Credit_Risk_Weight_Amount, LN_PTMI_CRCP_AFT_FLR_WTHO_CTC_ADJM_AMT Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_After_Floor_Without_Countercyclical_Adjustment_Amount, LN_PTMI_AFT_FLR_WITH_STC_CTC_ADJM_CRSK_WGHT_AMT Loan_Post_Mortgage_Insurance_After_Floor_With_Static_Countercyclical_Adjustment_Credit_Risk_Weight_Amount, LN_PTMI_CRCP_AFT_FLR_WITH_STC_CTC_ADJM_AMT Loan_Post_Mortgage_Insurance_Credit_Risk_Capital_After_Floor_With_Static_Countercyclical_Adjustment_Amount, LN_PSCR_CPL_RGULTRY_BP_RT Loan_Prescribed_Capital_Regulatory_Basis_Point_Rate, LN_PSCR_CPL_WITH_STC_CTC_ADJM_RGULTRY_BP_RT Loan_Prescribed_Capital_With_Static_Countercyclical_Adjustment_Regulatory_Basis_Point_Rate, LN_CET1_WTHO_CTC_ADJM_CRCP_BP_RT Loan_CET1_Without_Countercyclical_Adjustment_Credit_Risk_Capital_Basis_Point_Rate, LN_CET1_WITH_STC_CTC_ADJM_CRCP_BP_RT Loan_CET1_With_Static_Countercyclical_Adjustment_Credit_Risk_Capital_Basis_Point_Rate, ln_noi_bp_rt Loan_Net_Operating_Income_Basis_Point_Rate, ln_lftm_rocet1_nmrt_amt Loan_Lifetime_Return_On_Common_Equity_Tier_1_Numerator_Amount, ln_lftm_rocet1_dnmntr_amt Loan_Lifetime_Return_On_Common_Equity_Tier_1_Denominator_Amount, port_cet1_vlnty_mgmt_bfr_bp_rt Portfolio_CET1_Voluntary_Management_Buffer_Basis_Point_Rate, port_tier_1_rsk_bsd_vlnty_mgmt_bfr_bp_rt Portfolio_Tier_1_Risk_Based_Voluntary_Management_Buffer_Basis_Point_Rate, port_tier_1_lvrg_vlnty_mgmt_bfr_bp_rt Portfolio_Tier_1_Leverage_Voluntary_Management_Buffer_Basis_Point_Rate, port_atcpl_vlnty_mgmt_bfr_bp_rt Portfolio_Adjusted_Voluntary_Management_Buffer_Basis_Point_Rate, port_pscr_cet1_cpl_bp_rt Portfolio_Prescribed_CET1_Capital_Basis_Point_Rate, port_pscr_tier_1_rbc_bp_rt Portfolio_Prescribed_Tier_1_Risk_Based_Capital_Basis_Point_Rate, port_pscr_tier_1_lvrg_cpl_bp_rt Portfolio_Prescribed_Tier_1_Leverage_Capital_Basis_Point_Rate, port_pscr_adjd_tot_cpl_bp_rt Portfolio_Prescribed_Adjusted_Total_Capital_Basis_Point_Rate, port_cet1_vlnty_mgmt_bfr_rgultry_bp_rt Portfolio_CET1_Voluntary_Management_Buffer_Regulatory_Basis_Point_Rate, port_cet1_vlnty_mgmt_bfr_mgmt_bp_rt Portfolio_CET1_Voluntary_Management_Buffer_Management_Basis_Point_Rate, port_tier_1_rsk_bsd_vlnty_mgmt_bfr_rgultry_bp_rt Portfolio_Tier_1_Risk_Based_Voluntary_Management_Buffer_Regulatory_Basis_Point_Rate, port_tier_1_rsk_bsd_vlnty_mgmt_bfr_mgmt_bp_rt Portfolio_Tier_1_Risk_Based_Voluntary_Management_Buffer_Management_Basis_Point_Rate, port_tier_1_lvrg_vlnty_mgmt_bfr_rgultry_bp_rt Portfolio_Tier_1_Leverage_Voluntary_Management_Buffer_Regulatory_Basis_Point_Rate, port_tier_1_lvrg_vlnty_mgmt_bfr_mgmt_bp_rt Portfolio_Tier_1_Leverage_Voluntary_Management_Buffer_Management_Basis_Point_Rate, port_atcpl_vlnty_mgmt_bfr_rgultry_bp_rt Portfolio_Adjusted_Total_Capital_Voluntary_Management_Buffer_Regulatory_Basis_Point_Rate, port_atcpl_vlnty_mgmt_bfr_mgmt_bp_rt Portfolio_Adjusted_Total_Capital_Voluntary_Management_Buffer_Management_Basis_Point_Rate, ln_tail_mtrc_for_all_ln_wtho_ctc_adjm_rnk_cnt Loan_Tail_Metric_For_All_Loans_Without_Countercyclical_Adjustment_Rank_Count, ln_tail_mtrc_rnk_for_all_ln_wtho_ctc_adjm_cum_upb_amt Loan_Tail_Metric_Ranked_For_All_Loans_Without_Countercyclical_Adjustment_Cumulative_UPB_Amount, ln_tail_mtrc_for_all_ln_wtho_ctc_adjm_ind Loan_Tail_Metric_For_All_Loans_Without_Countercyclical_Adjustment_Indicator, ln_tail_mtrc_for_pur_ln_wtho_ctc_adjm_rnk_cnt Loan_Tail_Metric_For_Purchase_Loans_Without_Countercyclical_Adjustment_Rank_Count, ln_tail_mtrc_rnk_for_pur_ln_wtho_ctc_adjm_cum_upb_amt Loan_Tail_Metric_Ranked_For_Purchase_Loans_Without_Countercyclical_Adjustment_Cumulative_UPB_Amount, ln_tail_mtrc_for_pur_ln_wtho_ctc_adjm_ind Loan_Tail_Metric_For_Purchase_Loans_Without_Countercyclical_Adjustment_Indicator, ln_tail_mtrc_for_refi_ln_wtho_ctc_adjm_rnk_cnt Loan_Tail_Metric_For_Refinance_Loans_Without_Countercyclical_Adjustment_Rank_Count, ln_tail_mtrc_rnk_for_refi_ln_wtho_ctc_adjm_cum_upb_amt Loan_Tail_Metric_Ranked_For_Refinance_Loans_Without_Countercyclical_Adjustment_Cumulative_UPB_Amount, ln_tail_mtrc_for_refi_ln_wtho_ctc_adjm_ind Loan_Tail_Metric_For_Refinance_Loans_Without_Countercyclical_Adjustment_Indicator, ln_tail_mtrc_for_all_ln_with_ctc_adjm_rnk_cnt Loan_Tail_Metric_For_All_Loans_With_Countercyclical_Adjustment_Rank_Count, ln_tail_mtrc_rnk_for_all_ln_with_ctc_adjm_cum_upb_amt Loan_Tail_Metric_Ranked_For_All_Loans_With_Countercyclical_Adjustment_Cumulative_UPB_Amount, ln_tail_mtrc_for_all_ln_with_ctc_adjm_ind Loan_Tail_Metric_For_All_Loans_With_Countercyclical_Adjustment_Indicator, ln_tail_mtrc_for_pur_ln_with_ctc_adjm_rnk_cnt Loan_Tail_Metric_For_Purchase_Loans_With_Countercyclical_Adjustment_Rank_Count, ln_tail_mtrc_rnk_for_pur_ln_with_ctc_adjm_cum_upb_amt Loan_Tail_Metric_Ranked_For_Purchase_Loans_With_Countercyclical_Adjustment_Cumulative_UPB_Amount, ln_tail_mtrc_for_pur_ln_with_ctc_adjm_ind Loan_Tail_Metric_For_Purchase_Loans_With_Countercyclical_Adjustment_Indicator, ln_tail_mtrc_for_refi_ln_with_ctc_adjm_rnk_cnt Loan_Tail_Metric_For_Refinance_Loans_With_Countercyclical_Adjustment_Rank_Count, ln_tail_mtrc_rnk_for_refi_ln_with_ctc_adjm_cum_upb_amt Loan_Tail_Metric_Ranked_For_Refinance_Loans_With_Countercyclical_Adjustment_Cumulative_UPB_Amount, ln_tail_mtrc_for_refi_ln_with_ctc_adjm_ind Loan_Tail_Metric_For_Refinance_Loans_With_Countercyclical_Adjustment_Indicator, ln_harp_ecd Loan_Home_Affordable_Refinance_Plan_Enterprisecode, ln_tail_mtrc_rnk_for_all_ln_with_ctc_adjm_cum_upb_rt Loan_Tail_Metric_Ranked_For_All_Loans_With_Countercyclical_Adjustment_Cumulative_UPB_Rate, ln_tail_mtrc_rnk_for_all_ln_wtho_ctc_adjm_cum_upb_rt Loan_Tail_Metric_Ranked_For_All_Loans_Without_Countercyclical_Adjustment_Cumulative_UPB_Rate, ln_tail_mtrc_rnk_for_pur_ln_with_ctc_adjm_cum_upb_rt Loan_Tail_Metric_Ranked_For_Purchase_Loans_With_Countercyclical_Adjustment_Cumulative_UPB_Rate, ln_tail_mtrc_rnk_for_pur_ln_wtho_ctc_adjm_cum_upb_rt Loan_Tail_Metric_Ranked_For_Purchase_Loans_Without_Countercyclical_Adjustment_Cumulative_UPB_Rate, ln_tail_mtrc_rnk_for_refi_ln_with_ctc_adjm_cum_upb_rt Loan_Tail_Metric_Ranked_For_Refinance_Loans_With_Countercyclical_Adjustment_Cumulative_UPB_Rate, ln_tail_mtrc_rnk_for_refi_ln_wtho_ctc_adjm_cum_upb_rt Loan_Tail_Metric_Ranked_For_Refinance_Loans_Without_Countercyclical_Adjustment_Cumulative_UPB_Rate from (SELECT ld.*, case when LN_FNL_ADDL_TIER_1_COST_OF_CPL_BP_RT is not NULL then LN_FNL_ADDL_TIER_1_COST_OF_CPL_BP_RT else ln_addl_tier_1_rbcocr_bp_rt end as PSC_ERCF, case when LN_FNL_TIER_2_COST_OF_CPL_BP_RT is not NULL then LN_FNL_TIER_2_COST_OF_CPL_BP_RT else ln_tier_2_cost_of_cpl_rsk_bsd_brty_bp_rt end T2CC_ERCF from RAW."f5g_glue_f5g_edl_ent_crs_dflt_fnmo_isgt".SF."ln_dly_calc_fact" ld ) A