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

sub-job

MiddletownMedical · Revfind-Process-Post-Load-Account-Routing

Job to update Account and AccountInsurance tables prior to scoring for any custom rules needed to properly assign insurance and score (ie - Prefix Mapping, Age at Service mapping, etc.)

called by RevFind-Process-Accounts, RevFind-Daily-Processing

sub-job MiddletownMedical/Revfind-Process-Post-Load-Account-Routing · db MiddletownMedical_ProdMirror · updated 2026-06-03

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

Revfind-Process-Post-Load-Account-Routing

4 tasks · MiddletownMedical
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. Create AccountDeltaRouting Tablesqlrevfind_process_post_load_account_routing__create_accountdeltarouting_table.sql
    ✨ Builds a staging table to store insurance routing logic and comments for accounts requiring updates.
  2. Aetna/Aetna Medicare Routingsqlrevfind_process_post_load_account_routing__aetna_aetna_medicare_routing.sql
    ✨ Identifies Aetna accounts and assigns specific insurance keys based on member identification patterns for proper routing.
    writes AccountDeltaRouting · reads AccountAccountDeltaAccountInsuranceFacilityInsurancePatient
    ↳ feeds from AccountDeltaRouting Merge
  3. Anthem Medicaidsqlrevfind_process_post_load_account_routing__anthem_medicaid.sql
    ✨ Categorizes Anthem accounts into Medicaid or Medicare plans based on member ID prefixes to ensure accurate insurance mapping.
    writes AccountDeltaRouting · reads AccountAccountDeltaAccountInsuranceFacilityInsurancePatient
    ↳ feeds from AccountDeltaRouting Merge
  4. AccountDeltaRouting Mergesqlrevfind_process_post_load_account_routing__accountdeltarouting_merge.sql
    ✨ Updates account and insurance records with new routing information and appends relevant processing notes to the account history.
    writes AccountAccountInsuranceAccountNote · reads AccountDeltaRoutingAccountNoteaccountDelta
    ↳ feeds from Aetna/Aetna Medicare Routing, Anthem Medicaid