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

sub-job

SunLife · Load-ECW-Files

called by Daily-Visits-Processing

sub-job SunLife/Load-ECW-Files · db SunLife_ProdMirror · updated 2025-09-17

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

Load-ECW-Files

12 tasks · SunLife
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. ▶Download-ECW-Filessub-job · 1↗
    1. Download ECW Files from SFTPDownload
      Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
      server=SunLife_ProdMirror-mdcssh-sftpremote directory=/local directory=D:\ClientData\SunLife
  2. Process ExportEncounterProcessFile
    writes ImportEncounterSourceEncounter
    archive directory=D:\ClientData\SunLife\Archivebase table name=Encounterrow terminator=Newline
  3. Process ExportPatientInsuranceProcessFile
    writes ImportPatientInsuranceSourcePatientInsurance
    archive directory=D:\ClientData\SunLife\Archivebase table name=PatientInsurancerow terminator=Newline
  4. Process ExportChargeItemsProcessFile
    writes ImportChargeItemsSourceChargeItems
    archive directory=D:\ClientData\SunLife\Archivebase table name=ChargeItemsrow terminator=Newline
  5. Process ExportDoctorsProcessFile
    writes ImportDoctorsSourceDoctors
    file path=D:\ClientData\SunLife\ExportDoctors.txtarchive directory=D:\ClientData\SunLife\Archivebase table name=Doctorsrow terminator=Newline
  6. Process ExportFacilitiesProcessFile
    writes ImportFacilitiesSourceFacilities
    archive directory=D:\ClientData\SunLife\Archivebase table name=Facilitiesrow terminator=Newline
  7. Process ExportFeeScheduleProcessFile
    writes ImportFeeScheduleSourceFeeSchedule
    archive directory=D:\ClientData\SunLife\Archivebase table name=FeeSchedulerow terminator=Newline
  8. Process ExportChargeMasterProcessFile
    archive directory=D:\ClientData\SunLife\Archiverow terminator=Newline
  9. Process ExportInsuranceProcessFile
    writes ImportInsuranceSourceInsurance
    archive directory=D:\ClientData\SunLife\Archivebase table name=Insurancerow terminator=Newline
  10. Process ExportPatientsProcessFile
    writes ImportPatientsSourcePatients
    archive directory=D:\ClientData\SunLife\Archivebase table name=Patientsrow terminator=Newline
  11. Process ExportVisitCodesProcessFile
    writes ImportVisitCodesSourceVisitCodes
    archive directory=D:\ClientData\SunLife\Archivebase table name=VisitCodesrow terminator=Newline
  12. Process Export VisitStatusProcessFile
    writes ImportVisitStatusSourceVisitStatus
    archive directory=D:\ClientData\SunLife\Archivebase table name=VisitStatusrow terminator=Newline