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

sub-job

StrideCare · RevFind-Process-LoadAccount

Load Account-Level Tables

called by RevFind-Daily-Processing-Accounts-33143

sub-job StrideCare/RevFind-Process-LoadAccount · db StrideCare_ProdMirror · updated 2025-09-17

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-LoadAccount

8 tasks · StrideCare
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. Augment AccountDeltaReprocessChangedConfigs
    reprocess accounts
  2. Augment AccountDelta ReprocessChangedConfigurationssqlrevfind_process_loadaccount__augment_accountdelta_reprocesschangedconfigurations.sql
    ✨ Adds accounts requiring reprocessing due to configuration changes into the account delta table for downstream processing.
    writes AccountDelta · reads AccountDeltaAccountsToReprocessTransformAccount
  3. Load ChargeMeasuressqlrevfind_process_loadaccount__load_chargemeasures.sql
    ✨ Calculates and loads financial metrics including payments, adjustments, and denials for account charges into the charge measures table.
    writes ChargeMeasures · reads AccountDeltaTransformChargeTransformChargeTransactionMeasure
    ↳ feeds from Augment AccountDelta ReprocessChangedConfigurations
  4. LoadAccountDataLoadAccountData
    Imports historical billing data from external systems into core account tables while preserving manual user modifications and application fields.
    · reads AccountChargeAccountDeltaChargeMeasuresChargeTypeInsuranceMapPatientProviderSourcePatientInsurance
    ↳ feeds from Augment AccountDelta ReprocessChangedConfigurations, Load ChargeMeasures
    custom account charge queryauto account querycustom account remit querycustom account insurance query
  5. ▶RevFind-Process-LoadCustomPropertiessub-job · 3↗
    1. Load Claim ID Custom PropertyUpdateCustomPropertyFromQuery
      · reads AccountDeltaTransformAccount
      entity=Accountcustom property key=CustomProperty-[id]auto querybatch mode
    2. Load Plan NameUpdateCustomPropertyFromQuery
      · reads AccountDeltaTransformAccount
      entity=Accountcustom property key=Plan Nameauto querybatch mode
    3. SyncBatchSyncBatch
      Synchronizes processed data from batch staging tables to production tables, updating visits, quotes, and custom property mappings.
      writes CustomPropertyMap · reads CustomPropertyMapBatch
      sync custom property map
  6. ▶RevFind-Process-LoadDimensionMemberssub-job · 13↗
    1. LoadInsuranceDimensionMembersLoadInsuranceDimensionMembers
      Synchronize insurance-specific dimension members from the insurance table to update contract and eligibility filtering options across the application.
      writes DimensionMember
      load insuranceload quote insuranceload eligibility insurance
    2. Load Time Dimensionssqlrevfind_process_loaddimensionmembers__load_time_dimensions.sql
      ✨ Builds time dimension members for days, months, and years based on account service dates to enable temporal reporting.
      writes DimensionMember · reads TransformAccount
    3. Load Provider Dimensionsqlrevfind_process_loaddimensionmembers__load_provider_dimension.sql
      ✨ Builds and updates the Provider and ProviderType dimensions, managing hierarchical relationships and identifying archived records.
      writes DimensionMember · reads DimensionMemberProvider
      ↳ feeds from Load AllowedStatus Dimensions, Load BilledToInsurance Dimensions, Load DenialCategory Dimensions, Load DiagnosisCode Dimension, Load Facility Dimensions, Load FacilityGroup Dimension, Load FacilityType Dimension, Load PlaceOfService Dimension, Load State Dimensions, Load Time Dimensions, LoadInsuranceDimensionMembers
    4. Load Facility Dimensionssqlrevfind_process_loaddimensionmembers__load_facility_dimensions.sql
      ✨ Builds and updates the Facility dimension by mapping source departments to specific facility groups and parent entities.
      writes DimensionMember · reads FacilitySourceDepartment_33143
    5. Load FacilityGroup Dimensionsqlrevfind_process_loaddimensionmembers__load_facilitygroup_dimension.sql
      ✨ Builds the FacilityGroup dimension by extracting unique parent entities from the existing Facility dimension members.
      writes DimensionMember · reads DimensionMember
      ↳ feeds from Load AllowedStatus Dimensions, Load BilledToInsurance Dimensions, Load DenialCategory Dimensions, Load DiagnosisCode Dimension, Load Facility Dimensions, Load FacilityType Dimension, Load PlaceOfService Dimension, Load Provider Dimension, Load State Dimensions, Load Time Dimensions, LoadInsuranceDimensionMembers
    6. Load FacilityType Dimensionsqlrevfind_process_loaddimensionmembers__load_facilitytype_dimension.sql
      ✨ Loads facility type dimension members from facility records to enable standardized categorization across the revenue cycle pipeline.
      writes DimensionMember · reads Facility
    7. Load SourceInsurance Dimensionssqlrevfind_process_loaddimensionmembers__load_sourceinsurance_dimensions.sql
      ✨ Builds and updates the SourceInsurance dimension using mapped insurance data for active accounts from the source system.
    8. Load PlaceOfService Dimensionsqlrevfind_process_loaddimensionmembers__load_placeofservice_dimension.sql
      ✨ Loads place of service dimension members from transformed charge data to categorize where healthcare services were provided.
      writes DimensionMember · reads TransformCharge
    9. Load DiagnosisCode Dimensionsqlrevfind_process_loaddimensionmembers__load_diagnosiscode_dimension.sql
      ✨ Loads unique diagnosis codes from charge records into the dimension member table to support standardized clinical reporting.
      writes DimensionMember · reads TransformCharge
    10. Load State Dimensionssqlrevfind_process_loaddimensionmembers__load_state_dimensions.sql
      ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
      writes DimensionMember · reads Facility
    11. Load BilledToInsurance Dimensionssqlrevfind_process_loaddimensionmembers__load_billedtoinsurance_dimensions.sql
      ✨ Builds and updates the BilledToInsurance dimension using unique insurance identifiers and names from the source insurance map.
      writes DimensionMember · reads SourceInsuranceMap
    12. Load DenialCategory Dimensionssqlrevfind_process_loaddimensionmembers__load_denialcategory_dimensions.sql
      ✨ Loads denial category dimensions from adjustment code rollup data to categorize claim denials.
      writes DimensionMember · reads AdjustmentCodeRollup
    13. Load AllowedStatus Dimensionssqlrevfind_process_loaddimensionmembers__load_allowedstatus_dimensions.sql
      ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
      writes DimensionMember
  7. ▶Job-[id]sub-job · 1↗
    1. Score Medicare SenarioBatchProcessAccounts
      writes AccountEstimate · reads QuoteBatchVisitBatch
      scenario insurance=Medicareincrementalupdate dimensions
  8. ▶RevFind-Process-ScoreAccountssub-job · 1↗
    1. BatchProcessAccountDataBatchProcessAccountData
      Calculates patient account estimates across multiple facilities and insurance types to update pricing after contract or configuration changes.
      writes AccountEstimate · reads QuoteBatchVisitBatch
      incremental