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

sub-job

USHP · RevFind-Transform-Accounts-MultiSource

NextGen Transforms-RevFind

called by RevFind-Daily-Processing-Accounts

sub-job USHP/RevFind-Transform-Accounts-MultiSource · db USHP_ProdMirror · updated 2026-04-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-Transform-Accounts-MultiSource

13 tasks · USHP
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 AccountDeltasqlrevfind_transform_accounts_multisource__create_accountdelta.sql
    ✨ Identifies new or updated encounters across multiple source systems to determine which accounts require processing in the current delta.
  2. Load TransformTransactionsqlrevfind_transform_accounts_multisource__load_transformtransaction.sql
    ✨ Transforms and loads transaction details for delta accounts, categorizing payments, adjustments, and refunds across all source systems.
    writes TransformTransaction · reads AccountDelta
  3. Load TransformRemitAdjustmentsqlrevfind_transform_accounts_multisource__load_transformremitadjustment.sql
    ✨ Processes and categorizes remittance adjustments for delta accounts, mapping reason codes to standardized denial and adjustment categories.
    writes TransformRemitAdjustment · reads AccountDelta
  4. Load TransformChargesqlrevfind_transform_accounts_multisource__load_transformcharge.sql
    ✨ Transforms and loads charge-level data for delta accounts, including service dates, procedure codes, and balances across multiple sources.
    writes TransformCharge · reads AccountDeltaSourceChargeSourceChargeDESourceChargeFL
  5. Load TransformAccountsqlrevfind_transform_accounts_multisource__load_transformaccount.sql
    ✨ Consolidates encounter-level data into a standardized account format, capturing provider, facility, and balance information for all delta records.
    writes TransformAccount · reads AccountDeltaSourceEncounterSourceEncounterDESourceEncounterFL
  6. Load TransformRemitsqlrevfind_transform_accounts_multisource__load_transformremit.sqldisabled
    ✨ Builds the remit transformation table by consolidating electronic remittance advice adjustments and transaction-level payment data for updated encounters.
    writes TransformRemit · reads EncounterDeltaTransformRemitTransformRemitAdjustmentTransformTransactionPaymentAdjustment
  7. Create TempZeroBalanceDatesqlrevfind_transform_accounts_multisource__create_tempzerobalancedate.sqldisabled
    ✨ Calculates the specific date an encounter reached a zero balance by comparing cumulative transaction amounts against total charges.
    writes TempZeroBalanceDate · reads EncounterDeltaSourceTransactionDetailTransformAccountCharge
  8. Load TransformRemitOrdersqlrevfind_transform_accounts_multisource__load_transformremitorder.sqldisabled
    ✨ Determines the sequence of insurance remittances for each account to identify initial, current, and post-zero-balance payment activities.
    writes TransformRemitOrder · reads EncounterDeltaTempZeroBalanceDateTransformRemitTransformRemitOrder
  9. Load TransformAccountInsurancesqlrevfind_transform_accounts_multisource__load_transformaccountinsurance.sql
    ✨ Maps insurance coverage and coordination of benefits to accounts, incorporating the latest remittance information for delta processing.
    writes TransformAccountInsurance · reads AccountDeltaSourceEncounterInsuranceSourceEncounterInsuranceDESourceEncounterInsuranceFLTransformAccountTransformRemitAdjustment
    ↳ feeds from Load TransformAccount, Load TransformRemitAdjustment
  10. ?? Load TransformPatientResponsibilityChargessqlrevfind_transform_accounts_multisource__load_transformpatientresponsibilitycharges.sqldisabled
    ✨ Flags specific charges as patient responsibility based on source system indicators and insurance remittance transfer records.
    writes TransformPatientResponsibilityCharge · reads EncounterDeltaSourceEncounterTransformAccountChargeTransformPatientResponsibilityChargeTransformRemit
  11. Load TransformRemitAdjustmentAggregatesqlrevfind_transform_accounts_multisource__load_transformremitadjustmentaggregate.sql
    ✨ Builds aggregated remittance adjustment data by calculating initial and current denial totals and categories for each charge and encounter.
    writes TransformRemitAdjustmentAggregate · reads AccountDeltaTransformChargeTransformRemitAdjustment
    ↳ feeds from Load TransformCharge, Load TransformRemitAdjustment
  12. Load TransformChargeTransactionMeasuressqlrevfind_transform_accounts_multisource__load_transformchargetransactionmeasures.sql
    ✨ Loads charge-level transaction measures by aggregating adjustments, payments, refunds, and remittance data from multiple source systems.
    writes TransformChargeTransactionMeasure · reads AccountDeltaSourceEncounterSourceEncounterDESourceEncounterFLTransformChargeTransformRemitAdjustmentAggregateTransformTransaction
    ↳ feeds from Load TransformCharge, Load TransformRemitAdjustmentAggregate, Load TransformTransaction
  13. Load TransformPatientsqlrevfind_transform_accounts_multisource__load_transformpatient.sql
    ✨ Merges and updates patient demographic information from multiple source systems into a unified patient transformation table.
    writes TransformPatient · reads SourcePatientSourcePatientDESourcePatientFL