sub-job

PAA · Load-Appointment-File-Mobile

called by Load-Phygen-Files, Load-Phygen-Files-Mobile

sub-job PAA/Load-Appointment-File-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-Appointment-File-Mobile

3 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

Load PAA Mobile AppointmentLoadFile
writes ImportMobileAppointment
data file spec=ImportMobileAppointmentfile path={FilePath}import mode=Replacearchive file path={SourceDataArchive}
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
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