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

sub-job

StrideCare · Flow-HL7-Transform-LoadDimensionMembers

called by Flow-HL7-Processing

sub-job StrideCare/Flow-HL7-Transform-LoadDimensionMembers · db StrideCare_ProdMirror · updated 2026-06-11

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-HL7-Transform-LoadDimensionMembers

9 tasks · StrideCare
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. LoadInsuranceDimensionMembersLoadInsuranceDimensionMembersdisabled
    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 insuranceDISABLED
  2. Load Time Dimensionssqlflow_hl7_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_hl7_transform_loaddimensionmembers__load_visitstatus_dimension.sql
    ✨ Loads visit status dimension members from appointment data to ensure all scheduling statuses are available for reporting and filtering.
    writes DimensionMember · reads TransformVisit
  4. Load Provider Dimensionsqlflow_hl7_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_hl7_transform_loaddimensionmembers__load_facility_dimensions.sqldisabled
    ✨ Loads facility dimension members and their parent groups to organize service locations for consistent reporting across the organization.
    writes DimensionMember · reads Facility
  6. Load VisitType Dimensionssqlflow_hl7_transform_loaddimensionmembers__load_visittype_dimensions.sql
    ✨ Loads visit type dimension members by consolidating appointment codes and descriptions from multiple source systems for standardized visit categorization.
    writes DimensionMember · reads SourceAppointmentTypeSourceAppointmentType_33143TransformVisit
  7. Load VisitTypeCategory Dimensionssqlflow_hl7_transform_loaddimensionmembers__load_visittypecategory_dimensions.sql
    ✨ Builds the visit type category dimension by extracting unique parent classifications from existing visit type records.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load Provider Dimension, Load SourceInsurance Dimensions, Load Time Dimensions, Load VisitStatus Dimension, Load VisitType Dimensions
  8. Load SourceInsurance Dimensionssqlflow_hl7_transform_loaddimensionmembers__load_sourceinsurance_dimensions.sql
    ✨ Loads source insurance and insurance parent dimensions to map specific insurance packages to their broader reporting categories.
    writes DimensionMember · reads AccountInsuranceDimensionMemberInsuranceMapSourcePayer
    ↳ feeds from Load Provider Dimension, Load Time Dimensions, Load VisitStatus Dimension, Load VisitType Dimensions, Load VisitTypeCategory Dimensions
  9. Load State Dimensionssqlflow_hl7_transform_loaddimensionmembers__load_state_dimensions.sqldisabled
    ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
    writes DimensionMember · reads Facility