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

sub-job

JewishBoard · Load-Account-Data-RevFind

Load Account-Level Tables-RevFind

called by RevFind-Daily-Processing

sub-job JewishBoard/Load-Account-Data-RevFind · db JewishBoard_ProdMirror · updated 2025-12-01

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-Account-Data-RevFind

4 tasks · JewishBoard
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. Load ChargeMeasuresqlload_account_data_revfind__load_chargemeasure.sql
    ✨ Builds financial metrics for charges, including payments, adjustments, and denials, to track account-level charge performance.
    writes ChargeMeasures · reads AccountDeltaTransformChargeTransformChargeTransactionMeasure
  2. LoadAccountDataLoadAccountData
    Imports historical billing data from external systems into core account tables while preserving manual user modifications and application fields.
    · reads AccountChargeAccountDeltaChargeMeasuresChargeTypeFacilityInsuranceMapPatientTransformAccount
    ↳ feeds from Load ChargeMeasure
    custom account charge querycustom account querycustom account remit querycustom account insurance query
  3. ▶Load-Custom-Properties-2sub-job · 2↗
    1. UpdateCustomPropertyFromQuery: ClaimNumberUpdateCustomPropertyFromQuery
      · reads CustomPropertyMapTransformCharge
      entity=Accountcustom property key=CustomProperty-[id]auto query
    2. UpdateCustomPropertyFromQuery: ClaimDateUpdateCustomPropertyFromQuery
      · reads CustomPropertyMapTransformCharge
      entity=Accountcustom property key=CustomProperty-[id]auto query
  4. ▶Score-Accounts-RevFindsub-job · 2↗
    1. Score All Unscored AccountsProcessAccountDataFromQuerydisabled
      · reads AccountAccountChargeContractMap
      custom queryDISABLED
    2. Score All accountsBatchProcessAccounts
      writes AccountEstimate · reads QuoteBatchVisitBatch
      incremental