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

sub-job

ISpine · RevFind-Load-Account-Data

Load Account-Level Tables

called by RevFind-Daily-Processing

sub-job ISpine/RevFind-Load-Account-Data · db ISpine_ProdMirror · updated 2026-05-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

RevFind-Load-Account-Data

9 tasks · ISpine
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. ReprocessChangedConfigurationsReprocessChangedConfigurations
    Identify and queue visits or accounts affected by configuration changes to ensure historical data reflects updated pricing or insurance rules.
    reprocess accounts
  2. LoadPatientsLoadPatients
    Upsert patient records into the patient dimension.
    · reads PatientTransformPatient
    custom patient query
  3. Load ChargeMeasuressqlrevfind_load_account_data__load_chargemeasures.sql
    ✨ Aggregates remittance activity by charge to calculate paid, denied, and allowed amounts for financial analysis.
    writes ChargeMeasures · reads TransformAccountRemitTransformCharge
  4. LoadAccountDataLoadAccountData
    Imports historical billing data from external systems into core account tables while preserving manual user modifications and application fields.
    · reads AccountChargeChargeMeasuresChargeTypeFacilityInsuranceMapPatientProviderTransformAccount
    ↳ feeds from Load ChargeMeasures
    custom account charge queryauto account querycustom account remit querycustom account insurance query
  5. Load-Custom-Propertiessub-jobdisabled
  6. SyncBatchSyncBatchdisabled
    Synchronizes processed data from batch staging tables to production tables, updating visits, quotes, and custom property mappings.
    writes CustomPropertyMap · reads CustomPropertyMapBatch
    sync custom property mapDISABLED
  7. ▶Score-Accountssub-job · 3↗
    1. Rescore Profee AccountsBatchProcessAccounts
      writes AccountEstimate · reads QuoteBatchVisitBatch
    2. Rescore Accounts FacilityBatchProcessAccounts
      writes AccountEstimate · reads QuoteBatchVisitBatch
      incremental
    3. Medicare ScenarioBatchProcessAccounts
      writes AccountEstimate · reads QuoteBatchVisitBatch
      scenario insurance=Medicareincremental
  8. Load AccountDetailsqlrevfind_load_account_data__load_accountdetail.sqldisabled
    ✨ Builds a comprehensive account summary table by combining patient, insurance, and financial data for detailed encounter reporting.
    writes AccountDetail · reads AccountAccountChargeAccountDeltaAccountEstimateDimensionMemberPatientSourceEncounterInsuranceSourcePayer
  9. Load AccountChargeDetailsqlrevfind_load_account_data__load_accountchargedetail.sqldisabled
    ✨ Loads granular charge-level details including procedure codes, modifiers, and payment metrics for individual service line analysis.
    writes AccountChargeDetail · reads AccountAccountChargeAccountDeltaAccountEstimateCalculationAccountEstimateChargeDimensionMemberPatientSourceEncounterInsurance