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

sub-job

EugeneGI · Load-Visits-Benefits-To-AutoSend

called by HL7-Processing-Nightly

sub-job EugeneGI/Load-Visits-Benefits-To-AutoSend · db EugeneGI_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-Visits-Benefits-To-AutoSend

9 tasks · EugeneGI
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. CheckBenefitsflow
    Verifies insurance eligibility and retrieves detailed benefits information for visits by making real-time API calls to insurance providers.
    · reads TempBatchVisitVisitBatch
    custom query
  2. Re-Check Benefitsflowdisabled
    Verifies insurance eligibility and retrieves detailed benefits information for visits by making real-time API calls to insurance providers.
    · reads EligibilityStatusMapEligibilityTxnTempBatchVisitVisitBatch
    custom queryDISABLED
  3. AutoApplyBenefitsAutoApplyBenefits
    Populates insurance benefits like copays and deductibles on batch visits using data from eligibility verification transactions.
  4. CalculateVisitsflow
    Compute the good-faith estimate (CalculateVisits).
    · reads DimensionMemberVisitBatch
    custom querycalculate chargesbatch mode
  5. ExportBatchVisitEligibility before recheckflow
    Push the batch to the app / export results.
    · reads EligibilityTxnvisitbatch
    custom querytable name=BatchVisitEligibility
  6. Update HasMisMatchedMemberID Custom Property after recheckUpdateCustomPropertyFromQuery
    · reads BatchVisitEligibilityEligibilityTxnVisitBatch
    entity=Visitcustom property key=HasMismatchedMemberIDcustom querybatch mode
  7. LogVisitChangeEventsBatchLogVisitChangeEventsBatch
    Compare batch visits against production records to detect and log specific property changes for auditing and compliance tracking.
  8. Load TransformVisitInsuranceCoverageStatussqlload_visits_benefits_to_autosend__load_transformvisitinsurancecoveragestatus.sql
    ✨ Updates insurance coverage statuses by analyzing the latest eligibility transactions to determine if coverage is active, inactive, or errored.
    writes TempEligibilityStatsTransformVisitInsuranceCoverageStatus · reads TempEligibilityStatsTransformVisitInsuranceVisitBatch
  9. ▶Load-CustomProperty-CoverageStatussub-job · 4↗
    1. Load Primary Coverage StatusUpdateCustomPropertyFromQuery
      · reads CustomPropertyMapTransformVisitInsuranceCoverageStatusVisitBatch
      entity=Visitcustom property key=PrimaryCoverageStatuscustom querybatch mode
    2. Load Secondary Coverage StatusUpdateCustomPropertyFromQuery
      · reads CustomPropertyMapTransformVisitInsuranceCoverageStatusVisitBatch
      entity=Visitcustom property key=SecondaryCoverageStatuscustom querybatch mode
    3. Load Tertiary Coverage StatusUpdateCustomPropertyFromQuery
      · reads CustomPropertyMapTransformVisitInsuranceCoverageStatusVisitBatch
      entity=Visitcustom property key=TertiaryCoverageStatuscustom querybatch mode
    4. Load Has Active Medicaid/Medicare InsuranceUpdateCustomPropertyFromQuery
      · reads DimensionMemberTransformVisitInsuranceCoverageStatusVisitBatch
      entity=Visitcustom property key=HasActiveMedicaid/MedicareInsurancecustom querybatch mode