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

sub-job

PPRM · Load-Visit-Transform-Tables

Loads transform tables for Visits

called by Daily-Visit-Processing

sub-job PPRM/Load-Visit-Transform-Tables · db PPRM_ProdMirror · updated 2026-07-06

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-Visit-Transform-Tables

7 tasks · PPRM
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. Load TempVisitDeltasqlload_visit_transform_tables__load_tempvisitdelta.sql
    ✨ Identifies visits and insurance records updated since the last process run to populate a delta table for incremental processing.
    writes VisitDelta · reads ProcessLogVisitDelta
  2. ▶Load-SourceAppointmentChainsub-job · 1↗
    1. Load SourceAppointmentChainsqlload_sourceappointmentchain__load_sourceappointmentchain.sql
      ✨ Builds a chain of rescheduled appointments to identify and retain the most recent record for each visit.
      writes SourceAppointmentChain · reads SourceAppointmentVisitDelta
  3. Load TransformPatientsqlload_visit_transform_tables__load_transformpatient.sql
    ✨ Synchronizes patient demographic and contact information from source records into the transformed patient table using a merge operation.
    writes TransformPatient · reads SourcePatient
  4. Load TransformVisitsqlload_visit_transform_tables__load_transformvisit.sql
    ✨ Updates the transformed visit table with current appointment details, statuses, and facility information for records identified in the delta set.
    writes TransformVisit · reads SourceAppointmentSourceAppointmentChainSourceEventVisitDelta
    ↳ feeds from Load TempVisitDelta
  5. Load TransformCustomPropertiessqlload_visit_transform_tables__load_transformcustomproperties.sql
    ✨ Extracts and loads custom appointment properties and key-value pairs into the transformed properties table for updated visits.
    writes TransformCustomProperties · reads SourceAppointmentSourceAppointmentChainVisitDelta
    ↳ feeds from Load TempVisitDelta
  6. Load TransformVisitInsurancesqlload_visit_transform_tables__load_transformvisitinsurance.sql
    ✨ Updates transformed insurance coverage and coordination of benefits data for visits, including logic to identify self-pay and unmapped payers.
    writes TransformVisitInsurance · reads SourceAppointmentSourceAppointmentChainSourceInsuranceMapSourcePatientInsuranceSourcePatientRelationTransformCustomPropertiesTransformPatientTransformVisit
    ↳ feeds from Load TempVisitDelta, Load TransformCustomProperties, Load TransformPatient, Load TransformVisit
  7. Load TransformVisitChargesqlload_visit_transform_tables__load_transformvisitcharge.sql
    ✨ Builds visit charges by mapping appointment types and patient demographics to procedure codes and quantities for cost estimation.
    writes TransformVisitCharge · reads ChargeTypeImportGFEMappingSourceEventTransformPatientTransformVisitVisitDelta
    ↳ feeds from Load TempVisitDelta, Load TransformPatient, Load TransformVisit