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

sub-job

USDH · Score-Accounts

called by Load-Account-Data

sub-job USDH/Score-Accounts · db USDH_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

Score-Accounts

17 tasks · USDH
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. MedicareMedicare
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  2. RGAL - Capital BlueBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2024-01-01incrementalupdate dimensions
  3. RGAL - UHCBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  4. RGAL - CignaBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  5. RGAL - AetnaBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2024-01-01incrementalupdate dimensions
  6. RGAL - Highmark CommercialBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  7. RGAL - Independence CommercialBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  8. RGAL - Preferred Healthcare CommercialBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2024-10-01incrementalupdate dimensions
  9. DCDC - AetnaBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2024-01-01incrementalupdate dimensions
  10. DCDC - AmerihealthBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  11. DCDC - CignaBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  12. DCDC - DE First HealthBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  13. DCDC - HighmarkBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  14. DCDC - TricareBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  15. DCDC - UHCBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  16. DCDC - World Trade CenterBatchProcessAccounts
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2023-01-01incrementalupdate dimensions
  17. UPMCUPMC
    writes AccountEstimate · reads QuoteBatchVisitBatch
    min service date=2025-01-01incremental