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

sub-job

MNEye · Load-Visits-Flow

Removing references to TempVisitBundleCharge, which is loaded by ad-hoc tables, to transition MNEye to fully using the Bundle entity instead -CW [date]

called by Daily-Processing-Visits

sub-job MNEye/Load-Visits-Flow · db MNEye_ProdMirror · updated 2026-03-27

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-Visits-Flow

18 tasks · MNEye
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. ReprocessChangedConfigurationsReprocessChangedConfigurations
    Identify and queue visits or accounts affected by configuration changes to ensure historical data reflects updated pricing or insurance rules.
    reprocess visits
  2. Augment VisitDelta from Change Configssqlload_visits_flow__augment_visitdelta_from_change_configs.sql
    ✨ Adds visits from the reprocess queue to the delta table to ensure they are included in the next processing cycle.
    writes VisitDelta · reads VisitVisitDeltaVisitReprocessQueueItem
    ↳ feeds from Sync Quotes, Visits, and CustomProperties
  3. LoadVisitsLoadVisits
    Load scheduled visits and associated charges into the processing pipeline using custom SQL queries for pricing estimation and quote generation.
    writes QuoteBatchVisitBatch · reads FacilityInsuranceMapPatientSourceEventCategoryMapSourceEventTypeMapTransformVisitTransformVisitInsuranceVisit
    ↳ feeds from Augment VisitDelta from Change Configs, Sync Quotes, Visits, and CustomProperties
    custom visit queryauto charge querycustom service type querycustom coverage queryadd zero charge
  4. AutoApplyBundlesToVisitBatchAutoApplyBundlesToVisitBatch
    Applies matching charge bundles to batch visits based on facility and insurance to ensure consistent pricing across service types.
  5. Load TempBatchVisitssqlload_visits_flow__load_tempbatchvisits.sqldisabled
    ✨ Loads a temporary table with visits eligible for batch insurance verification based on scheduling, service type, and prior transaction history.
    writes TempBatchVisit
  6. CheckBenefitsflow
    Verifies insurance eligibility and retrieves detailed benefits information for visits by making real-time API calls to insurance providers.
    auto query
  7. Auto BenefitsAutoBenefits
    Populates insurance benefits like copays and deductibles on batch visits using data from eligibility verification transactions.
  8. Calculate Visitsflow
    Compute the good-faith estimate (CalculateVisits).
    · reads ContractMapDimensionMemberVisitBatch
    ↳ feeds from Load Visits
    custom querycalculate chargesupdate dimensionsbatch mode
  9. AutoSendLettersAutoSendLetters
    Generates and sends patient cost estimate letters for visits in the batch table based on configured qualification and communication rules.
  10. AutoSendLettersForFutureVisitsAutoSendLettersForFutureVisits
    Generates and sends cost estimate letters for upcoming scheduled visits based on patient preferences and configured qualification criteria.
  11. AutoSendReminderAutoSendReminder
    Resends patient cost estimate letters via email or SMS if they remain unviewed after a specified time interval.
  12. LogVisitChangeEventsBatchLogVisitChangeEventsBatch
    Compare batch visits against production records to detect and log specific property changes for auditing and compliance tracking.
  13. VisitAfterDate1.1.26VisitAfterDate1.1.26
    · reads CustomPropertyMapVisitBatch
    ↳ feeds from Load Visits, Sync Quotes, Visits, and CustomProperties
    entity=Visitcustom property key=VisitAfterDate1.1.26custom querybatch mode
  14. PrimaryCoverageStatus (CustomProp)UpdateCustomPropertyFromQuery
    · reads CustomPropertyMapEligibilityTxnVisitBatchVisitCoverageBatch
    ↳ feeds from Load Visits, Sync Quotes, Visits, and CustomProperties
    entity=Visitcustom property key=PrimaryCoverageStatuscustom querybatch mode
  15. SecondaryCoverageStatus (CustomProp)UpdateCustomPropertyFromQuery
    · reads CustomPropertyMapEligibilityTxnVisitBatchVisitCoverageBatch
    ↳ feeds from Load Visits, Sync Quotes, Visits, and CustomProperties
    entity=Visitcustom property key=SecondaryCoverageStatuscustom querybatch mode
  16. MedicarePartC Custom Prop (need to refine)UpdateCustomPropertyFromQuery
    · reads CustomPropertyMapEligibilityTxnVisitBatch
    ↳ feeds from Load Visits, Sync Quotes, Visits, and CustomProperties
    entity=Visitcustom property key=HasMedicarePartCCoverageauto querybatch mode
  17. Sync Quotes, Visits, and CustomPropertiesSyncBatch
    Synchronizes processed data from batch staging tables to production tables, updating visits, quotes, and custom property mappings.
    writes CustomPropertyMapQuoteVisitVisitChangeEvent · reads CustomPropertyMapBatchQuoteBatchVisitBatchVisitChangeEventBatch
    ↳ feeds from Load Visits
    sync quotesync visitsync custom property mapsync visit change event
  18. ▶Load-Visit-Factsub-job · 1↗
    1. Load VisitFactsqlload_visit_fact__load_visitfact.sql
      ✨ Updates the visit fact table by refreshing records with recent activity, including insurance, eligibility, and payment status.
      writes VisitFactVisitFactDelta · reads EligibilityStatusMapEligibilityTxnFacilityPatientLetterPaymentTxnVisitVisitFactDelta