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

sub-job

HeatonEye · Load-Dimension-Members-Flow

Loads Dimension Members

called by Daily-Visit-Processing-Flow

sub-job HeatonEye/Load-Dimension-Members-Flow · db HeatonEye_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-Dimension-Members-Flow

2 tasks · HeatonEye
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 VisitStatussqlload_dimension_members_flow__load_visitstatus.sql
    ✨ Loads visit status members into the dimension table using appointment status values extracted from transformed visit data.
    writes DimensionMember · reads TransformVisit
  2. Load VisitType Dimensionsqlload_dimension_members_flow__load_visittype_dimension.sql
    ✨ Populates the visit type dimension by mapping unique event identifiers and practice-specific descriptions from source event records.
    writes DimensionMember · reads SourceEvent