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

sub-job

EyeSouth · Load-Dimension-Members-NextTechPP

Loads Dimension Members and Dimension Relations and Entities

called by Daily-Processing

sub-job EyeSouth/Load-Dimension-Members-NextTechPP · db EyeSouth_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-NextTechPP

10 tasks · EyeSouth
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 QuoteInsurance Dimension?sqlload_dimension_members_nexttechpp__load_quoteinsurance_dimension.sqldisabled
    ✨ Updates the insurance dimension with all available insurance keys to ensure comprehensive coverage for quote-related data analysis.
    writes DimensionMember · reads Insurance
  2. Load EligibilityInsurance Dimensionsqlload_dimension_members_nexttechpp__load_eligibilityinsurance_dimension.sqldisabled
    ✨ Loads insurance providers with active benefits API references into a specialized eligibility insurance dimension for verification workflows.
    writes DimensionMember · reads Insurance
  3. Load Facility Dimensionsqlload_dimension_members_nexttechpp__load_facility_dimension.sqldisabled
    ✨ Loads the Facility dimension for NextTech providers by mapping source IDs to internal keys and parent practices.
    writes DimensionMember · reads FacilityFacilityMapImportNextTechPPFacilityPracticeMap
  4. Load Practice Dimensionsqlload_dimension_members_nexttechpp__load_practice_dimension.sql
    ✨ Builds the Practice dimension for NextTech providers, applying specific name overrides and ensuring associated facilities exist.
    writes DimensionMember · reads DimensionMemberImportNextTechPPPracticePracticeMap
    ↳ feeds from Load InsurancePlan Dimension, Load PlaceOfService Dimension
  5. Load ProcedureCategory Dimensionsqlload_dimension_members_nexttechpp__load_procedurecategory_dimension.sqldisabled
    ✨ Builds the Procedure Category dimension by extracting unique parent categories from existing procedure code records.
    writes DimensionMember · reads DimensionMember
  6. Load Modifier Dimensionsqlload_dimension_members_nexttechpp__load_modifier_dimension.sqldisabled
    ✨ Loads and updates procedure modifier dimension members from charge records to ensure consistent reporting across the pipeline.
    writes DimensionMember · reads ProcedureModifierSourceCharge
  7. Load PlaceOfService Dimensionsqlload_dimension_members_nexttechpp__load_placeofservice_dimension.sql
    ✨ Loads the place of service dimension by synchronizing standardized facility codes and names from common reference data.
    writes DimensionMember · reads POSCodes
  8. Load All Diagnosis Dimensionssqlload_dimension_members_nexttechpp__load_all_diagnosis_dimensions.sqldisabled
    ✨ Builds and updates diagnosis-related dimension members by processing both known reference data and new codes found in charge entries.
    writes DimensionMember · reads DimensionMemberProcessLogSourceCharge
  9. Load EncounterStatussqlload_dimension_members_nexttechpp__load_encounterstatus.sqldisabled
    ✨ Builds the Encounter Status dimension using unique status codes and descriptions from source encounter records.
    writes DimensionMember · reads SourceEncounter
  10. Load InsurancePlan Dimensionsqlload_dimension_members_nexttechpp__load_insuranceplan_dimension.sql
    ✨ Loads and updates insurance plan dimension members by mapping imported plan identifiers to standardized master insurance records.
    writes DimensionMember · reads ImportNextTechPPInsurancePlanMasterInsuranceMap