CREATE OR REPLACE TABLE POC_DB.ODSFISRV.save_copy_errors AS SELECT * FROM TABLE(VALIDATE(POC_DB.ODSFISRV.temp, JOB_ID=>'_last')); MERGE INTO ORIG_LOAN USING POC_DB.ODSFISRV.temp ON ORIG_LOAN."LOAN_NUMBER"=POC_DB.ODSFISRV.temp."LOAN_NUMBER" WHEN NOT MATCHED THEN INSERT ("LOAN_NUMBER", "ML_ORIG_EFF_YLD", "ML_CANCEL_DATE", "ML_REPAIR_FUNDS", "ML_APPL_DATE", "ML_CENSUS_TRACT_NBR", "ML_RBP_STREAM_REFI", "ML_PUR_CODE", "ML_DAYS_CLS", "ML_MTGOR_PD_PTS_OT", "ML_SELLER_ID", "ML_ORIG_STAT_CD", "ML_INT_REFI_CODE", "ML_ORIGIN_DATE", "ML_ORIGIN_BAL", "ML_APPRA_DATE", "ML_APPRA_VALUE", "ML_SALE_PRICE", "ML_TERM_CLOS", "ML_COLLATERAL_FLAG", "ML_BRCH_MGR", "ML_CUSTODIAN_NO", "ML_PAST_POINTS_YTD", "ML_COUNS_CD", "ML_AUDIT_DATE", "ML_SIGN_DATE", "ML_PP_EXP_DT_NOTE", "ML_REFINANCE_IND", "ML_APPRAISAL_TYPE", "ML_HOEPA_ST", "ML_RATE_SPD", "ML_NBR_MINOR", "ML_MIN_INCOME", "ML_SUBPRM_FLG", "ML_EMPL_CODE", "ML_TIC_SEG_IND", "ML_COMMIT_DT", "ML_COMMIT_EXP_DT", "ML_COMMIT_RATE", "ML_ANT_STLMT_DT", "ML_BRANCH", "ML_BANK_NBR", "ML_BRWD_DT", "ML_BRWD_AMT", "ML_PAYF_DT", "ML_PHASE_CD", "ML_ORG_APR_PNTS_FEES", "ML_MTGOR_PD_POINTS", "ML_AMT_FINANCED", "ML_EMORTGAGE_FLAG", "ML_CREDIT_GRADE", "ML_RBP_ORIG_BASE_AMT", "ML_RBP_UFMIP_AMT", "ML_BUYER_ASST_AMT_CD", "ML_BUYER_ASST_AMT", "ML_LN_ORIG_TRAN_OPT", "ML_FASB_ORIG_RATE", "ML_COVERAGE_AH_REQ_CODE", "ML_COVERAGE_CL_REQ_CODE", "ML_COVERAGE_GAP_REQ_CODE", "ML_COVERAGE_IUI_REQ_CODE", "ML_COVERAGE_UD1_REQ_CODE", "ML_COVERAGE_UD2_REQ_CODE", "ML_COVERAGE_UD3_REQ_CODE", "ML_UCC_COLL", "ML_ORIG_RECOVERY_BALANCE", "ML_SETUP_DATE", "ML_INITIAL_STMNT_IND", "ML_STMNT_DATE_IND", "ML_TARGET_STMNT_DATE", "ML_TARGET_STMNT_IND", "ML_PRE_POST_FLAG", "ML_CLOSE_ESC_BAL", "ML_CLOSE_ESC_PYMT", "ML_1099_LIAB_IND", "ML_BORR_INTNT_RET_PROP", "ML_BORR_INTNT_RET_DATE", "ML_APPR_ST_LIC_NO", "ML_SUPR_APPR_ST_LIC_NO", "ML_LO_ORIG_CO_ID", "ML_LO_ORIG_ID", "ML_APPR_DOC_FILE_ID", "ML_INTERIM_FUNDER", "ML_1CLOS_COST_TYPE", "ML_2CLOS_COST_TYPE", "ML_3CLOS_COST_TYPE", "ML_4CLOS_COST_TYPE", "ML_1DOWN_PYMT", "ML_2DOWN_PYMT", "ML_3DOWN_PYMT", "ML_4DOWN_PYMT", "ML_HMDA_TYPE", "ML_1FINANCE_SRC_TYPE", "ML_2FINANCE_SRC_TYPE", "ML_LOAN_DISB_DT", "ML_REFI_CASH", "ML_TRANS_TO_INV_DT", "ML_ORIG_MAT_DATE", "ML_FHA_MIP_FILE_DT", "ML_CLTL_CODE", "LAST_UPDT_DATE", "DELETED_FLAG", "ML_QM_ORIGINATION_RISK", "ML_ORIGINATION_ATR", "ML_ORIGINATION_APOR_RATE", "ML_HIGH_COST_CALC_FLAG", "ML_QM_APPLICATION_DT", "ML_JUMBO_LOAN", "ML_CLOSE_COST_FNDS_OTH_DES_1", "ML_CLOSE_COST_FNDS_OTH_DES_2", "ML_CLOSE_COST_FNDS_OTH_DES_3", "ML_CLOSE_COST_FNDS_OTH_DES_4", "ML_CLOSE_COST_SORC_OTH_DES_1", "ML_CLOSE_COST_SORC_OTH_DES_2", "ML_CLOSE_COST_SORC_OTH_DES_3", "ML_CLOSE_COST_SORC_OTH_DES_4", "ML_DOWN_PAY_SORC_OTH_DES_1", "ML_DOWN_PAY_SORC_OTH_DES_2", "ML_DOWN_PAY_SORC_OTH_DES_3", "ML_DOWN_PAY_SORC_OTH_DES_4", "ML_DOWN_PAY_TYP_OTH_DESC_1", "ML_DOWN_PAY_TYP_OTH_DESC_2", "ML_DOWN_PAY_TYP_OTH_DESC_3", "ML_DOWN_PAY_TYP_OTH_DESC_4") VALUES (POC_DB.ODSFISRV.temp."LOAN_NUMBER", POC_DB.ODSFISRV.temp."ML_ORIG_EFF_YLD", POC_DB.ODSFISRV.temp."ML_CANCEL_DATE", POC_DB.ODSFISRV.temp."ML_REPAIR_FUNDS", POC_DB.ODSFISRV.temp."ML_APPL_DATE", POC_DB.ODSFISRV.temp."ML_CENSUS_TRACT_NBR", POC_DB.ODSFISRV.temp."ML_RBP_STREAM_REFI", POC_DB.ODSFISRV.temp."ML_PUR_CODE", POC_DB.ODSFISRV.temp."ML_DAYS_CLS", POC_DB.ODSFISRV.temp."ML_MTGOR_PD_PTS_OT", POC_DB.ODSFISRV.temp."ML_SELLER_ID", POC_DB.ODSFISRV.temp."ML_ORIG_STAT_CD", POC_DB.ODSFISRV.temp."ML_INT_REFI_CODE", POC_DB.ODSFISRV.temp."ML_ORIGIN_DATE", POC_DB.ODSFISRV.temp."ML_ORIGIN_BAL", POC_DB.ODSFISRV.temp."ML_APPRA_DATE", POC_DB.ODSFISRV.temp."ML_APPRA_VALUE", POC_DB.ODSFISRV.temp."ML_SALE_PRICE", POC_DB.ODSFISRV.temp."ML_TERM_CLOS", POC_DB.ODSFISRV.temp."ML_COLLATERAL_FLAG", POC_DB.ODSFISRV.temp."ML_BRCH_MGR", POC_DB.ODSFISRV.temp."ML_CUSTODIAN_NO", POC_DB.ODSFISRV.temp."ML_PAST_POINTS_YTD", POC_DB.ODSFISRV.temp."ML_COUNS_CD", POC_DB.ODSFISRV.temp."ML_AUDIT_DATE", POC_DB.ODSFISRV.temp."ML_SIGN_DATE", POC_DB.ODSFISRV.temp."ML_PP_EXP_DT_NOTE", POC_DB.ODSFISRV.temp."ML_REFINANCE_IND", POC_DB.ODSFISRV.temp."ML_APPRAISAL_TYPE", POC_DB.ODSFISRV.temp."ML_HOEPA_ST", POC_DB.ODSFISRV.temp."ML_RATE_SPD", POC_DB.ODSFISRV.temp."ML_NBR_MINOR", POC_DB.ODSFISRV.temp."ML_MIN_INCOME", POC_DB.ODSFISRV.temp."ML_SUBPRM_FLG", POC_DB.ODSFISRV.temp."ML_EMPL_CODE", POC_DB.ODSFISRV.temp."ML_TIC_SEG_IND", POC_DB.ODSFISRV.temp."ML_COMMIT_DT", POC_DB.ODSFISRV.temp."ML_COMMIT_EXP_DT", POC_DB.ODSFISRV.temp."ML_COMMIT_RATE", POC_DB.ODSFISRV.temp."ML_ANT_STLMT_DT", POC_DB.ODSFISRV.temp."ML_BRANCH", POC_DB.ODSFISRV.temp."ML_BANK_NBR", POC_DB.ODSFISRV.temp."ML_BRWD_DT", POC_DB.ODSFISRV.temp."ML_BRWD_AMT", POC_DB.ODSFISRV.temp."ML_PAYF_DT", POC_DB.ODSFISRV.temp."ML_PHASE_CD", POC_DB.ODSFISRV.temp."ML_ORG_APR_PNTS_FEES", POC_DB.ODSFISRV.temp."ML_MTGOR_PD_POINTS", POC_DB.ODSFISRV.temp."ML_AMT_FINANCED", POC_DB.ODSFISRV.temp."ML_EMORTGAGE_FLAG", POC_DB.ODSFISRV.temp."ML_CREDIT_GRADE", POC_DB.ODSFISRV.temp."ML_RBP_ORIG_BASE_AMT", POC_DB.ODSFISRV.temp."ML_RBP_UFMIP_AMT", POC_DB.ODSFISRV.temp."ML_BUYER_ASST_AMT_CD", POC_DB.ODSFISRV.temp."ML_BUYER_ASST_AMT", POC_DB.ODSFISRV.temp."ML_LN_ORIG_TRAN_OPT", POC_DB.ODSFISRV.temp."ML_FASB_ORIG_RATE", POC_DB.ODSFISRV.temp."ML_COVERAGE_AH_REQ_CODE", POC_DB.ODSFISRV.temp."ML_COVERAGE_CL_REQ_CODE", POC_DB.ODSFISRV.temp."ML_COVERAGE_GAP_REQ_CODE", POC_DB.ODSFISRV.temp."ML_COVERAGE_IUI_REQ_CODE", POC_DB.ODSFISRV.temp."ML_COVERAGE_UD1_REQ_CODE", POC_DB.ODSFISRV.temp."ML_COVERAGE_UD2_REQ_CODE", POC_DB.ODSFISRV.temp."ML_COVERAGE_UD3_REQ_CODE", POC_DB.ODSFISRV.temp."ML_UCC_COLL", POC_DB.ODSFISRV.temp."ML_ORIG_RECOVERY_BALANCE", POC_DB.ODSFISRV.temp."ML_SETUP_DATE", POC_DB.ODSFISRV.temp."ML_INITIAL_STMNT_IND", POC_DB.ODSFISRV.temp."ML_STMNT_DATE_IND", POC_DB.ODSFISRV.temp."ML_TARGET_STMNT_DATE", POC_DB.ODSFISRV.temp."ML_TARGET_STMNT_IND", POC_DB.ODSFISRV.temp."ML_PRE_POST_FLAG", POC_DB.ODSFISRV.temp."ML_CLOSE_ESC_BAL", POC_DB.ODSFISRV.temp."ML_CLOSE_ESC_PYMT", POC_DB.ODSFISRV.temp."ML_1099_LIAB_IND", POC_DB.ODSFISRV.temp."ML_BORR_INTNT_RET_PROP", POC_DB.ODSFISRV.temp."ML_BORR_INTNT_RET_DATE", POC_DB.ODSFISRV.temp."ML_APPR_ST_LIC_NO", POC_DB.ODSFISRV.temp."ML_SUPR_APPR_ST_LIC_NO", POC_DB.ODSFISRV.temp."ML_LO_ORIG_CO_ID", POC_DB.ODSFISRV.temp."ML_LO_ORIG_ID", POC_DB.ODSFISRV.temp."ML_APPR_DOC_FILE_ID", POC_DB.ODSFISRV.temp."ML_INTERIM_FUNDER", POC_DB.ODSFISRV.temp."ML_1CLOS_COST_TYPE", POC_DB.ODSFISRV.temp."ML_2CLOS_COST_TYPE", POC_DB.ODSFISRV.temp."ML_3CLOS_COST_TYPE", POC_DB.ODSFISRV.temp."ML_4CLOS_COST_TYPE", POC_DB.ODSFISRV.temp."ML_1DOWN_PYMT", POC_DB.ODSFISRV.temp."ML_2DOWN_PYMT", POC_DB.ODSFISRV.temp."ML_3DOWN_PYMT", POC_DB.ODSFISRV.temp."ML_4DOWN_PYMT", POC_DB.ODSFISRV.temp."ML_HMDA_TYPE", POC_DB.ODSFISRV.temp."ML_1FINANCE_SRC_TYPE", POC_DB.ODSFISRV.temp."ML_2FINANCE_SRC_TYPE", POC_DB.ODSFISRV.temp."ML_LOAN_DISB_DT", POC_DB.ODSFISRV.temp."ML_REFI_CASH", POC_DB.ODSFISRV.temp."ML_TRANS_TO_INV_DT", POC_DB.ODSFISRV.temp."ML_ORIG_MAT_DATE", POC_DB.ODSFISRV.temp."ML_FHA_MIP_FILE_DT", POC_DB.ODSFISRV.temp."ML_CLTL_CODE", POC_DB.ODSFISRV.temp."LAST_UPDT_DATE", POC_DB.ODSFISRV.temp."DELETED_FLAG", POC_DB.ODSFISRV.temp."ML_QM_ORIGINATION_RISK", POC_DB.ODSFISRV.temp."ML_ORIGINATION_ATR", POC_DB.ODSFISRV.temp."ML_ORIGINATION_APOR_RATE", POC_DB.ODSFISRV.temp."ML_HIGH_COST_CALC_FLAG", POC_DB.ODSFISRV.temp."ML_QM_APPLICATION_DT", POC_DB.ODSFISRV.temp."ML_JUMBO_LOAN", POC_DB.ODSFISRV.temp."ML_CLOSE_COST_FNDS_OTH_DES_1", POC_DB.ODSFISRV.temp."ML_CLOSE_COST_FNDS_OTH_DES_2", POC_DB.ODSFISRV.temp."ML_CLOSE_COST_FNDS_OTH_DES_3", POC_DB.ODSFISRV.temp."ML_CLOSE_COST_FNDS_OTH_DES_4", POC_DB.ODSFISRV.temp."ML_CLOSE_COST_SORC_OTH_DES_1", POC_DB.ODSFISRV.temp."ML_CLOSE_COST_SORC_OTH_DES_2", POC_DB.ODSFISRV.temp."ML_CLOSE_COST_SORC_OTH_DES_3", POC_DB.ODSFISRV.temp."ML_CLOSE_COST_SORC_OTH_DES_4", POC_DB.ODSFISRV.temp."ML_DOWN_PAY_SORC_OTH_DES_1", POC_DB.ODSFISRV.temp."ML_DOWN_PAY_SORC_OTH_DES_2", POC_DB.ODSFISRV.temp."ML_DOWN_PAY_SORC_OTH_DES_3", POC_DB.ODSFISRV.temp."ML_DOWN_PAY_SORC_OTH_DES_4", POC_DB.ODSFISRV.temp."ML_DOWN_PAY_TYP_OTH_DESC_1", POC_DB.ODSFISRV.temp."ML_DOWN_PAY_TYP_OTH_DESC_2", POC_DB.ODSFISRV.temp."ML_DOWN_PAY_TYP_OTH_DESC_3", POC_DB.ODSFISRV.temp."ML_DOWN_PAY_TYP_OTH_DESC_4") WHEN MATCHED THEN UPDATE SET "ML_ORIG_EFF_YLD"=POC_DB.ODSFISRV.temp."ML_ORIG_EFF_YLD", "ML_CANCEL_DATE"=POC_DB.ODSFISRV.temp."ML_CANCEL_DATE", "ML_REPAIR_FUNDS"=POC_DB.ODSFISRV.temp."ML_REPAIR_FUNDS", "ML_APPL_DATE"=POC_DB.ODSFISRV.temp."ML_APPL_DATE", "ML_CENSUS_TRACT_NBR"=POC_DB.ODSFISRV.temp."ML_CENSUS_TRACT_NBR", "ML_RBP_STREAM_REFI"=POC_DB.ODSFISRV.temp."ML_RBP_STREAM_REFI", "ML_PUR_CODE"=POC_DB.ODSFISRV.temp."ML_PUR_CODE", "ML_DAYS_CLS"=POC_DB.ODSFISRV.temp."ML_DAYS_CLS", "ML_MTGOR_PD_PTS_OT"=POC_DB.ODSFISRV.temp."ML_MTGOR_PD_PTS_OT", "ML_SELLER_ID"=POC_DB.ODSFISRV.temp."ML_SELLER_ID", "ML_ORIG_STAT_CD"=POC_DB.ODSFISRV.temp."ML_ORIG_STAT_CD", "ML_INT_REFI_CODE"=POC_DB.ODSFISRV.temp."ML_INT_REFI_CODE", "ML_ORIGIN_DATE"=POC_DB.ODSFISRV.temp."ML_ORIGIN_DATE", "ML_ORIGIN_BAL"=POC_DB.ODSFISRV.temp."ML_ORIGIN_BAL", "ML_APPRA_DATE"=POC_DB.ODSFISRV.temp."ML_APPRA_DATE", "ML_APPRA_VALUE"=POC_DB.ODSFISRV.temp."ML_APPRA_VALUE", "ML_SALE_PRICE"=POC_DB.ODSFISRV.temp."ML_SALE_PRICE", "ML_TERM_CLOS"=POC_DB.ODSFISRV.temp."ML_TERM_CLOS", "ML_COLLATERAL_FLAG"=POC_DB.ODSFISRV.temp."ML_COLLATERAL_FLAG", "ML_BRCH_MGR"=POC_DB.ODSFISRV.temp."ML_BRCH_MGR", "ML_CUSTODIAN_NO"=POC_DB.ODSFISRV.temp."ML_CUSTODIAN_NO", "ML_PAST_POINTS_YTD"=POC_DB.ODSFISRV.temp."ML_PAST_POINTS_YTD", "ML_COUNS_CD"=POC_DB.ODSFISRV.temp."ML_COUNS_CD", "ML_AUDIT_DATE"=POC_DB.ODSFISRV.temp."ML_AUDIT_DATE", "ML_SIGN_DATE"=POC_DB.ODSFISRV.temp."ML_SIGN_DATE", "ML_PP_EXP_DT_NOTE"=POC_DB.ODSFISRV.temp."ML_PP_EXP_DT_NOTE", "ML_REFINANCE_IND"=POC_DB.ODSFISRV.temp."ML_REFINANCE_IND", "ML_APPRAISAL_TYPE"=POC_DB.ODSFISRV.temp."ML_APPRAISAL_TYPE", "ML_HOEPA_ST"=POC_DB.ODSFISRV.temp."ML_HOEPA_ST", "ML_RATE_SPD"=POC_DB.ODSFISRV.temp."ML_RATE_SPD", "ML_NBR_MINOR"=POC_DB.ODSFISRV.temp."ML_NBR_MINOR", "ML_MIN_INCOME"=POC_DB.ODSFISRV.temp."ML_MIN_INCOME", "ML_SUBPRM_FLG"=POC_DB.ODSFISRV.temp."ML_SUBPRM_FLG", "ML_EMPL_CODE"=POC_DB.ODSFISRV.temp."ML_EMPL_CODE", "ML_TIC_SEG_IND"=POC_DB.ODSFISRV.temp."ML_TIC_SEG_IND", "ML_COMMIT_DT"=POC_DB.ODSFISRV.temp."ML_COMMIT_DT", "ML_COMMIT_EXP_DT"=POC_DB.ODSFISRV.temp."ML_COMMIT_EXP_DT", "ML_COMMIT_RATE"=POC_DB.ODSFISRV.temp."ML_COMMIT_RATE", "ML_ANT_STLMT_DT"=POC_DB.ODSFISRV.temp."ML_ANT_STLMT_DT", "ML_BRANCH"=POC_DB.ODSFISRV.temp."ML_BRANCH", "ML_BANK_NBR"=POC_DB.ODSFISRV.temp."ML_BANK_NBR", "ML_BRWD_DT"=POC_DB.ODSFISRV.temp."ML_BRWD_DT", "ML_BRWD_AMT"=POC_DB.ODSFISRV.temp."ML_BRWD_AMT", "ML_PAYF_DT"=POC_DB.ODSFISRV.temp."ML_PAYF_DT", "ML_PHASE_CD"=POC_DB.ODSFISRV.temp."ML_PHASE_CD", "ML_ORG_APR_PNTS_FEES"=POC_DB.ODSFISRV.temp."ML_ORG_APR_PNTS_FEES", "ML_MTGOR_PD_POINTS"=POC_DB.ODSFISRV.temp."ML_MTGOR_PD_POINTS", "ML_AMT_FINANCED"=POC_DB.ODSFISRV.temp."ML_AMT_FINANCED", "ML_EMORTGAGE_FLAG"=POC_DB.ODSFISRV.temp."ML_EMORTGAGE_FLAG", "ML_CREDIT_GRADE"=POC_DB.ODSFISRV.temp."ML_CREDIT_GRADE", "ML_RBP_ORIG_BASE_AMT"=POC_DB.ODSFISRV.temp."ML_RBP_ORIG_BASE_AMT", "ML_RBP_UFMIP_AMT"=POC_DB.ODSFISRV.temp."ML_RBP_UFMIP_AMT", "ML_BUYER_ASST_AMT_CD"=POC_DB.ODSFISRV.temp."ML_BUYER_ASST_AMT_CD", "ML_BUYER_ASST_AMT"=POC_DB.ODSFISRV.temp."ML_BUYER_ASST_AMT", "ML_LN_ORIG_TRAN_OPT"=POC_DB.ODSFISRV.temp."ML_LN_ORIG_TRAN_OPT", "ML_FASB_ORIG_RATE"=POC_DB.ODSFISRV.temp."ML_FASB_ORIG_RATE", "ML_COVERAGE_AH_REQ_CODE"=POC_DB.ODSFISRV.temp."ML_COVERAGE_AH_REQ_CODE", "ML_COVERAGE_CL_REQ_CODE"=POC_DB.ODSFISRV.temp."ML_COVERAGE_CL_REQ_CODE", "ML_COVERAGE_GAP_REQ_CODE"=POC_DB.ODSFISRV.temp."ML_COVERAGE_GAP_REQ_CODE", "ML_COVERAGE_IUI_REQ_CODE"=POC_DB.ODSFISRV.temp."ML_COVERAGE_IUI_REQ_CODE", "ML_COVERAGE_UD1_REQ_CODE"=POC_DB.ODSFISRV.temp."ML_COVERAGE_UD1_REQ_CODE", "ML_COVERAGE_UD2_REQ_CODE"=POC_DB.ODSFISRV.temp."ML_COVERAGE_UD2_REQ_CODE", "ML_COVERAGE_UD3_REQ_CODE"=POC_DB.ODSFISRV.temp."ML_COVERAGE_UD3_REQ_CODE", "ML_UCC_COLL"=POC_DB.ODSFISRV.temp."ML_UCC_COLL", "ML_ORIG_RECOVERY_BALANCE"=POC_DB.ODSFISRV.temp."ML_ORIG_RECOVERY_BALANCE", "ML_SETUP_DATE"=POC_DB.ODSFISRV.temp."ML_SETUP_DATE", "ML_INITIAL_STMNT_IND"=POC_DB.ODSFISRV.temp."ML_INITIAL_STMNT_IND", "ML_STMNT_DATE_IND"=POC_DB.ODSFISRV.temp."ML_STMNT_DATE_IND", "ML_TARGET_STMNT_DATE"=POC_DB.ODSFISRV.temp."ML_TARGET_STMNT_DATE", "ML_TARGET_STMNT_IND"=POC_DB.ODSFISRV.temp."ML_TARGET_STMNT_IND", "ML_PRE_POST_FLAG"=POC_DB.ODSFISRV.temp."ML_PRE_POST_FLAG", "ML_CLOSE_ESC_BAL"=POC_DB.ODSFISRV.temp."ML_CLOSE_ESC_BAL", "ML_CLOSE_ESC_PYMT"=POC_DB.ODSFISRV.temp."ML_CLOSE_ESC_PYMT", "ML_1099_LIAB_IND"=POC_DB.ODSFISRV.temp."ML_1099_LIAB_IND", "ML_BORR_INTNT_RET_PROP"=POC_DB.ODSFISRV.temp."ML_BORR_INTNT_RET_PROP", "ML_BORR_INTNT_RET_DATE"=POC_DB.ODSFISRV.temp."ML_BORR_INTNT_RET_DATE", "ML_APPR_ST_LIC_NO"=POC_DB.ODSFISRV.temp."ML_APPR_ST_LIC_NO", "ML_SUPR_APPR_ST_LIC_NO"=POC_DB.ODSFISRV.temp."ML_SUPR_APPR_ST_LIC_NO", "ML_LO_ORIG_CO_ID"=POC_DB.ODSFISRV.temp."ML_LO_ORIG_CO_ID", "ML_LO_ORIG_ID"=POC_DB.ODSFISRV.temp."ML_LO_ORIG_ID", "ML_APPR_DOC_FILE_ID"=POC_DB.ODSFISRV.temp."ML_APPR_DOC_FILE_ID", "ML_INTERIM_FUNDER"=POC_DB.ODSFISRV.temp."ML_INTERIM_FUNDER", "ML_1CLOS_COST_TYPE"=POC_DB.ODSFISRV.temp."ML_1CLOS_COST_TYPE", "ML_2CLOS_COST_TYPE"=POC_DB.ODSFISRV.temp."ML_2CLOS_COST_TYPE", "ML_3CLOS_COST_TYPE"=POC_DB.ODSFISRV.temp."ML_3CLOS_COST_TYPE", "ML_4CLOS_COST_TYPE"=POC_DB.ODSFISRV.temp."ML_4CLOS_COST_TYPE", "ML_1DOWN_PYMT"=POC_DB.ODSFISRV.temp."ML_1DOWN_PYMT", "ML_2DOWN_PYMT"=POC_DB.ODSFISRV.temp."ML_2DOWN_PYMT", "ML_3DOWN_PYMT"=POC_DB.ODSFISRV.temp."ML_3DOWN_PYMT", "ML_4DOWN_PYMT"=POC_DB.ODSFISRV.temp."ML_4DOWN_PYMT", "ML_HMDA_TYPE"=POC_DB.ODSFISRV.temp."ML_HMDA_TYPE", "ML_1FINANCE_SRC_TYPE"=POC_DB.ODSFISRV.temp."ML_1FINANCE_SRC_TYPE", "ML_2FINANCE_SRC_TYPE"=POC_DB.ODSFISRV.temp."ML_2FINANCE_SRC_TYPE", "ML_LOAN_DISB_DT"=POC_DB.ODSFISRV.temp."ML_LOAN_DISB_DT", "ML_REFI_CASH"=POC_DB.ODSFISRV.temp."ML_REFI_CASH", "ML_TRANS_TO_INV_DT"=POC_DB.ODSFISRV.temp."ML_TRANS_TO_INV_DT", "ML_ORIG_MAT_DATE"=POC_DB.ODSFISRV.temp."ML_ORIG_MAT_DATE", "ML_FHA_MIP_FILE_DT"=POC_DB.ODSFISRV.temp."ML_FHA_MIP_FILE_DT", "ML_CLTL_CODE"=POC_DB.ODSFISRV.temp."ML_CLTL_CODE", "LAST_UPDT_DATE"=POC_DB.ODSFISRV.temp."LAST_UPDT_DATE", "DELETED_FLAG"=POC_DB.ODSFISRV.temp."DELETED_FLAG", "ML_QM_ORIGINATION_RISK"=POC_DB.ODSFISRV.temp."ML_QM_ORIGINATION_RISK", "ML_ORIGINATION_ATR"=POC_DB.ODSFISRV.temp."ML_ORIGINATION_ATR", "ML_ORIGINATION_APOR_RATE"=POC_DB.ODSFISRV.temp."ML_ORIGINATION_APOR_RATE", "ML_HIGH_COST_CALC_FLAG"=POC_DB.ODSFISRV.temp."ML_HIGH_COST_CALC_FLAG", "ML_QM_APPLICATION_DT"=POC_DB.ODSFISRV.temp."ML_QM_APPLICATION_DT", "ML_JUMBO_LOAN"=POC_DB.ODSFISRV.temp."ML_JUMBO_LOAN", "ML_CLOSE_COST_FNDS_OTH_DES_1"=POC_DB.ODSFISRV.temp."ML_CLOSE_COST_FNDS_OTH_DES_1", "ML_CLOSE_COST_FNDS_OTH_DES_2"=POC_DB.ODSFISRV.temp."ML_CLOSE_COST_FNDS_OTH_DES_2", "ML_CLOSE_COST_FNDS_OTH_DES_3"=POC_DB.ODSFISRV.temp."ML_CLOSE_COST_FNDS_OTH_DES_3", "ML_CLOSE_COST_FNDS_OTH_DES_4"=POC_DB.ODSFISRV.temp."ML_CLOSE_COST_FNDS_OTH_DES_4", "ML_CLOSE_COST_SORC_OTH_DES_1"=POC_DB.ODSFISRV.temp."ML_CLOSE_COST_SORC_OTH_DES_1", "ML_CLOSE_COST_SORC_OTH_DES_2"=POC_DB.ODSFISRV.temp."ML_CLOSE_COST_SORC_OTH_DES_2", "ML_CLOSE_COST_SORC_OTH_DES_3"=POC_DB.ODSFISRV.temp."ML_CLOSE_COST_SORC_OTH_DES_3", "ML_CLOSE_COST_SORC_OTH_DES_4"=POC_DB.ODSFISRV.temp."ML_CLOSE_COST_SORC_OTH_DES_4", "ML_DOWN_PAY_SORC_OTH_DES_1"=POC_DB.ODSFISRV.temp."ML_DOWN_PAY_SORC_OTH_DES_1", "ML_DOWN_PAY_SORC_OTH_DES_2"=POC_DB.ODSFISRV.temp."ML_DOWN_PAY_SORC_OTH_DES_2", "ML_DOWN_PAY_SORC_OTH_DES_3"=POC_DB.ODSFISRV.temp."ML_DOWN_PAY_SORC_OTH_DES_3", "ML_DOWN_PAY_SORC_OTH_DES_4"=POC_DB.ODSFISRV.temp."ML_DOWN_PAY_SORC_OTH_DES_4", "ML_DOWN_PAY_TYP_OTH_DESC_1"=POC_DB.ODSFISRV.temp."ML_DOWN_PAY_TYP_OTH_DESC_1", "ML_DOWN_PAY_TYP_OTH_DESC_2"=POC_DB.ODSFISRV.temp."ML_DOWN_PAY_TYP_OTH_DESC_2", "ML_DOWN_PAY_TYP_OTH_DESC_3"=POC_DB.ODSFISRV.temp."ML_DOWN_PAY_TYP_OTH_DESC_3", "ML_DOWN_PAY_TYP_OTH_DESC_4"=POC_DB.ODSFISRV.temp."ML_DOWN_PAY_TYP_OTH_DESC_4"