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

sub-job

MNEye · Load-NextGen-Data

called by Daily-Processing-Source-Data

sub-job MNEye/Load-NextGen-Data · db MNEye_ProdMirror · updated 2026-05-29

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-NextGen-Data

16 tasks · MNEye
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. DownloadDownload
    Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
    server=MNEye_ProdMirror-mdcssh-sftpremote directory=/local directory={SourceDataFolder}
  2. Download FilesExecuteProcessdisabled
    command={SSHToolPath}\SSH.exeserver=MNEye_ProdMirror-mdcssh-sftpDISABLED
  3. Load AppointmentsLoadFile
    writes ImportAppointments
    data file spec=ImportAppointmentsimport mode=Replace
  4. Load PatientsLoadFile
    writes ImportPatients
    data file spec=ImportPatientsfile path={SourceDataFolder}\ExportPatient.txtimport mode=Replace
  5. Load Patient InsuranceLoadFile
    writes ImportPatientInsurance
    data file spec=ImportPatientInsuranceimport mode=Replace
  6. Load PayerLoadFile
    writes ImportPayer
    data file spec=ImportPayerfile path={SourceDataFolder}\ExportPayer.txtimport mode=Replace
  7. Load ProvidersLoadFile
    writes ImportProviders
    data file spec=ImportProvidersfile path={SourceDataFolder}\ExportProviders.txtimport mode=Replace
  8. Load ChargeMasterLoadFile
    writes ImportChargeMaster
    data file spec=ImportChargeMasterimport mode=Replace
  9. Load EncountersLoadFile
    writes ImportEncounters
    data file spec=ImportEncountersfile path={SourceDataFolder}\ExportEncounters.txtimport mode=Replace
  10. Load ChargesLoadFile
    writes ImportCharges
    data file spec=ImportChargesfile path={SourceDataFolder}\ExportCharges.txtimport mode=Replace
  11. Load AdjustmentsLoadFile
    writes ImportAdjustments
    data file spec=ImportAdjustmentsimport mode=Replace
  12. Load TransactionDetailLoadFile
    writes ImportTransactionDetail
    data file spec=ImportTransactionDetailimport mode=Replace
  13. Load Encounter InsuranceLoadFile
    writes ImportEncounterInsurance
    data file spec=ImportEncounterInsuranceimport mode=Replace
  14. Load LocationsLoadFile
    writes ImportLocations
    data file spec=ImportLocationsfile path={SourceDataFolder}\ExportLocation.txtimport mode=Replace
  15. Load EventLoadFile
    writes ImportEvent
    data file spec=ImportEventfile path={SourceDataFolder}\ExportEvent.txtimport mode=Replace
  16. Archive FilesExecuteProcess
    command=cmd.exe