importTestData.sql

/*

USE [BDESIME]
GO

INSERT INTO [dbo].[payment_tran]
           ([delta_file_byte]
           ,[LOAN NUMBER]
           ,[PMT TRANSACTION DATE_old]
           ,[PMT SEQUENCE NUMBER]
           ,[PMT A H INSURANCE AMOUNT]
           ,[PMT ACTION CODE]
           ,[PMT BATCH NUMBER]
           ,[PMT ESCROW AMOUNT]
           ,[PMT FEE AMOUNT]
           ,[PMT FEE CODE]
           ,[PMT HUD AMOUNT]
           ,[PMT INTEREST AMOUNT]
           ,[PMT LIFE INSURANCE AMOUNT]
           ,[PMT MISC AMOUNT]
           ,[PMT PRINCIPAL AMOUNT]
           ,[PMT REPLACEMENT RES]
           ,[PMT RESTRICTED ESC AMOUNT]
           ,[PMT SERVICE CHARGE AMOUNT]
           ,[PMT SERVICE FEE AMOUNT]
           ,[PMT SUB CODE]
           ,[PMT SUSPENSE AMOUNT]
           ,[PMT TOTAL AMOUNT]
           ,[PMT TRANSACTION CODE]
           ,[PMT DUE DATE]
           ,[pmt_due_null]
           ,[PMT EFFECTIVE DATE]
           ,[pmt_effective_null]
           ,[PMT HI TYPE]
           ,[PMT MODIFIED PAYMENT PLAN ID]
           ,[CLIENT NUMBER]
           ,[PMT AUTO ADJUSTMENT INDICATOR]
           ,[PMT PREVIOUSLY POSTED AMOUNT]
           ,[PMT INTEREST DUE PAID AMOUNT]
           ,[PMT REVERSAL REASON CODE]
           ,[PMT DISTRIBUTION TYPE]
           ,[PMT SUBSIDY SOURCE CODE]
           ,[PMT INCENTIVE PROCESS CODE]
           ,[PMT PRIN ADJ REASON CODE]
           ,[PMT PRIN REDUCTION AMOUNT]
           ,[PMT PRIN FORBEARANCE AMOUNT]
           ,[PMT SCHEDULED DUE AMOUNT]
           ,[PMT SCHEDULED DUE INDICATOR]
           ,[load_date]
           ,[EXTR_GUID]
           ,[ERRORS]
           ,[SID]
           ,[PMT TRANSACTION DATE])
     select [delta_file_byte]
           ,[LOAN NUMBER]
           ,[PMT TRANSACTION DATE_old]
           ,[PMT SEQUENCE NUMBER]
           ,[PMT A H INSURANCE AMOUNT]
           ,[PMT ACTION CODE]
           ,[PMT BATCH NUMBER]
           ,[PMT ESCROW AMOUNT]
           ,[PMT FEE AMOUNT]
           ,[PMT FEE CODE]
           ,[PMT HUD AMOUNT]
           ,[PMT INTEREST AMOUNT]
           ,[PMT LIFE INSURANCE AMOUNT]
           ,[PMT MISC AMOUNT]
           ,[PMT PRINCIPAL AMOUNT]
           ,[PMT REPLACEMENT RES]
           ,[PMT RESTRICTED ESC AMOUNT]
           ,[PMT SERVICE CHARGE AMOUNT]
           ,[PMT SERVICE FEE AMOUNT]
           ,[PMT SUB CODE]
           ,[PMT SUSPENSE AMOUNT]
           ,[PMT TOTAL AMOUNT]
           ,[PMT TRANSACTION CODE]
           ,[PMT DUE DATE]
           ,[pmt_due_null]
           ,[PMT EFFECTIVE DATE]
           ,[pmt_effective_null]
           ,[PMT HI TYPE]
           ,[PMT MODIFIED PAYMENT PLAN ID]
           ,[CLIENT NUMBER]
           ,[PMT AUTO ADJUSTMENT INDICATOR]
           ,[PMT PREVIOUSLY POSTED AMOUNT]
           ,[PMT INTEREST DUE PAID AMOUNT]
           ,[PMT REVERSAL REASON CODE]
           ,[PMT DISTRIBUTION TYPE]
           ,[PMT SUBSIDY SOURCE CODE]
           ,[PMT INCENTIVE PROCESS CODE]
           ,[PMT PRIN ADJ REASON CODE]
           ,[PMT PRIN REDUCTION AMOUNT]
           ,[PMT PRIN FORBEARANCE AMOUNT]
           ,[PMT SCHEDULED DUE AMOUNT]
           ,[PMT SCHEDULED DUE INDICATOR]
           ,[load_date]
           ,[EXTR_GUID]
           ,[ERRORS]
           ,[SID]
           ,[PMT TRANSACTION DATE]
		   from [10.0.15.10].bdesime.dbo.payment_tran
		where [LOAN NUMBER] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 
--and [load_date] in ('3/31/2017','2/28/2017','1/31/2017','12/31/2016','11/30/2016','10/31/2016','9/30/2016','8/31/2016','7/31/2016','6/30/2016','5/31/2016','4/30/2016','3/31/2016','2/29/2016','1/31/2016')




use BDE_Data
go
insert into loan
(delta_file_byte,
    ln_no,
    load_date,
    iv_id,
    ln_zero_prinbal_cd, 
    ln_pif_null,
    ln_arm_cd,
    ln_lo_ty,
    ln_1st_prin_ba,
    ln_1st_p_i_am,
    ln_suspense_ba,
    ln_lm_status_cd,
    co_man_cd,
    ln_zone_xx,
    ln_nxt_pmt_due_dt,
    iv_cat_cd,
    ltv_ratio,
    ln_last_tran_dt,
    ln_loan_mod_dt,
    ln_cre_qul_orig_cd,
    ln_serv_sold_dt,
    orig_ltv_ratio_fc,
    ln_pif_stop_cd,
    ln_pif_dt,
    ln_bill_mode_cd,
    ln_matures_dt,
    ln_ann_int_rt,
    ln_nsf_ba,
    ln_monthly_pmt_am,
    ln_acr_lte_chrg_am,
    ln_hi_ty,
    ln_tr,
    ln_action_cd,
    ln_mers_id,
    ln_mers_reg_dt,
    ln_assum_cd,
    ln_matures_df,
    ln_dist_type1_int_only_flag,
    ln_pmt_option_cd,
    ln_purchase_dt,
    ln_loan_mod_type,
    ln_funding_date,
    ln_pen_pool_no,
    ln_convt_status_cd,
    ln_pmt_pd,
    ln_rem_tr,
    ln_fnma_ftr1_cd,
    ln_fnma_ftr2_cd,
    ln_fnma_ftr3_cd,
    ln_fnma_ftr4_cd,
    ln_bkr_status_cd,
    ln_bk13_cd,
    ln_bk11_cd,
    ln_bk07_cd,
    ln_sold_cd,
    ln_fc_wkst_stat_cd,
    ln_reo_status_cd,
    ln_hazard_table_fg,
    es_escrowed_cd ,
    ln_cre_qul_cur_cd,
    ln_process_stop_cd,
    ln_procstop_exp_dt,
    ln_lc_stop_chg_id,
    ln_proc_stp_chg_id,
    ln_int_due_ba,
    ln_next_paymt_no,
    ln_stop_bill_cd,	
    ln_gse_cd,
    ln_sale_dt,
    ln_gnma_pool_no,
    ln_check_stop_cd,
    ln_drafting_cd,
    ln_stp_bill_exp_dt,
    ln_coup_tape_dt,
    ln_no_notice_cd,
    ln_bill_cycle_cd,
    ln_lfp_dt,
    ln_du_dt_lst_ch_dt,
    ln_tot_pymt_due_am,
    ln_pp_disb_stop_cd,
    fc_stop_cd,
    arm_conv_to_fix_cd,
    ln_mil_srv_stat_cd,
	asm_dt,
	ln_fc_stop_chg_dt,
	ln_bill_table04_xx
)
SELECT delta_file_byte,
    ln_no,
    load_date,
    iv_id,
    ln_zero_prinbal_cd, 
    ln_pif_null,
    ln_arm_cd,
    ln_lo_ty,
    ln_1st_prin_ba,
    ln_1st_p_i_am,
    ln_suspense_ba,
    ln_lm_status_cd,
    co_man_cd,
    ln_zone_xx,
    ln_nxt_pmt_due_dt,
    iv_cat_cd,
    ltv_ratio,
    ln_last_tran_dt,
    ln_loan_mod_dt,
    ln_cre_qul_orig_cd,
    ln_serv_sold_dt,
    orig_ltv_ratio_fc,
    ln_pif_stop_cd,
    ln_pif_dt,
    ln_bill_mode_cd,
    ln_matures_dt,
    ln_ann_int_rt,
    ln_nsf_ba,
    ln_monthly_pmt_am,
    ln_acr_lte_chrg_am,
    ln_hi_ty,
    ln_tr,
    ln_action_cd,
    ln_mers_id,
    ln_mers_reg_dt,
    ln_assum_cd,
    ln_matures_df,
    ln_dist_type1_int_only_flag,
    ln_pmt_option_cd,
    ln_purchase_dt,
    ln_loan_mod_type,
    ln_funding_date,
    ln_pen_pool_no,
    ln_convt_status_cd,
    ln_pmt_pd,
    ln_rem_tr,
    ln_fnma_ftr1_cd,
    ln_fnma_ftr2_cd,
    ln_fnma_ftr3_cd,
    ln_fnma_ftr4_cd,
    ln_bkr_status_cd,
    ln_bk13_cd,
    ln_bk11_cd,
    ln_bk07_cd,
    ln_sold_cd,
    ln_fc_wkst_stat_cd,
    ln_reo_status_cd,
    ln_hazard_table_fg,
    es_escrowed_cd ,
    ln_cre_qul_cur_cd,
    ln_process_stop_cd,
    ln_procstop_exp_dt,
    ln_lc_stop_chg_id,
    ln_proc_stp_chg_id,
    ln_int_due_ba,
    ln_next_paymt_no,
    ln_stop_bill_cd,	
    ln_gse_cd,
    ln_sale_dt,
    ln_gnma_pool_no,
    ln_check_stop_cd,
    ln_drafting_cd,
    ln_stp_bill_exp_dt,
    ln_coup_tape_dt,
    ln_no_notice_cd,
    ln_bill_cycle_cd,
    ln_lfp_dt,
    ln_du_dt_lst_ch_dt,
    ln_tot_pymt_due_am,
    ln_pp_disb_stop_cd,
    fc_stop_cd,
    arm_conv_to_fix_cd,
    ln_mil_srv_stat_cd,
	asm_dt,
	ln_fc_stop_chg_dt,
	ln_bill_table04_xx
from [10.0.15.10].bde_data.dbo.loan
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 
and [load_date] in ('3/31/2017','2/28/2017','1/31/2017','12/31/2016','11/30/2016','10/31/2016','9/30/2016','8/31/2016','7/31/2016','6/30/2016','5/31/2016','4/30/2016','3/31/2016','2/29/2016','1/31/2016')



USE [BDESime]
GO
INSERT INTO [dbo].[dim_delinquency]
           ([ln_no]
           ,[co_delq_cd]
           ,[times_delq_qt]
           ,[co_avg_days_dlq_qt]
           ,[co_dlq_pmt_ba]
           ,[co_late_chrg_fc]
           ,[co_bad_chk_tbl_01]
           ,[co_bad_chk_tbl_02]
           ,[co_bad_chk_tbl_03]
           ,[co_bad_chk_tbl_04]
           ,[co_bad_chk_tbl_05]
           ,[co_bad_chk_tbl_06]
           ,[co_bad_chk_tbl_07]
           ,[co_bad_chk_tbl_08]
           ,[co_bad_chk_tbl_09]
           ,[co_bad_chk_tbl_10]
           ,[co_bad_chk_tbl_11]
           ,[co_bad_chk_tbl_12]
           ,[co_delq_class_cd]
           ,[co_man_cd]
           ,[co_delq_reason_cd]
           ,[co_late_chrg_am]
           ,[co_dlq_col_days_qt]
           ,[co_loss_mitgn_cd]
           ,[co_repay_plan_cd]
           ,[valid_from_date]
           ,[valid_through_date]
           )
		   SELECT [ln_no]
           ,[co_delq_cd]
           ,[times_delq_qt]
           ,[co_avg_days_dlq_qt]
           ,[co_dlq_pmt_ba]
           ,[co_late_chrg_fc]
           ,[co_bad_chk_tbl_01]
           ,[co_bad_chk_tbl_02]
           ,[co_bad_chk_tbl_03]
           ,[co_bad_chk_tbl_04]
           ,[co_bad_chk_tbl_05]
           ,[co_bad_chk_tbl_06]
           ,[co_bad_chk_tbl_07]
           ,[co_bad_chk_tbl_08]
           ,[co_bad_chk_tbl_09]
           ,[co_bad_chk_tbl_10]
           ,[co_bad_chk_tbl_11]
           ,[co_bad_chk_tbl_12]
           ,[co_delq_class_cd]
           ,[co_man_cd]
           ,[co_delq_reason_cd]
           ,[co_late_chrg_am]
           ,[co_dlq_col_days_qt]
           ,[co_loss_mitgn_cd]
           ,[co_repay_plan_cd]
           ,[valid_from_date]
           ,[valid_through_date]
           FROM [10.0.15.10].[BDESime].[dbo].[dim_delinquency]
		   where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 
and [valid_through_date] in ('3/31/2017','2/28/2017','1/31/2017','12/31/2016','11/30/2016','10/31/2016','9/30/2016','8/31/2016','7/31/2016','6/30/2016','5/31/2016','4/30/2016','3/31/2016','2/29/2016','1/31/2016')



USE [BDESime]
GO

INSERT INTO [dbo].[delinquency_snapshot]
           ([LOAN NUMBER]
           ,[OLD LOAN NUMBER]
           ,[INVESTOR ID]
           ,[ARM INDICATOR]
           ,[LO TYPE]
           ,[ORIGINAL LO TYPE]
           ,[FIRST PRINCIPAL BALANCE]
           ,[FIRST P AND I AMOUNT]
           ,[SUSPENSE BALANCE]
           ,[LOAN LOSS MIT STATUS CODE]
           ,[MAN CODE]
           ,[MSP DLQ STATUS]
           ,[MTH STATUS NAME]
           ,[NEXT PAYMENT DUE DATE]
           ,[CS BORR ORIG CREDIT QLTY CODE]
           ,[CS BORR CREDIT QUALITY CODE]
           ,[CS BORR CREDIT QUALITY DATE]
           ,[STREAMLINE]
           ,[SOURCE CHANNEL]
           ,[NOTE DATE]
           ,[MONTH FROM ORIGINATION]
           ,[IS COMPARE]
           ,[IS EOM]
           ,[SIXTY]
           ,[NINETY]
           ,[BDE LOAD]
           ,[MSP LOAD]
           ,[LOAN DATE]
           ,[IS_COMPARE_YEAR]
           ,[proper_status]
           ,[owner_name]
           ,[iv_cat_cd]
           ,[bnk_status]
           ,[reo_status]
           ,[fc_status])
SELECT [LOAN NUMBER]
           ,[OLD LOAN NUMBER]
           ,[INVESTOR ID]
           ,[ARM INDICATOR]
           ,[LO TYPE]
           ,[ORIGINAL LO TYPE]
           ,[FIRST PRINCIPAL BALANCE]
           ,[FIRST P AND I AMOUNT]
           ,[SUSPENSE BALANCE]
           ,[LOAN LOSS MIT STATUS CODE]
           ,[MAN CODE]
           ,[MSP DLQ STATUS]
           ,[MTH STATUS NAME]
           ,[NEXT PAYMENT DUE DATE]
           ,[CS BORR ORIG CREDIT QLTY CODE]
           ,[CS BORR CREDIT QUALITY CODE]
           ,[CS BORR CREDIT QUALITY DATE]
           ,[STREAMLINE]
           ,[SOURCE CHANNEL]
           ,[NOTE DATE]
           ,[MONTH FROM ORIGINATION]
           ,[IS COMPARE]
           ,[IS EOM]
           ,[SIXTY]
           ,[NINETY]
           ,[BDE LOAD]
           ,[MSP LOAD]
           ,[LOAN DATE]
           ,[IS_COMPARE_YEAR]
           ,[proper_status]
           ,[owner_name]
           ,[iv_cat_cd]
           ,[bnk_status]
           ,[reo_status]
           ,[fc_status]
from [10.0.15.10].bdesime.dbo.delinquency_snapshot
where [loan number] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 
and [loan date] = '4/30/2017' --in ('3/31/2017','2/28/2017','1/31/2017','12/31/2016','11/30/2016','10/31/2016','9/30/2016','8/31/2016','7/31/2016','6/30/2016','5/31/2016','4/30/2016','3/31/2016','2/29/2016','1/31/2016')


USE [BDESIME]
GO
INSERT INTO [dbo].[borrower]
 SELECT *  from [10.0.15.10].bdesime.dbo.borrower
where [loan number] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 
and [load_date] in ('3/31/2017','2/28/2017','1/31/2017','12/31/2016','11/30/2016','10/31/2016','9/30/2016','8/31/2016','7/31/2016','6/30/2016','5/31/2016','4/30/2016','3/31/2016','2/29/2016','1/31/2016')


USE [BDESIME]
GO
INSERT INTO [dbo].[property]
select * from [10.0.15.10].bdesime.dbo.property
where [loan number] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 
and [load_date] > '12/31/2015' --in ('3/31/2017','2/28/2017','1/31/2017','12/31/2016','11/30/2016','10/31/2016','9/30/2016','8/31/2016','7/31/2016','6/30/2016','5/31/2016','4/30/2016','3/31/2016','2/29/2016','1/31/2016')


USE [BDESIME]
GO
INSERT INTO [dbo].[original_loan]
select * from [10.0.15.10].bdesime.dbo.original_loan
where [loan number] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 

USE [BDE_Data]
GO

INSERT INTO [dbo].[loss_mitigation]
           ([delta_file_byte]
           ,[ln_no]
           ,[lm_set_up_dt]
           ,[lm_processor_id]
           ,[lm_stage_cd]
           ,[lm_received_dt]
           ,[lm_received_null]
           ,[lm_deficiency_cd]
           ,[lm_template_nm]
           ,[lm_serv_atty_id]
           ,[lm_mtgr_atty_id]
           ,[lm_approval_dt]
           ,[lm_approval_null]
           ,[lm_oth_atty_id]
           ,[lm_den_reason_cd]
           ,[lm_removal_dt]
           ,[lm_removal_null]
           ,[lm_status_cd]
           ,[lm_ty]
           ,[lm_referral_cd]
           ,[lm_reserve_ba]
           ,[lm_writedown_am]
           ,[lm_lst_expir_dt]
           ,[lm_lst_expir_null]
           ,[lm_lst_agent_id]
           ,[lm_lst_price_am]
           ,[lm_lst_payee_id]
           ,[lm_lst_pd]
           ,[lm_sal_start_dt]
           ,[lm_sal_start_null]
           ,[lm_sal_close_dt]
           ,[lm_sal_close_null]
           ,[lm_sal_ty]
           ,[lm_sal_concesn_cd]
           ,[lm_sal_proceeds_am]
           ,[lm_cont_start_dt]
           ,[lm_cont_start_null]
           ,[lm_cont_follow_dt]
           ,[lm_cont_follow_null]
           ,[lm_cont_wdraw_dt]
           ,[lm_cont_wdraw_null]
           ,[lm_cond_citatn_dt]
           ,[lm_cond_citatn_null]
           ,[lm_cond_env_haz_xx]
           ,[lm_cond_bathrm_qt]
           ,[lm_cond_sq_ft_qt]
           ,[lm_cond_bedrm_qt]
           ,[lm_cond_secured_cd]
           ,[lm_repa_start_dt]
           ,[lm_repa_start_null]
           ,[lm_repa_damage_dt]
           ,[lm_repa_damage_null]
           ,[lm_repa_hazclam_cd]
           ,[lm_clai_fst_st_dt]
           ,[lm_clai_fst_st_null]
           ,[lm_clai_sup_st_dt]
           ,[lm_clai_sup_st_null]
           ,[lm_clai_fnl_st_dt]
           ,[lm_clai_fnl_st_null]
           ,[lm_clai_fst_fu_dt]
           ,[lm_clai_fst_fu_null]
           ,[lm_clai_sup_fu_dt]
           ,[lm_clai_sup_fu_null]
           ,[lm_clai_fnl_fu_dt]
           ,[lm_clai_fnl_fu_null]
           ,[client_no]
           ,[lm_mod_eff_dt]
           ,[lm_mod_eff_null]
           ,[lm_prev_mod_dt]
           ,[lm_prev_mod_null]
           ,[lm_template_id]
           ,[lm_accting_updt_dt]
           ,[lm_acctg_updt_null]
           ,[lm_current_step_cd]
           ,[lm_file_owner_cd]
           ,[lm_status_chg_dt]
           ,[lm_status_chg_null]
           ,[lm_step_ct]
           ,[lm_templat_crte_dt]
           ,[lm_templat_cr_null]
           ,[lm_templat_updt_dt]
           ,[lm_templat_up_null]
           ,[lm_templat_updt_tm]
           ,[lm_templat_updt_id]
           ,[lm_templat_wkst_cd]
           ,[lm_sale_price_am]
           ,[lm_cls_costs_am]
           ,[lm_cls_agent_id]
           ,[lm_buyer_id]
           ,[lm_sale_flwup_dt]
           ,[lm_sale_flwup_null]
           ,[lm_spoc_id]
           ,[load_date])
SELECT [delta_file_byte]
           ,[ln_no]
           ,[lm_set_up_dt]
           ,[lm_processor_id]
           ,[lm_stage_cd]
           ,[lm_received_dt]
           ,[lm_received_null]
           ,[lm_deficiency_cd]
           ,[lm_template_nm]
           ,[lm_serv_atty_id]
           ,[lm_mtgr_atty_id]
           ,[lm_approval_dt]
           ,[lm_approval_null]
           ,[lm_oth_atty_id]
           ,[lm_den_reason_cd]
           ,[lm_removal_dt]
           ,[lm_removal_null]
           ,[lm_status_cd]
           ,[lm_ty]
           ,[lm_referral_cd]
           ,[lm_reserve_ba]
           ,[lm_writedown_am]
           ,[lm_lst_expir_dt]
           ,[lm_lst_expir_null]
           ,[lm_lst_agent_id]
           ,[lm_lst_price_am]
           ,[lm_lst_payee_id]
           ,[lm_lst_pd]
           ,[lm_sal_start_dt]
           ,[lm_sal_start_null]
           ,[lm_sal_close_dt]
           ,[lm_sal_close_null]
           ,[lm_sal_ty]
           ,[lm_sal_concesn_cd]
           ,[lm_sal_proceeds_am]
           ,[lm_cont_start_dt]
           ,[lm_cont_start_null]
           ,[lm_cont_follow_dt]
           ,[lm_cont_follow_null]
           ,[lm_cont_wdraw_dt]
           ,[lm_cont_wdraw_null]
           ,[lm_cond_citatn_dt]
           ,[lm_cond_citatn_null]
           ,[lm_cond_env_haz_xx]
           ,[lm_cond_bathrm_qt]
           ,[lm_cond_sq_ft_qt]
           ,[lm_cond_bedrm_qt]
           ,[lm_cond_secured_cd]
           ,[lm_repa_start_dt]
           ,[lm_repa_start_null]
           ,[lm_repa_damage_dt]
           ,[lm_repa_damage_null]
           ,[lm_repa_hazclam_cd]
           ,[lm_clai_fst_st_dt]
           ,[lm_clai_fst_st_null]
           ,[lm_clai_sup_st_dt]
           ,[lm_clai_sup_st_null]
           ,[lm_clai_fnl_st_dt]
           ,[lm_clai_fnl_st_null]
           ,[lm_clai_fst_fu_dt]
           ,[lm_clai_fst_fu_null]
           ,[lm_clai_sup_fu_dt]
           ,[lm_clai_sup_fu_null]
           ,[lm_clai_fnl_fu_dt]
           ,[lm_clai_fnl_fu_null]
           ,[client_no]
           ,[lm_mod_eff_dt]
           ,[lm_mod_eff_null]
           ,[lm_prev_mod_dt]
           ,[lm_prev_mod_null]
           ,[lm_template_id]
           ,[lm_accting_updt_dt]
           ,[lm_acctg_updt_null]
           ,[lm_current_step_cd]
           ,[lm_file_owner_cd]
           ,[lm_status_chg_dt]
           ,[lm_status_chg_null]
           ,[lm_step_ct]
           ,[lm_templat_crte_dt]
           ,[lm_templat_cr_null]
           ,[lm_templat_updt_dt]
           ,[lm_templat_up_null]
           ,[lm_templat_updt_tm]
           ,[lm_templat_updt_id]
           ,[lm_templat_wkst_cd]
           ,[lm_sale_price_am]
           ,[lm_cls_costs_am]
           ,[lm_cls_agent_id]
           ,[lm_buyer_id]
           ,[lm_sale_flwup_dt]
           ,[lm_sale_flwup_null]
           ,[lm_spoc_id]
           ,[load_date]
		   from [10.0.15.10].bde_data.dbo.loss_mitigation
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 

use BDE_Data
go
insert INTO [dbo].[loss_mit_steps]
           (
		   [delta_file_byte]
           ,[ln_no]
           ,[ls_setup_dt]
           ,[ls_no]
           ,[ls_actual_compl_dt]
           ,[ls_actual_compl_null]
           ,[ls_critical_stp_cd]
           ,[ls_float_days_qt]
           ,[ls_pred_step_cd]
           ,[ls_sched_compl_dt]
           ,[ls_sched_compl_null]
           ,[ls_step_cd]
           ,[ls_comment_cd]
           ,[ls_cost_am]
           ,[client_no]
           ,[load_date]
)
SELECT [delta_file_byte]
           ,[ln_no]
           ,[ls_setup_dt]
           ,[ls_no]
           ,[ls_actual_compl_dt]
           ,[ls_actual_compl_null]
           ,[ls_critical_stp_cd]
           ,[ls_float_days_qt]
           ,[ls_pred_step_cd]
           ,[ls_sched_compl_dt]
           ,[ls_sched_compl_null]
           ,[ls_step_cd]
           ,[ls_comment_cd]
           ,[ls_cost_am]
           ,[client_no]
           ,[load_date]
from [10.0.15.10].bde_data.[dbo].[loss_mit_steps]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 

use BDE_Data
go
USE [BDE_Data]
GO

INSERT INTO [dbo].[foreclosure]
           ([delta_file_byte]
           ,[ln_no]
           ,[fc_setup_dt]
           ,[fc_attorney_id]
           ,[fc_begin_esc_ba]
           ,[fc_claim_ty]
           ,[fc_damage_cd]
           ,[fc_days_qt]
           ,[fc_deed_in_lieu_cd]
           ,[fc_default_dt]
           ,[fc_default_null]
           ,[fc_expense_tot_am]
           ,[fc_fcst_lte_chr_ba]
           ,[fc_full_sttl_dt]
           ,[fc_full_sttl_null]
           ,[fc_interest_due_am]
           ,[fc_lst_note_dt]
           ,[fc_lst_note_null]
           ,[fc_misc1_am]
           ,[fc_misc2_am]
           ,[fc_misc3_am]
           ,[fc_misc4_am]
           ,[fc_misc1_de]
           ,[fc_misc2_de]
           ,[fc_misc3_de]
           ,[fc_misc4_de]
           ,[fc_pmts_due_qt]
           ,[fc_part_sttl_dt]
           ,[fc_part_sttl_null]
           ,[fc_pmts_due_ba]
           ,[fc_prev_status_cd]
           ,[fc_processor_id]
           ,[fc_prop_disp_cd]
           ,[fc_reason_cd]
           ,[fc_reinst_dt]
           ,[fc_reinst_null]
           ,[fc_reinst_quote_dt]
           ,[fc_reinst_quote_null]
           ,[fc_reinst_due_am]
           ,[fc_removal_cd]
           ,[fc_removal_dt]
           ,[fc_removal_null]
           ,[fc_start_dt]
           ,[fc_start_null]
           ,[fc_status_cd]
           ,[fc_stat_cd_chg_dt]
           ,[fc_stat_cd_chg_null]
           ,[fc_status_code_de]
           ,[fc_stop_cd]
           ,[fc_suspend_dt]
           ,[fc_suspend_null]
           ,[fc_template_id]
           ,[fc_ty]
           ,[fc_bad_chk_fee_ba]
           ,[fc_bad_check_qt]
           ,[fc_rstr_esc_cd]
           ,[fc_sale_dt]
           ,[fc_sale_null]
           ,[fc_314_709_cmpl_dt]
           ,[fc_314_709_cmpl_null]
           ,[fc_307_703_cmpl_dt]
           ,[fc_307_703_cmpl_null]
           ,[fc_sale_am]
           ,[re_loan_ind]
           ,[client_no]
           ,[fc_attr_crtmail_no]
           ,[fc_attorney_nm]
           ,[fc_attorney_ph_no]
           ,[fc_attr_ref_no]
           ,[fc_auto_pr_insp_cd]
           ,[fc_comm_only_dt]
           ,[fc_comm_only_null]
           ,[fc_part_a_tran_dt]
           ,[fc_parta_tran_null]
           ,[fc_part_ab_tran_dt]
           ,[fc_partab_trn_null]
           ,[fc_part_b_tran_dt]
           ,[fc_partb_tran_null]
           ,[fc_crit_stp_de]
           ,[fc_final_part_b_dt]
           ,[fc_final_prtb_null]
           ,[fc_tran_082_dt]
           ,[fc_tran_082_null]
           ,[fc_inspect_ord_cd]
           ,[fc_lst_inspect_dt]
           ,[fc_lst_inspct_null]
           ,[fc_last_updated_dt]
           ,[fc_last_updt_null]
           ,[fc_mic_certify_no]
           ,[fc_mic_mailing_dt]
           ,[fc_mic_mail_null]
           ,[fc_mic_return_dt]
           ,[fc_mic_return_null]
           ,[fc_next_inspect_dt]
           ,[fc_next_insp_null]
           ,[fc_orig_part_a_dt]
           ,[fc_orig_parta_null]
           ,[fc_orig_part_ab_dt]
           ,[fc_org_partab_null]
           ,[fc_inspect_stop_dt]
           ,[fc_insp_stop_null]
           ,[fc_inspect_strt_dt]
           ,[fc_insp_strt_null]
           ,[fc_inspection_cd]
           ,[fc_susp_removal_dt]
           ,[fc_susp_remov_null]
           ,[fc_va_nobid_rep_cd]
           ,[fc_stop_chg_id]
           ,[fc_stop_chg_dt]
           ,[fc_stop_chg_null]
           ,[fc_corr_pt_a_st_fg]
           ,[fc_corr_pt_b_st_fg]
           ,[fc_finl_pt_b_st_fg]
           ,[fc_org_prt_a_st_fg]
           ,[fc_bid_am]
           ,[load_date]
)
SELECT [delta_file_byte]
           ,[ln_no]
           ,[fc_setup_dt]
           ,[fc_attorney_id]
           ,[fc_begin_esc_ba]
           ,[fc_claim_ty]
           ,[fc_damage_cd]
           ,[fc_days_qt]
           ,[fc_deed_in_lieu_cd]
           ,[fc_default_dt]
           ,[fc_default_null]
           ,[fc_expense_tot_am]
           ,[fc_fcst_lte_chr_ba]
           ,[fc_full_sttl_dt]
           ,[fc_full_sttl_null]
           ,[fc_interest_due_am]
           ,[fc_lst_note_dt]
           ,[fc_lst_note_null]
           ,[fc_misc1_am]
           ,[fc_misc2_am]
           ,[fc_misc3_am]
           ,[fc_misc4_am]
           ,[fc_misc1_de]
           ,[fc_misc2_de]
           ,[fc_misc3_de]
           ,[fc_misc4_de]
           ,[fc_pmts_due_qt]
           ,[fc_part_sttl_dt]
           ,[fc_part_sttl_null]
           ,[fc_pmts_due_ba]
           ,[fc_prev_status_cd]
           ,[fc_processor_id]
           ,[fc_prop_disp_cd]
           ,[fc_reason_cd]
           ,[fc_reinst_dt]
           ,[fc_reinst_null]
           ,[fc_reinst_quote_dt]
           ,[fc_reinst_quote_null]
           ,[fc_reinst_due_am]
           ,[fc_removal_cd]
           ,[fc_removal_dt]
           ,[fc_removal_null]
           ,[fc_start_dt]
           ,[fc_start_null]
           ,[fc_status_cd]
           ,[fc_stat_cd_chg_dt]
           ,[fc_stat_cd_chg_null]
           ,[fc_status_code_de]
           ,[fc_stop_cd]
           ,[fc_suspend_dt]
           ,[fc_suspend_null]
           ,[fc_template_id]
           ,[fc_ty]
           ,[fc_bad_chk_fee_ba]
           ,[fc_bad_check_qt]
           ,[fc_rstr_esc_cd]
           ,[fc_sale_dt]
           ,[fc_sale_null]
           ,[fc_314_709_cmpl_dt]
           ,[fc_314_709_cmpl_null]
           ,[fc_307_703_cmpl_dt]
           ,[fc_307_703_cmpl_null]
           ,[fc_sale_am]
           ,[re_loan_ind]
           ,[client_no]
           ,[fc_attr_crtmail_no]
           ,[fc_attorney_nm]
           ,[fc_attorney_ph_no]
           ,[fc_attr_ref_no]
           ,[fc_auto_pr_insp_cd]
           ,[fc_comm_only_dt]
           ,[fc_comm_only_null]
           ,[fc_part_a_tran_dt]
           ,[fc_parta_tran_null]
           ,[fc_part_ab_tran_dt]
           ,[fc_partab_trn_null]
           ,[fc_part_b_tran_dt]
           ,[fc_partb_tran_null]
           ,[fc_crit_stp_de]
           ,[fc_final_part_b_dt]
           ,[fc_final_prtb_null]
           ,[fc_tran_082_dt]
           ,[fc_tran_082_null]
           ,[fc_inspect_ord_cd]
           ,[fc_lst_inspect_dt]
           ,[fc_lst_inspct_null]
           ,[fc_last_updated_dt]
           ,[fc_last_updt_null]
           ,[fc_mic_certify_no]
           ,[fc_mic_mailing_dt]
           ,[fc_mic_mail_null]
           ,[fc_mic_return_dt]
           ,[fc_mic_return_null]
           ,[fc_next_inspect_dt]
           ,[fc_next_insp_null]
           ,[fc_orig_part_a_dt]
           ,[fc_orig_parta_null]
           ,[fc_orig_part_ab_dt]
           ,[fc_org_partab_null]
           ,[fc_inspect_stop_dt]
           ,[fc_insp_stop_null]
           ,[fc_inspect_strt_dt]
           ,[fc_insp_strt_null]
           ,[fc_inspection_cd]
           ,[fc_susp_removal_dt]
           ,[fc_susp_remov_null]
           ,[fc_va_nobid_rep_cd]
           ,[fc_stop_chg_id]
           ,[fc_stop_chg_dt]
           ,[fc_stop_chg_null]
           ,[fc_corr_pt_a_st_fg]
           ,[fc_corr_pt_b_st_fg]
           ,[fc_finl_pt_b_st_fg]
           ,[fc_org_prt_a_st_fg]
           ,[fc_bid_am]
           ,[load_date]

from [10.0.15.10].bde_data.[dbo].[foreclosure]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO

INSERT INTO [dbo].[foreclsure_step]
           ([delta_file_byte]
           ,[ln_no]
           ,[fc_setup_dt]
           ,[fs_step_seq_no]
           ,[fs_actual_compl_dt]
           ,[fs_actual_compl_null]
           ,[fs_critical_stp_cd]
           ,[fs_float_days_qt]
           ,[fs_pred_step_cd]
           ,[fs_sched_compl_dt]
           ,[fs_sched_compl_null]
           ,[fs_step_cd]
           ,[fs_comment_cd]
           ,[fs_cost_am]
           ,[client_no]
           ,[load_date])
SELECT [delta_file_byte]
           ,[ln_no]
           ,[fc_setup_dt]
           ,[fs_step_seq_no]
           ,[fs_actual_compl_dt]
           ,[fs_actual_compl_null]
           ,[fs_critical_stp_cd]
           ,[fs_float_days_qt]
           ,[fs_pred_step_cd]
           ,[fs_sched_compl_dt]
           ,[fs_sched_compl_null]
           ,[fs_step_cd]
           ,[fs_comment_cd]
           ,[fs_cost_am]
           ,[client_no]
           ,[load_date]
		   from [10.0.15.10].bde_data.dbo.[foreclsure_step]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO

INSERT INTO [dbo].[bankruptcy]
           ([delta_file_byte]
           ,[ln_no]
           ,[bkr_setup_dt]
           ,[bkr_asset_cd]
           ,[bkr_case_no]
           ,[bkr_chapter_ty]
           ,[bkr_coborr_mtgr_cd]
           ,[bkr_conf_hear_dt]
           ,[bkr_conf_hear_null]
           ,[bkr_court_id]
           ,[bkr_cred_meet_dt]
           ,[bkr_cred_meet_null]
           ,[bkr_dbtr_atty_id]
           ,[bkr_debtor_ba]
           ,[bkr_discharge_dt]
           ,[bkr_discharge_null]
           ,[bkr_dismissal_dt]
           ,[bkr_dismissal_null]
           ,[bkr_est_disch_dt]
           ,[bkr_est_disch_null]
           ,[bkr_filing_dt]
           ,[bkr_filing_null]
           ,[bkr_flwup_compl_dt]
           ,[bkr_flwup_compl_null]
           ,[bkr_flwup_dt]
           ,[bkr_flwup_null]
           ,[bkr_lst_note_dt]
           ,[bkr_lst_note_null]
           ,[bkr_mtgr_atty_id]
           ,[bkr_notice_rec_dt]
           ,[bkr_notice_rec_null]
           ,[bkr_pi_order_cd]
           ,[bkr_post1_ba]
           ,[bkr_post2_ba]
           ,[bkr_pstpet1_clm_dt]
           ,[bkr_pstpet1_clm_null]
           ,[bkr_pstpet1_cnf_am]
           ,[bkr_pstpet1_due_dt]
           ,[bkr_pstpet1_due_null]
           ,[bkr_pstpet1_rem_ba]
           ,[bkr_pstpet2_clm_dt]
           ,[bkr_pstpet2_clm_null]
           ,[bkr_pstpet2_cnf_am]
           ,[bkr_pstpet2_due_dt]
           ,[bkr_pstpet2_due_null]
           ,[bkr_pstpet2_rem_ba]
           ,[bkr_pst_pet_due_dt]
           ,[bkr_pst_pet_due_null]
           ,[bkr_post_pet_cd]
           ,[bkr_prepet_clm_dt]
           ,[bkr_prepet_clm_null]
           ,[bkr_prepet_cnf_am]
           ,[bkr_prepet_due_dt]
           ,[bkr_prepet_due_null]
           ,[bkr_pre_pet_ba]
           ,[bkr_processor_id]
           ,[bkr_poc_file_dt]
           ,[bkr_poc_file_null]
           ,[bkr_relf_denied_dt]
           ,[bkr_relf_denied_null]
           ,[bkr_relf_fle_co_dt]
           ,[bkr_relf_fle_co_null]
           ,[bkr_relf_file_dt]
           ,[bkr_relf_file_null]
           ,[bkr_relf_fle_fu_dt]
           ,[bkr_relf_fle_fu_null]
           ,[bkr_relf_grant_dt]
           ,[bkr_relf_grant_null]
           ,[bkr_relf_her_co_dt]
           ,[bkr_relf_her_co_null]
           ,[bkr_relf_hear_dt]
           ,[bkr_relf_hear_null]
           ,[bkr_relf_her_fu_dt]
           ,[bkr_relf_her_fu_null]
           ,[bkr_relf_other_dt]
           ,[bkr_relf_other_null]
           ,[bkr_relf_req_co_dt]
           ,[bkr_relf_req_co_null]
           ,[bkr_relf_req_dt]
           ,[bkr_relf_req_null]
           ,[bkr_relf_req_fu_dt]
           ,[bkr_relf_req_fu_null]
           ,[bkr_removal_cd]
           ,[bkr_removal_dt]
           ,[bkr_removal_null]
           ,[bkr_repay_tr]
           ,[bkr_status_cd]
           ,[bkr_stay_lift_cd]
           ,[bkr_trust_aband_dt]
           ,[bkr_trust_aband_null]
           ,[bkr_trustee_id]
           ,[bkr_trustee_ba]
           ,[bkr_truste_tele_no]
           ,[bkr_trustee_nm]
           ,[bkr_prepet_ack_dt]
           ,[bkr_prepet_ack_null]
           ,[bkr_prepet_cnf_dt]
           ,[bkr_prepet_cnf_null]
           ,[bkr_pstpet1_cnf_dt]
           ,[bkr_pstpet1_cnf_null]
           ,[bkr_pstpet2_cnf_dt]
           ,[bkr_pstpet2_cnf_null]
           ,[bkr_prepet_efee_am]
           ,[re_loan_ind]
           ,[client_no]
           ,[bkr_prep_efeepd_am]
           ,[bkr_template_id]
           ,[bkr_altdebt1_ss_no]
           ,[bkr_altdebt2_ss_no]
           ,[bkr_altdebt1_nm]
           ,[bkr_altdebt2_nm]
           ,[bkr_completion_dt]
           ,[bkr_compltion_null]
           ,[bkr_debtor_fee_cd]
           ,[bkr_debtor_pmt_cd]
           ,[bkr_disposition_de]
           ,[bkr_fnma_laser_cd]
           ,[bkr_flwup_note1_xx]
           ,[bkr_flwup_note2_xx]
           ,[bkr_flwup_note3_xx]
           ,[bkr_flwup_proc_nm]
           ,[bkr_item1_de]
           ,[bkr_item1_flwup_dt]
           ,[bkr_item1_flw_null]
           ,[bkr_item1_recpt_dt]
           ,[bkr_item1_rec_null]
           ,[bkr_item1_req_dt]
           ,[bkr_item1_req_null]
           ,[bkr_item2_de]
           ,[bkr_item2_flwup_dt]
           ,[bkr_item2_flw_null]
           ,[bkr_item2_recpt_dt]
           ,[bkr_item2_rec_null]
           ,[bkr_item2_req_dt]
           ,[bkr_item2_req_null]
           ,[bkr_item3_de]
           ,[bkr_item3_flwup_dt]
           ,[bkr_item3_flw_null]
           ,[bkr_item3_recpt_dt]
           ,[bkr_item3_rec_null]
           ,[bkr_item3_req_dt]
           ,[bkr_item3_req_null]
           ,[bkr_item4_de]
           ,[bkr_item4_flwup_dt]
           ,[bkr_item4_flw_null]
           ,[bkr_item4_recpt_dt]
           ,[bkr_item4_rec_null]
           ,[bkr_item4_req_dt]
           ,[bkr_item4_req_null]
           ,[bkr_other_dt]
           ,[bkr_other_null]
           ,[bkr_pmt_stp_odr_de]
           ,[bkr_region_cd]
           ,[bkr_trustee_fee_cd]
           ,[bkr_trustee_pmt_cd]
           ,[bkr_update_user_id]
           ,[bkr_altdbt1_ss_no]
           ,[bkr_altdbt2_ss_no]
           ,[bkr_ch7_dischrg_cd]
           ,[bkr_ch7_dischrg_dt]
           ,[bkr_ch7_dchrg_null]
           ,[bkr_removal_de]
           ,[bkr_revised_clm_dt]
           ,[bkr_revised_clm_null]
           ,[bkr_pst_pet_pmt_ct]
           ,[bkr_uniform_clm_id]
           ,[bkr_pppmt_susp_ba]
           ,[bkr_conv_dt]
           ,[bkr_conv_null]
           ,[load_date]
           ,[BKR_PST_PET_PMT_AM]
           ,[BKR_PPET_PMT_AM_FG]
           ,[BKR_LEDGER_UPD_CD])
SELECT [delta_file_byte]
           ,[ln_no]
           ,[bkr_setup_dt]
           ,[bkr_asset_cd]
           ,[bkr_case_no]
           ,[bkr_chapter_ty]
           ,[bkr_coborr_mtgr_cd]
           ,[bkr_conf_hear_dt]
           ,[bkr_conf_hear_null]
           ,[bkr_court_id]
           ,[bkr_cred_meet_dt]
           ,[bkr_cred_meet_null]
           ,[bkr_dbtr_atty_id]
           ,[bkr_debtor_ba]
           ,[bkr_discharge_dt]
           ,[bkr_discharge_null]
           ,[bkr_dismissal_dt]
           ,[bkr_dismissal_null]
           ,[bkr_est_disch_dt]
           ,[bkr_est_disch_null]
           ,[bkr_filing_dt]
           ,[bkr_filing_null]
           ,[bkr_flwup_compl_dt]
           ,[bkr_flwup_compl_null]
           ,[bkr_flwup_dt]
           ,[bkr_flwup_null]
           ,[bkr_lst_note_dt]
           ,[bkr_lst_note_null]
           ,[bkr_mtgr_atty_id]
           ,[bkr_notice_rec_dt]
           ,[bkr_notice_rec_null]
           ,[bkr_pi_order_cd]
           ,[bkr_post1_ba]
           ,[bkr_post2_ba]
           ,[bkr_pstpet1_clm_dt]
           ,[bkr_pstpet1_clm_null]
           ,[bkr_pstpet1_cnf_am]
           ,[bkr_pstpet1_due_dt]
           ,[bkr_pstpet1_due_null]
           ,[bkr_pstpet1_rem_ba]
           ,[bkr_pstpet2_clm_dt]
           ,[bkr_pstpet2_clm_null]
           ,[bkr_pstpet2_cnf_am]
           ,[bkr_pstpet2_due_dt]
           ,[bkr_pstpet2_due_null]
           ,[bkr_pstpet2_rem_ba]
           ,[bkr_pst_pet_due_dt]
           ,[bkr_pst_pet_due_null]
           ,[bkr_post_pet_cd]
           ,[bkr_prepet_clm_dt]
           ,[bkr_prepet_clm_null]
           ,[bkr_prepet_cnf_am]
           ,[bkr_prepet_due_dt]
           ,[bkr_prepet_due_null]
           ,[bkr_pre_pet_ba]
           ,[bkr_processor_id]
           ,[bkr_poc_file_dt]
           ,[bkr_poc_file_null]
           ,[bkr_relf_denied_dt]
           ,[bkr_relf_denied_null]
           ,[bkr_relf_fle_co_dt]
           ,[bkr_relf_fle_co_null]
           ,[bkr_relf_file_dt]
           ,[bkr_relf_file_null]
           ,[bkr_relf_fle_fu_dt]
           ,[bkr_relf_fle_fu_null]
           ,[bkr_relf_grant_dt]
           ,[bkr_relf_grant_null]
           ,[bkr_relf_her_co_dt]
           ,[bkr_relf_her_co_null]
           ,[bkr_relf_hear_dt]
           ,[bkr_relf_hear_null]
           ,[bkr_relf_her_fu_dt]
           ,[bkr_relf_her_fu_null]
           ,[bkr_relf_other_dt]
           ,[bkr_relf_other_null]
           ,[bkr_relf_req_co_dt]
           ,[bkr_relf_req_co_null]
           ,[bkr_relf_req_dt]
           ,[bkr_relf_req_null]
           ,[bkr_relf_req_fu_dt]
           ,[bkr_relf_req_fu_null]
           ,[bkr_removal_cd]
           ,[bkr_removal_dt]
           ,[bkr_removal_null]
           ,[bkr_repay_tr]
           ,[bkr_status_cd]
           ,[bkr_stay_lift_cd]
           ,[bkr_trust_aband_dt]
           ,[bkr_trust_aband_null]
           ,[bkr_trustee_id]
           ,[bkr_trustee_ba]
           ,[bkr_truste_tele_no]
           ,[bkr_trustee_nm]
           ,[bkr_prepet_ack_dt]
           ,[bkr_prepet_ack_null]
           ,[bkr_prepet_cnf_dt]
           ,[bkr_prepet_cnf_null]
           ,[bkr_pstpet1_cnf_dt]
           ,[bkr_pstpet1_cnf_null]
           ,[bkr_pstpet2_cnf_dt]
           ,[bkr_pstpet2_cnf_null]
           ,[bkr_prepet_efee_am]
           ,[re_loan_ind]
           ,[client_no]
           ,[bkr_prep_efeepd_am]
           ,[bkr_template_id]
           ,[bkr_altdebt1_ss_no]
           ,[bkr_altdebt2_ss_no]
           ,[bkr_altdebt1_nm]
           ,[bkr_altdebt2_nm]
           ,[bkr_completion_dt]
           ,[bkr_compltion_null]
           ,[bkr_debtor_fee_cd]
           ,[bkr_debtor_pmt_cd]
           ,[bkr_disposition_de]
           ,[bkr_fnma_laser_cd]
           ,[bkr_flwup_note1_xx]
           ,[bkr_flwup_note2_xx]
           ,[bkr_flwup_note3_xx]
           ,[bkr_flwup_proc_nm]
           ,[bkr_item1_de]
           ,[bkr_item1_flwup_dt]
           ,[bkr_item1_flw_null]
           ,[bkr_item1_recpt_dt]
           ,[bkr_item1_rec_null]
           ,[bkr_item1_req_dt]
           ,[bkr_item1_req_null]
           ,[bkr_item2_de]
           ,[bkr_item2_flwup_dt]
           ,[bkr_item2_flw_null]
           ,[bkr_item2_recpt_dt]
           ,[bkr_item2_rec_null]
           ,[bkr_item2_req_dt]
           ,[bkr_item2_req_null]
           ,[bkr_item3_de]
           ,[bkr_item3_flwup_dt]
           ,[bkr_item3_flw_null]
           ,[bkr_item3_recpt_dt]
           ,[bkr_item3_rec_null]
           ,[bkr_item3_req_dt]
           ,[bkr_item3_req_null]
           ,[bkr_item4_de]
           ,[bkr_item4_flwup_dt]
           ,[bkr_item4_flw_null]
           ,[bkr_item4_recpt_dt]
           ,[bkr_item4_rec_null]
           ,[bkr_item4_req_dt]
           ,[bkr_item4_req_null]
           ,[bkr_other_dt]
           ,[bkr_other_null]
           ,[bkr_pmt_stp_odr_de]
           ,[bkr_region_cd]
           ,[bkr_trustee_fee_cd]
           ,[bkr_trustee_pmt_cd]
           ,[bkr_update_user_id]
           ,[bkr_altdbt1_ss_no]
           ,[bkr_altdbt2_ss_no]
           ,[bkr_ch7_dischrg_cd]
           ,[bkr_ch7_dischrg_dt]
           ,[bkr_ch7_dchrg_null]
           ,[bkr_removal_de]
           ,[bkr_revised_clm_dt]
           ,[bkr_revised_clm_null]
           ,[bkr_pst_pet_pmt_ct]
           ,[bkr_uniform_clm_id]
           ,[bkr_pppmt_susp_ba]
           ,[bkr_conv_dt]
           ,[bkr_conv_null]
           ,[load_date]
           ,[BKR_PST_PET_PMT_AM]
           ,[BKR_PPET_PMT_AM_FG]
           ,[BKR_LEDGER_UPD_CD]
		   from [10.0.15.10].bde_data.dbo.bankruptcy
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 

USE [BDE_Data]
GO

INSERT INTO [dbo].[bankruptcy_step]
           ([delta_file_byte]
           ,[ln_no]
           ,[bks_setup_dt]
           ,[bks_no]
           ,[bks_actual_cmpl_dt]
           ,[bks_actual_cmpl_null]
           ,[bks_criticl_stp_cd]
           ,[bks_float_days_qt]
           ,[bks_pred_step_cd]
           ,[bks_sched_compl_dt]
           ,[bks_sched_compl_null]
           ,[bks_step_cd]
           ,[bks_comment_cd]
           ,[bks_cost_am]
           ,[client_no]
           ,[load_date]
     )
     select [delta_file_byte]
           ,[ln_no]
           ,[bks_setup_dt]
           ,[bks_no]
           ,[bks_actual_cmpl_dt]
           ,[bks_actual_cmpl_null]
           ,[bks_criticl_stp_cd]
           ,[bks_float_days_qt]
           ,[bks_pred_step_cd]
           ,[bks_sched_compl_dt]
           ,[bks_sched_compl_null]
           ,[bks_step_cd]
           ,[bks_comment_cd]
           ,[bks_cost_am]
           ,[client_no]
           ,[load_date]
		   from [10.0.15.10].bde_data.dbo.bankruptcy_step
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO

INSERT INTO [dbo].[five9_activity]
           ([Loan Number]
           ,[CALL ID]
           ,[CAMPAIGN]
           ,[CALL TYPE]
           ,[AGENT]
           ,[AGENT NAME]
           ,[DISPOSITION]
           ,[ANI]
           ,[CUSTOMER NAME]
           ,[DNIS]
           ,[CALL TIME]
           ,[BILL TIME (ROUNDED)]
           ,[COST]
           ,[IVR TIME]
           ,[QUEUE WAIT TIME]
           ,[RING TIME]
           ,[TALK TIME]
           ,[HOLD TIME]
           ,[PARK TIME]
           ,[AFTER CALL WORK TIME]
           ,[TRANSFERS]
           ,[CONFERENCES]
           ,[HOLDS]
           ,[ABANDONED]
           ,[RECORDINGS]
           ,[NOTES]
           ,[CALLS TIMED OUT IN IVR]
           ,[ABANDON RATE]
           ,[DNIS AREA CODE]
           ,[IVR PATH]
           ,[CALLS]
           ,[CAMPAIGN TYPE]
           ,[ANI STATE]
           ,[SERVICE LEVEL]
           ,[NO PARTY CONTACT]
           ,[DNIS STATE]
           ,[CONTACTED]
           ,[CALLS COMPLETED IN IVR]
           ,[ANI AREA CODE]
           ,[LIVE CONNECT]
           ,[SPEED OF ANSWER]
           ,[DNIS COUNTRY CODE]
           ,[DISCONNECTED FROM HOLD]
           ,[DNIS COUNTRY]
           ,[PARENT SESSION ID]
           ,[SKILL]
           ,[LIST NAME]
           ,[SESSION ID]
           ,[CALL SURVEY RESULT]
           ,[ANI COUNTRY]
           ,[ANI COUNTRY CODE]
           ,[3RD PARTY TALK TIME]
           ,[CONFERENCE TIME]
           ,[CONSULT TIME]
           ,[DIAL TIME]
           ,[HANDLE TIME]
           ,[MANUAL TIME]
           ,[PARKS]
           ,[PREVIEW INTERRUPTED]
           ,[PREVIEW INTERRUPTED BY CALL]
           ,[PREVIEW INTERRUPTED BY SKILL VM]
           ,[PREVIEW TIME]
           ,[RATE]
           ,[TALK TIME LESS HOLD AND PARK]
           ,[VOICEMAILS]
           ,[VOICEMAILS DECLINED]
           ,[VOICEMAILS DELETED]
           ,[VOICEMAILS HANDLE TIME]
           ,[VOICEMAILS HANDLED]
           ,[VOICEMAILS RETURNED CALL]
           ,[VOICEMAILS TRANSFERRED]
           ,[AGENT EMAIL]
           ,[AGENT FIRST NAME]
           ,[AGENT GROUP]
           ,[AGENT LAST NAME]
           ,[DEST AGENT]
           ,[DEST AGENT EMAIL]
           ,[DEST AGENT EXTENSION]
           ,[DEST AGENT FIRST NAME]
           ,[DEST AGENT GROUP]
           ,[DEST AGENT LAST NAME]
           ,[DEST AGENT NAME]
           ,[EXTENSION]
           ,[number1]
           ,[Phone 4]
           ,[Phone 8]
           ,[Phone 5]
           ,[number2]
           ,[Phone 9]
           ,[Campaign ID]
           ,[number3]
           ,[Phone 6]
           ,[Phone 7]
           ,[Phone 10]
           ,[Tape-Option]
           ,[Tape-Number]
           ,[Welcome Call]
           ,[DATE]
           ,[DAY OF MONTH]
           ,[DAY OF WEEK]
           ,[HALF HOUR]
           ,[HOUR]
           ,[HOUR OF DAY]
           ,[MONTH]
           ,[QUARTER HOUR]
           ,[TIME]
           ,[3RD PARTY TALK TIME (Interval)]
           ,[YEAR]
           ,[LoadDate]
           ,[BORROWER_FIRST_NAME]
           ,[BORROWER_LAST_NAME]
           ,[STATE]
           ,[MTGR_PHONE_NUMBER]
           ,[OTHER_PHONE_NUMBER_1]
           ,[OTHER_PHONE_NUMBER_2]
           ,[OTHER_PHONE_NUMBER_3]
           ,[THIRD_PARTY_PHONE_NUMBER]
           ,[TIMESTAMP]
           ,[DATE AND HOUR]
           ,[TIME TO ABANDON]
           ,[AUDIT_FLAG]
           ,[CALL RECORDING STATUS]
           ,[CALL RECORDING PATH]
           ,[CALL RECORDING ADD DATE]
           ,[CALL RECORDING REMOVE DATE]
           ,[CALL RECORDING PHONE NUMBER]
           ,[AGENT_AUDIT_FLAG]
           ,[STORAGE]
           ,[LeadCreateDate]
           ,[LeadId])
SELECT [Loan Number]
           ,[CALL ID]
           ,[CAMPAIGN]
           ,[CALL TYPE]
           ,[AGENT]
           ,[AGENT NAME]
           ,[DISPOSITION]
           ,[ANI]
           ,[CUSTOMER NAME]
           ,[DNIS]
           ,[CALL TIME]
           ,[BILL TIME (ROUNDED)]
           ,[COST]
           ,[IVR TIME]
           ,[QUEUE WAIT TIME]
           ,[RING TIME]
           ,[TALK TIME]
           ,[HOLD TIME]
           ,[PARK TIME]
           ,[AFTER CALL WORK TIME]
           ,[TRANSFERS]
           ,[CONFERENCES]
           ,[HOLDS]
           ,[ABANDONED]
           ,[RECORDINGS]
           ,[NOTES]
           ,[CALLS TIMED OUT IN IVR]
           ,[ABANDON RATE]
           ,[DNIS AREA CODE]
           ,[IVR PATH]
           ,[CALLS]
           ,[CAMPAIGN TYPE]
           ,[ANI STATE]
           ,[SERVICE LEVEL]
           ,[NO PARTY CONTACT]
           ,[DNIS STATE]
           ,[CONTACTED]
           ,[CALLS COMPLETED IN IVR]
           ,[ANI AREA CODE]
           ,[LIVE CONNECT]
           ,[SPEED OF ANSWER]
           ,[DNIS COUNTRY CODE]
           ,[DISCONNECTED FROM HOLD]
           ,[DNIS COUNTRY]
           ,[PARENT SESSION ID]
           ,[SKILL]
           ,[LIST NAME]
           ,[SESSION ID]
           ,[CALL SURVEY RESULT]
           ,[ANI COUNTRY]
           ,[ANI COUNTRY CODE]
           ,[3RD PARTY TALK TIME]
           ,[CONFERENCE TIME]
           ,[CONSULT TIME]
           ,[DIAL TIME]
           ,[HANDLE TIME]
           ,[MANUAL TIME]
           ,[PARKS]
           ,[PREVIEW INTERRUPTED]
           ,[PREVIEW INTERRUPTED BY CALL]
           ,[PREVIEW INTERRUPTED BY SKILL VM]
           ,[PREVIEW TIME]
           ,[RATE]
           ,[TALK TIME LESS HOLD AND PARK]
           ,[VOICEMAILS]
           ,[VOICEMAILS DECLINED]
           ,[VOICEMAILS DELETED]
           ,[VOICEMAILS HANDLE TIME]
           ,[VOICEMAILS HANDLED]
           ,[VOICEMAILS RETURNED CALL]
           ,[VOICEMAILS TRANSFERRED]
           ,[AGENT EMAIL]
           ,[AGENT FIRST NAME]
           ,[AGENT GROUP]
           ,[AGENT LAST NAME]
           ,[DEST AGENT]
           ,[DEST AGENT EMAIL]
           ,[DEST AGENT EXTENSION]
           ,[DEST AGENT FIRST NAME]
           ,[DEST AGENT GROUP]
           ,[DEST AGENT LAST NAME]
           ,[DEST AGENT NAME]
           ,[EXTENSION]
           ,[number1]
           ,[Phone 4]
           ,[Phone 8]
           ,[Phone 5]
           ,[number2]
           ,[Phone 9]
           ,[Campaign ID]
           ,[number3]
           ,[Phone 6]
           ,[Phone 7]
           ,[Phone 10]
           ,[Tape-Option]
           ,[Tape-Number]
           ,[Welcome Call]
           ,[DATE]
           ,[DAY OF MONTH]
           ,[DAY OF WEEK]
           ,[HALF HOUR]
           ,[HOUR]
           ,[HOUR OF DAY]
           ,[MONTH]
           ,[QUARTER HOUR]
           ,[TIME]
           ,[3RD PARTY TALK TIME (Interval)]
           ,[YEAR]
           ,[LoadDate]
           ,[BORROWER_FIRST_NAME]
           ,[BORROWER_LAST_NAME]
           ,[STATE]
           ,[MTGR_PHONE_NUMBER]
           ,[OTHER_PHONE_NUMBER_1]
           ,[OTHER_PHONE_NUMBER_2]
           ,[OTHER_PHONE_NUMBER_3]
           ,[THIRD_PARTY_PHONE_NUMBER]
           ,[TIMESTAMP]
           ,[DATE AND HOUR]
           ,[TIME TO ABANDON]
           ,[AUDIT_FLAG]
           ,[CALL RECORDING STATUS]
           ,[CALL RECORDING PATH]
           ,[CALL RECORDING ADD DATE]
           ,[CALL RECORDING REMOVE DATE]
           ,[CALL RECORDING PHONE NUMBER]
           ,[AGENT_AUDIT_FLAG]
           ,[STORAGE]
           ,[LeadCreateDate]
           ,[LeadId]

		   from [10.0.15.10].bde_data.dbo.five9_activity
where [Loan Number] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 



USE [BDE_Data]
GO

INSERT INTO [dbo].[letter_writer]
           ([delta_file_byte]
           ,[ln_no]
           ,[ltr_id]
           ,[ltr_sender_id]
           ,[ltr_version_no]
           ,[client_no]
           ,[ltr_de]
           ,[ltr_processing_dt]
           ,[ltr_processing_dt_null]
           ,[ltr_record_no]
           ,[ltr_source_cd]
           ,[load_date]
           ,[ltr_dt])
		   SELECT [delta_file_byte]
           ,[ln_no]
           ,[ltr_id]
           ,[ltr_sender_id]
           ,[ltr_version_no]
           ,[client_no]
           ,[ltr_de]
           ,[ltr_processing_dt]
           ,[ltr_processing_dt_null]
           ,[ltr_record_no]
           ,[ltr_source_cd]
           ,[load_date]
           ,[ltr_dt]
		   from [10.0.15.10].bde_data.dbo.[letter_writer]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 

INSERT INTO [dbo].[reo]
           ([delta_file_byte]
           ,[ln_no]
           ,[reo_setup_dt]
           ,[reo_acquisition_cd]
           ,[reo_actl_close_dt]
           ,[reo_actl_close_null]
           ,[reo_appr_cmplt_dt]
           ,[reo_appr_cmplt_null]
           ,[reo_appr_order_dt]
           ,[reo_appr_order_null]
           ,[reo_appr_asis_am]
           ,[reo_appr_repard_am]
           ,[reo_appraiser_id]
           ,[reo_asset_cd]
           ,[reo_assoc_dues_am]
           ,[reo_assoc_due_dt]
           ,[reo_assoc_due_null]
           ,[reo_association_id]
           ,[reo_available_dt]
           ,[reo_available_null]
           ,[reo_buyer_id]
           ,[reo_actl_sum_am]
           ,[reo_estm_sum_am]
           ,[reo_cls_agent_id]
           ,[reo_cls_costs_am]
           ,[reo_cma_asis_am]
           ,[reo_cma_cmplt_dt]
           ,[reo_cma_cmplt_null]
           ,[reo_cma_order_dt]
           ,[reo_cma_order_null]
           ,[reo_cma_repard_am]
           ,[reo_completed_dt]
           ,[reo_completed_null]
           ,[reo_evic_cmplt_dt]
           ,[reo_evic_cmplt_null]
           ,[reo_evic_cont_id]
           ,[reo_evic_payee_id]
           ,[reo_evic_start_dt]
           ,[reo_evic_start_null]
           ,[reo_file_def_cd]
           ,[reo_fore_sale_dt]
           ,[reo_fore_sale_null]
           ,[reo_inv_disallw_am]
           ,[reo_inv_ioa_cd]
           ,[reo_inv_ioa_pay_am]
           ,[reo_inv_repaid_am]
           ,[reo_lst_agent_id]
           ,[reo_lst_comm_rt]
           ,[reo_lst_expir_dt]
           ,[reo_lst_expir_null]
           ,[reo_lst_payee_id]
           ,[reo_lst_price_am]
           ,[reo_lst_start_dt]
           ,[reo_lst_start_null]
           ,[reo_mgt_co_id]
           ,[reo_mi_cd]
           ,[reo_prin_ba]
           ,[reo_proceeds_am]
           ,[reo_processor_id]
           ,[reo_secured_cd]
           ,[reo_sale_price_am]
           ,[reo_sale_ty]
           ,[reo_sch_close_dt]
           ,[reo_sch_close_null]
           ,[reo_srv_owned_fc]
           ,[reo_square_ft_qt]
           ,[reo_stage_cd]
           ,[reo_status_cd]
           ,[reo_tenant_id]
           ,[reo_tena_end_dt]
           ,[reo_tena_end_null]
           ,[reo_tena_start_dt]
           ,[reo_tena_start_null]
           ,[reo_leasing_co_id]
           ,[reo_tena_rent_am]
           ,[reo_tena_due_dt]
           ,[reo_tena_due_null]
           ,[reo_acquisition_dt]
           ,[reo_acquisition_null]
           ,[reo_city_cita_dt]
           ,[reo_city_cita_null]
           ,[reo_env_hazard_xx]
           ,[reo_indem_am]
           ,[reo_indem_cd]
           ,[reo_orig_apprsl_dt]
           ,[reo_orig_apprsl_null]
           ,[reo_follow_up_dt]
           ,[reo_follow_up_null]
           ,[reo_esc_payee_id]
           ,[reo_writedown_am]
           ,[reo_bedrm_qt]
           ,[reo_bathrm_qt]
           ,[reo_reserve_ba]
           ,[client_no]
           ,[reo_acctng_updt_dt]
           ,[reo_acctng_up_null]
           ,[reo_appr_rec_ct]
           ,[reo_appr_payee_id]
           ,[reo_assoc_dues_tr]
           ,[reo_assoc_payee_id]
           ,[reo_cma_rec_ct]
           ,[reo_contrct_rec_ct]
           ,[reo_curr_step_cd]
           ,[reo_evic_flwup_dt]
           ,[reo_evic_flw_null]
           ,[reo_expct_sale_ty]
           ,[reo_file_loc_cd]
           ,[reo_fc_adv_am]
           ,[reo_hz_cancel_dt]
           ,[reo_hz_cancel_null]
           ,[reo_hz_adv_am]
           ,[reo_inv_aband_cd]
           ,[reo_inv_markets_cd]
           ,[reo_inv_pd_gros_cd]
           ,[reo_inv_pd_proc_am]
           ,[reo_inv_pd_proc_dt]
           ,[reo_inv_pd_pr_null]
           ,[reo_inv_pay_esc_cd]
           ,[reo_inv_billing_am]
           ,[reo_lst_inv_bl_am]
           ,[reo_lst_inv_bil_dt]
           ,[reo_lst_inv_b_null]
           ,[reo_list_flwup_dt]
           ,[reo_list_flw_null]
           ,[reo_mgt_payee_id]
           ,[reo_mi_adv_am]
           ,[reo_pr_hz_payee_id]
           ,[reo_project_nm]
           ,[reo_received_dt]
           ,[reo_received_null]
           ,[reo_repairs_rec_ct]
           ,[reo_sale_flwup_dt]
           ,[reo_sale_flw_null]
           ,[reo_start_dt]
           ,[reo_start_null]
           ,[reo_step_cd]
           ,[reo_step_ct]
           ,[reo_tax_adv_am]
           ,[reo_templat_cre_dt]
           ,[reo_templ_cre_null]
           ,[reo_template_id]
           ,[reo_templat_upd_dt]
           ,[reo_templ_upd_null]
           ,[reo_templat_upd_tm]
           ,[reo_templat_usr_id]
           ,[reo_templat_wks_cd]
           ,[reo_tenant_comp_dt]
           ,[reo_tenant_co_null]
           ,[reo_tenant_dep_am]
           ,[reo_ten_flwup_dt]
           ,[reo_ten_flwup_null]
           ,[reo_ten_leas_pd]
           ,[reo_stage_cd_xx]
           ,[reo_sal_concesn_cd]
           ,[reo_sq_ft_dec_qt]
           ,[load_date]
)

SELECT [delta_file_byte]
           ,[ln_no]
           ,[reo_setup_dt]
           ,[reo_acquisition_cd]
           ,[reo_actl_close_dt]
           ,[reo_actl_close_null]
           ,[reo_appr_cmplt_dt]
           ,[reo_appr_cmplt_null]
           ,[reo_appr_order_dt]
           ,[reo_appr_order_null]
           ,[reo_appr_asis_am]
           ,[reo_appr_repard_am]
           ,[reo_appraiser_id]
           ,[reo_asset_cd]
           ,[reo_assoc_dues_am]
           ,[reo_assoc_due_dt]
           ,[reo_assoc_due_null]
           ,[reo_association_id]
           ,[reo_available_dt]
           ,[reo_available_null]
           ,[reo_buyer_id]
           ,[reo_actl_sum_am]
           ,[reo_estm_sum_am]
           ,[reo_cls_agent_id]
           ,[reo_cls_costs_am]
           ,[reo_cma_asis_am]
           ,[reo_cma_cmplt_dt]
           ,[reo_cma_cmplt_null]
           ,[reo_cma_order_dt]
           ,[reo_cma_order_null]
           ,[reo_cma_repard_am]
           ,[reo_completed_dt]
           ,[reo_completed_null]
           ,[reo_evic_cmplt_dt]
           ,[reo_evic_cmplt_null]
           ,[reo_evic_cont_id]
           ,[reo_evic_payee_id]
           ,[reo_evic_start_dt]
           ,[reo_evic_start_null]
           ,[reo_file_def_cd]
           ,[reo_fore_sale_dt]
           ,[reo_fore_sale_null]
           ,[reo_inv_disallw_am]
           ,[reo_inv_ioa_cd]
           ,[reo_inv_ioa_pay_am]
           ,[reo_inv_repaid_am]
           ,[reo_lst_agent_id]
           ,[reo_lst_comm_rt]
           ,[reo_lst_expir_dt]
           ,[reo_lst_expir_null]
           ,[reo_lst_payee_id]
           ,[reo_lst_price_am]
           ,[reo_lst_start_dt]
           ,[reo_lst_start_null]
           ,[reo_mgt_co_id]
           ,[reo_mi_cd]
           ,[reo_prin_ba]
           ,[reo_proceeds_am]
           ,[reo_processor_id]
           ,[reo_secured_cd]
           ,[reo_sale_price_am]
           ,[reo_sale_ty]
           ,[reo_sch_close_dt]
           ,[reo_sch_close_null]
           ,[reo_srv_owned_fc]
           ,[reo_square_ft_qt]
           ,[reo_stage_cd]
           ,[reo_status_cd]
           ,[reo_tenant_id]
           ,[reo_tena_end_dt]
           ,[reo_tena_end_null]
           ,[reo_tena_start_dt]
           ,[reo_tena_start_null]
           ,[reo_leasing_co_id]
           ,[reo_tena_rent_am]
           ,[reo_tena_due_dt]
           ,[reo_tena_due_null]
           ,[reo_acquisition_dt]
           ,[reo_acquisition_null]
           ,[reo_city_cita_dt]
           ,[reo_city_cita_null]
           ,[reo_env_hazard_xx]
           ,[reo_indem_am]
           ,[reo_indem_cd]
           ,[reo_orig_apprsl_dt]
           ,[reo_orig_apprsl_null]
           ,[reo_follow_up_dt]
           ,[reo_follow_up_null]
           ,[reo_esc_payee_id]
           ,[reo_writedown_am]
           ,[reo_bedrm_qt]
           ,[reo_bathrm_qt]
           ,[reo_reserve_ba]
           ,[client_no]
           ,[reo_acctng_updt_dt]
           ,[reo_acctng_up_null]
           ,[reo_appr_rec_ct]
           ,[reo_appr_payee_id]
           ,[reo_assoc_dues_tr]
           ,[reo_assoc_payee_id]
           ,[reo_cma_rec_ct]
           ,[reo_contrct_rec_ct]
           ,[reo_curr_step_cd]
           ,[reo_evic_flwup_dt]
           ,[reo_evic_flw_null]
           ,[reo_expct_sale_ty]
           ,[reo_file_loc_cd]
           ,[reo_fc_adv_am]
           ,[reo_hz_cancel_dt]
           ,[reo_hz_cancel_null]
           ,[reo_hz_adv_am]
           ,[reo_inv_aband_cd]
           ,[reo_inv_markets_cd]
           ,[reo_inv_pd_gros_cd]
           ,[reo_inv_pd_proc_am]
           ,[reo_inv_pd_proc_dt]
           ,[reo_inv_pd_pr_null]
           ,[reo_inv_pay_esc_cd]
           ,[reo_inv_billing_am]
           ,[reo_lst_inv_bl_am]
           ,[reo_lst_inv_bil_dt]
           ,[reo_lst_inv_b_null]
           ,[reo_list_flwup_dt]
           ,[reo_list_flw_null]
           ,[reo_mgt_payee_id]
           ,[reo_mi_adv_am]
           ,[reo_pr_hz_payee_id]
           ,[reo_project_nm]
           ,[reo_received_dt]
           ,[reo_received_null]
           ,[reo_repairs_rec_ct]
           ,[reo_sale_flwup_dt]
           ,[reo_sale_flw_null]
           ,[reo_start_dt]
           ,[reo_start_null]
           ,[reo_step_cd]
           ,[reo_step_ct]
           ,[reo_tax_adv_am]
           ,[reo_templat_cre_dt]
           ,[reo_templ_cre_null]
           ,[reo_template_id]
           ,[reo_templat_upd_dt]
           ,[reo_templ_upd_null]
           ,[reo_templat_upd_tm]
           ,[reo_templat_usr_id]
           ,[reo_templat_wks_cd]
           ,[reo_tenant_comp_dt]
           ,[reo_tenant_co_null]
           ,[reo_tenant_dep_am]
           ,[reo_ten_flwup_dt]
           ,[reo_ten_flwup_null]
           ,[reo_ten_leas_pd]
           ,[reo_stage_cd_xx]
           ,[reo_sal_concesn_cd]
           ,[reo_sq_ft_dec_qt]
           ,[load_date]
		   from [10.0.15.10].bde_data.dbo.[reo]

USE [BDE_Data]
go

INSERT INTO [dbo].[reo_steps]
           ([delta_file_byte]
           ,[ln_no]
           ,[rs_setup_dt]
           ,[rs_no]
           ,[rs_actual_compl_dt]
           ,[rs_actual_compl_null]
           ,[rs_critical_stp_cd]
           ,[rs_float_days_qt]
           ,[rs_pred_step_cd]
           ,[rs_sched_compl_dt]
           ,[rs_sched_compl_null]
           ,[rs_step_cd]
           ,[rs_comment_cd]
           ,[rs_cost_am]
           ,[client_no]
           ,[load_date]
           )
     SELECT [delta_file_byte]
           ,[ln_no]
           ,[rs_setup_dt]
           ,[rs_no]
           ,[rs_actual_compl_dt]
           ,[rs_actual_compl_null]
           ,[rs_critical_stp_cd]
           ,[rs_float_days_qt]
           ,[rs_pred_step_cd]
           ,[rs_sched_compl_dt]
           ,[rs_sched_compl_null]
           ,[rs_step_cd]
           ,[rs_comment_cd]
           ,[rs_cost_am]
           ,[client_no]
           ,[load_date]
          from [10.0.15.10].bde_data.dbo.[reo_steps]
--where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 



INSERT INTO [dbo].[tbl_investor_lookup]
           ([adddate]
           ,[iv_id]
           ,[iv_cat_cd]
           ,[investor])
SELECT [adddate]
           ,[iv_id]
           ,[iv_cat_cd]
           ,[investor]  from [10.0.15.10].bde_data.dbo.[tbl_investor_lookup]


		   USE [BDE_Data]
GO

INSERT INTO [dbo].[escrow]
           ([delta_file_byte]
           ,[ln_no]
           ,[es_adv_ba]
           ,[es_ba]
           ,[es_bsc_svc_chg_am]
           ,[es_disb_stop_cd]
           ,[es_dly_avr_ti_ba]
           ,[es_repl_reserve_ba]
           ,[es_disb_st_chg_dt]
           ,[es_disb_st_chg_null]
           ,[es_e_pst_due_30_ba]
           ,[es_e_pst_due_60_ba]
           ,[es_e_pst_due_90_ba]
           ,[es_e_due_30_ba]
           ,[es_e_due_60_ba]
           ,[es_e_due_90_ba]
           ,[es_int_on_es_cd]
           ,[es_lst_anal_dt]
           ,[es_lst_anal_null]
           ,[es_misc_am]
           ,[es_misc_cd]
           ,[es_over_short_am]
           ,[es_os_st_chg_dt]
           ,[es_os_st_chg_null]
           ,[es_pend_misc_am]
           ,[es_pend_misc_cd]
           ,[es_pend_ti_mon_am]
           ,[es_repl_reserve_am]
           ,[es_repl_reserve_cd]
           ,[es_restrict_es_ba]
           ,[es_ti_mnthly_am]
           ,[es_hud_part_ba]
           ,[es_atty_adv_am]
           ,[es_haz_adv_am]
           ,[es_pmi_adv_am]
           ,[es_tax_adv_am]
           ,[es_doc_ty]
           ,[es_init_stmt_cd]
           ,[es_init_stmt_dt]
           ,[es_init_stmt_null]
           ,[es_min_bal_qt]
           ,[es_compute_dt]
           ,[es_compute_null]
           ,[es_lien_am]
           ,[es_city_tax_am]
           ,[es_county_tax_am]
           ,[es_coupon_mth_no]
           ,[es_ctl_hdr_nm]
           ,[hz_flood_del_dt]
           ,[hz_flood_del_null]
           ,[hz_flood_ins_cd]
           ,[hz_endorsement_dt]
           ,[hz_endorsement_null]
           ,[hz_mnthly_am]
           ,[tx_serv_contr_dt]
           ,[tx_serv_contr_null]
           ,[tx_serv_contr_no]
           ,[tx_serv_fee_am]
           ,[tx_service_id]
           ,[es_a_h_prem_am]
           ,[es_life_prem_am]
           ,[es_tax_ser_cd]
           ,[es_min_bal_qx]
           ,[re_loan_ind]
           ,[es_lst_anal_os_am]
           ,[es_lst_anal_spd_qt]
           ,[es_lst_anal_eff_dt]
           ,[es_lst_anal_eff_null]
           ,[es_ioe_curr_acc_am]
           ,[es_ioe_lst_cred_dt]
           ,[es_ioe_lst_cred_null]
           ,[es_ioe_snce_lst_am]
           ,[es_pend_os_am]
           ,[es_ctl_hdr_exp_dt]
           ,[es_ctl_hdr_exp_null]
           ,[tx_serv_norm_cd]
           ,[tx_serv_branch_cd]
           ,[tx_serv_dlq_ltr_cd]
           ,[es_disbstop_exp_dt]
           ,[es_disbstop_exp_null]
           ,[client_no]
           ,[es_a_h_cd]
           ,[es_adv_bill_dt]
           ,[es_adv_bill_null]
           ,[es_forc_adv_am]
           ,[es_inv_adv_am]
           ,[es_pend_depo_am]
           ,[es_tax_tran_am]
           ,[es_tax_tran_dt]
           ,[es_tax_tran_null]
           ,[es_ioe_wh_fg]
           ,[es_iore_snc_lst_am]
           ,[es_iore_cur_acc_am]
           ,[es_iore_lst_acr_dt]
           ,[es_iorelstacr_null]
           ,[es_iore_lst_crd_dt]
           ,[es_iorelstcrd_null]
           ,[es_iore_witheld_am]
           ,[es_iore_wh_fg]
           ,[es_p_a_h_prem_am]
           ,[es_p_hz_monthly_am]
           ,[es_p_lien_am]
           ,[es_p_life_prem_am]
           ,[es_p_rep_res_am]
           ,[es_p_rep_res_dt]
           ,[es_p_rep_res_null]
           ,[es_outsrcr_pa_id]
           ,[es_ffp_ins_cov1_ty]
           ,[es_ffp_vendor1_cd]
           ,[es_ffp_ins_cov2_ty]
           ,[es_ffp_vendor2_cd]
           ,[es_ffp_ins_cov3_ty]
           ,[es_ffp_vendor3_cd]
           ,[es_ffp_ins_cov4_ty]
           ,[es_ffp_vendor4_cd]
           ,[es_ffp_ins_cov5_ty]
           ,[es_ffp_vendor5_cd]
           ,[es_adv_pr_y_e_ba]
           ,[es_exp_adv_ba]
           ,[es_disb_st_chg_id]
           ,[es_fld_sp_hand_cd]
           ,[es_cnty_tax_tot_am]
           ,[es_cnty_tax_mth_am]
           ,[es_city_tax_tot_am]
           ,[es_city_tax_mth_am]
           ,[es_schl_tax_tot_am]
           ,[es_schl_tax_mth_am]
           ,[es_utility_tot_am]
           ,[es_utility_mth_am]
           ,[es_assmnt_tot_am]
           ,[es_assmnt_mth_am]
           ,[es_fire_tot_am]
           ,[es_fire_mth_am]
           ,[es_flood_tot_am]
           ,[es_flood_mth_am]
           ,[es_equake_tot_am]
           ,[es_equake_mth_am]
           ,[es_wind_tot_am]
           ,[es_wind_mth_am]
           ,[es_tax_serv_div_cd]
           ,[es_tax_bus_cd]
           ,[es_wind_ins_fg]
           ,[es_p_cnty_tax_am]
           ,[es_p_city_tax_am]
           ,[es_haz_prop_dmg_dt]
           ,[es_haz_prop_dmg_null]
           ,[es_dmg_clm_sbm_fg]
           ,[es_prp_dmg_repr_fg]
           ,[load_date]
)
SELECT [delta_file_byte]
           ,[ln_no]
           ,[es_adv_ba]
           ,[es_ba]
           ,[es_bsc_svc_chg_am]
           ,[es_disb_stop_cd]
           ,[es_dly_avr_ti_ba]
           ,[es_repl_reserve_ba]
           ,[es_disb_st_chg_dt]
           ,[es_disb_st_chg_null]
           ,[es_e_pst_due_30_ba]
           ,[es_e_pst_due_60_ba]
           ,[es_e_pst_due_90_ba]
           ,[es_e_due_30_ba]
           ,[es_e_due_60_ba]
           ,[es_e_due_90_ba]
           ,[es_int_on_es_cd]
           ,[es_lst_anal_dt]
           ,[es_lst_anal_null]
           ,[es_misc_am]
           ,[es_misc_cd]
           ,[es_over_short_am]
           ,[es_os_st_chg_dt]
           ,[es_os_st_chg_null]
           ,[es_pend_misc_am]
           ,[es_pend_misc_cd]
           ,[es_pend_ti_mon_am]
           ,[es_repl_reserve_am]
           ,[es_repl_reserve_cd]
           ,[es_restrict_es_ba]
           ,[es_ti_mnthly_am]
           ,[es_hud_part_ba]
           ,[es_atty_adv_am]
           ,[es_haz_adv_am]
           ,[es_pmi_adv_am]
           ,[es_tax_adv_am]
           ,[es_doc_ty]
           ,[es_init_stmt_cd]
           ,[es_init_stmt_dt]
           ,[es_init_stmt_null]
           ,[es_min_bal_qt]
           ,[es_compute_dt]
           ,[es_compute_null]
           ,[es_lien_am]
           ,[es_city_tax_am]
           ,[es_county_tax_am]
           ,[es_coupon_mth_no]
           ,[es_ctl_hdr_nm]
           ,[hz_flood_del_dt]
           ,[hz_flood_del_null]
           ,[hz_flood_ins_cd]
           ,[hz_endorsement_dt]
           ,[hz_endorsement_null]
           ,[hz_mnthly_am]
           ,[tx_serv_contr_dt]
           ,[tx_serv_contr_null]
           ,[tx_serv_contr_no]
           ,[tx_serv_fee_am]
           ,[tx_service_id]
           ,[es_a_h_prem_am]
           ,[es_life_prem_am]
           ,[es_tax_ser_cd]
           ,[es_min_bal_qx]
           ,[re_loan_ind]
           ,[es_lst_anal_os_am]
           ,[es_lst_anal_spd_qt]
           ,[es_lst_anal_eff_dt]
           ,[es_lst_anal_eff_null]
           ,[es_ioe_curr_acc_am]
           ,[es_ioe_lst_cred_dt]
           ,[es_ioe_lst_cred_null]
           ,[es_ioe_snce_lst_am]
           ,[es_pend_os_am]
           ,[es_ctl_hdr_exp_dt]
           ,[es_ctl_hdr_exp_null]
           ,[tx_serv_norm_cd]
           ,[tx_serv_branch_cd]
           ,[tx_serv_dlq_ltr_cd]
           ,[es_disbstop_exp_dt]
           ,[es_disbstop_exp_null]
           ,[client_no]
           ,[es_a_h_cd]
           ,[es_adv_bill_dt]
           ,[es_adv_bill_null]
           ,[es_forc_adv_am]
           ,[es_inv_adv_am]
           ,[es_pend_depo_am]
           ,[es_tax_tran_am]
           ,[es_tax_tran_dt]
           ,[es_tax_tran_null]
           ,[es_ioe_wh_fg]
           ,[es_iore_snc_lst_am]
           ,[es_iore_cur_acc_am]
           ,[es_iore_lst_acr_dt]
           ,[es_iorelstacr_null]
           ,[es_iore_lst_crd_dt]
           ,[es_iorelstcrd_null]
           ,[es_iore_witheld_am]
           ,[es_iore_wh_fg]
           ,[es_p_a_h_prem_am]
           ,[es_p_hz_monthly_am]
           ,[es_p_lien_am]
           ,[es_p_life_prem_am]
           ,[es_p_rep_res_am]
           ,[es_p_rep_res_dt]
           ,[es_p_rep_res_null]
           ,[es_outsrcr_pa_id]
           ,[es_ffp_ins_cov1_ty]
           ,[es_ffp_vendor1_cd]
           ,[es_ffp_ins_cov2_ty]
           ,[es_ffp_vendor2_cd]
           ,[es_ffp_ins_cov3_ty]
           ,[es_ffp_vendor3_cd]
           ,[es_ffp_ins_cov4_ty]
           ,[es_ffp_vendor4_cd]
           ,[es_ffp_ins_cov5_ty]
           ,[es_ffp_vendor5_cd]
           ,[es_adv_pr_y_e_ba]
           ,[es_exp_adv_ba]
           ,[es_disb_st_chg_id]
           ,[es_fld_sp_hand_cd]
           ,[es_cnty_tax_tot_am]
           ,[es_cnty_tax_mth_am]
           ,[es_city_tax_tot_am]
           ,[es_city_tax_mth_am]
           ,[es_schl_tax_tot_am]
           ,[es_schl_tax_mth_am]
           ,[es_utility_tot_am]
           ,[es_utility_mth_am]
           ,[es_assmnt_tot_am]
           ,[es_assmnt_mth_am]
           ,[es_fire_tot_am]
           ,[es_fire_mth_am]
           ,[es_flood_tot_am]
           ,[es_flood_mth_am]
           ,[es_equake_tot_am]
           ,[es_equake_mth_am]
           ,[es_wind_tot_am]
           ,[es_wind_mth_am]
           ,[es_tax_serv_div_cd]
           ,[es_tax_bus_cd]
           ,[es_wind_ins_fg]
           ,[es_p_cnty_tax_am]
           ,[es_p_city_tax_am]
           ,[es_haz_prop_dmg_dt]
           ,[es_haz_prop_dmg_null]
           ,[es_dmg_clm_sbm_fg]
           ,[es_prp_dmg_repr_fg]
           ,[load_date]
		   FROM [10.0.15.10].bde_data.dbo.[escrow]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO

INSERT INTO [dbo].[mortgage_insurance]
           ([delta_file_byte]
           ,[ln_no]
           ,[mi_bill_cd]
           ,[mi_va_no]
           ,[mi_fha_case_no]
           ,[mi_fha_chk_dig_xx]
           ,[mi_fha_office_cd]
           ,[mi_fha_adp_cd]
           ,[mi_fha_section_cd]
           ,[mi_adjuster_cd]
           ,[mi_anniv_ytd_am]
           ,[mi_cert_no]
           ,[mi_disb_am]
           ,[mi_disb_due_dt]
           ,[mi_disb_due_null]
           ,[mi_mnthly_am]
           ,[mi_payee_id]
           ,[mi_pmi_rt]
           ,[mi_pool_payee_id]
           ,[mi_pool_ins_pol_nm]
           ,[mi_pri_coverage_fc]
           ,[mi_tr]
           ,[mi_seq_no_cd]
           ,[mi_va_loan_no]
           ,[mi_va_loan_ty]
           ,[mi_va_orig_of_no]
           ,[mi_va_jur_of_no]
           ,[mi_certif_dt]
           ,[mi_certif_null]
           ,[mi_expire_dt]
           ,[mi_expire_null]
           ,[mi_fha_fin_am]
           ,[mi_rpt_status_cd]
           ,[re_loan_ind]
           ,[mi_service_dt]
           ,[mi_service_null]
           ,[mi_service_cd]
           ,[mi_upfront_am]
           ,[mi_cancel_dt]
           ,[mi_cancel_null]
           ,[mi_term_dt]
           ,[mi_term_null]
           ,[mi_midpoint_dt]
           ,[mi_midpoint_null]
           ,[mi_req_cancel_dt]
           ,[mi_req_cancel_null]
           ,[mi_ty]
           ,[mi_hi_risk_cd]
           ,[mi_pd_by_lender_cd]
           ,[client_no]
           ,[mi_va_lin_ckdig_xx]
           ,[mi_va_lin_conv_cd]
           ,[mi_va_guar_pc]
           ,[mi_p_monthly_am]
           ,[mi_78_pct_ltv_am]
           ,[mi_premium_end_dt]
           ,[mi_premium_end_null]
           ,[mi_pmi_cncl_rsn_cd]
           ,[mi_co_cd]
           ,[pmi_cts_code]
           ,[mi_deletion_dt]
           ,[mi_deletion_null]
           ,[mip_pend_annual_am]
           ,[mip_pend_anniv_dt]
           ,[mip_pend_anniv_null]
           ,[mi_exp_cert_no]
           ,[mi_exp_co_cd]
           ,[load_date]
           ,[EXTR_GUID]
           ,[ERRORS]
           ,[MI_RHS_L_PO_SET_DT]
           ,[MI_RHS_L_PO_SET_NULL]
           ,[MI_RHS_MTH_FEE_AM]
           ,[MI_RHS_RPTD_TRM_TY]
           ,[MI_RHS_E_L_PO_R_DT]
           ,[MI_RHS_E_L_PO_R_NULL]
           ,[MI_RHS_PMTH_FEE_AM])
SELECT [delta_file_byte]
           ,[ln_no]
           ,[mi_bill_cd]
           ,[mi_va_no]
           ,[mi_fha_case_no]
           ,[mi_fha_chk_dig_xx]
           ,[mi_fha_office_cd]
           ,[mi_fha_adp_cd]
           ,[mi_fha_section_cd]
           ,[mi_adjuster_cd]
           ,[mi_anniv_ytd_am]
           ,[mi_cert_no]
           ,[mi_disb_am]
           ,[mi_disb_due_dt]
           ,[mi_disb_due_null]
           ,[mi_mnthly_am]
           ,[mi_payee_id]
           ,[mi_pmi_rt]
           ,[mi_pool_payee_id]
           ,[mi_pool_ins_pol_nm]
           ,[mi_pri_coverage_fc]
           ,[mi_tr]
           ,[mi_seq_no_cd]
           ,[mi_va_loan_no]
           ,[mi_va_loan_ty]
           ,[mi_va_orig_of_no]
           ,[mi_va_jur_of_no]
           ,[mi_certif_dt]
           ,[mi_certif_null]
           ,[mi_expire_dt]
           ,[mi_expire_null]
           ,[mi_fha_fin_am]
           ,[mi_rpt_status_cd]
           ,[re_loan_ind]
           ,[mi_service_dt]
           ,[mi_service_null]
           ,[mi_service_cd]
           ,[mi_upfront_am]
           ,[mi_cancel_dt]
           ,[mi_cancel_null]
           ,[mi_term_dt]
           ,[mi_term_null]
           ,[mi_midpoint_dt]
           ,[mi_midpoint_null]
           ,[mi_req_cancel_dt]
           ,[mi_req_cancel_null]
           ,[mi_ty]
           ,[mi_hi_risk_cd]
           ,[mi_pd_by_lender_cd]
           ,[client_no]
           ,[mi_va_lin_ckdig_xx]
           ,[mi_va_lin_conv_cd]
           ,[mi_va_guar_pc]
           ,[mi_p_monthly_am]
           ,[mi_78_pct_ltv_am]
           ,[mi_premium_end_dt]
           ,[mi_premium_end_null]
           ,[mi_pmi_cncl_rsn_cd]
           ,[mi_co_cd]
           ,[pmi_cts_code]
           ,[mi_deletion_dt]
           ,[mi_deletion_null]
           ,[mip_pend_annual_am]
           ,[mip_pend_anniv_dt]
           ,[mip_pend_anniv_null]
           ,[mi_exp_cert_no]
           ,[mi_exp_co_cd]
           ,[load_date]
           ,[EXTR_GUID]
           ,[ERRORS]
           ,[MI_RHS_L_PO_SET_DT]
           ,[MI_RHS_L_PO_SET_NULL]
           ,[MI_RHS_MTH_FEE_AM]
           ,[MI_RHS_RPTD_TRM_TY]
           ,[MI_RHS_E_L_PO_R_DT]
           ,[MI_RHS_E_L_PO_R_NULL]
           ,[MI_RHS_PMTH_FEE_AM]
FROM [10.0.15.10].bde_data.dbo.mortgage_insurance
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO

INSERT INTO [dbo].[hazard_insurance]
           ([delta_file_byte]
           ,[ln_no]
           ,[hz_disb_ty]
           ,[hz_seq_no]
           ,[hz_flood_del_dt]
           ,[hz_flood_del_null]
           ,[hz_flood_ins_cd]
           ,[hz_forced_cov_dt]
           ,[hz_forced_cov_null]
           ,[hz_force_cov_cd]
           ,[hz_agent_cd]
           ,[hz_coverage_am]
           ,[hz_coverage_ty]
           ,[hz_disb_am]
           ,[hz_disb_due_dt]
           ,[hz_disb_due_null]
           ,[hz_endorsement_dt]
           ,[hz_endorsement_null]
           ,[hz_expiration_dt]
           ,[hz_expiration_null]
           ,[hz_mnthly_am]
           ,[hz_new_ln_cd]
           ,[hz_payee_id]
           ,[hz_tr]
           ,[hz_type_pmt_cd]
           ,[hz_policy_no]
           ,[hz_ins_co_cd]
           ,[re_loan_ind]
           ,[hz_dec_coverage_am]
           ,[hz_disb_due_df]
           ,[hz_expiration_df]
           ,[hz_mtg_cl_cd]
           ,[hz_mtg_cl_dt]
           ,[hz_mtg_cl_null]
           ,[haz_update_cd]
           ,[client_no]
           ,[hz_rep_cost_cov_fg]
           ,[hz_fld_sp_hand_cd]
           ,[hz_deduct_am]
           ,[hz_deduct_pc]
           ,[hz_multi_ln_pol_fg]
           ,[hz_fld_zone_xx]
           ,[hz_fld_grandpa_fg]
           ,[hz_fld_dscrpncy_fg]
           ,[hz_cancel_rsn_cd]
           ,[hz_lst_knwn_cvr_am]
           ,[load_date])
SELECT [delta_file_byte]
           ,[ln_no]
           ,[hz_disb_ty]
           ,[hz_seq_no]
           ,[hz_flood_del_dt]
           ,[hz_flood_del_null]
           ,[hz_flood_ins_cd]
           ,[hz_forced_cov_dt]
           ,[hz_forced_cov_null]
           ,[hz_force_cov_cd]
           ,[hz_agent_cd]
           ,[hz_coverage_am]
           ,[hz_coverage_ty]
           ,[hz_disb_am]
           ,[hz_disb_due_dt]
           ,[hz_disb_due_null]
           ,[hz_endorsement_dt]
           ,[hz_endorsement_null]
           ,[hz_expiration_dt]
           ,[hz_expiration_null]
           ,[hz_mnthly_am]
           ,[hz_new_ln_cd]
           ,[hz_payee_id]
           ,[hz_tr]
           ,[hz_type_pmt_cd]
           ,[hz_policy_no]
           ,[hz_ins_co_cd]
           ,[re_loan_ind]
           ,[hz_dec_coverage_am]
           ,[hz_disb_due_df]
           ,[hz_expiration_df]
           ,[hz_mtg_cl_cd]
           ,[hz_mtg_cl_dt]
           ,[hz_mtg_cl_null]
           ,[haz_update_cd]
           ,[client_no]
           ,[hz_rep_cost_cov_fg]
           ,[hz_fld_sp_hand_cd]
           ,[hz_deduct_am]
           ,[hz_deduct_pc]
           ,[hz_multi_ln_pol_fg]
           ,[hz_fld_zone_xx]
           ,[hz_fld_grandpa_fg]
           ,[hz_fld_dscrpncy_fg]
           ,[hz_cancel_rsn_cd]
           ,[hz_lst_knwn_cvr_am]
           ,[load_date]
 FROM [10.0.15.10].bde_data.dbo.[hazard_insurance]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 

USE [BDE_Data]
GO

INSERT INTO [dbo].[escrow_disb_tran]
           ([delta_file_byte]
           ,[ln_no]
           ,[dsb_seq_no]
           ,[dsb_action_cd]
           ,[dsb_am]
           ,[dsb_batch_no]
           ,[dsb_payee_id]
           ,[dsb_trans_cd]
           ,[dsb_hud_fee_am]
           ,[client_no]
           ,[dsb_due_dt]
           ,[dsb_due_null]
           ,[dsb_ck_micr_pre_no]
           ,[dsb_check_no]
           ,[dsb_manual_ck_cd]
           ,[dsb_eff_dt]
           ,[dsb_eff_null]
           ,[dsb_suspense_am]
           ,[dsb_rsn_cd_inv_ty]
           ,[load_date]
           ,[EXTR_GUID]
           ,[ERRORS]
           ,[dsb_trans_dt])
SELECT [delta_file_byte]
           ,[ln_no]
           ,[dsb_seq_no]
           ,[dsb_action_cd]
           ,[dsb_am]
           ,[dsb_batch_no]
           ,[dsb_payee_id]
           ,[dsb_trans_cd]
           ,[dsb_hud_fee_am]
           ,[client_no]
           ,[dsb_due_dt]
           ,[dsb_due_null]
           ,[dsb_ck_micr_pre_no]
           ,[dsb_check_no]
           ,[dsb_manual_ck_cd]
           ,[dsb_eff_dt]
           ,[dsb_eff_null]
           ,[dsb_suspense_am]
           ,[dsb_rsn_cd_inv_ty]
           ,[load_date]
           ,[EXTR_GUID]
           ,[ERRORS]
           ,[dsb_trans_dt]
 FROM [10.0.15.10].bde_data.dbo.[escrow_disb_tran]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO

INSERT INTO [dbo].[comment]
           ([delta_file_byte]
           ,[ln_no]
           ,[wkst_cd]
           ,[comm_dt]
           ,[comm_ti]
           ,[comm_cd]
           ,[comm_user_id]
           ,[client_no]
           ,[comm_key_dt_tm]
           ,[comm_key_dt_tm_xx]
           ,[load_date]
)
     SELECT [delta_file_byte]
           ,[ln_no]
           ,[wkst_cd]
           ,[comm_dt]
           ,[comm_ti]
           ,[comm_cd]
           ,[comm_user_id]
           ,[client_no]
           ,[comm_key_dt_tm]
           ,[comm_key_dt_tm_xx]
           ,[load_date]
 FROM [10.0.15.10].bde_data.dbo.[comment]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 

USE [BDE_Data]
GO

INSERT INTO [dbo].[corporate_adv_hist]
           ([delta_file_byte]
           ,[client_no]
           ,[ln_no]
           ,[cah_adv_am]
           ,[cah_corp_payee_id]
           ,[cah_payee_id]
           ,[cah_processor_id]
           ,[cah_reason_cd]
           ,[cah_reason_de]
           ,[cah_recover_cd]
           ,[cah_seq_no]
           ,[cah_user_seq_no]
           ,[cah_trans_cd]
           ,[cah_trans_dt]
           ,[cah_disb_check_no]
           ,[cah_ck_micr_pre_no]
           ,[cah_manual_ck_cd]
           ,[cah_orig_disb_dt]
           ,[cah_orig_disb_null]
           ,[cah_item_seq_nn]
           ,[cah_match_seq_nn]
           ,[cah_source_cd]
           ,[cah_exc_rept_fg]
           ,[cah_matched_fg]
           ,[cah_repayment_cd]
           ,[cah_age_days_ct]
           ,[cah_da_lst_tran_ct]
           ,[cah_nt_outstand_am]
           ,[ca_batch_no]
           ,[cah_pmt_act_cd]
           ,[cah_obligor_id]
           ,[load_date]
           )
select [delta_file_byte]
           ,[client_no]
           ,[ln_no]
           ,[cah_adv_am]
           ,[cah_corp_payee_id]
           ,[cah_payee_id]
           ,[cah_processor_id]
           ,[cah_reason_cd]
           ,[cah_reason_de]
           ,[cah_recover_cd]
           ,[cah_seq_no]
           ,[cah_user_seq_no]
           ,[cah_trans_cd]
           ,[cah_trans_dt]
           ,[cah_disb_check_no]
           ,[cah_ck_micr_pre_no]
           ,[cah_manual_ck_cd]
           ,[cah_orig_disb_dt]
           ,[cah_orig_disb_null]
           ,[cah_item_seq_nn]
           ,[cah_match_seq_nn]
           ,[cah_source_cd]
           ,[cah_exc_rept_fg]
           ,[cah_matched_fg]
           ,[cah_repayment_cd]
           ,[cah_age_days_ct]
           ,[cah_da_lst_tran_ct]
           ,[cah_nt_outstand_am]
           ,[ca_batch_no]
           ,[cah_pmt_act_cd]
           ,[cah_obligor_id]
           ,[load_date]
		   
 FROM [10.0.15.10].bde_data.dbo.[corporate_adv_hist]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 

USE [BDE_Data]
GO

USE [BDE_Data]
GO

INSERT INTO [dbo].[corporate_adv_tran]
           ([delta_file_byte]
           ,[ln_no]
           ,[adv_trans_dt]
           ,[adv_seq_no]
           ,[adv_am]
           ,[adv_corp_payee_id]
           ,[adv_payee_id]
           ,[adv_processor_id]
           ,[adv_reason_cd]
           ,[adv_trans_cd]
           ,[adv_recover_cd]
           ,[adv_user_seq_no]
           ,[client_no]
           ,[adv_reason_de]
           ,[adv_disb_check_no]
           ,[adv_manual_ck_cd]
           ,[adv_ck_micr_pre_no]
           ,[ca_batch_no]
           ,[adv_suspense_am]
           ,[adv_pmt_act_cd]
           ,[adv_rsn_cd_inv_ty]
           ,[load_date]
)
SELECT [delta_file_byte]
           ,[ln_no]
           ,[adv_trans_dt]
           ,[adv_seq_no]
           ,[adv_am]
           ,[adv_corp_payee_id]
           ,[adv_payee_id]
           ,[adv_processor_id]
           ,[adv_reason_cd]
           ,[adv_trans_cd]
           ,[adv_recover_cd]
           ,[adv_user_seq_no]
           ,[client_no]
           ,[adv_reason_de]
           ,[adv_disb_check_no]
           ,[adv_manual_ck_cd]
           ,[adv_ck_micr_pre_no]
           ,[ca_batch_no]
           ,[adv_suspense_am]
           ,[adv_pmt_act_cd]
           ,[adv_rsn_cd_inv_ty]
           ,[load_date]
 FROM [10.0.15.10].bde_data.dbo.[corporate_adv_tran]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO
USE [BDE_Data]
GO

INSERT INTO [dbo].[fee]
           ([delta_file_byte]
           ,[ln_no]
           ,[fee_tran_cd]
           ,[fee_tran_ty]
           ,[fee_cd]
           ,[fee_tran_dt]
           ,[fee_tran_null]
           ,[fee_tran_am]
           ,[fee_batch_cd]
           ,[fee_sub_cd]
           ,[client_no]
           ,[load_date]
)
select [delta_file_byte]
           ,[ln_no]
           ,[fee_tran_cd]
           ,[fee_tran_ty]
           ,[fee_cd]
           ,[fee_tran_dt]
           ,[fee_tran_null]
           ,[fee_tran_am]
           ,[fee_batch_cd]
           ,[fee_sub_cd]
           ,[client_no]
           ,[load_date]
 FROM [10.0.15.10].bde_data.dbo.fee
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO
USE [BDE_Data]
GO

INSERT INTO [dbo].[servicing_fee]
           ([delta_file_byte]
           ,[ln_no]
           ,[sv_acr_rt]
           ,[sv_act_def_ba]
           ,[sv_bubdwn_ratio_fc]
           ,[sv_corr_cd]
           ,[ca_disc_fc]
           ,[sv_exs_sf_amrt_cd]
           ,[sv_fhlmc_stat_cd]
           ,[sv_fhlmc_redoc_cd]
           ,[sv_sf_paid_amt]
           ,[sv_1st_serv_fee_cd]
           ,[sv_1st_serv_fee_rt]
           ,[sv_1st_step1_am]
           ,[sv_1st_step1_rt]
           ,[sv_1st_step2_am]
           ,[sv_1st_step2_rt]
           ,[sv_1st_step3_am]
           ,[sv_1st_step3_rt]
           ,[sv_1st_step4_am]
           ,[sv_1st_step4_rt]
           ,[sv_laser_action_cd]
           ,[sv_laser_action_dt]
           ,[sv_laser_action_null]
           ,[sv_laser_chg_dt]
           ,[sv_laser_chg_null]
           ,[sv_fnma_ltv_cd]
           ,[sv_fnma_pln_no]
           ,[sv_fnma_proj_ty]
           ,[sv_fore_loss_rk_cd]
           ,[sv_guar_aft_acc_fc]
           ,[sv_guar_aft_buy_fc]
           ,[sv_guar_per_con_fc]
           ,[sv_guar_rt]
           ,[sv_iv_chg_dt]
           ,[sv_iv_chg_null]
           ,[sv_iv_ln_no]
           ,[sv_inv_reqd_mrg_fc]
           ,[sv_lst_iv_chg_dt]
           ,[sv_lst_iv_chg_null]
           ,[sv_level_sf_amt]
           ,[sv_new_1st_pmt_dt]
           ,[sv_new_1st_pmt_null]
           ,[sv_new_iv_cat_cd]
           ,[sv_new_iv_id]
           ,[sv_new_iv_ln_no]
           ,[sv_old_iv_cat_cd]
           ,[sv_old_iv_id]
           ,[sv_orig_exs_sf_ba]
           ,[sv_orig_sf_amrt_tr]
           ,[sv_pen_budn_rat_fc]
           ,[sv_pen_fore_rk_cd]
           ,[sv_pen_gr_aft_b_fc]
           ,[sv_pen_gr_aft_a_fc]
           ,[sv_pen_inv_mrg_fc]
           ,[sv_pend_guar_fe_fc]
           ,[pool_contr_no]
           ,[sv_prepay_pen_cd]
           ,[sv_pur_prc_am]
           ,[co_recr_expire_dt]
           ,[co_recr_expire_null]
           ,[co_recr_cd]
           ,[sv_rem_exs_sf_tr]
           ,[sv_sch_def_ba]
           ,[sv_sch_prin_ba]
           ,[sv_2nd_level_sf_am]
           ,[sv_2nd_ppay_pen_cd]
           ,[sv_2nd_serv_fee_cd]
           ,[sv_2nd_serv_fee_rt]
           ,[sv_2nd_step1_am]
           ,[sv_2nd_step1_rt]
           ,[sv_2nd_step2_am]
           ,[sv_2nd_step2_rt]
           ,[sv_2nd_step3_am]
           ,[sv_2nd_step3_rt]
           ,[sv_2nd_step4_am]
           ,[sv_2nd_step4_rt]
           ,[sv_unamrt_sf_ba]
           ,[re_loan_ind]
           ,[sv_pend_sf_rt]
           ,[sv_pend_levl_sf_am]
           ,[sv_prepay_pen_1_de]
           ,[sv_prepay_pen_2_de]
           ,[sv_2nd_ppaypen1_de]
           ,[sv_2nd_ppaypen2_de]
           ,[sf_1st_remit_dt]
           ,[sf_1st_remit_null]
           ,[client_no]
           ,[sv_ppp_hdr_id]
           ,[sv_prepay_pen_3_de]
           ,[sv_prepay_pen_4_de]
           ,[sv_prepay_pen_5_de]
           ,[sv_2nd_ppaypen3_de]
           ,[sv_2nd_ppaypen4_de]
           ,[sv_2nd_ppaypen5_de]
           ,[sv_guar_aft_buy_xx]
           ,[sv_1st_stp1_dec_am]
           ,[sv_1st_stp2_dec_am]
           ,[sv_1st_stp3_dec_am]
           ,[sv_1st_stp4_dec_am]
           ,[sv_2nd_stp1_dec_am]
           ,[sv_2nd_stp2_dec_am]
           ,[sv_2nd_stp3_dec_am]
           ,[sv_2nd_stp4_dec_am]
           ,[load_date]
)
SELECT [delta_file_byte]
           ,[ln_no]
           ,[sv_acr_rt]
           ,[sv_act_def_ba]
           ,[sv_bubdwn_ratio_fc]
           ,[sv_corr_cd]
           ,[ca_disc_fc]
           ,[sv_exs_sf_amrt_cd]
           ,[sv_fhlmc_stat_cd]
           ,[sv_fhlmc_redoc_cd]
           ,[sv_sf_paid_amt]
           ,[sv_1st_serv_fee_cd]
           ,[sv_1st_serv_fee_rt]
           ,[sv_1st_step1_am]
           ,[sv_1st_step1_rt]
           ,[sv_1st_step2_am]
           ,[sv_1st_step2_rt]
           ,[sv_1st_step3_am]
           ,[sv_1st_step3_rt]
           ,[sv_1st_step4_am]
           ,[sv_1st_step4_rt]
           ,[sv_laser_action_cd]
           ,[sv_laser_action_dt]
           ,[sv_laser_action_null]
           ,[sv_laser_chg_dt]
           ,[sv_laser_chg_null]
           ,[sv_fnma_ltv_cd]
           ,[sv_fnma_pln_no]
           ,[sv_fnma_proj_ty]
           ,[sv_fore_loss_rk_cd]
           ,[sv_guar_aft_acc_fc]
           ,[sv_guar_aft_buy_fc]
           ,[sv_guar_per_con_fc]
           ,[sv_guar_rt]
           ,[sv_iv_chg_dt]
           ,[sv_iv_chg_null]
           ,[sv_iv_ln_no]
           ,[sv_inv_reqd_mrg_fc]
           ,[sv_lst_iv_chg_dt]
           ,[sv_lst_iv_chg_null]
           ,[sv_level_sf_amt]
           ,[sv_new_1st_pmt_dt]
           ,[sv_new_1st_pmt_null]
           ,[sv_new_iv_cat_cd]
           ,[sv_new_iv_id]
           ,[sv_new_iv_ln_no]
           ,[sv_old_iv_cat_cd]
           ,[sv_old_iv_id]
           ,[sv_orig_exs_sf_ba]
           ,[sv_orig_sf_amrt_tr]
           ,[sv_pen_budn_rat_fc]
           ,[sv_pen_fore_rk_cd]
           ,[sv_pen_gr_aft_b_fc]
           ,[sv_pen_gr_aft_a_fc]
           ,[sv_pen_inv_mrg_fc]
           ,[sv_pend_guar_fe_fc]
           ,[pool_contr_no]
           ,[sv_prepay_pen_cd]
           ,[sv_pur_prc_am]
           ,[co_recr_expire_dt]
           ,[co_recr_expire_null]
           ,[co_recr_cd]
           ,[sv_rem_exs_sf_tr]
           ,[sv_sch_def_ba]
           ,[sv_sch_prin_ba]
           ,[sv_2nd_level_sf_am]
           ,[sv_2nd_ppay_pen_cd]
           ,[sv_2nd_serv_fee_cd]
           ,[sv_2nd_serv_fee_rt]
           ,[sv_2nd_step1_am]
           ,[sv_2nd_step1_rt]
           ,[sv_2nd_step2_am]
           ,[sv_2nd_step2_rt]
           ,[sv_2nd_step3_am]
           ,[sv_2nd_step3_rt]
           ,[sv_2nd_step4_am]
           ,[sv_2nd_step4_rt]
           ,[sv_unamrt_sf_ba]
           ,[re_loan_ind]
           ,[sv_pend_sf_rt]
           ,[sv_pend_levl_sf_am]
           ,[sv_prepay_pen_1_de]
           ,[sv_prepay_pen_2_de]
           ,[sv_2nd_ppaypen1_de]
           ,[sv_2nd_ppaypen2_de]
           ,[sf_1st_remit_dt]
           ,[sf_1st_remit_null]
           ,[client_no]
           ,[sv_ppp_hdr_id]
           ,[sv_prepay_pen_3_de]
           ,[sv_prepay_pen_4_de]
           ,[sv_prepay_pen_5_de]
           ,[sv_2nd_ppaypen3_de]
           ,[sv_2nd_ppaypen4_de]
           ,[sv_2nd_ppaypen5_de]
           ,[sv_guar_aft_buy_xx]
           ,[sv_1st_stp1_dec_am]
           ,[sv_1st_stp2_dec_am]
           ,[sv_1st_stp3_dec_am]
           ,[sv_1st_stp4_dec_am]
           ,[sv_2nd_stp1_dec_am]
           ,[sv_2nd_stp2_dec_am]
           ,[sv_2nd_stp3_dec_am]
           ,[sv_2nd_stp4_dec_am]
           ,[load_date]

 FROM [10.0.15.10].bde_data.dbo.[servicing_fee]
where [ln_no] IN ('0000997379','0001020627','0010776706','0030645840','001511461','0011481785','0011451820','0014194021', '0014103378','0030089502','0030181259','0030392567','0015113681','0002139285') 


USE [BDE_Data]
GO

INSERT INTO [dbo].[delinquency]
           ([delta_file_byte]
           ,[ln_no]
           ,[co_man_cd]
           ,[co_delq_cd]
           ,[co_2nd_man_cd]
           ,[co_bad_chk_stop]
           ,[co_bad_chk_tbl_01]
           ,[co_bad_chk_tbl_10]
           ,[co_bad_chk_tbl_11]
           ,[co_bad_chk_tbl_12]
           ,[co_bad_chk_tbl_02]
           ,[co_bad_chk_tbl_03]
           ,[co_bad_chk_tbl_04]
           ,[co_bad_chk_tbl_05]
           ,[co_bad_chk_tbl_06]
           ,[co_bad_chk_tbl_07]
           ,[co_bad_chk_tbl_08]
           ,[co_bad_chk_tbl_09]
           ,[co_delq_class_cd]
           ,[co_delq_table_01]
           ,[co_delq_table_10]
           ,[co_delq_table_11]
           ,[co_delq_table_12]
           ,[co_delq_table_02]
           ,[co_delq_table_03]
           ,[co_delq_table_04]
           ,[co_delq_table_05]
           ,[co_delq_table_06]
           ,[co_delq_table_07]
           ,[co_delq_table_08]
           ,[co_delq_table_09]
           ,[co_grace_days_qt]
           ,[co_lst_late_dt]
           ,[co_lst_late_null]
           ,[co_late_chrg_dt]
           ,[co_late_chrg_null]
           ,[co_min_lte_chrg_am]
           ,[co_recr_expire_dt]
           ,[co_recr_expire_null]
           ,[co_recr_cd]
           ,[co_max_lte_chg_am]
           ,[co_late_chrg_cd]
           ,[co_late_chrg_fc]
           ,[co_late_chrg_am]
           ,[co_loss_mitgn_cd]
           ,[co_2nd_lienhldr_nm]
           ,[co_delq_reason_cd]
           ,[co_delq_status_cd]
           ,[co_pay_history]
           ,[co_pmt_history_tbl]
           ,[co_lossmit_stat_cd]
           ,[co_dlq_col_days_qt]
           ,[co_dlq_pmt_ba]
           ,[co_dlq_pmt_qt]
           ,[co_grace_days_qx]
           ,[re_loan_ind]
           ,[re_late_chrg_am]
           ,[re_late_chrg_fc]
           ,[times_delq_qt]
           ,[co_remind_note_qt]
           ,[co_final_note_qt]
           ,[co_dfltrpt_stop_cd]
           ,[co_dfltrpt_exp_dt]
           ,[co_dfltrpt_exp_null]
           ,[co_avg_days_dlq_qt]
           ,[co_grace_days2_qx]
           ,[co_bad_chk_tbl2_01]
           ,[co_bad_chk_tbl2_10]
           ,[co_bad_chk_tbl2_11]
           ,[co_bad_chk_tbl2_12]
           ,[co_bad_chk_tbl2_02]
           ,[co_bad_chk_tbl2_03]
           ,[co_bad_chk_tbl2_04]
           ,[co_bad_chk_tbl2_05]
           ,[co_bad_chk_tbl2_06]
           ,[co_bad_chk_tbl2_07]
           ,[co_bad_chk_tbl2_08]
           ,[co_bad_chk_tbl2_09]
           ,[co_pmt_history_tbl2]
           ,[co_badck_st_exp_dt]
           ,[co_badck_st_exp_null]
           ,[client_no]
           ,[co_queue_id]
           ,[co_repay_plan_cd]
           ,[co_cur_inst_rul_fg]
           ,[co_badck_st_chg_id]
           ,[co_badck_st_chg_dt]
           ,[co_badck_st_chg_null]
           ,[co_dfltrpt_chg_id]
           ,[co_dfltrpt_chg_dt]
           ,[co_dfltrpt_chg_null]
           ,[co_va_dflt_rsn_cd]
           ,[co_spc_hdlg_da_ct]
           ,[co_fnma_stat_eff_dt]
           ,[co_fnma_stat_eff_dt_null]
           ,[co_dflt_restrict_fg]
           ,[co_fnma_stat_ex_dt]
           ,[co_fnma_stat_ex_null]
           ,[co_sp_svc_req_cd]
           ,[co_imm_dflt_cd]
           ,[co_imm_dflt_cd_dt]
           ,[co_imm_dflt_cd_null]
           ,[co_hi_rsk_alt_a_cd]
           ,[co_im_dflt_fico_xx]
           ,[co_im_dflt_fico_dt]
           ,[co_im_dflt_fico_null]
           ,[co_rcvr_stat_cd]
           ,[co_rcvr_stat_dt]
           ,[co_rcvr_stat_null]
           ,[co_shrt_pymt_ca_ba]
           ,[co_lc_cd_chg_dt]
           ,[co_lc_cd_chg_null]
           ,[co_prtl_lt_ind_cd]
           ,[co_prtl_lt_ind_dt]
           ,[co_prtl_lt_ind_null]
           ,[co_lc_vldtn_cd]
           ,[co_lc_vldtn_usr_id]
           ,[co_lc_vldtn_dt]
           ,[co_lc_vldtn_dt_null]
           ,[co_dlq_ntce_snt_dt]
           ,[co_dlq_ntce_snt_null]
           ,[co_dlq_hst_excl_cd]
           ,[load_date]
           )
select [delta_file_byte]
           ,[ln_no]
           ,[co_man_cd]
           ,[co_delq_cd]
           ,[co_2nd_man_cd]
           ,[co_bad_chk_stop]
           ,[co_bad_chk_tbl_01]
           ,[co_bad_chk_tbl_10]
           ,[co_bad_chk_tbl_11]
           ,[co_bad_chk_tbl_12]
           ,[co_bad_chk_tbl_02]
           ,[co_bad_chk_tbl_03]
           ,[co_bad_chk_tbl_04]
           ,[co_bad_chk_tbl_05]
           ,[co_bad_chk_tbl_06]
           ,[co_bad_chk_tbl_07]
           ,[co_bad_chk_tbl_08]
           ,[co_bad_chk_tbl_09]
           ,[co_delq_class_cd]
           ,[co_delq_table_01]
           ,[co_delq_table_10]
           ,[co_delq_table_11]
           ,[co_delq_table_12]
           ,[co_delq_table_02]
           ,[co_delq_table_03]
           ,[co_delq_table_04]
           ,[co_delq_table_05]
           ,[co_delq_table_06]
           ,[co_delq_table_07]
           ,[co_delq_table_08]
           ,[co_delq_table_09]
           ,[co_grace_days_qt]
           ,[co_lst_late_dt]
           ,[co_lst_late_null]
           ,[co_late_chrg_dt]
           ,[co_late_chrg_null]
           ,[co_min_lte_chrg_am]
           ,[co_recr_expire_dt]
           ,[co_recr_expire_null]
           ,[co_recr_cd]
           ,[co_max_lte_chg_am]
           ,[co_late_chrg_cd]
           ,[co_late_chrg_fc]
           ,[co_late_chrg_am]
           ,[co_loss_mitgn_cd]
           ,[co_2nd_lienhldr_nm]
           ,[co_delq_reason_cd]
           ,[co_delq_status_cd]
           ,[co_pay_history]
           ,[co_pmt_history_tbl]
           ,[co_lossmit_stat_cd]
           ,[co_dlq_col_days_qt]
           ,[co_dlq_pmt_ba]
           ,[co_dlq_pmt_qt]
           ,[co_grace_days_qx]
           ,[re_loan_ind]
           ,[re_late_chrg_am]
           ,[re_late_chrg_fc]
           ,[times_delq_qt]
           ,[co_remind_note_qt]
           ,[co_final_note_qt]
           ,[co_dfltrpt_stop_cd]
           ,[co_dfltrpt_exp_dt]
           ,[co_dfltrpt_exp_null]
           ,[co_avg_days_dlq_qt]
           ,[co_grace_days2_qx]
           ,[co_bad_chk_tbl2_01]
           ,[co_bad_chk_tbl2_10]
           ,[co_bad_chk_tbl2_11]
           ,[co_bad_chk_tbl2_12]
           ,[co_bad_chk_tbl2_02]
           ,[co_bad_chk_tbl2_03]
           ,[co_bad_chk_tbl2_04]
           ,[co_bad_chk_tbl2_05]
           ,[co_bad_chk_tbl2_06]
           ,[co_bad_chk_tbl2_07]
           ,[co_bad_chk_tbl2_08]
           ,[co_bad_chk_tbl2_09]
           ,[co_pmt_history_tbl2]
           ,[co_badck_st_exp_dt]
           ,[co_badck_st_exp_null]
           ,[client_no]
           ,[co_queue_id]
           ,[co_repay_plan_cd]
           ,[co_cur_inst_rul_fg]
           ,[co_badck_st_chg_id]
           ,[co_badck_st_chg_dt]
           ,[co_badck_st_chg_null]
           ,[co_dfltrpt_chg_id]
           ,[co_dfltrpt_chg_dt]
           ,[co_dfltrpt_chg_null]
           ,[co_va_dflt_rsn_cd]
           ,[co_spc_hdlg_da_ct]
           ,[co_fnma_stat_eff_dt]
           ,[co_fnma_stat_eff_dt_null]
           ,[co_dflt_restrict_fg]
           ,[co_fnma_stat_ex_dt]
           ,[co_fnma_stat_ex_null]
           ,[co_sp_svc_req_cd]
           ,[co_imm_dflt_cd]
           ,[co_imm_dflt_cd_dt]
           ,[co_imm_dflt_cd_null]
           ,[co_hi_rsk_alt_a_cd]
           ,[co_im_dflt_fico_xx]
           ,[co_im_dflt_fico_dt]
           ,[co_im_dflt_fico_null]
           ,[co_rcvr_stat_cd]
           ,[co_rcvr_stat_dt]
           ,[co_rcvr_stat_null]
           ,[co_shrt_pymt_ca_ba]
           ,[co_lc_cd_chg_dt]
           ,[co_lc_cd_chg_null]
           ,[co_prtl_lt_ind_cd]
           ,[co_prtl_lt_ind_dt]
           ,[co_prtl_lt_ind_null]
           ,[co_lc_vldtn_cd]
           ,[co_lc_vldtn_usr_id]
           ,[co_lc_vldtn_dt]
           ,[co_lc_vldtn_dt_null]
           ,[co_dlq_ntce_snt_dt]
           ,[co_dlq_ntce_snt_null]
           ,[co_dlq_hst_excl_cd]
           ,[load_date]
		   from [10.0.15.10].bde_data.dbo.delinquency
where ln_no in (select distinct ln_no from bde_data.dbo.loan)


USE [BDESIME]
GO

INSERT INTO [dbo].[delinquency]
           ([delta_file_byte]
           ,[LOAN NUMBER]
           ,[MAN CODE]
           ,[DELINQUENCY INDICATOR]
           ,[SECOND MAN CODE]
           ,[BAD CHECK STOP CODE]
           ,[BAD CHECK TABLE POSITION 01]
           ,[BAD CHECK TABLE POSITION 10]
           ,[BAD CHECK TABLE POSITION 11]
           ,[BAD CHECK TABLE POSITION 12]
           ,[BAD CHECK TABLE POSITION 02]
           ,[BAD CHECK TABLE POSITION 03]
           ,[BAD CHECK TABLE POSITION 04]
           ,[BAD CHECK TABLE POSITION 05]
           ,[BAD CHECK TABLE POSITION 06]
           ,[BAD CHECK TABLE POSITION 07]
           ,[BAD CHECK TABLE POSITION 08]
           ,[BAD CHECK TABLE POSITION 09]
           ,[DELINQUENCY CLASS CODE]
           ,[DELINQUENCY TABLE POSITION 01]
           ,[DELINQUENCY TABLE POSITION 10]
           ,[DELINQUENCY TABLE POSITION 11]
           ,[DELINQUENCY TABLE POSITION 12]
           ,[DELINQUENCY TABLE POSITION 02]
           ,[DELINQUENCY TABLE POSITION 03]
           ,[DELINQUENCY TABLE POSITION 04]
           ,[DELINQUENCY TABLE POSITION 05]
           ,[DELINQUENCY TABLE POSITION 06]
           ,[DELINQUENCY TABLE POSITION 07]
           ,[DELINQUENCY TABLE POSITION 08]
           ,[DELINQUENCY TABLE POSITION 09]
           ,[GRACE DAYS]
           ,[LAST LATE DATE]
           ,[co_lst_late_null]
           ,[LATE CHARGE DATE]
           ,[co_late_chrg_null]
           ,[MINIMUM LATE CHARGE AMOUNT]
           ,[RECOURSE EXPIRATION DATE]
           ,[co_recr_expire_null]
           ,[RECOURSE FLAG]
           ,[MAXIMUM LATE CHARGE AMOUNT]
           ,[LATE CHARGE CODE]
           ,[LATE CHARGE FACTOR]
           ,[LATE CHARGE AMOUNT]
           ,[LOSS MITIGATION INDICATOR]
           ,[SECOND LIENHOLDER NAME]
           ,[DELINQUENCY REASON CODE]
           ,[DELINQUENCY REPORTING STATUS]
           ,[PAY HISTORY]
           ,[CO PAYMENT HIST TABLE DEAD]
           ,[LOSS MITIGATION STATUS CODE]
           ,[DELINQUENCY COLLECTOR DAYS]
           ,[DELINQUENT PAYMENT BALANCE]
           ,[DELINQUENT PAYMENT COUNT]
           ,[ALTERNATE GRACE DAYS]
           ,[RE LOAN INDICATOR]
           ,[RE LATE CHARGE AMOUNT]
           ,[RE LATE CHARGE FACTOR]
           ,[TIMES DELINQUENT]
           ,[DELINQUENCY REMIND NOTICE DAYS]
           ,[DELINQUENCY FINAL NOTICE DAYS]
           ,[DEFAULT REPORTING STOP CODE]
           ,[DEFAULT REPORTING EXPIRE DATE]
           ,[co_dfltrpt_exp_null]
           ,[AVERAGE DAYS DELINQUENT]
           ,[GRACE DAYS TEXT]
           ,[BAD CHECK TABLE POSITION 13]
           ,[BAD CHECK TABLE POSITION 22]
           ,[BAD CHECK TABLE POSITION 23]
           ,[BAD CHECK TABLE POSITION 24]
           ,[BAD CHECK TABLE POSITION 14]
           ,[BAD CHECK TABLE POSITION 15]
           ,[BAD CHECK TABLE POSITION 16]
           ,[BAD CHECK TABLE POSITION 17]
           ,[BAD CHECK TABLE POSITION 18]
           ,[BAD CHECK TABLE POSITION 19]
           ,[BAD CHECK TABLE POSITION 20]
           ,[BAD CHECK TABLE POSITION 21]
           ,[ALTERNATE PAYMENT HIST TABLE]
           ,[BAD CHECK STOP EXPIRE DATE]
           ,[co_badck_st_exp_null]
           ,[CLIENT NUMBER]
           ,[COLLECTION QUEUE ID]
           ,[REPAYMENT PLAN INDICATOR]
           ,[CURRENT INSTALLMENT RULE FLAG]
           ,[BAD CHECK STOP CHANGE BY ID]
           ,[BAD CHECK STOP CHANGE DATE]
           ,[co_badck_st_chg_null]
           ,[DEFAULT RPTING STOP CHG BY ID]
           ,[DEFAULT RPTING STOP CHG DATE]
           ,[co_dfltrpt_chg_null]
           ,[VA DEFAULT REASON CODE]
           ,[EARLY RSLTN SPECIAL HDLG DAYS]
           ,[FNMA STATUS EFFECTIVE DATE]
           ,[co_fnma_stat_eff_dt_null]
           ,[DEFAULT RESTRUCTURED FLAG]
           ,[FNMA STATUS EXPIRATION DATE]
           ,[co_fnma_stat_ex_null]
           ,[SPEC SERVICING REQ INDICATOR]
           ,[IMMINENT DEFAULT INDICATOR]
           ,[IMMINENT DEFLT INDICATOR DATE]
           ,[co_imm_dflt_cd_null]
           ,[HIGH RISK ALT A CODE]
           ,[IMMINENT DEFAULT FICO SCORE]
           ,[IMMINENT DEFAULT FICO DATE]
           ,[co_im_dflt_fico_null]
           ,[RECOVERY STATUS CODE]
           ,[RECOVERY STATUS DATE]
           ,[co_rcvr_stat_null]
           ,[SHORT PAYMENT CORP ADV BALANCE]
           ,[LATE CHARGE CODE CHANGE DATE]
           ,[co_lc_cd_chg_null]
           ,[PARTIAL LATE CHARGE IND CODE]
           ,[PARTIAL LATE CHRG IND CHG DATE]
           ,[co_prtl_lt_ind_null]
           ,[LATE CHARGE VALIDATION CODE]
           ,[LATE CHARGE VALIDATION USER ID]
           ,[LATE CHARGE VALIDATION DATE]
           ,[co_lc_vldtn_dt_null]
           ,[DELQ NOTICE SENT DATE]
           ,[co_dlq_ntce_snt_null]
           ,[DELQ HISTORY EXCLUDE CODE]
           ,[load_date]
           ,[SID])

		   select [delta_file_byte]
           ,[LOAN NUMBER]
           ,[MAN CODE]
           ,[DELINQUENCY INDICATOR]
           ,[SECOND MAN CODE]
           ,[BAD CHECK STOP CODE]
           ,[BAD CHECK TABLE POSITION 01]
           ,[BAD CHECK TABLE POSITION 10]
           ,[BAD CHECK TABLE POSITION 11]
           ,[BAD CHECK TABLE POSITION 12]
           ,[BAD CHECK TABLE POSITION 02]
           ,[BAD CHECK TABLE POSITION 03]
           ,[BAD CHECK TABLE POSITION 04]
           ,[BAD CHECK TABLE POSITION 05]
           ,[BAD CHECK TABLE POSITION 06]
           ,[BAD CHECK TABLE POSITION 07]
           ,[BAD CHECK TABLE POSITION 08]
           ,[BAD CHECK TABLE POSITION 09]
           ,[DELINQUENCY CLASS CODE]
           ,[DELINQUENCY TABLE POSITION 01]
           ,[DELINQUENCY TABLE POSITION 10]
           ,[DELINQUENCY TABLE POSITION 11]
           ,[DELINQUENCY TABLE POSITION 12]
           ,[DELINQUENCY TABLE POSITION 02]
           ,[DELINQUENCY TABLE POSITION 03]
           ,[DELINQUENCY TABLE POSITION 04]
           ,[DELINQUENCY TABLE POSITION 05]
           ,[DELINQUENCY TABLE POSITION 06]
           ,[DELINQUENCY TABLE POSITION 07]
           ,[DELINQUENCY TABLE POSITION 08]
           ,[DELINQUENCY TABLE POSITION 09]
           ,[GRACE DAYS]
           ,[LAST LATE DATE]
           ,[co_lst_late_null]
           ,[LATE CHARGE DATE]
           ,[co_late_chrg_null]
           ,[MINIMUM LATE CHARGE AMOUNT]
           ,[RECOURSE EXPIRATION DATE]
           ,[co_recr_expire_null]
           ,[RECOURSE FLAG]
           ,[MAXIMUM LATE CHARGE AMOUNT]
           ,[LATE CHARGE CODE]
           ,[LATE CHARGE FACTOR]
           ,[LATE CHARGE AMOUNT]
           ,[LOSS MITIGATION INDICATOR]
           ,[SECOND LIENHOLDER NAME]
           ,[DELINQUENCY REASON CODE]
           ,[DELINQUENCY REPORTING STATUS]
           ,[PAY HISTORY]
           ,[CO PAYMENT HIST TABLE DEAD]
           ,[LOSS MITIGATION STATUS CODE]
           ,[DELINQUENCY COLLECTOR DAYS]
           ,[DELINQUENT PAYMENT BALANCE]
           ,[DELINQUENT PAYMENT COUNT]
           ,[ALTERNATE GRACE DAYS]
           ,[RE LOAN INDICATOR]
           ,[RE LATE CHARGE AMOUNT]
           ,[RE LATE CHARGE FACTOR]
           ,[TIMES DELINQUENT]
           ,[DELINQUENCY REMIND NOTICE DAYS]
           ,[DELINQUENCY FINAL NOTICE DAYS]
           ,[DEFAULT REPORTING STOP CODE]
           ,[DEFAULT REPORTING EXPIRE DATE]
           ,[co_dfltrpt_exp_null]
           ,[AVERAGE DAYS DELINQUENT]
           ,[GRACE DAYS TEXT]
           ,[BAD CHECK TABLE POSITION 13]
           ,[BAD CHECK TABLE POSITION 22]
           ,[BAD CHECK TABLE POSITION 23]
           ,[BAD CHECK TABLE POSITION 24]
           ,[BAD CHECK TABLE POSITION 14]
           ,[BAD CHECK TABLE POSITION 15]
           ,[BAD CHECK TABLE POSITION 16]
           ,[BAD CHECK TABLE POSITION 17]
           ,[BAD CHECK TABLE POSITION 18]
           ,[BAD CHECK TABLE POSITION 19]
           ,[BAD CHECK TABLE POSITION 20]
           ,[BAD CHECK TABLE POSITION 21]
           ,[ALTERNATE PAYMENT HIST TABLE]
           ,[BAD CHECK STOP EXPIRE DATE]
           ,[co_badck_st_exp_null]
           ,[CLIENT NUMBER]
           ,[COLLECTION QUEUE ID]
           ,[REPAYMENT PLAN INDICATOR]
           ,[CURRENT INSTALLMENT RULE FLAG]
           ,[BAD CHECK STOP CHANGE BY ID]
           ,[BAD CHECK STOP CHANGE DATE]
           ,[co_badck_st_chg_null]
           ,[DEFAULT RPTING STOP CHG BY ID]
           ,[DEFAULT RPTING STOP CHG DATE]
           ,[co_dfltrpt_chg_null]
           ,[VA DEFAULT REASON CODE]
           ,[EARLY RSLTN SPECIAL HDLG DAYS]
           ,[FNMA STATUS EFFECTIVE DATE]
           ,[co_fnma_stat_eff_dt_null]
           ,[DEFAULT RESTRUCTURED FLAG]
           ,[FNMA STATUS EXPIRATION DATE]
           ,[co_fnma_stat_ex_null]
           ,[SPEC SERVICING REQ INDICATOR]
           ,[IMMINENT DEFAULT INDICATOR]
           ,[IMMINENT DEFLT INDICATOR DATE]
           ,[co_imm_dflt_cd_null]
           ,[HIGH RISK ALT A CODE]
           ,[IMMINENT DEFAULT FICO SCORE]
           ,[IMMINENT DEFAULT FICO DATE]
           ,[co_im_dflt_fico_null]
           ,[RECOVERY STATUS CODE]
           ,[RECOVERY STATUS DATE]
           ,[co_rcvr_stat_null]
           ,[SHORT PAYMENT CORP ADV BALANCE]
           ,[LATE CHARGE CODE CHANGE DATE]
           ,[co_lc_cd_chg_null]
           ,[PARTIAL LATE CHARGE IND CODE]
           ,[PARTIAL LATE CHRG IND CHG DATE]
           ,[co_prtl_lt_ind_null]
           ,[LATE CHARGE VALIDATION CODE]
           ,[LATE CHARGE VALIDATION USER ID]
           ,[LATE CHARGE VALIDATION DATE]
           ,[co_lc_vldtn_dt_null]
           ,[DELQ NOTICE SENT DATE]
           ,[co_dlq_ntce_snt_null]
           ,[DELQ HISTORY EXCLUDE CODE]
           ,[load_date]
           ,[SID]
		   from [10.0.15.10].bdesime.dbo.delinquency
where [LOAN NUMBER] in (select distinct ln_no from bde_data.dbo.loan)

*/


select * from