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

sub-job

EyeSouth · Load-Relations-NextTechPP

Loads relational tables like Patient and Provider

called by Daily-Processing

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

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_nexttechpp__load_provider_map.sql
    ✨ Builds a mapping table to link imported provider identifiers with unique internal keys for cross-system consistency.
    writes ProviderMap · reads ImportNextTechPPProviderProviderMap
  2. Load Provider Relationsqlload_relations_nexttechpp__load_provider_relation.sql
    ✨ Updates or inserts provider records, including names, types, and credentials, into the master provider table.
    writes Provider · reads ImportNextTechPPProviderProviderMap
    ↳ feeds from Load Provider Map
  3. Load Practice Mapsqlload_relations_nexttechpp__load_practice_map.sql
    ✨ Updates the practice mapping table by synchronizing practice identifiers and names from the source system.
    writes PracticeMap · reads ImportNextTechPPPractice
  4. Load Facility Mapsqlload_relations_nexttechpp__load_facility_map.sql
    ✨ Loads new facility identifiers into the facility map to ensure unique tracking across different source databases.
    writes FacilityMap · reads FacilityMapImportNextTechPPFacility
  5. Load FacilityLoadEntities
    writes Facility · reads FacilityMapImportNextTechPPFacilityPracticeMapSourceNextTechPPEncounter
    ↳ feeds from Load Facility Map, Load Practice Map
    entity type=Facilitycustom querykey prefix=F
  6. Load Insurance Mapsqlload_relations_nexttechpp__load_insurance_map.sql
    ✨ Loads unique plan identifiers into the master insurance map from the source system to support insurance plan tracking.
    writes MasterInsuranceMap · reads ImportNextTechPPInsurancePlanMasterInsuranceMap
  7. Load SourceInsuranceMapsqlload_relations_nexttechpp__load_sourceinsurancemap.sql
    ✨ Updates the source insurance map by linking internal insurance identifiers with their corresponding source system plan data.
    writes SourceInsuranceMap · reads ImportNextTechPPInsuranceMap
  8. Load InsuranceLoadEntities
    writes Insurance · reads InsuranceSourceInsuranceMap
    ↳ feeds from Load SourceInsuranceMap
    entity type=Insuranceauto querykey prefix=I