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

sub-job

EyeSouth · Load-Dimension-Members-NextTechSelect

Loads Dimension Members and Dimension Relations and Entities

called by Daily-Processing

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

9 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_nexttechselect__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_nexttechselect__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_nexttechselect__load_facility_dimension.sql
    ✨ Builds and updates facility dimension members by mapping imported location data to specific practices and standardized facility identifiers.
    writes DimensionMember · reads FacilityFacilityMapImportNextTechSelectLocationPracticeMap
  4. Load Practice Dimensionsqlload_dimension_members_nexttechselect__load_practice_dimension.sql
    ✨ Loads and updates practice dimension members by mapping imported practice identifiers to standardized internal keys for reporting.
    writes DimensionMember · reads ImportNextTechSelectPracticePracticeMap
  5. Load ProcedureCategory Dimensionsqlload_dimension_members_nexttechselect__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_nexttechselect__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_nexttechselect__load_placeofservice_dimension.sqldisabled
    ✨ 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_nexttechselect__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 InsurancePlan Dimensionsqlload_dimension_members_nexttechselect__load_insuranceplan_dimension.sql
    ✨ Loads and updates insurance plan dimension members by synchronizing imported plan names and identifiers with the master insurance map.
    writes DimensionMember · reads ImportNextTechSelectInsPlanMasterInsuranceMap