Legacy Pipeline Atlas worker-1snapshot 2026-07-15

sub-job

MiddletownMedical · RevFind-Source-Load-PM-Data

Main job that calls all other Source jobs to load each file

called by RevFind-Daily-Processing

sub-job MiddletownMedical/RevFind-Source-Load-PM-Data · db MiddletownMedical_ProdMirror · updated 2026-06-13

task tree

What the sub-job runs

Tasks in order, each with what it does — typed stepsfrom the MDClarity task docs (click to open the reference), sub-jobsyou can expand inline (▶) to reveal their own tasks, and SQL steps summarized by Gemini (✨). Every step shows the tables it writes/reads and which earlier step it feeds from(sqlglot lineage).

sub-job

RevFind-Source-Load-PM-Data

18 tasks · MiddletownMedical
sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc
  1. DownloadDownloaddisabled
    Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
    host=mdcssh.mymdclarity.comprotocol=Sftpremote directory=/local directory={SourceDataFolder}remote archive directory=/Archive/
  2. Download from S3ExecuteProcess
    command=powershell.exe
  3. ▶RevFind-Source-Load-ECW-ChargeItemssub-job · 1↗
    1. Load ECW ExportChargeItemsProcessFile
      writes ImportECWChargeItemsSourceECWChargeItems
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWChargeItemsrow terminator=Newline
  4. ▶RevFind-Source-Load-ECW-Doctorssub-job · 1↗
    1. Load ECW ExportDoctorsProcessFile
      writes ImportECWDoctorsSourceECWDoctors
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWDoctorsrow terminator=Newline
  5. ▶RevFind-Source-Load-ECW-EdiInvAdjustmentssub-job · 1↗
    1. Load ECW EdiInvAdjustmentsProcessFile
      writes ImportECWEdiInvAdjustmentsSourceECWEdiInvAdjustments
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiInvAdjustmentsrow terminator=Newline
  6. ▶RevFind-Source-Load-ECW-EdiInvCPTsub-job · 1↗
    1. Load ECW EdiInvCPTProcessFile
      writes ImportECWEdiInvCPTSourceECWEdiInvCPT
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiInvCPTrow terminator=Newline
  7. ▶RevFind-Source-Load-ECW-EdiInvDiagnosissub-job · 1↗
    1. Load ECW ExportEdiInvDiagnosisProcessFile
      writes ImportECWEdiInvDiagnosisSourceECWEdiInvDiagnosis
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiInvDiagnosisrow terminator=Newline
  8. ▶RevFind-Source-Load-ECW-EdiInvEobCassub-job · 1↗
    1. Load ECW ExportEdiInvEobCasProcessFile
      writes ImportECWEdiInvEobCasSourceECWEdiInvEobCas
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiInvEobCasrow terminator=Newline
  9. ▶RevFind-Source-Load-ECW-EdiInvEobsub-job · 1↗
    1. Load ECW ExportEdiInvEobProcessFile
      writes ImportECWEdiInvEOBSourceECWEdiInvEOB
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiInvEOBrow terminator=Newline
  10. ▶RevFind-Source-Load-ECW-EdiInvInsurancesub-job · 1↗
    1. Load ECW Export EdiInvInsuranceProcessFile
      writes ImportECWEdiInvInsuranceSourceECWEdiInvInsurance
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiInvInsurancerow terminator=Newline
  11. ▶RevFind-Source-Load-ECW-EdiInvoicesub-job · 1↗
    1. Load ECW ExportEdiInvoiceProcessFile
      writes ImportECWEdiInvoiceSourceECWEdiInvoice
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiInvoicerow terminator=Newline
  12. ▶RevFind-Source-Load-ECW-EdiPaymentDetailsub-job · 1↗
    1. Load ECW ExportEdiPaymentDetailProcessFile
      writes ImportECWEdiPaymentDetailSourceECWEdiPaymentDetail
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiPaymentDetailrow terminator=Newline
  13. ▶RevFind-Source-Load-ECW-EdiRemarkCodessub-job · 1↗
    1. Load ECW ExportEdiRemarkCodesProcessFile
      writes ImportECWEdiRemarkCodesSourceECWEdiRemarkCodes
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWEdiRemarkCodesrow terminator=Newline
  14. ▶RevFind-Source-Load-ECW-Facilitiessub-job · 1↗
    1. Load ECW FacilitiesProcessFile
      writes ImportECWFacilitiesSourceECWFacilities
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWFacilitiesrow terminator=Newline
  15. ▶RevFind-Source-Load-ECW-FeeSchedulesub-job · 1↗
    1. Load ECW ExportFeeScheduleProcessFile
      writes ImportECWFeeScheduleSourceECWFeeSchedule
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWFeeSchedulerow terminator=Newline
  16. ▶RevFind-Source-Load-ECW-Insurancesub-job · 1↗
    1. Load ECW ExportInsuranceProcessFile
      writes ImportECWInsuranceSourceECWInsurance
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWInsurancerow terminator=Newline
  17. ▶RevFind-Source-Load-ECW-PatientInsurancesub-job · 1↗
    1. Load ECW ExportPatientInsuranceProcessFile
      writes ImportECWPatientInsuranceSourceECWPatientInsurance
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWPatientInsurancerow terminator=Newline
  18. ▶RevFind-Source-Load-ECW-Patientssub-job · 1↗
    1. Load ECW ExportPatientsProcessFile
      writes ImportECWPatientsSourceECWPatients
      file path={FilePath}archive directory={SourceDataArchiveECW}base table name=ECWPatientsrow terminator=Newline