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

sub-job

SeaRad · Load-Source-Visit-Info

called by Daily-Visit-Processing

sub-job SeaRad/Load-Source-Visit-Info · 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

Load-Source-Visit-Info

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
  1. Load TempVisitDeltasqlload_source_visit_info__load_tempvisitdelta.sql
    ✨ Identifies and loads recently updated visit IDs into a delta table to facilitate incremental processing of appointment data.
    · reads ProcessLogSourceAppointment
  2. Load TransformVisitInsurancesqlload_source_visit_info__load_transformvisitinsurance.sql
    ✨ Standardizes and upserts visit-specific insurance information, including coordination of benefits and member details, from source appointment data.
    writes ImportTransformVisitInsurance · reads SourceAppointmentSourceInsuranceMapVisitDelta
  3. Load TransformVisitChargesqlload_source_visit_info__load_transformvisitcharge.sql
    ✨ Transforms appointment CPT codes and modalities into standardized visit charges and upserts them into the charge transformation table.
    writes ImportTransformVisitCharge · reads SourceAppointmentVisitDelta
  4. Load TransformVisitsqlload_source_visit_info__load_transformvisit.sql
    ✨ Consolidates and standardizes visit metadata, including scheduling, provider details, and service types, for the visit transformation layer.
    writes ImportTransformVisit · reads SourceAppointmentSourceInsuranceMapVisitDelta