dpu-daily-capri-current-topbox

dpu-daily-capri-current-topbox dpu-daily-capri-current-srcfile-chk dpu-daily-capri-current-trg-watch dpu-daily-capri-current-emptyworkdir dpu-daily-capri-current-insert-audit dpu-daily-capri-rundate-param-extract dpu-daily-capri-current-xfmrefredeemstatus-----------------------(1-1) XfmRefRedemStatus source: REF_REDEM_STATUS,MARITZ_DTL_SETTLE_ACTV ----target: STG_XFM_REF_REDEM_STATUS,Ref_RedemStatus.txt dpu-daily-capri-current-xfmrefrecontype-----------------------(1-2) XfmRefReconType source: REF_RECON_TYPE,MARITZ_DTL_SETTLE_ACTV,MARITZ_SUMM_SETTLE_DTL----- target: STG_XFM_REF_RECON_TYPE,Ref_ReconType.txt dpu-daily-capri-current-xfmrefparticipanttype-----------------------(1-3) XfmRefParticipantType source: REF_PARTICIPANT_TYPE,MARITZ_DTL_SETTLE_ACTV -----target: STG_XFM_REF_PARTICIPANT_TYPE,Ref_ParticipantType.txt dpu-daily-capri-current-xfmvendorredemdlysettlement-----------------(6) s(2-2,3,4,5) XfmVendorRedemDlySettlement source: MARITZ_DTL_SETTLE_ACTV,Ref_ReconType.txt,Ref_RedemStatus.txt,Ref_ParticipantType.txt,dset_alpha_travel_credit_lkp.ds ------------target: STG_XFM_VENDOR_REDEM_DLY_SETTL,LD_ETLERREVNT_XfmVendorRedemDlySettlement.dat dpu-daily-capri-current-xfmvendorredemdlysummary-----------------(2-1) s(1-2) XfmVendorRedemDlySummary source: MARITZ_SUMM_SETTLE_DTL,MARITZ_SUMM_SETTLE_HDR,VENDOR_REDEM_DLY_SUMMARY_DTL -------traget: .STG_XFM_REDEM_DLY_SUMMARY_DTL,STG_XFM_REDEM_DLY_SUMMARY_HDR,LD_ETLERREVNT_XfmVendorRedemDlySummary.dat, dpu-daily-capri-current-xfmtsysredemdlysettlement1a-----------------(7-1) s(2-1,6) XfmTsysRedemDlySettlement1a source: TSYS_TRAVEL_RWD_REDEM,TSYS_REDEM_DLY_SETTLEMENT ------target: STG_XFM_TSYS_REDEM_DLY_SETTL,OUT_MaritzReconciliationPar.dat dpu-daily-capri-current-xfmtsysredemdlysettlement1b-----------------(8-1) s(7) XfmTsysRedemDlySettlement1b source: STG_XFM_TSYS_REDEM_DLY_SETTL ------ Target: TEMP_TSYS_MULTI_REC dpu-daily-capri-current-xfmmaritzsummaryrecon1a---------------------(7-2) s(2-1,6) XfmMaritzSummaryRecon1a source: STG_XFM_REDEM_DLY_SUMMARY_HDR,STG_XFM_REDEM_DLY_SUMMARY_DTL,STG_XFM_VENDOR_REDEM_DLY_SETTL,VENDOR_DTL_SUMM_RECON_REPT ------target:STG_XFM_VENDOR_SUM_RECON_REPT dpu-daily-capri-current-xfmmaritzsummaryrecon1b---------------------(8-2) s(7-2) XfmMaritzSummaryRecon1b source: STG_XFM_VENDOR_SUM_RECON_REPT -----target: OUT_MaritzReconciliationTransRpt_Multi.dat dpu-daily-capri-current-batchxfmmaritzsummaryout--------------------(9) s(8-2) BatchXfmMaritzSummaryOut(XfmMaritzSummaryOutPrep) source: OUT_MaritzReconciliationTransRpt_Multi.dat,XfmMaritzSummaryOutPrep_HdrTlr.dat -----target: /OUT_MaritzReconciliationTransRpt_Hdr.dat,OUT_MaritzReconciliationTransRpt_Tlr.dat,OUT_MaritzReconciliationTransRpt_Dtl_#FileDate#.dat(Out_MaritzReconciliationTransRpt_#FileDate#.dat) dpu-daily-capri-current-xfmtsysmaritzrecon1a------------------------(10) s(7-1,6) XfmTsysMaritzRecon1a source: STG_XFM_VENDOR_REDEM_DLY_SETTL,TEMP_TSYS_MULTI_REC ----target: XfmTsysMaritzRecon_TsysUnmatch.dat,XfmTsysMaritzRecon_MaritzUnmatch.dat,XfmTsysMaritzRecon_FoundNotMatch.dat,STG_XFM_VENDOR_REDEM_DLY_SETTL(update),TEMP_DUP_VENDOR_SETTL,(XfmTsysMaritzRecon_NotMatch.dat) dpu-daily-capri-current-xfmtsysmaritzrecon2b------------------------(11) s(10) XfmTsysMaritzRecon2b source: TEMP_DUP_VENDOR_SETTL ----target: STG_XFM_VENDOR_REDEM_DLY_SETTL(update),STG_XFM_TSYS_REDEM_DLY_SETTL(update) dpu-daily-capri-current-xfmreconreptdup-----------------------------(12) s(11) XfmReconReptDup source: VENDOR_RECON_DTL_REPT,TEMP_DUP_VENDOR_SETTL,VENDOR_REDEM_DLY_SETTLEMENT -------target: STG_XFM_VENDOR_REDEM_DLY_SETTL(update),VENDOR_REDEM_DLY_SETTLEMENT(update),XfmHistoricalRecon_DailyFound_Can.dat,XfmHistoricalRecon_DailyFound_Ret.dat,XfmHistoricalRecon_DailyFound.dat,XfmHistoricalRecon_PreviousFound.dat dpu-daily-capri-current-xfmmaritzhistoricalshippedrecon-a ---------(13) s(8-2,11,12) XfmMaritzHistoricalShippedRecon_a source: TEMP_XFM_VENDOR_SETTLE,STG_XFM_VENDOR_REDEM_DLY_SETTL -----target: Maritz_Pending_tpm.txt,StgXfmVendorRedemDlySettl_Pending_Flg.ds,VENDOR_REDEM_DLY_SETTLEMENT(update),TempXfmVendorSettleUpdShp.ds,XfmMaritzShipped_daily_MisDup.dat dpu-daily-capri-current-xfmmaritzhistoricalshippedrecon-b ---------(14) s(13) XfmMaritzHistoricalShippedRecon_b source: StgXfmVendorRedemDlySettl_Pending_Flg.ds,TempXfmVendorSettleUpdShp.ds -----target: STG_XFM_VENDOR_REDEM_DLY_SETTL(update),TEMP_XFM_VENDOR_SETTLE(update) dpu-daily-capri-current-xfmmaritzhistoricalshippedrecon0a ---------(15) s(14) XfmMaritzHistoricalShippedRecon0a source: STG_XFM_VENDOR_REDEM_DLY_SETTL,Maritz_Pending_tpm.txt ---target: StgXfmVendorRedemDlySettl_upd.ds,StgXfmVendorRedemDlySettl_Pendflagds.ds,StgXfmVendorRedemDlySettl_Pednflagtempds.ds dpu-daily-capri-current-xfmmaritzhistoricalshippedrecon0b ---------(16) s(15) XfmMaritzHistoricalShippedRecon0b source: StgXfmVendorRedemDlySettl_Pendflagds.ds,StgXfmVendorRedemDlySettl_upd.ds,StgXfmVendorRedemDlySettl_Pednflagtempds.ds ----target: VENDOR_REDEM_DLY_SETTLEMENT(update),STG_XFM_VENDOR_REDEM_DLY_SETTL(update),TEMP_XFM_VENDOR_SETTLE(update) dpu-daily-capri-current-xfmmaritzhistoricalshippedrecon2 -----------(17) s(16) XfmMaritzHistoricalShippedRecon2 source: STG_XFM_VENDOR_REDEM_DLY_SETTL,Maritz_Pending_tpm.txt -------target: STG_XFM_VENDOR_REDEM_DLY_SETTL (update) dpu-daily-capri-current-xfmmaritzhistoricalshippedrecon3 ---------(18) s(17) XfmMaritzHistoricalShippedRecon3 source: Maritz_Pending_tpm.txt,STG_XFM_VENDOR_REDEM_DLY_SETTL ---target: STG_XFM_VENDOR_REDEM_DLY_SETTL(update) dpu-daily-capri-current-xfmmaritzhistoricalshippedrecon1 ---------(19) s(18) XfmMaritzHistoricalShippedRecon1 source: TEMP_XFM_VENDOR_SETTLE,XfmMaritzShipped_daily_MisDup.dat ----target: XfmHistoricalRecon_DailyFound_Mis.dat,XfmHistoricalRecon_DailyFound_Dup.dat,XfmHistoricalRecon_DailyFound_PtsMis.dat(XfmMaritzHistoricalRecon_Found.dat) dpu-daily-capri-current-batchxfmmaritztsyshistreconreptout ---------(20) S(19) BatchXfmMaritzTsysHistReconReptOut(XfmMaritzTransReptPrep) source: XfmTsysMaritzRecon_NotMatch.dat,VENDOR_RECON_DTL_REPT,STG_XFM_VENDOR_RECON_DTL_REPT ---target: STG_XFM_VENDOR_RECON_DTL_REPT(update,insert) dpu-daily-capri-current-loading-box --------------------------------(21) s(20) dpu-daily-capri-current-stgerroreventdetails --------------------(22) StgCapriEtlErrorEventDetails source: CombinedEtlErrorDetails.dat -----target: ETL_ERROR_EVENT_DETAILS(append)(CombinedEtlErrorDetails.dat) dpu-daily-capri-current-lderroreventdetails --------------------(23) s(22) LdCapriEtlErrorEventDetails source: ETL_ERROR_EVENT_DETAILS ------target:ETL_ERROR_EVENT_DETAILS dpu-daily-capri-current-ldrefredeemstatus --------(24) LdRefRedemStatus source: REF_REDEM_STATUS dpu-daily-capri-current-ldrefrecontype --------(25) LdRefReconType source:REF_RECON_TYPE dpu-daily-capri-current-ldrefparticipanttype ---------(26) LdRefParticipantType source: REF_PARTICIPANT_TYPE dpu-daily-capri-current-ldtsysredemdlysettlement ---------(27) LdTsysRedemDlySettlement source: TSYS_REDEM_DLY_SETTLEMENT dpu-daily-capri-current-ldvendorredemdlysettlement ---------(28) LdVendorRedemDlySettlement source: VENDOR_REDEM_DLY_SETTLEMENT dpu-daily-capri-current-ldvendorredemdlysumhdr ---------(29) LdVendorRedemDlySumHdr source:VENDOR_REDEM_DLY_SUMMARY_HDR dpu-daily-capri-current-ldvendorredemdlysumdtl ---------(30) LdVendorRedemDlySumDtl source: VENDOR_REDEM_DLY_SUMMARY_DTL dpu-daily-capri-current-ldvendorrecondtlrept ---------(31) LdVendorReconDtlRept source: VENDOR_RECON_DTL_REPT dpu-daily-capri-current-ldvendordtlsummreconrept ---------(32) LdVendorDtlSummReconRept source: VENDOR_DTL_SUMM_RECON_REPT dpu-daily-capri-current-xfmupdatevendorhistory ---------(33) XfmUpdateVendorHistory source: XfmTsysMaritzRecon_NotMatch.dat,XfmMaritzCompRecon_HdrTlr.dat,VENDOR_RECON_DTL_REPT ---target: OUT_MaritzComparisonTransRpt_Dtl_#CIBC_DPU_LOCAL_PARM.DPU_RunDate#.dat,OUT_MaritzComparisonTransRpt_Hdr.dat,OUT_MaritzComparisonTransRpt_Tlr.dat(Out_MaritzComparisonTransRpt_#CIBC_DPU_LOCAL_PARM.DPU_RunDate#.dat) dpu-daily-capri-current-xfmupdatehistoricalshippedrecon ---------(34) XfmUpdateHistoricalShippedRecon source: TEMP_HIS_VENDOR_SETTL,VENDOR_RECON_DTL_REPT -----target: VENDOR_RECON_DTL_REPT(update),Vendor_Recon_rept.txt,VENDOR_REDEM_DLY_SETTLEMENT (update) dpu-daily-capri-current-outmaritzreconfiles-mv dpu-daily-capri-current-feedhubmaritzrecon-send dpu-daily-capri-current-update-audit dpu-daily-capri-current-trg-rm dpu-daily-capri-current-xfmupdateawardoptionset ---------(35) s(34,28) XfmUpdateAwardOptionSet source: VENDOR_REDEM_DLY_SETTLEMENT,REF_PRODUCT -----target: VENDOR_REDEM_DLY_SETTLEMENT(update) dpu-daily-capri-current-meritz-vendar-redeem ---------(36) S(35) XfmMeritzVendarRedem source: VENDOR_REDEM_DLY_SETTLEMENT,TSYS_TRAVEL_RWD_REDEM ----target: VENDOR_REDEM_DLY_SETTLEMENT(update) dpu-daily-capri-current-outmaritzreconfiles-bkp dpu-daily-capri-dlysettlactv-tempalpha---------------------------(2-2) s(1) Xfm_DetlSettleActv_Temp_Alpha source: MARITZ_DTL_SETTLE_ACTV,TEMP_ALPHA_CURR,dset_alpha_travel_credit_currday_init.ds,dset_alpha_travel_credit_duplicates.ds,dset_alpha_travel_credit_hist_duplicates.ds,dset_alpha_travel_credit_cost_rej.ds,dset_alpha_travel_credit_currday.ds,dset_alpha_travel_credit_pair_return.ds,dset_alpha_travel_credit_no_pair_return.ds,dset_alpha_travel_credit_no_pair_ship.ds,dset_alpha_travel_credit_pair_ship.ds dpu-daily-capri-dlysettlactv-tempalpha-rej----------------------(5) s(4) XfMaritz_DetlSettleActv_Temp_Alpha_Rej source: dset_alpha_travel_credit_pair_ship.ds,dset_alpha_travel_credit_no_pair_ship_final.ds,dset_alpha_travel_credit_ship_duplicate.ds,dset_alpha_travel_credit_cost_rej.ds,dset_alpha_travel_credit_pair_return.ds,dset_alpha_travel_credit_no_pair_return_final.ds,dset_alpha_travel_credit_currday.ds,dset_alpha_travel_credit_duplicates.ds,dset_alpha_travel_credit_hist_duplicates.ds,TSYS_CIF_CONSUMER_ACCOUNT_LATEST,ref_product -------------------------target:TEMP_ALPHA_TRAVEL_CREDIT_REJ,TEMP_ALPHA_CURR,TEMP_ALPHA_HIST,MARITZ_ALPHA_TRAVEL_CREDIT_REJ,dset_alpha_travel_credit_lkp.ds dpu-daily-capri-dlysettlactv-tempalpha-ship-nopair--------------(3) s(2-2) Xfm_DetlSettleActv_Temp_Alpha_Ship_NoPair source: dset_alpha_travel_credit_no_pair_ship.ds,temp_alpha_curr,dset_alpha_travel_credit_no_pair_return.ds -----target: dset_alpha_travel_credit_ship_duplicate.ds,dset_alpha_travel_credit_no_pair_ship_final.ds dpu-daily-capri-dlysettlactv-tempalpha-return-nopair------------(4) s(3) Xfm_DetlSettleActv_Temp_Alpha_Return_NoPair source: dset_alpha_travel_credit_no_pair_return.ds,dset_alpha_travel_credit_no_pair_ship_final.ds,TEMP_ALPHA_CURR --------- target: dset_alpha_travel_credit_no_pair_return_final.ds