sub-job

PAA · Load-Phygen-Files-Mobile

The Load SourceAppointment File file mask has a temp hack pattern match (? x12) to exclude the Endo file that is being sent with the same beggining of the file name ("AnFutSched").

called by Daily-Processing-PAAMobile

sub-job PAA/Load-Phygen-Files-Mobile · db PAA_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-Phygen-Files-Mobile

2 tasks · PAA

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=PAA_ProdMirror-mdcssh-sftpremote directory=/local directory={SourceDataFolder}remote archive directory=/StagingProcessingTest/
▶Load-Appointment-File-Mobilesub-job · 3↗
1. Load PAA Mobile AppointmentLoadFile
  writes ImportMobileAppointment
  data file spec=ImportMobileAppointmentfile path={FilePath}import mode=Replacearchive file path={SourceDataArchive}
2. OLD - Attempt to Match Existing SourceAppointment Tablesqlload_appointment_file_mobile__old_attempt_to_match_existing_sourceappointment_table.sqldisabled
  ✨ Loads mobile appointment data into the source table by mapping fields from the mobile import staging area for processing.
  writes SourceAppointment · reads ImportMobileAppointment
3. Load SourceAppointmentMobilesqlload_appointment_file_mobile__load_sourceappointmentmobile.sql
  ✨ Builds the mobile-specific source appointment table by transforming and importing data from the mobile application staging area.
  writes SourceAppointmentMobile · reads ImportMobileAppointment
  ↳ feeds from Load PAA Mobile Appointment