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

sub-job

EyeSouth · Load-Relations-NextTechSelect

Loads relational tables like Patient and Provider

called by Daily-Processing

sub-job EyeSouth/Load-Relations-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-Relations-NextTechSelect

8 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 Provider Mapsqlload_relations_nexttechselect__load_provider_map.sql
    ✨ Loads unique provider identifiers into the provider map by joining provider and practice data from the source system.
    writes ProviderMap · reads ImportNextTechSelectPracticeImportNextTechSelectProviderProviderMap
  2. Load Provider Relationsqlload_relations_nexttechselect__load_provider_relation.sql
    ✨ Updates provider records with names, types, and credentials for providers who have associated billing activity in the system.
    writes Provider · reads ImportNextTechSelectChargeImportNextTechSelectProviderProviderMap
    ↳ feeds from Load Provider Map
  3. Load Practice Mapsqlload_relations_nexttechselect__load_practice_map.sql
    ✨ Updates the practice mapping table by synchronizing practice names and identifiers from the source system.
    writes PracticeMap · reads ImportNextTechSelectPractice
  4. Load Facility Mapsqlload_relations_nexttechselect__load_facility_map.sql
    ✨ Loads new facility and location identifiers into the facility map by linking location data with practice records.
    writes FacilityMap · reads FacilityMapImportNextTechSelectLocationImportNextTechSelectPractice
  5. Load FacilityLoadEntities
    writes Facility · reads FacilityMapImportNextTechSelectBillImportNextTechSelectLocationPracticeMap
    ↳ feeds from Load Facility Map, Load Practice Map
    entity type=Facilitycustom querykey prefix=F
  6. Load Insurance Mapsqlload_relations_nexttechselect__load_insurance_map.sql
    ✨ Builds the master insurance map by importing new insurance plan and practice associations from the source system.
    writes MasterInsuranceMap · reads ImportNextTechSelectInsPlanImportNextTechSelectPracticeMasterInsuranceMap
  7. Load SourceInsuranceMapsqlload_relations_nexttechselect__load_sourceinsurancemap.sql
    ✨ Updates or inserts insurance mapping records to synchronize source insurance data with the internal mapping table.
    writes SourceInsuranceMap · reads ImportNextTechSelectInsuranceMapImportNextTechSelectPractice
  8. Load InsuranceLoadEntities
    writes Insurance · reads InsuranceSourceInsuranceMap
    ↳ feeds from Load SourceInsuranceMap
    entity type=Insuranceauto querykey prefix=I