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

sub-job

OneGI · 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-ModMed, RevFind-Daily-Processing

sub-job OneGI/Revfind-Process-Post-Load-Account-Routing · db OneGI_ProdMirror · updated 2026-05-18

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

8 tasks · OneGI
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. GAVA - Anthem Routingsqlrevfind_process_post_load_account_routing__gava_anthem_routing.sqldisabled
    ✨ Routes Anthem and BCBS accounts to specific plan categories based on member ID prefixes and eligibility data.
    writes AccountDeltaRouting · reads AccountDeltaSourceAnthemBCBSEligibilityPrefixDataaccountfacilitytransformAccountInsurance
  3. GCM - Anthem TN Routingsqlrevfind_process_post_load_account_routing__gcm_anthem_tn_routing.sqldisabled
    ✨ Routes Tennessee Anthem accounts to specific provider networks based on member ID prefixes and plan names.
    writes AccountDeltaRouting · reads AccountDeltaFacilitySourceAnthemBCBSEligibilityPrefixDataaccounttransformAccountInsurance
  4. AccountDeltaRouting Mergesqlrevfind_process_post_load_account_routing__accountdeltarouting_merge.sqldisabled
    ✨ Updates account and insurance records with new routing information and appends relevant processing notes to the account history.
    writes AccountAccountInsuranceAccountNote · reads AccountDeltaRoutingAccountNoteaccountDelta
  5. Merge Account Label CommentsMergeSqldisabled
    writes AccountNote · reads AccountDeltaAccountDeltaRouting
    merge data source type=ThisDatabasetable name=AccountNotemerge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  6. GAVA - UHC Physician Statussqlrevfind_process_post_load_account_routing__gava_uhc_physician_status.sql
    ✨ Flags UnitedHealthcare account charges with physician or non-physician status based on provider credentials for differential rate calculation.
    · reads AccountChargeCommonDataaccountaccountDeltaprovider
  7. GAVA - VA Region (Anthem + Aetna + Human Medicare)sqlrevfind_process_post_load_account_routing__gava_va_region_anthem_aetna_human_medicare.sql
    ✨ Appends geographic region codes to account charges for specific payers based on facility zip codes.
    · reads AccountChargeAccountDeltaaccountfacilitysourceVAFacilityRegion
  8. ALL UHC - Add UHC procedure category to code stringsqlrevfind_process_post_load_account_routing__all_uhc_add_uhc_procedure_category_to_code_string.sql
    ✨ Updates account charges by appending United Healthcare procedure categories to code strings for relevant insurance accounts.
    · reads AccountAccountChargeChargeTypeaccountDelta