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

sub-job

OneGI · Flow-MM-Processing-LoadDimensionMembers

called by Flow-MM-Processing

sub-job OneGI/Flow-MM-Processing-LoadDimensionMembers · db OneGI_ProdMirror · updated 2026-04-02

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-MM-Processing-LoadDimensionMembers

16 tasks · OneGI
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. LoadDimensionMembersLoadDimensionMembers
    Synchronize facility, provider, and insurance metadata into the dimension member table to refresh dashboard filters and reporting categories.
    writes DimensionMember
    load insuranceload quote insuranceload eligibility insuranceload facilityload provider
  2. Load Insurance Dimensionsqlflow_mm_processing_loaddimensionmembers__load_insurance_dimension.sqldisabled
    ✨ Populates the insurance dimension with unique carrier keys to enable filtering and analysis by payer.
    writes DimensionMember · reads Insurance
  3. Load EligibilityInsurance Dimensionsqlflow_mm_processing_loaddimensionmembers__load_eligibilityinsurance_dimension.sqldisabled
    ✨ Loads insurance members that support electronic eligibility and benefits verification via API integration.
    writes DimensionMember · reads DimensionMemberInsurance
  4. Load QuoteInsurance Dimensionsqlflow_mm_processing_loaddimensionmembers__load_quoteinsurance_dimension.sqldisabled
    ✨ Builds a dimension of insurance providers associated with active contracts to facilitate accurate patient cost estimates.
    writes DimensionMember · reads ContractMapInsurance
  5. 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
  6. Load Time Dimensionssqlflow_mm_processing_loaddimensionmembers__load_time_dimensions.sql
    ✨ Populates time dimension hierarchies for days, months, and years using appointment timestamps to support temporal data analysis.
    writes DimensionMember · reads TransformVisit
  7. Load VisitStatus Dimensionsqlflow_mm_processing_loaddimensionmembers__load_visitstatus_dimension.sql
    ✨ Builds the visit status dimension by extracting unique appointment statuses from transformed visit data.
    writes DimensionMember · reads TransformVisit
  8. Load Provider Dimensionsqlflow_mm_processing_loaddimensionmembers__load_provider_dimension.sqldisabled
    ✨ Synchronizes provider details into the dimension member table to enable provider-based filtering and grouping in reports.
    writes DimensionMember · reads Provider
  9. Load Facility Dimensionssqlflow_mm_processing_loaddimensionmembers__load_facility_dimensions.sqldisabled
    ✨ Builds facility and facility group hierarchies, linking clinics to their parent groups and tax identification numbers for financial reporting.
    writes DimensionMember · reads DimensionMemberFacilitysourceFacilityGroupToTIN
  10. Load VisitType Dimensionssqlflow_mm_processing_loaddimensionmembers__load_visittype_dimensions.sql
    ✨ Builds and updates visit type dimension members using appointment types from transformed visit data.
    writes DimensionMember · reads TransformVisit
  11. Load Diagnosis Code Dimensionsqlflow_mm_processing_loaddimensionmembers__load_diagnosis_code_dimension.sqldisabled
    ✨ Loads and updates the DiagnosisCode dimension by extracting unique primary, secondary, and tertiary diagnosis codes from charge data.
    writes DimensionMember · reads TransformCharge
  12. Load RadioIsotopes Code Dimensionsqlflow_mm_processing_loaddimensionmembers__load_radioisotopes_code_dimension.sqldisabled
    ✨ Flags and updates the RadioIsotopes dimension to indicate the presence of radioisotope codes within the source risk data.
    writes DimensionMember · reads SourceCareRiskRadioIsotopeCodes
  13. Load Modifier Dimensionsqlflow_mm_processing_loaddimensionmembers__load_modifier_dimension.sqldisabled
    ✨ Loads and updates the Modifier dimension by collecting unique modifier codes from multiple charge record fields.
    writes DimensionMember · reads TransformCharge
  14. Load Place of Service Dimensionsqlflow_mm_processing_loaddimensionmembers__load_place_of_service_dimension.sqldisabled
    ✨ Builds and updates the PlaceOfService dimension using unique location codes extracted from charge transaction records.
    writes DimensionMember · reads TransformCharge
  15. Load SourceInsurance Dimensionsqlflow_mm_processing_loaddimensionmembers__load_sourceinsurance_dimension.sqldisabled
    ✨ Loads and updates the SourceInsurance dimension with mapped insurance provider details for specific data sources and active accounts.
    writes DimensionMember · reads AccountInsuranceInsuranceMap
  16. Load State Dimensionssqlflow_mm_processing_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