sub-job

SeaRad · Parse-Appointment-Files

called by Daily-Visit-Processing

sub-job SeaRad/Parse-Appointment-Files · db SeaRad_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

Parse-Appointment-Files

4 tasks · SeaRad

sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc

DownloadDownload
Downloads files from remote FTP or SFTP servers to local directories with support for archiving and parallel transfers.
server=SeaRad_ProdMirror-mdcssh-sftpremote directory=/local directory={SourceDirectory}
▶Download-Filessub-job · 1↗
1. Download FilesExecuteProcess
  command={SSHToolPath}\SSH.exeserver=SeaRad_ProdMirror-mdcssh-sftp
Delete Archived FilesExecuteProcessdisabled
command=cmd.exearguments=/c del /F /Q /A "{ArchiveDirectory}\*"DISABLED
▶Parse-Appointment-Filesub-job · 3↗
1. Load ImportAppointmentLoadFile
  writes ImportAppointment
  data file spec=ImportAppointmentfile path={FilePath}import mode=Replace
2. Merge to SourceAppointmentsqlparse_appointment_file__merge_to_sourceappointment.sql
  ✨ Maps appointment identifiers to imported records and isolates duplicate entries to ensure data integrity within the appointment source.
  writes DuplicateAppointmentRowsPatientDateAppointmentIDMap · reads DuplicateAppointmentRowsImportAppointmentPatientDateAppointmentIDMap
  ↳ feeds from Load ImportAppointment
3. Archive Appointment FileExecuteProcess
  command=cmd.exe