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

sub-job

Wildflower · Flow-Transform-LoadDimensionMembers

called by Flow-Processing

sub-job Wildflower/Flow-Transform-LoadDimensionMembers · db Wildflower_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

Flow-Transform-LoadDimensionMembers

8 tasks · Wildflower
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. LoadInsuranceDimensionMembersLoadInsuranceDimensionMembers
    Synchronize insurance-specific dimension members from the insurance table to update contract and eligibility filtering options across the application.
    writes DimensionMember
    load insuranceload quote insuranceload eligibility insurance
  2. Load Time Dimensionssqlflow_transform_loaddimensionmembers__load_time_dimensions.sql
    ✨ Builds and updates time-based dimension members for days, months, and years based on the range of scheduled appointment dates.
    writes DimensionMember · reads TransformVisit
  3. Load VisitStatus Dimensionsqlflow_transform_loaddimensionmembers__load_visitstatus_dimension.sql
    ✨ Loads appointment status values into the visit status dimension to track patient encounter progress.
    writes DimensionMember · reads TransformVisit
  4. Load Provider Dimensionsqlflow_transform_loaddimensionmembers__load_provider_dimension.sql
    ✨ Updates provider and provider type dimensions to maintain a hierarchical relationship between individual clinicians and their professional categories.
    writes DimensionMember · reads Provider
  5. Load Facility Dimensionssqlflow_transform_loaddimensionmembers__load_facility_dimensions.sql
    ✨ Builds and updates facility dimension members to maintain a consistent list of healthcare locations for reporting.
    writes DimensionMember · reads Facility
  6. Load VisitType Dimensionssqlflow_transform_loaddimensionmembers__load_visittype_dimensions.sql
    ✨ Loads unique visit types into the dimension table to standardize appointment categories for downstream processing.
    writes DimensionMember · reads TransformVisit
  7. Load SourceInsurance Dimensionssqlflow_transform_loaddimensionmembers__load_sourceinsurance_dimensions.sqldisabled
    ✨ Loads source insurance and insurance parent dimensions to map specific insurance packages to their broader reporting categories.
    writes DimensionMember · reads AccountInsuranceDimensionMemberInsuranceMapSourcePayer
  8. Load State Dimensionssqlflow_transform_loaddimensionmembers__load_state_dimensions.sql
    ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
    writes DimensionMember · reads Facility